units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
253 rows where MNG_AGENCY = 32 sorted by map descending
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL
DES_TP >30
ACCESS_TYP 2
- Open Access 247
- Restricted Access 6
MNG_AG_TYP 1
- City Agency 253
MNG_AGENCY 1
- San Jose, City of · 253 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
751 | 751 | 750 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30262], [-122.02649, 37.30263], [-122.02622, 37.30302], [-122.02611, 37.30314], [-122.02528, 37.30385], [-122.02406, 37.30433], [-122.02399, 37.30413], [-122.02384, 37.30385], [-122.0238, 37.30366], [-122.02375, 37.30168], [-122.0238, 37.30147], [-122.02381, 37.30133], [-122.02383, 37.30129], [-122.02389, 37.30126], [-122.02608, 37.30126], [-122.02635, 37.30123], [-122.02668, 37.30115], [-122.02681, 37.30115]]]} | Open Access 1 | 5576 | Calabazas | 16668 | 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 | 16.77 | Calabazas | 1978 | None 69 | ||
10636 | 10636 | 10635 | {"type": "Polygon", "coordinates": [[[-122.00954, 37.30075], [-122.00901, 37.30197], [-122.00665, 37.30109], [-122.0066, 37.30106], [-122.00659, 37.30103], [-122.00702, 37.29988], [-122.0071, 37.29985], [-122.00954, 37.30075]]]} | Open Access 1 | 18961 | Rainbow | 24083 | 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.476 | Rainbow | 1991 | None 935 | ||
10297 | 10297 | 10296 | {"type": "Polygon", "coordinates": [[[-121.99956, 37.30345], [-121.99939, 37.30349], [-121.99906, 37.30343], [-121.99898, 37.30362], [-121.99877, 37.30357], [-121.99874, 37.30348], [-121.99883, 37.30339], [-121.99878, 37.30332], [-121.99868, 37.303], [-121.99851, 37.30304], [-121.99837, 37.30345], [-121.99781, 37.3033], [-121.99669, 37.30278], [-121.99678, 37.30246], [-121.99697, 37.30198], [-121.99716, 37.30158], [-121.99765, 37.30171], [-121.99763, 37.30174], [-121.99763, 37.30179], [-121.99768, 37.30186], [-121.99784, 37.3019], [-121.9982, 37.30207], [-121.99856, 37.3022], [-121.99897, 37.30232], [-121.99986, 37.30254], [-121.99988, 37.30259], [-121.99956, 37.30345]]]} | Open Access 1 | 18130 | Murdock | 22602 | 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.508 | Murdock | None 898 | |||
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 | |
2589 | 2589 | 2588 | {"type": "Polygon", "coordinates": [[[-121.99104, 37.31833], [-121.99006, 37.31807], [-121.98956, 37.31796], [-121.98887, 37.31783], [-121.98886, 37.31751], [-121.9889, 37.31748], [-121.98891, 37.31744], [-121.98887, 37.3173], [-121.98888, 37.31598], [-121.9893, 37.31588], [-121.9898, 37.31567], [-121.98985, 37.31569], [-121.9901, 37.31583], [-121.99032, 37.3159], [-121.99056, 37.31593], [-121.99093, 37.31593], [-121.99095, 37.31829], [-121.99104, 37.3183], [-121.99104, 37.31833]]]} | Open Access 1 | 17931 | Mise | 22290 | 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.988 | Mise | 1968 | None 213 | ||
9566 | 9566 | 9565 | {"type": "Polygon", "coordinates": [[[-121.98081, 37.29674], [-121.97979, 37.29762], [-121.97973, 37.29764], [-121.97969, 37.29763], [-121.97888, 37.29703], [-121.97825, 37.29663], [-121.97823, 37.29659], [-121.97824, 37.29656], [-121.97929, 37.29565], [-121.98081, 37.29674]]]} | Open Access 1 | 16881 | Hathaway Park | 19736 | 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.253 | Hathaway Park | 1979 | Local Park 2 | 4 | |
5947 | 5947 | 5946 | {"type": "Polygon", "coordinates": [[[-121.97624, 37.27999], [-121.97415, 37.28001], [-121.97397, 37.27964], [-121.97428, 37.2795], [-121.97443, 37.27938], [-121.97475, 37.27908], [-121.97486, 37.27901], [-121.97499, 37.27896], [-121.97526, 37.27891], [-121.97613, 37.27893], [-121.97617, 37.27894], [-121.97619, 37.27898], [-121.97617, 37.27919], [-121.97624, 37.27999]]]} | Open Access 1 | 511 | San Tomas Park | 24995 | 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 | 4.806 | San Tomas Park | 1978 | 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 | |
9422 | 9422 | 9421 | {"type": "Polygon", "coordinates": [[[-121.96948, 37.42504], [-121.96911, 37.42631], [-121.96897, 37.42625], [-121.96621, 37.4255], [-121.96617, 37.42548], [-121.96616, 37.42544], [-121.96616, 37.42534], [-121.96674, 37.42526], [-121.9667, 37.42508], [-121.96711, 37.42501], [-121.96722, 37.42537], [-121.96863, 37.42514], [-121.96837, 37.42417], [-121.96898, 37.42432], [-121.96891, 37.42471], [-121.96948, 37.42504]]]} | Open Access 1 | 15752 | Alviso Park | 15432 | 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.581 | Alviso Park | 1968 | Local Park 2 | 4 | |
9664 | 9664 | 9663 | {"type": "Polygon", "coordinates": [[[-121.96605, 37.3077], [-121.96589, 37.30789], [-121.96586, 37.30806], [-121.96586, 37.3084], [-121.96581, 37.30846], [-121.96575, 37.30848], [-121.96447, 37.30856], [-121.96429, 37.30857], [-121.96425, 37.30855], [-121.96423, 37.30853], [-121.96423, 37.3085], [-121.96434, 37.30655], [-121.96605, 37.30654], [-121.96605, 37.3077]]]} | Open Access 1 | 16294 | Starbird Park | 25802 | 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.149 | Starbird Park | 1985 | Local Park 2 | 4 | |
14030 | 14030 | 14029 | {"type": "Polygon", "coordinates": [[[-121.96308, 37.29872], [-121.96265, 37.29819], [-121.96239, 37.29789], [-121.96265, 37.2979], [-121.96266, 37.29797], [-121.9628, 37.29824], [-121.96308, 37.29872]]]} | Open Access 1 | 38028 | Gleason Park | 19311 | 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.215 | Gleason Park | 0 | Local Park 2 | 4 | |
194 | 194 | 193 | {"type": "Polygon", "coordinates": [[[-121.94552, 37.31845], [-121.94347, 37.31848], [-121.94348, 37.31762], [-121.94351, 37.31759], [-121.94354, 37.31758], [-121.94357, 37.31766], [-121.94364, 37.31768], [-121.94368, 37.31766], [-121.9437, 37.31764], [-121.94369, 37.31755], [-121.94377, 37.31753], [-121.94543, 37.31734], [-121.94548, 37.31734], [-121.94551, 37.31739], [-121.94552, 37.31845]]]} | Open Access 1 | 550 | Santana Park | 25148 | 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.009 | Santana Park | 1978 | Local Park 2 | 4 | |
2316 | 2316 | 2315 | {"type": "Polygon", "coordinates": [[[-121.94309, 37.25721], [-121.943, 37.2574], [-121.94296, 37.25751], [-121.94294, 37.25764], [-121.94292, 37.25789], [-121.94181, 37.2579], [-121.94179, 37.25646], [-121.94054, 37.25646], [-121.94054, 37.25582], [-121.94051, 37.25566], [-121.9405, 37.25537], [-121.94076, 37.25537], [-121.94127, 37.25542], [-121.94178, 37.25552], [-121.94227, 37.25557], [-121.9426, 37.25557], [-121.94293, 37.2555], [-121.943, 37.25552], [-121.94325, 37.25587], [-121.94352, 37.25614], [-121.94371, 37.25629], [-121.94375, 37.25635], [-121.94376, 37.2564], [-121.94373, 37.25649], [-121.94321, 37.25706], [-121.94309, 37.25721]]]} | Open Access 1 | 16994 | Houge | 20107 | 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.677 | Houge | 1986 | None 194 | ||
9852 | 9852 | 9851 | {"type": "Polygon", "coordinates": [[[-121.94125, 37.30332], [-121.94129, 37.30339], [-121.94138, 37.30343], [-121.94151, 37.30339], [-121.943, 37.30339], [-121.94305, 37.30341], [-121.94307, 37.30345], [-121.94307, 37.30376], [-121.94308, 37.30507], [-121.94307, 37.3051], [-121.94302, 37.30512], [-121.94091, 37.30513], [-121.94087, 37.30332], [-121.94125, 37.30332]]]} | Open Access 1 | 16855 | Hamann | 19612 | 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 | 9.248 | Hamann | 1995 | None 854 | ||
7875 | 7875 | 7874 | {"type": "Polygon", "coordinates": [[[-121.94096, 37.40636], [-121.94091, 37.40636], [-121.94082, 37.40642], [-121.9408, 37.40647], [-121.93892, 37.40768], [-121.93888, 37.40767], [-121.93854, 37.40733], [-121.93855, 37.40728], [-121.94044, 37.4061], [-121.94048, 37.4061], [-121.94057, 37.40604], [-121.94058, 37.40601], [-121.94162, 37.40537], [-121.94169, 37.40537], [-121.94173, 37.4054], [-121.9422, 37.40604], [-121.94218, 37.4061], [-121.94197, 37.40619], [-121.94185, 37.4062], [-121.9416, 37.40617], [-121.94139, 37.40618], [-121.9412, 37.40623], [-121.94096, 37.40636]]]} | Open Access 1 | 9665 | Moitozo Park | 22348 | 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.125 | Moitozo Park | 2004 | 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 | |
7270 | 7270 | 7269 | {"type": "Polygon", "coordinates": [[[-121.93454, 37.26366], [-121.93454, 37.26383], [-121.93449, 37.26388], [-121.93447, 37.26395], [-121.93446, 37.2643], [-121.93449, 37.26439], [-121.93448, 37.26468], [-121.9316, 37.2647], [-121.9316, 37.26461], [-121.93187, 37.26459], [-121.93183, 37.26378], [-121.93196, 37.2638], [-121.93212, 37.26384], [-121.93211, 37.26389], [-121.93241, 37.26393], [-121.93261, 37.26393], [-121.93285, 37.26391], [-121.93302, 37.26387], [-121.93309, 37.26392], [-121.9331, 37.26427], [-121.93378, 37.26427], [-121.93379, 37.26407], [-121.93376, 37.26406], [-121.93375, 37.26376], [-121.93367, 37.26376], [-121.93365, 37.26359], [-121.93396, 37.26359], [-121.93396, 37.26373], [-121.93439, 37.26372], [-121.9344, 37.26367], [-121.93454, 37.26366]]]} | Open Access 1 | 6499 | Camden Park Center | 16755 | 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.013 | Camden Park Ctr. | 1961 | Local Recreation Area 3 | 4 | |
14027 | 14027 | 14026 | {"type": "Polygon", "coordinates": [[[-121.93192, 37.40428], [-121.93187, 37.40434], [-121.93178, 37.40435], [-121.92938, 37.40376], [-121.92932, 37.40372], [-121.92931, 37.40366], [-121.92942, 37.4035], [-121.92955, 37.40337], [-121.92971, 37.40326], [-121.9299, 37.40318], [-121.93015, 37.40311], [-121.93042, 37.40307], [-121.93068, 37.40308], [-121.93095, 37.40313], [-121.93119, 37.40321], [-121.93131, 37.40327], [-121.93152, 37.4034], [-121.9317, 37.40356], [-121.93182, 37.40372], [-121.93189, 37.40387], [-121.93193, 37.40412], [-121.93192, 37.40428]]]} | Open Access 1 | 38023 | River Oaks Park | 24414 | 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 | 4.994 | River Oaks Park | 0 | Local Park 2 | 4 | |
5929 | 5929 | 5928 | {"type": "Polygon", "coordinates": [[[-121.93019, 37.33171], [-121.92846, 37.33306], [-121.92699, 37.33185], [-121.92873, 37.3305], [-121.93019, 37.33171]]]} | Open Access 1 | 429 | San Jose Municipal Rose Garden | 24917 | 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 | 9.904 | San Jose Municipal Rose Garden | 1940 | Local Park 2 | 4 | |
5849 | 5849 | 5848 | {"type": "Polygon", "coordinates": [[[-121.93015, 37.41536], [-121.92815, 37.41536], [-121.92804, 37.41519], [-121.92703, 37.41523], [-121.92676, 37.41512], [-121.92641, 37.41467], [-121.92601, 37.41424], [-121.92596, 37.414], [-121.92589, 37.41339], [-121.92553, 37.41292], [-121.92524, 37.41279], [-121.92486, 37.4127], [-121.92436, 37.41249], [-121.92393, 37.41211], [-121.92327, 37.4112], [-121.92303, 37.41065], [-121.92305, 37.40999], [-121.92341, 37.40923], [-121.92362, 37.40871], [-121.92389, 37.40786], [-121.92406, 37.40779], [-121.92406, 37.40726], [-121.92401, 37.40682], [-121.9239, 37.40642], [-121.92378, 37.40617], [-121.92369, 37.406], [-121.92489, 37.4057], [-121.92501, 37.40591], [-121.92539, 37.4068], [-121.92564, 37.40746], [-121.9257, 37.40776], [-121.9257, 37.40794], [-121.92569, 37.40812], [-121.92565, 37.4083], [-121.92493, 37.41014], [-121.92491, 37.41025], [-121.9249, 37.41046], [-121.92495, 37.41068], [-121.92503, 37.41091], [-121.92512, 37.41106], [-121.92526, 37.41125], [-121.92569, 37.41165], [-121.92745, 37.4134], [-121.9279, 37.41382], [-121.92821, 37.41407], [-121.9286, 37.41435], [-121.92876, 37.41444], [-121.92929, 37.41467], [-121.92948, 37.41479], [-121.92974, 37.41498], [-121.93015, 37.41536]]]} | Open Access 1 | 181 | River Oaks | 24412 | 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 | 44.122 | River Oaks | 1981 | None 468 |
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]);