superunits_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)
PARK_URL 15 ✖
- http://www.sanjoseca.gov/Facilities?clear=True 2
- http://www.sanjoseca.gov/?nid=2819 1
- http://www.sanjoseca.gov/Facilities/Facility/Details/179 1
- http://www.sanjoseca.gov/Facilities/Facility/Details/187 1
- http://www.sanjoseca.gov/Facilities/Facility/Details/Dog-Parks-140 1
- http://www.sanjoseca.gov/Facilities/Facility/Details/Metcalf-Park-155 1
- http://www.sanjoseca.gov/Facilities/Facility/Details/Shady-Oaks-Park-157 1
- http://www.sanjoseca.gov/Facilities/Facility/Details/Sylvia-Cassell-Park-61 1
- http://www.sanjoseca.gov/Facilities/Facility/Details/Tully-Community-Ballfields-97 1
- http://www.sanjoseca.gov/index.aspx?NID=2821 1
- http://www.sanjoseca.gov/prns 1
- https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ 1
- https://www.sanjoseca.gov/Facilities/Facility/Details/126 1
- https://www.sanjoseca.gov/Home/Components/FacilityDirectory/FacilityDirectory/2945/37 1
- https://www.sanjoseca.gov/Home/Components/News/News/402/5103 1
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 | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2451 | 2451 | 2450 | {"type": "Polygon", "coordinates": [[[-122.02681, 37.30115], [-122.02645, 37.30261], [-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.02376, 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 | Calabazas | 16668 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 16.77 | Calabazas | 1978 | |
8468 | 8468 | 8467 | {"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 | Rainbow | 24083 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.475 | Rainbow | 1991 | |
7286 | 7286 | 7285 | {"type": "Polygon", "coordinates": [[[-121.99988, 37.30259], [-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.30175], [-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]]]} | Open Access 1 | Murdock | 22602 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.513 | Murdock | ||
4799 | 4799 | 4798 | {"type": "Polygon", "coordinates": [[[-121.99301, 37.30887], [-121.99266, 37.30927], [-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 | Gullo Park | 19567 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.509 | Gullo Park | 1987 | |
5936 | 5936 | 5935 | {"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.98986, 37.31569], [-121.9901, 37.31583], [-121.99032, 37.3159], [-121.99057, 37.31593], [-121.99093, 37.31593], [-121.99095, 37.31828], [-121.99104, 37.3183], [-121.99104, 37.31833]]]} | Open Access 1 | Mise | 22290 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 10.989 | Mise | 1968 | |
4961 | 4961 | 4960 | {"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 | Hathaway Park | 19736 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.253 | Hathaway Park | 1979 | |
9261 | 9261 | 9260 | {"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.27907], [-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 | San Tomas Park | 24995 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.804 | San Tomas Park | 1978 | |
4728 | 4728 | 4727 | {"type": "Polygon", "coordinates": [[[-121.97282, 37.30461], [-121.97236, 37.30462], [-121.97234, 37.30457], [-121.97223, 37.30457], [-121.97221, 37.3038], [-121.97282, 37.3038], [-121.97282, 37.30461]]]} | Open Access 1 | Green Thumb Community Garden | 19467 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.174 | Green Thumb Community Garden | ||
857 | 857 | 856 | {"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.96673, 37.42526], [-121.9667, 37.42508], [-121.96711, 37.42501], [-121.96723, 37.42536], [-121.96863, 37.42514], [-121.96837, 37.42417], [-121.96898, 37.42432], [-121.96891, 37.42472], [-121.96948, 37.42504]]]} | Open Access 1 | Alviso Park | 15432 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 6.598 | Alviso Park | 1968 | |
9919 | 9919 | 9918 | {"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.30856], [-121.96425, 37.30855], [-121.96423, 37.30853], [-121.96423, 37.30849], [-121.96434, 37.30655], [-121.96605, 37.30654], [-121.96605, 37.3077]]]} | Open Access 1 | Starbird Park | 25802 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 8.149 | Starbird Park | 1985 | |
4564 | 4564 | 4563 | {"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 | Gleason Park | 19311 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.215 | Gleason Park | ||
9337 | 9337 | 9336 | {"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.31765], [-121.94365, 37.31768], [-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 | Santana Park | 25148 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.009 | Santana Park | 1978 | |
5263 | 5263 | 5262 | {"type": "Polygon", "coordinates": [[[-121.94376, 37.2564], [-121.94373, 37.25649], [-121.94321, 37.25706], [-121.94309, 37.25721], [-121.943, 37.2574], [-121.94296, 37.25752], [-121.94294, 37.25764], [-121.94292, 37.25789], [-121.94181, 37.2579], [-121.94179, 37.25647], [-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.94376, 37.2564]]]} | Open Access 1 | Houge | 20107 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 11.686 | Houge | 1986 | |
4850 | 4850 | 4849 | {"type": "Polygon", "coordinates": [[[-121.94307, 37.3051], [-121.94302, 37.30512], [-121.94091, 37.30513], [-121.94087, 37.30332], [-121.94125, 37.30332], [-121.94129, 37.30339], [-121.94139, 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]]]} | Open Access 1 | Hamann | 19612 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.248 | Hamann | 1995 | |
7092 | 7092 | 7091 | {"type": "Polygon", "coordinates": [[[-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], [-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.93856, 37.40728], [-121.94044, 37.4061], [-121.94048, 37.40609], [-121.94057, 37.40604], [-121.94058, 37.40601], [-121.94162, 37.40537], [-121.94169, 37.40537], [-121.94173, 37.4054], [-121.9422, 37.40604]]]} | Open Access 1 | Moitozo Park | 22348 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.125 | Moitozo Park | 2004 | |
2643 | 2643 | 2642 | {"type": "Polygon", "coordinates": [[[-121.9386, 37.25096], [-121.93856, 37.25097], [-121.93856, 37.25136], [-121.93859, 37.25139], [-121.93853, 37.2516], [-121.93847, 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 | Carolyn Norris Park | 16888 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.303 | Carolyn Norris Park | ||
1809 | 1809 | 1808 | {"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.93212, 37.26389], [-121.93241, 37.26393], [-121.93262, 37.26393], [-121.93285, 37.26391], [-121.93302, 37.26387], [-121.93309, 37.26392], [-121.9331, 37.26427], [-121.93377, 37.26427], [-121.93379, 37.26408], [-121.93376, 37.26406], [-121.93375, 37.26377], [-121.93367, 37.26376], [-121.93365, 37.26359], [-121.93396, 37.26359], [-121.93397, 37.26373], [-121.93438, 37.26372], [-121.9344, 37.26367], [-121.93454, 37.26366]]]} | Open Access 1 | Camden Park Center | 16755 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.024 | Camden Park Ctr. | 1961 | |
8754 | 8754 | 8753 | {"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.92972, 37.40326], [-121.9299, 37.40318], [-121.93015, 37.40311], [-121.93042, 37.40308], [-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 | River Oaks Park | 24414 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 4.994 | River Oaks Park | ||
7781 | 7781 | 7780 | {"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 | San Jose Municipal Rose Garden | 24917 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 9.903 | San Jose Municipal Rose Garden | 1940 | |
7395 | 7395 | 7394 | {"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.92523, 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.40778], [-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.92491, 37.41046], [-121.92495, 37.41068], [-121.92503, 37.41091], [-121.92512, 37.41107], [-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 | River Oaks | 24412 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 44.124 | River Oaks | 1981 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);