units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 and MNG_AG_TYP = 2 sorted by YR_EST
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 2
- Open Access 227
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 233 ✖
MNG_AGENCY 1
- San Jose, City of · 233 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3836 | 3836 | 3835 | {"type": "Polygon", "coordinates": [[[-121.79521, 37.26427], [-121.79424, 37.26476], [-121.79239, 37.26413], [-121.79167, 37.2636], [-121.7931, 37.26341], [-121.79449, 37.26319], [-121.79503, 37.26315], [-121.79521, 37.26427]]]} | Open Access 1 | 45387 | Shady Oaks Park | 27915 | 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 | http://www.sanjoseca.gov/Facilities/Facility/Details/Shady-Oaks-Park-157 | Santa Clara 19 | 8.29 | Shady Oaks Park | 0 | Local Park 2 | 4 |
3837 | 3837 | 3836 | {"type": "Polygon", "coordinates": [[[-121.81525, 37.30826], [-121.81558, 37.30859], [-121.81559, 37.30863], [-121.81499, 37.30902], [-121.81463, 37.30865], [-121.81525, 37.30826]]]} | Open Access 1 | 45391 | West Evergreen Park | 27916 | 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 | http://www.sanjoseca.gov/Facilities?clear=True | Santa Clara 19 | 0.9 | West Evergreen Park | 0 | Local Park 2 | 4 |
3972 | 3972 | 3971 | {"type": "Polygon", "coordinates": [[[-121.79739, 37.24527], [-121.79676, 37.24527], [-121.79675, 37.24494], [-121.79681, 37.24492], [-121.79681, 37.24487], [-121.79675, 37.24487], [-121.79673, 37.2445], [-121.79688, 37.24449], [-121.79687, 37.24443], [-121.79682, 37.24427], [-121.79614, 37.24386], [-121.79566, 37.24437], [-121.79468, 37.24377], [-121.794, 37.24379], [-121.79391, 37.24089], [-121.79399, 37.24085], [-121.79408, 37.24088], [-121.79423, 37.24107], [-121.79431, 37.24129], [-121.79433, 37.24143], [-121.79439, 37.24301], [-121.79443, 37.24317], [-121.79455, 37.24339], [-121.79467, 37.24352], [-121.79482, 37.24362], [-121.79498, 37.24371], [-121.79517, 37.24377], [-121.79545, 37.2438], [-121.79596, 37.24376], [-121.79613, 37.24376], [-121.79639, 37.24382], [-121.79661, 37.24393], [-121.79674, 37.24403], [-121.79688, 37.24421], [-121.79694, 37.24434], [-121.79701, 37.2446], [-121.79708, 37.24479], [-121.79732, 37.24518], [-121.79739, 37.24527]]]} | Open Access 1 | 38004 | Raleigh Park | 24095 | 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 | 5.429 | Raleigh Park | 0 | Local Park 2 | 4 | |
3974 | 3974 | 3973 | {"type": "Polygon", "coordinates": [[[-121.80056, 37.25232], [-121.79928, 37.25154], [-121.79891, 37.25141], [-121.79868, 37.25121], [-121.79825, 37.25096], [-121.79925, 37.25094], [-121.79923, 37.24979], [-121.80095, 37.24977], [-121.80099, 37.24979], [-121.80102, 37.25092], [-121.80104, 37.25108], [-121.80112, 37.25129], [-121.80121, 37.25143], [-121.80131, 37.25154], [-121.80132, 37.25157], [-121.80065, 37.25231], [-121.80061, 37.25233], [-121.80056, 37.25232]]]} | Open Access 1 | 38006 | RMAC Park | 24473 | 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 | 10.55 | RMAC Park | 0 | Local Park 2 | 4 | |
3977 | 3977 | 3976 | {"type": "Polygon", "coordinates": [[[-121.85453, 37.34889], [-121.85442, 37.34894], [-121.85423, 37.34868], [-121.85434, 37.34863], [-121.85453, 37.34889]]]} | Open Access 1 | 48844 | San Antonio Tot Lot | 33564 | 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/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 | Santa Clara 19 | 0.09 | San Antonio Tot Lot | 0 | Local Recreation Area 3 | 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 | |
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 | |
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 | |
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 | |
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 | |
4313 | 4313 | 4312 | {"type": "Polygon", "coordinates": [[[-121.84378, 37.30875], [-121.84355, 37.30896], [-121.84336, 37.30881], [-121.84333, 37.30882], [-121.84321, 37.30875], [-121.84336, 37.3085], [-121.84378, 37.30875]]]} | Open Access 1 | 45393 | La Raggione Tot Lot | 27912 | 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 | http://www.sanjoseca.gov/Facilities?clear=True | Santa Clara 19 | 0.304 | La Raggione Tot Lot | 0 | Local Recreation Area 3 | 4 |
4314 | 4314 | 4313 | {"type": "Polygon", "coordinates": [[[-121.89634, 37.32873], [-121.89614, 37.32883], [-121.89583, 37.32829], [-121.8955, 37.32782], [-121.89562, 37.32786], [-121.89574, 37.32795], [-121.89634, 37.32873]]]} | Open Access 1 | 45398 | Delmas Dog Park | 27904 | 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 | http://www.sanjoseca.gov/Facilities/Facility/Details/Dog-Parks-140 | Santa Clara 19 | 0.426 | Delmas Dog Park | 0 | Local Park 2 | 4 |
5569 | 5569 | 5568 | {"type": "MultiPolygon", "coordinates": [[[[-121.90397, 37.34203], [-121.90269, 37.34294], [-121.90249, 37.34308], [-121.90226, 37.34254], [-121.90227, 37.34201], [-121.90224, 37.34179], [-121.90229, 37.3414], [-121.90234, 37.34138], [-121.90229, 37.34169], [-121.90264, 37.34146], [-121.90296, 37.34174], [-121.90337, 37.34147], [-121.90397, 37.34203]]], [[[-121.90391, 37.34388], [-121.90321, 37.34435], [-121.903, 37.34414], [-121.90284, 37.34392], [-121.90256, 37.34325], [-121.90293, 37.34299], [-121.90391, 37.34388]]], [[[-121.90512, 37.34306], [-121.90407, 37.34377], [-121.90308, 37.34288], [-121.90411, 37.34215], [-121.90512, 37.34306]]], [[[-121.90518, 37.34118], [-121.90413, 37.34192], [-121.90341, 37.34126], [-121.90339, 37.34122], [-121.9034, 37.34117], [-121.90344, 37.34114], [-121.90364, 37.34109], [-121.90415, 37.34099], [-121.90487, 37.3409], [-121.90518, 37.34118]]], [[[-121.90478, 37.34466], [-121.90413, 37.34511], [-121.9034, 37.34451], [-121.90409, 37.34404], [-121.90478, 37.34466]]], [[[-121.90598, 37.34384], [-121.90494, 37.34455], [-121.90425, 37.34393], [-121.9053, 37.34323], [-121.90598, 37.34384]]], [[[-121.90634, 37.34222], [-121.90528, 37.34296], [-121.90427, 37.34204], [-121.90532, 37.34131], [-121.90634, 37.34222]]], [[[-121.90587, 37.34564], [-121.90522, 37.34609], [-121.90516, 37.34604], [-121.90503, 37.34613], [-121.90482, 37.34598], [-121.90474, 37.34591], [-121.90467, 37.34581], [-121.90456, 37.34558], [-121.90447, 37.34544], [-121.90428, 37.34522], [-121.90492, 37.34478], [-121.90587, 37.34564]]], [[[-121.90612, 37.34396], [-121.90706, 37.34481], [-121.90708, 37.34484], [-121.90705, 37.34488], [-121.90603, 37.34554], [-121.90507, 37.34468], [-121.90612, 37.34396]]], [[[-121.90715, 37.34164], [-121.90652, 37.34209], [-121.90543, 37.34112], [-121.90579, 37.34087], [-121.90583, 37.34087], [-121.90621, 37.34121], [-121.90635, 37.34112], [-121.90668, 37.34142], [-121.90693, 37.34124], [-121.90707, 37.34137], [-121.90695, 37.34146], [-121.90715, 37.34164]]], [[[-121.90801, 37.34242], [-121.90751, 37.34279], [-121.90718, 37.34248], [-121.90703, 37.34257], [-121.9067, 37.34226], [-121.90721, 37.3419], [-121.90755, 37.34221], [-121.90768, 37.34212], [-121.90801, 37.34242]]]]} | Open Access 1 | 29145 | Guadalupe River Park | 19558 | 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 | 31.407 | Guadalupe River Park | 0 | Local Park 2 | 4 | |
6121 | 6121 | 6120 | {"type": "MultiPolygon", "coordinates": [[[[-121.89071, 37.33999], [-121.88974, 37.33869], [-121.89053, 37.33832], [-121.89059, 37.33834], [-121.89151, 37.33957], [-121.89148, 37.33962], [-121.89071, 37.33999]], [[-121.891, 37.33929], [-121.891, 37.33928], [-121.89082, 37.33922], [-121.89078, 37.3393], [-121.89069, 37.33928], [-121.89076, 37.33909], [-121.89046, 37.33901], [-121.89038, 37.33919], [-121.89058, 37.33925], [-121.89053, 37.3394], [-121.89057, 37.33942], [-121.89052, 37.33957], [-121.8907, 37.33961], [-121.89068, 37.33968], [-121.89085, 37.33974], [-121.89087, 37.3397], [-121.89106, 37.33974], [-121.89119, 37.33943], [-121.89118, 37.33941], [-121.89097, 37.33936], [-121.891, 37.33929]]], [[[-121.89259, 37.33909], [-121.89183, 37.33945], [-121.89176, 37.33945], [-121.89084, 37.33823], [-121.89084, 37.33818], [-121.89086, 37.33815], [-121.89162, 37.33779], [-121.89259, 37.33909]]]]} | Open Access 1 | 1091 | St. James Park | 25766 | 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 | 6.283 | St. James Park | 0 | Local Park 2 | 4 | |
7530 | 7530 | 7529 | {"type": "Polygon", "coordinates": [[[-121.76202, 37.3228], [-121.76181, 37.32286], [-121.76161, 37.32298], [-121.76142, 37.32279], [-121.76175, 37.32258], [-121.76187, 37.32271], [-121.76202, 37.3228]]]} | Open Access 1 | 9183 | Pocket Park No. 8 | 23838 | 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.273 | PP No. 8 | 0 | Local Park 2 | 4 | |
7787 | 7787 | 7786 | {"type": "Polygon", "coordinates": [[[-121.84487, 37.36184], [-121.84462, 37.362], [-121.8445, 37.36188], [-121.84451, 37.36186], [-121.84448, 37.36183], [-121.84446, 37.36184], [-121.84431, 37.36167], [-121.84456, 37.36152], [-121.84463, 37.36159], [-121.84462, 37.36161], [-121.84469, 37.36168], [-121.84471, 37.36167], [-121.84473, 37.3617], [-121.84472, 37.36172], [-121.84475, 37.36174], [-121.84477, 37.36174], [-121.84487, 37.36184]]]} | Open Access 1 | 47664 | Jackson Madden Park | 31404 | 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 | http://www.sanjoseca.gov/Facilities/Facility/Details/187 | Santa Clara 19 | 0.311 | Jackson Madden Park | 0 | 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 | |
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 | |
8193 | 8193 | 8192 | {"type": "Polygon", "coordinates": [[[-121.76509, 37.32215], [-121.7655, 37.32231], [-121.7656, 37.32238], [-121.7656, 37.32244], [-121.76549, 37.32254], [-121.76537, 37.32259], [-121.76523, 37.3226], [-121.76507, 37.32258], [-121.76509, 37.32215]]]} | Open Access 1 | 9147 | Pocket Park No. 5 | 23835 | 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.395 | PP No. 5 | 0 | Local Park 2 | 4 | |
8542 | 8542 | 8541 | {"type": "MultiPolygon", "coordinates": [[[[-121.90847, 37.34424], [-121.90854, 37.34426], [-121.90928, 37.34492], [-121.9093, 37.34496], [-121.9093, 37.34499], [-121.90788, 37.34598], [-121.9071, 37.34525], [-121.90708, 37.3452], [-121.90843, 37.34425], [-121.90847, 37.34424]]], [[[-121.91054, 37.34412], [-121.90959, 37.34479], [-121.90952, 37.34481], [-121.90945, 37.34479], [-121.90871, 37.34414], [-121.90869, 37.34409], [-121.90872, 37.34405], [-121.90972, 37.34339], [-121.90975, 37.34339], [-121.91054, 37.34412]]]]} | Open Access 1 | 13459 | Columbus Park | 17551 | 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.017 | Columbus Park | 0 | 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]);