units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where MNG_AGENCY = 32, MNG_AG_TYP = 2 and YR_EST = 1976
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 4
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 6 ✖
MNG_AGENCY 1
- San Jose, City of · 6 ✖
ACCESS_TYP 1
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
283 | 283 | 282 | {"type": "Polygon", "coordinates": [[[-121.83395, 37.28668], [-121.83326, 37.28716], [-121.83159, 37.28524], [-121.83237, 37.2848], [-121.83246, 37.28472], [-121.83255, 37.28474], [-121.83263, 37.28484], [-121.83263, 37.28489], [-121.83258, 37.28503], [-121.83268, 37.28506], [-121.83261, 37.28527], [-121.83299, 37.28536], [-121.83302, 37.2853], [-121.83308, 37.28531], [-121.83315, 37.2851], [-121.83366, 37.28521], [-121.83379, 37.28482], [-121.83386, 37.28484], [-121.83388, 37.28486], [-121.8339, 37.28555], [-121.83392, 37.28556], [-121.83395, 37.28668]]]} | Open Access 1 | 962 | Solari Park | 25596 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 7.564 | Solari Park | 1976 | Local Park 2 | 4 | |
6451 | 6451 | 6450 | {"type": "Polygon", "coordinates": [[[-121.87834, 37.35953], [-121.87826, 37.35958], [-121.87795, 37.35929], [-121.87664, 37.36016], [-121.87692, 37.36045], [-121.87668, 37.36061], [-121.87601, 37.36039], [-121.87538, 37.36015], [-121.8747, 37.35988], [-121.87397, 37.35955], [-121.87427, 37.35876], [-121.87405, 37.35604], [-121.87435, 37.35406], [-121.87456, 37.35424], [-121.87443, 37.35524], [-121.87498, 37.35558], [-121.87596, 37.35539], [-121.87636, 37.35567], [-121.87687, 37.35616], [-121.87698, 37.35629], [-121.87713, 37.35652], [-121.87749, 37.35687], [-121.877, 37.35719], [-121.8764, 37.35761], [-121.87668, 37.35791], [-121.87834, 37.35953]]]} | Open Access 1 | 1981 | Watson Park | 30905 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.sanjoseca.gov/Facilities/Facility/Details/126 | Santa Clara 19 | 34.437 | Watson Park | 1976 | Local Park 2 | 4 |
7920 | 7920 | 7919 | {"type": "Polygon", "coordinates": [[[-121.82621, 37.22902], [-121.82609, 37.22903], [-121.82596, 37.22907], [-121.82581, 37.22918], [-121.82516, 37.22872], [-121.82423, 37.22874], [-121.824, 37.22889], [-121.82393, 37.22912], [-121.82384, 37.22914], [-121.82379, 37.22909], [-121.82302, 37.22908], [-121.82296, 37.22912], [-121.82289, 37.2291], [-121.82283, 37.22911], [-121.82278, 37.22913], [-121.82275, 37.22918], [-121.82205, 37.22899], [-121.82192, 37.22928], [-121.82184, 37.2293], [-121.8218, 37.22936], [-121.82181, 37.22943], [-121.8219, 37.22951], [-121.8219, 37.22962], [-121.82152, 37.22963], [-121.82153, 37.23028], [-121.82141, 37.23029], [-121.82132, 37.23032], [-121.82132, 37.23054], [-121.82111, 37.23048], [-121.82083, 37.23033], [-121.82063, 37.23027], [-121.82065, 37.23], [-121.82039, 37.22994], [-121.82019, 37.22983], [-121.82009, 37.22971], [-121.81999, 37.22949], [-121.81985, 37.22937], [-121.81967, 37.2293], [-121.81919, 37.22926], [-121.81908, 37.22923], [-121.81898, 37.22918], [-121.8184, 37.22859], [-121.81824, 37.22849], [-121.81803, 37.22841], [-121.81799, 37.22825], [-121.81792, 37.22813], [-121.81781, 37.22804], [-121.81768, 37.22798], [-121.81765, 37.22798], [-121.81748, 37.22821], [-121.81742, 37.22823], [-121.81738, 37.22828], [-121.81738, 37.22878], [-121.81735, 37.22895], [-121.8173, 37.22906], [-121.81721, 37.2292], [-121.81703, 37.22939], [-121.81698, 37.22942], [-121.81627, 37.22915], [-121.81639, 37.22894], [-121.81612, 37.2287], [-121.81599, 37.22855], [-121.81608, 37.22841], [-121.81615, 37.22821], [-121.81616, 37.22804], [-121.81614, 37.22792], [-121.81608, 37.22777], [-121.816, 37.22766], [-121.81586, 37.22754], [-121.81576, 37.22748], [-121.81562, 37.22744], [-121.81548, 37.22744], [-121.81535, 37.22747], [-121.81523, 37.22753], [-121.81489, 37.22788], [-121.81461, 37.22822], [-121.81432, 37.22822], [-121.81409, 37.22815], [-121.81424, 37.22795], [-121.81407, 37.22783], [-121.81395, 37.2277], [-121.8139, 37.22761], [-121.81379, 37.22735], [-121.81364, 37.22711], [-121.81345, 37.22694], [-121.81327, 37.22686], [-121.81305, 37.22685], [-121.81294, 37.22688], [-121.81282, 37.22694], [-121.81269, 37.22707], [-121.81254, 37.22738], [-121.81249, 37.22743], [-121.81241, 37.22747], [-121.81229, 37.22749], [-121.81185, 37.22747], [-121.81159, 37.22753], [-121.81159, 37.22777], [-121.81095, 37.22777], [-121.81094, 37.22749], [-121.81111, 37.22727], [-121.81114, 37.22712], [-121.81111, 37.22701], [-121.81105, 37.22692], [-121.811, 37.22688], [-121.8109, 37.22684], [-121.8108, 37.22684], [-121.8104, 37.22691], [-121.80977, 37.22689], [-121.80969, 37.22692], [-121.80965, 37.22696], [-121.80956, 37.22715], [-121.80951, 37.22719], [-121.80916, 37.2272], [-121.8089, 37.22718], [-121.80882, 37.22725], [-121.80876, 37.22723], [-121.80882, 37.22715], [-121.80863, 37.22699], [-121.80856, 37.22698], [-121.80789, 37.22745], [-121.80781, 37.22744], [-121.80772, 37.22747], [-121.80771, 37.2274], [-121.80756, 37.22737], [-121.80742, 37.22737], [-121.8069, 37.22759], [-121.8069, 37.22782], [-121.80642, 37.22782], [-121.80642, 37.22759], [-121.80635, 37.22752], [-121.80634, 37.22703], [-121.80667, 37.22672], [-121.80696, 37.22647], [-121.80765, 37.22592], [-121.80832, 37.22662], [-121.80871, 37.22656], [-121.80883, 37.2269], [-121.80912, 37.22698], [-121.80945, 37.22694], [-121.80984, 37.2267], [-121.81032, 37.22681], [-121.81081, 37.22668], [-121.81143, 37.22669], [-121.81153, 37.22701], [-121.81164, 37.22719], [-121.81182, 37.22724], [-121.81199, 37.22723], [-121.81212, 37.22723], [-121.81245, 37.22711], [-121.81289, 37.22685], [-121.81337, 37.22683], [-121.8136, 37.22697], [-121.81423, 37.22782], [-121.8146, 37.22793], [-121.81528, 37.22743], [-121.81539, 37.22739], [-121.81554, 37.22736], [-121.81569, 37.22737], [-121.81582, 37.22741], [-121.81609, 37.22759], [-121.8163, 37.22808], [-121.81639, 37.2282], [-121.81648, 37.2283], [-121.81654, 37.22834], [-121.81678, 37.22838], [-121.81682, 37.22841], [-121.81732, 37.22816], [-121.81744, 37.22785], [-121.81783, 37.22786], [-121.81806, 37.2281], [-121.81851, 37.22843], [-121.81904, 37.22851], [-121.81925, 37.22902], [-121.81954, 37.22905], [-121.82014, 37.22903], [-121.82035, 37.22959], [-121.82053, 37.22974], [-121.82099, 37.2299], [-121.82124, 37.2298], [-121.82147, 37.22942], [-121.82159, 37.22835], [-121.82162, 37.22823], [-121.82184, 37.22817], [-121.82211, 37.22826], [-121.8223, 37.22837], [-121.82261, 37.22857], [-121.82297, 37.22873], [-121.82325, 37.2288], [-121.82358, 37.22879], [-121.82377, 37.22872], [-121.82412, 37.22849], [-121.82455, 37.22833], [-121.8247, 37.22818], [-121.82496, 37.22811], [-121.82507, 37.22813], [-121.82515, 37.22845], [-121.82528, 37.22858], [-121.8255, 37.22867], [-121.82587, 37.22874], [-121.82604, 37.22875], [-121.82615, 37.22867], [-121.82621, 37.22902]]]} | Open Access 1 | 10484 | Century Oaks | 17076 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 23.07 | Century Oaks | 1976 | None 659 | ||
8612 | 8612 | 8611 | {"type": "Polygon", "coordinates": [[[-121.89133, 37.27171], [-121.89131, 37.27178], [-121.89127, 37.27183], [-121.8895, 37.27229], [-121.88941, 37.27229], [-121.88931, 37.27223], [-121.88877, 37.27087], [-121.88877, 37.27083], [-121.8888, 37.27079], [-121.88885, 37.27077], [-121.89064, 37.2703], [-121.89071, 37.27031], [-121.89076, 37.27033], [-121.89079, 37.27036], [-121.89133, 37.27171]]]} | Open Access 1 | 13724 | Paul Moore Park | 23532 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 8.249 | Paul Moore Park | 1976 | Local Park 2 | 4 | |
9134 | 9134 | 9133 | {"type": "Polygon", "coordinates": [[[-121.85206, 37.22045], [-121.8521, 37.2206], [-121.85216, 37.22075], [-121.85214, 37.22081], [-121.8513, 37.22106], [-121.85106, 37.22121], [-121.8508, 37.22148], [-121.85074, 37.22148], [-121.85006, 37.22132], [-121.85011, 37.22032], [-121.85206, 37.22045]]]} | Open Access 1 | 16764 | Graystone Park | 19454 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 3.92 | Graystone Park | 1976 | Local Park 2 | 4 | |
9136 | 9136 | 9135 | {"type": "Polygon", "coordinates": [[[-121.80697, 37.26901], [-121.80436, 37.26903], [-121.80436, 37.26868], [-121.80443, 37.2686], [-121.80444, 37.26851], [-121.80435, 37.26807], [-121.80435, 37.26796], [-121.80437, 37.26791], [-121.80467, 37.26751], [-121.80471, 37.26743], [-121.80474, 37.2673], [-121.80473, 37.267], [-121.80474, 37.26697], [-121.80479, 37.26694], [-121.80533, 37.26693], [-121.80555, 37.26695], [-121.8057, 37.267], [-121.80588, 37.26709], [-121.80603, 37.26716], [-121.8064, 37.26724], [-121.80651, 37.2673], [-121.80662, 37.26738], [-121.80672, 37.26752], [-121.80677, 37.26763], [-121.80685, 37.26853], [-121.80689, 37.26862], [-121.80697, 37.2687], [-121.80697, 37.26901]]]} | Open Access 1 | 16767 | Great Oak | 19457 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 11.018 | Great Oak | 1976 | None 756 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);