units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by ACRES
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 187
- Restricted Access 6
MNG_AG_TYP 1
- City Agency 193
MNG_AGENCY 1
- San Jose, City of · 193 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1818 | 1818 | 1817 | {"type": "Polygon", "coordinates": [[[-121.8839, 37.2883], [-121.88362, 37.28834], [-121.88342, 37.28845], [-121.8832, 37.28805], [-121.88353, 37.28762], [-121.88367, 37.28739], [-121.8837, 37.28739], [-121.88371, 37.28755], [-121.88377, 37.2877], [-121.88391, 37.28787], [-121.88388, 37.28808], [-121.8839, 37.2883]]]} | Open Access 1 | 15657 | Roy Avenue Park | 24709 | 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 | 1.016 | Roy Avenue Park | 1954 | Local Park 2 | 4 | |
13065 | 13065 | 13064 | {"type": "Polygon", "coordinates": [[[-121.77292, 37.304], [-121.7721, 37.30412], [-121.77199, 37.30358], [-121.77225, 37.30356], [-121.77279, 37.30349], [-121.77279, 37.30353], [-121.77283, 37.3036], [-121.77292, 37.304]]]} | Open Access 1 | 34937 | Falls Creek Park | 18838 | 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 | 1.053 | Falls Creek Park | 0 | Local Park 2 | 4 | |
17064 | 17064 | 17063 | {"type": "Polygon", "coordinates": [[[-121.76669, 37.22574], [-121.76663, 37.22596], [-121.76591, 37.22583], [-121.76587, 37.22585], [-121.76581, 37.22583], [-121.76573, 37.22582], [-121.76565, 37.22586], [-121.7653, 37.2258], [-121.76528, 37.22575], [-121.76496, 37.22569], [-121.76491, 37.22572], [-121.76483, 37.22569], [-121.76475, 37.22571], [-121.76399, 37.22558], [-121.76395, 37.22554], [-121.76389, 37.22553], [-121.76383, 37.22553], [-121.76377, 37.22556], [-121.76341, 37.22549], [-121.76336, 37.2254], [-121.76308, 37.22534], [-121.76301, 37.22529], [-121.76293, 37.22528], [-121.76287, 37.2253], [-121.76288, 37.22524], [-121.76284, 37.22519], [-121.7625, 37.22512], [-121.76196, 37.22487], [-121.76201, 37.22481], [-121.76254, 37.22507], [-121.76289, 37.22513], [-121.76293, 37.22519], [-121.76298, 37.22521], [-121.76305, 37.22522], [-121.76311, 37.2252], [-121.76347, 37.22527], [-121.76346, 37.22534], [-121.76349, 37.22538], [-121.76378, 37.22543], [-121.76383, 37.22542], [-121.76391, 37.22546], [-121.764, 37.22546], [-121.76438, 37.22554], [-121.76438, 37.2256], [-121.7647, 37.22566], [-121.76481, 37.2256], [-121.76486, 37.22562], [-121.76494, 37.22562], [-121.76496, 37.22566], [-121.76532, 37.22572], [-121.76535, 37.22577], [-121.76564, 37.22582], [-121.76579, 37.22574], [-121.76585, 37.22575], [-121.76591, 37.22574], [-121.76593, 37.22576], [-121.76628, 37.22582], [-121.76633, 37.22568], [-121.76669, 37.22574]]]} | Open Access 1 | 13735 | Pocket Park No. 23 | 23833 | 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 | 1.085 | PP No. 23 | 0 | Local Park 2 | 4 | |
1804 | 1804 | 1803 | {"type": "Polygon", "coordinates": [[[-121.84341, 37.36447], [-121.84319, 37.36462], [-121.84225, 37.36365], [-121.84266, 37.36339], [-121.84316, 37.36423], [-121.84341, 37.36447]]]} | Open Access 1 | 13651 | Children of the Rainbow Park | 17197 | 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 | 1.1 | Children of the Rainbow Park | 1989 | Local Park 2 | 4 | |
8574 | 8574 | 8573 | {"type": "Polygon", "coordinates": [[[-121.76924, 37.29043], [-121.76917, 37.29049], [-121.7689, 37.29058], [-121.76865, 37.29073], [-121.76858, 37.29075], [-121.76849, 37.29075], [-121.76842, 37.29071], [-121.76826, 37.29055], [-121.76792, 37.29031], [-121.76785, 37.29021], [-121.76784, 37.29013], [-121.76786, 37.29009], [-121.76798, 37.2901], [-121.76798, 37.29014], [-121.76802, 37.29016], [-121.76855, 37.29025], [-121.76872, 37.29026], [-121.76892, 37.29023], [-121.76906, 37.29024], [-121.76914, 37.29027], [-121.76919, 37.29032], [-121.76923, 37.29038], [-121.76924, 37.29043]]]} | Open Access 1 | 13647 | Canyon Creek Park | 16813 | 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 | 1.151 | Canyon Creek Park | 2005 | Local Park 2 | 4 | |
8137 | 8137 | 8136 | {"type": "Polygon", "coordinates": [[[-121.97282, 37.30461], [-121.97236, 37.30462], [-121.97235, 37.30457], [-121.97223, 37.30457], [-121.97221, 37.3038], [-121.97282, 37.3038], [-121.97282, 37.30461]]]} | Open Access 1 | 13666 | Green Thumb Community Garden | 19467 | 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 | 1.174 | Green Thumb Community Garden | 0 | Local Park 2 | 4 | |
14028 | 14028 | 14027 | {"type": "Polygon", "coordinates": [[[-121.89024, 37.36141], [-121.88965, 37.36147], [-121.88895, 37.36154], [-121.89005, 37.36072], [-121.89015, 37.36081], [-121.89024, 37.36141]]]} | Open Access 1 | 38024 | Luna Park | 21595 | 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 | 1.178 | Luna Park | 0 | Local Park 2 | 4 | |
8196 | 8196 | 8195 | {"type": "MultiPolygon", "coordinates": [[[[-121.75909, 37.31125], [-121.75908, 37.31129], [-121.75903, 37.31135], [-121.75894, 37.31143], [-121.75879, 37.3115], [-121.75881, 37.31139], [-121.7588, 37.31118], [-121.7587, 37.3111], [-121.75843, 37.31101], [-121.758, 37.31101], [-121.75767, 37.31106], [-121.75771, 37.31101], [-121.75779, 37.31097], [-121.75801, 37.31095], [-121.75802, 37.31091], [-121.75822, 37.3109], [-121.75847, 37.31091], [-121.75859, 37.31093], [-121.75879, 37.31101], [-121.75901, 37.31116], [-121.75909, 37.31125]]], [[[-121.75906, 37.31205], [-121.75896, 37.31207], [-121.75881, 37.3116], [-121.75887, 37.31158], [-121.75906, 37.31205]]], [[[-121.75984, 37.31269], [-121.75981, 37.31281], [-121.75957, 37.31279], [-121.75949, 37.31283], [-121.75915, 37.31287], [-121.75902, 37.31229], [-121.75903, 37.31224], [-121.75907, 37.31221], [-121.75914, 37.31219], [-121.75928, 37.31243], [-121.75946, 37.31246], [-121.75954, 37.31264], [-121.75984, 37.31269]]]]} | Open Access 1 | 9073 | Pocket Park No. 17 | 23826 | 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 | 1.192 | PP No. 17 | 2004 | Local Park 2 | 4 | |
14019 | 14019 | 14018 | {"type": "MultiPolygon", "coordinates": [[[[-121.89295, 37.31787], [-121.89295, 37.31797], [-121.89085, 37.31787], [-121.89085, 37.31778], [-121.89295, 37.31787]]], [[[-121.89597, 37.31798], [-121.89596, 37.31807], [-121.89363, 37.31799], [-121.89363, 37.31789], [-121.89597, 37.31798]]], [[[-121.89742, 37.31803], [-121.89731, 37.31856], [-121.8972, 37.31855], [-121.89721, 37.31839], [-121.89724, 37.31838], [-121.89727, 37.31802], [-121.89742, 37.31803]]]]} | Open Access 1 | 38010 | Fuller Park | 28012 | 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 | 1.195 | Fuller Park | 0 | Local Park 2 | 4 | |
8598 | 8598 | 8597 | {"type": "Polygon", "coordinates": [[[-121.8864, 37.31025], [-121.88595, 37.31039], [-121.8854, 37.30953], [-121.8861, 37.3094], [-121.8864, 37.31025]], [[-121.88615, 37.3097], [-121.88616, 37.30969], [-121.88607, 37.30946], [-121.8859, 37.3095], [-121.88599, 37.30974], [-121.88615, 37.3097]]]} | Open Access 1 | 13678 | J.Frey/Willow Community Garden | 20293 | 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 | 1.211 | J.Frey/Willow Community Garden | 1961 | Local Park 2 | 4 | |
3600 | 3600 | 3599 | {"type": "Polygon", "coordinates": [[[-121.83447, 37.31838], [-121.83426, 37.31852], [-121.8342, 37.31862], [-121.83363, 37.31857], [-121.83358, 37.31855], [-121.83357, 37.31851], [-121.83364, 37.3179], [-121.83367, 37.31779], [-121.83375, 37.31764], [-121.83447, 37.31838]]]} | Open Access 1 | 38027 | Nisich Park | 22769 | 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 | 1.226 | Nisich Park | 0 | Local Park 2 | 4 | |
14026 | 14026 | 14025 | {"type": "Polygon", "coordinates": [[[-121.89165, 37.39019], [-121.89118, 37.39055], [-121.8907, 37.39015], [-121.89062, 37.39011], [-121.89063, 37.39005], [-121.89058, 37.39004], [-121.89058, 37.39001], [-121.89066, 37.38996], [-121.8907, 37.38986], [-121.891, 37.38967], [-121.89106, 37.38966], [-121.8911, 37.38967], [-121.89163, 37.39012], [-121.89165, 37.39015], [-121.89165, 37.39019]]]} | Open Access 1 | 38022 | Gran Paradiso Park | 19416 | 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 | 1.245 | Gran Paradiso Park | 0 | Local Park 2 | 4 | |
1043 | 1043 | 1042 | {"type": "Polygon", "coordinates": [[[-121.86197, 37.28707], [-121.86132, 37.28748], [-121.86081, 37.28697], [-121.86146, 37.28657], [-121.86197, 37.28707]]]} | Open Access 1 | 38008 | Vieira Park | 27092 | 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 | 1.298 | Vieira Park | 0 | Local Park 2 | 4 | |
3984 | 3984 | 3983 | {"type": "Polygon", "coordinates": [[[-121.9386, 37.25096], [-121.93856, 37.25096], [-121.93856, 37.25137], [-121.93859, 37.25138], [-121.93859, 37.25139], [-121.93853, 37.2516], [-121.93848, 37.25158], [-121.93834, 37.25157], [-121.93822, 37.25152], [-121.93802, 37.25154], [-121.93796, 37.25148], [-121.93794, 37.25145], [-121.93794, 37.25078], [-121.93797, 37.25073], [-121.93804, 37.2507], [-121.9386, 37.2507], [-121.9386, 37.25096]]]} | Open Access 1 | 38019 | Carolyn Norris Park | 16888 | 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 | 1.303 | Carolyn Norris Park | 0 | Local Park 2 | 4 | |
1810 | 1810 | 1809 | {"type": "Polygon", "coordinates": [[[-121.91563, 37.36258], [-121.91482, 37.36298], [-121.91447, 37.36254], [-121.91522, 37.36207], [-121.91563, 37.36258]]]} | Open Access 1 | 13739 | Rosemary Gardens Park | 24619 | 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 | 1.306 | Rosemary Gardens Park | 1972 | Local Park 2 | 4 | |
1405 | 1405 | 1404 | {"type": "Polygon", "coordinates": [[[-121.76494, 37.31564], [-121.7648, 37.3157], [-121.76466, 37.31572], [-121.7645, 37.3157], [-121.76436, 37.31564], [-121.76425, 37.31555], [-121.76419, 37.31544], [-121.76418, 37.31531], [-121.76422, 37.31518], [-121.76429, 37.3151], [-121.76435, 37.31505], [-121.76445, 37.315], [-121.76457, 37.31497], [-121.76477, 37.31498], [-121.76496, 37.31506], [-121.76504, 37.31513], [-121.76508, 37.31519], [-121.76511, 37.31526], [-121.76512, 37.31535], [-121.76511, 37.31543], [-121.76506, 37.31552], [-121.76494, 37.31564]]]} | Open Access 1 | 9014 | Pocket Park No. 11 | 23822 | 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 | 1.329 | PP No. 11 | 2004 | Local Park 2 | 4 | |
8608 | 8608 | 8607 | {"type": "MultiPolygon", "coordinates": [[[[-121.91295, 37.32069], [-121.91197, 37.32074], [-121.91197, 37.32068], [-121.91209, 37.32069], [-121.91213, 37.3206], [-121.91223, 37.3205], [-121.91235, 37.32046], [-121.91247, 37.32044], [-121.9126, 37.32046], [-121.91268, 37.3205], [-121.91275, 37.32056], [-121.91281, 37.32065], [-121.91294, 37.32064], [-121.91295, 37.32069]]], [[[-121.9129, 37.32142], [-121.91239, 37.32141], [-121.91205, 37.32142], [-121.91202, 37.32096], [-121.9129, 37.32092], [-121.9129, 37.32142]]]]} | Open Access 1 | 13701 | O'Connor Park | 22945 | 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 | 1.412 | O'Connor Park | 2003 | Local Park 2 | 4 | |
14021 | 14021 | 14020 | {"type": "Polygon", "coordinates": [[[-121.92579, 37.34618], [-121.92523, 37.34688], [-121.92464, 37.34658], [-121.92459, 37.34652], [-121.92451, 37.3465], [-121.92532, 37.34595], [-121.92579, 37.34618]]]} | Open Access 1 | 38012 | Newhall Park | 22725 | 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 | 1.428 | Newhall Park | 0 | Local Park 2 | 4 | |
7529 | 7529 | 7528 | {"type": "Polygon", "coordinates": [[[-121.77462, 37.32204], [-121.77446, 37.3223], [-121.77438, 37.32256], [-121.77431, 37.32259], [-121.77427, 37.32264], [-121.77426, 37.32269], [-121.7743, 37.32281], [-121.77426, 37.32325], [-121.77424, 37.32328], [-121.77419, 37.32331], [-121.77412, 37.32332], [-121.77382, 37.32324], [-121.77363, 37.32317], [-121.7736, 37.3231], [-121.77361, 37.32305], [-121.77423, 37.32204], [-121.77429, 37.322], [-121.77435, 37.32198], [-121.77462, 37.32204]]]} | Open Access 1 | 9172 | Pocket Park No. 7 | 23837 | 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 | 1.501 | PP No. 7 | 2004 | Local Park 2 | 4 | |
9373 | 9373 | 9372 | {"type": "Polygon", "coordinates": [[[-121.8662, 37.25613], [-121.86579, 37.25732], [-121.86566, 37.25762], [-121.86545, 37.25789], [-121.86519, 37.25816], [-121.8651, 37.25815], [-121.86508, 37.25811], [-121.86516, 37.25788], [-121.86534, 37.25761], [-121.86545, 37.25736], [-121.86584, 37.25611], [-121.8662, 37.25613]]]} | Open Access 1 | 15665 | William H Cilker Park | 27545 | 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 | 1.574 | William H Cilker Park | 2004 | 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]);