units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
175 rows where DES_TP = 2 and MNG_AGENCY = 32 sorted by ACRES
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
- Open Access 154
- Restricted Access 1
MNG_AG_TYP 1
- City Agency 155
MNG_AGENCY 1
- San Jose, City of · 155 ✖
DES_TP 1
- Local Park · 155 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1806 | 1806 | 1805 | {"type": "MultiPolygon", "coordinates": [[[[-121.83002, 37.34971], [-121.82992, 37.34978], [-121.82949, 37.34934], [-121.82959, 37.34928], [-121.83002, 37.34971]]], [[[-121.83066, 37.3502], [-121.83045, 37.35034], [-121.83004, 37.34991], [-121.83014, 37.34984], [-121.83034, 37.35006], [-121.83045, 37.34999], [-121.83066, 37.3502]]]]} | Open Access 1 | 13706 | Our Park | 23268 | 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 | 0.437 | Our Park | 1971 | Local Park 2 | 4 | |
7788 | 7788 | 7787 | {"type": "Polygon", "coordinates": [[[-121.79392, 37.23948], [-121.79391, 37.24008], [-121.79354, 37.23998], [-121.79354, 37.23956], [-121.79379, 37.23954], [-121.79392, 37.23948]]]} | Open Access 1 | 47665 | Miyuki Dog Park | 31406 | 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 | 0.44 | Miyuki Dog Park | 0 | Local Park 2 | 4 | |
3599 | 3599 | 3598 | {"type": "Polygon", "coordinates": [[[-121.81856, 37.37389], [-121.81827, 37.37437], [-121.81801, 37.37427], [-121.81798, 37.37424], [-121.81797, 37.37419], [-121.81809, 37.374], [-121.81822, 37.37388], [-121.81829, 37.37378], [-121.81856, 37.37389]]]} | Open Access 1 | 38026 | Fleming Park | 18944 | 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 | 0.446 | Fleming Park | 0 | Local Park 2 | 4 | |
3983 | 3983 | 3982 | {"type": "Polygon", "coordinates": [[[-121.9098, 37.3363], [-121.90931, 37.33668], [-121.90907, 37.33646], [-121.90955, 37.33609], [-121.9098, 37.3363]]]} | Open Access 1 | 38018 | Theodore Lenzen Park | 26299 | 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 | 0.472 | Theodore Lenzen Park | 0 | Local Park 2 | 4 | |
1231 | 1231 | 1230 | {"type": "Polygon", "coordinates": [[[-121.77596, 37.3123], [-121.77617, 37.31248], [-121.77619, 37.31251], [-121.77616, 37.31256], [-121.77565, 37.31284], [-121.77558, 37.31283], [-121.77541, 37.31269], [-121.77596, 37.3123]]]} | Open Access 1 | 8894 | Classico Park | 17392 | 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 | 0.476 | Classico Park | 2004 | Local Park 2 | 4 | |
14018 | 14018 | 14017 | {"type": "Polygon", "coordinates": [[[-121.86189, 37.28614], [-121.86177, 37.28619], [-121.8615, 37.28635], [-121.86099, 37.28584], [-121.86112, 37.28576], [-121.86125, 37.28585], [-121.8614, 37.28593], [-121.86153, 37.28599], [-121.86178, 37.28605], [-121.86189, 37.28614]]]} | Open Access 1 | 38009 | Tuscany Hills Overlook Park | 26600 | 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 | 0.482 | Tuscany Hills Overlook Park | 0 | Local Park 2 | 4 | |
3596 | 3596 | 3595 | {"type": "Polygon", "coordinates": [[[-121.86792, 37.27888], [-121.86754, 37.27898], [-121.86734, 37.2785], [-121.86775, 37.27841], [-121.86792, 37.27888]]]} | Open Access 1 | 38007 | Parkside Glen Park | 23449 | 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 | 0.502 | Parkside Glen Park | 0 | Local Park 2 | 4 | |
9171 | 9171 | 9170 | {"type": "Polygon", "coordinates": [[[-121.99301, 37.30887], [-121.99265, 37.30928], [-121.99273, 37.30943], [-121.99231, 37.30956], [-121.99225, 37.30954], [-121.99215, 37.30943], [-121.99257, 37.30912], [-121.99287, 37.30879], [-121.99301, 37.30887]]]} | Open Access 1 | 16828 | Gullo Park | 19567 | 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 | 0.508 | Gullo Park | 1987 | Local Park 2 | 4 | |
8197 | 8197 | 8196 | {"type": "Polygon", "coordinates": [[[-121.75759, 37.30772], [-121.75723, 37.3079], [-121.7574, 37.30815], [-121.75736, 37.30818], [-121.7573, 37.30817], [-121.75713, 37.30796], [-121.75708, 37.30783], [-121.75703, 37.30764], [-121.75707, 37.30757], [-121.75706, 37.3075], [-121.75702, 37.30746], [-121.75694, 37.30744], [-121.75688, 37.30733], [-121.75718, 37.30743], [-121.7573, 37.30749], [-121.75744, 37.30758], [-121.75759, 37.30772]]]} | Open Access 1 | 9095 | Pocket Park No. 19 | 23828 | 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 | 0.52 | PP No. 19 | 2004 | Local Park 2 | 4 | |
1242 | 1242 | 1241 | {"type": "MultiPolygon", "coordinates": [[[[-121.77122, 37.32389], [-121.77105, 37.32387], [-121.77102, 37.32367], [-121.77098, 37.32363], [-121.77095, 37.32344], [-121.77113, 37.32346], [-121.77115, 37.32364], [-121.77119, 37.32368], [-121.77122, 37.32389]]], [[[-121.77133, 37.32443], [-121.77116, 37.32444], [-121.77111, 37.32402], [-121.77128, 37.32402], [-121.77133, 37.32443]]], [[[-121.77142, 37.32496], [-121.77125, 37.32498], [-121.77117, 37.32458], [-121.77135, 37.32456], [-121.77142, 37.32496]]]]} | Open Access 1 | 9136 | Pocket Park No. 4 | 23834 | 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 | 0.527 | PP No. 4 | 2004 | Local Park 2 | 4 | |
1807 | 1807 | 1806 | {"type": "Polygon", "coordinates": [[[-121.90114, 37.3155], [-121.90116, 37.31561], [-121.90116, 37.31572], [-121.90114, 37.31582], [-121.9011, 37.31592], [-121.90019, 37.31569], [-121.90017, 37.31567], [-121.90019, 37.31565], [-121.90111, 37.31549], [-121.90114, 37.3155]]]} | Open Access 1 | 13708 | Palm Haven Plaza | 23339 | 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 | 0.563 | Palm Haven Plaza | 1990 | Local Park 2 | 4 | |
14020 | 14020 | 14019 | {"type": "Polygon", "coordinates": [[[-121.91633, 37.30724], [-121.91633, 37.30735], [-121.91628, 37.30751], [-121.91606, 37.30781], [-121.91582, 37.30782], [-121.91582, 37.30733], [-121.91601, 37.30733], [-121.91602, 37.3072], [-121.91633, 37.30718], [-121.91633, 37.30724]]]} | Open Access 1 | 38011 | St. Elizabeth Park | 25765 | 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 | 0.581 | St. Elizabeth Park | 0 | Local Park 2 | 4 | |
3668 | 3668 | 3667 | {"type": "Polygon", "coordinates": [[[-121.85409, 37.22428], [-121.85408, 37.22431], [-121.85404, 37.22435], [-121.85328, 37.22419], [-121.85329, 37.224], [-121.85332, 37.22396], [-121.85338, 37.22393], [-121.85355, 37.22387], [-121.85363, 37.22387], [-121.85381, 37.22392], [-121.85397, 37.22392], [-121.854, 37.22395], [-121.85404, 37.22418], [-121.85409, 37.22428]]]} | Open Access 1 | 13730 | Pfeiffer Park | 23637 | 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 | 0.664 | Pfeiffer Park | 2001 | Local Park 2 | 4 | |
8572 | 8572 | 8571 | {"type": "Polygon", "coordinates": [[[-121.87488, 37.32302], [-121.87497, 37.32314], [-121.87496, 37.32318], [-121.87417, 37.32356], [-121.87412, 37.32354], [-121.87388, 37.32322], [-121.87424, 37.32298], [-121.87443, 37.32323], [-121.87488, 37.32302]]]} | Open Access 1 | 13632 | Bestor Art Park | 16043 | 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 | 0.719 | Bestor Art Park | 1940 | Local Park 2 | 4 | |
4091 | 4091 | 4090 | {"type": "Polygon", "coordinates": [[[-121.82987, 37.29701], [-121.82983, 37.29708], [-121.82949, 37.29702], [-121.82873, 37.29701], [-121.82859, 37.29678], [-121.82926, 37.29636], [-121.82917, 37.29644], [-121.82911, 37.29655], [-121.82913, 37.29667], [-121.82917, 37.29674], [-121.82927, 37.29681], [-121.82953, 37.29688], [-121.82987, 37.29701]]]} | Open Access 1 | 44532 | Lone Bluff Park | 21436 | 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 | 0.778 | Lone Bluff Park | 0 | Local Park 2 | 4 | |
3985 | 3985 | 3984 | {"type": "Polygon", "coordinates": [[[-121.76724, 37.2524], [-121.7669, 37.25268], [-121.76631, 37.25222], [-121.76687, 37.25176], [-121.76697, 37.25184], [-121.76685, 37.25194], [-121.76681, 37.25199], [-121.76679, 37.25208], [-121.76681, 37.25215], [-121.76686, 37.2522], [-121.76704, 37.25234], [-121.76714, 37.25238], [-121.76724, 37.2524]]]} | Open Access 1 | 38020 | Piercy Park | 23663 | 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 | 0.784 | Piercy Park | 0 | Local Park 2 | 4 | |
7207 | 7207 | 7206 | {"type": "Polygon", "coordinates": [[[-121.77436, 37.31377], [-121.77415, 37.31422], [-121.77351, 37.31402], [-121.77373, 37.31357], [-121.77436, 37.31377]]]} | Open Access 1 | 9025 | Evergreen Village Park | 18768 | 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 | 0.806 | Evergreen Village Park | 2004 | Local Park 2 | 4 | |
3986 | 3986 | 3985 | {"type": "Polygon", "coordinates": [[[-121.8579, 37.34324], [-121.8574, 37.34356], [-121.85695, 37.3431], [-121.85708, 37.34304], [-121.8573, 37.34296], [-121.85745, 37.34288], [-121.8575, 37.34287], [-121.85754, 37.34289], [-121.8579, 37.34324]]]} | Open Access 1 | 38021 | Bonita Park | 16263 | 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 | 0.825 | Bonita Park | 0 | Local Park 2 | 4 | |
1417 | 1417 | 1416 | {"type": "Polygon", "coordinates": [[[-121.77114, 37.31589], [-121.77046, 37.31599], [-121.77034, 37.3155], [-121.77102, 37.3154], [-121.77114, 37.31589]]]} | Open Access 1 | 8957 | Michelangelo Park | 22198 | 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 | 0.844 | Michelangelo Park | 2007 | Local Park 2 | 4 | |
5253 | 5253 | 5252 | {"type": "Polygon", "coordinates": [[[-121.84018, 37.32321], [-121.84058, 37.32359], [-121.8406, 37.32362], [-121.84058, 37.32366], [-121.84013, 37.32397], [-121.83978, 37.32364], [-121.83982, 37.32356], [-121.83978, 37.32348], [-121.84018, 37.32321]]]} | Open Access 1 | 1720 | Turtle Rock Park | 26596 | 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 | 0.851 | Turtle Rock Park | 2003 | Local Park 2 | 4 |
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]);