superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where MNG_AGENCY = 152 sorted by map descending
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
871 | 871 | 870 | {"type": "Polygon", "coordinates": [[[-119.42089, 36.35261], [-119.42092, 36.35277], [-119.42091, 36.35293], [-119.42085, 36.35317], [-119.42004, 36.35376], [-119.41908, 36.35453], [-119.41863, 36.35485], [-119.41864, 36.35473], [-119.41817, 36.35426], [-119.41801, 36.35403], [-119.41795, 36.35386], [-119.41791, 36.35368], [-119.41791, 36.35276], [-119.4179, 36.35273], [-119.41786, 36.35271], [-119.41791, 36.35264], [-119.41873, 36.35262], [-119.42089, 36.35261]]]} | Open Access 1 | Goshen Park | 32745 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 10.717 | Goshen Park | ||
8241 | 8241 | 8240 | {"type": "Polygon", "coordinates": [[[-119.39303, 36.32471], [-119.39295, 36.32489], [-119.3927, 36.32484], [-119.39045, 36.32479], [-119.39025, 36.32471], [-119.39042, 36.3243], [-119.3902, 36.32419], [-119.39003, 36.32446], [-119.38997, 36.3248], [-119.38972, 36.3248], [-119.38943, 36.32484], [-119.38905, 36.325], [-119.38869, 36.32501], [-119.38834, 36.32486], [-119.38818, 36.32466], [-119.38794, 36.32414], [-119.3879, 36.32397], [-119.38792, 36.32382], [-119.38827, 36.32255], [-119.38842, 36.32226], [-119.38852, 36.32213], [-119.38869, 36.32201], [-119.38888, 36.32191], [-119.38905, 36.32185], [-119.38952, 36.32175], [-119.38983, 36.32163], [-119.38997, 36.32155], [-119.39026, 36.32131], [-119.39047, 36.32109], [-119.39063, 36.32115], [-119.39073, 36.32123], [-119.39297, 36.3245], [-119.39303, 36.32471]]]} | Open Access 1 | Plaza Park | 23789 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 30.74 | Plaza Park | ||
14577 | 14577 | 14576 | {"type": "Polygon", "coordinates": [[[-119.39039, 36.3206], [-119.39036, 36.32078], [-119.3903, 36.32093], [-119.39015, 36.32116], [-119.39001, 36.3213], [-119.38987, 36.32141], [-119.38968, 36.32151], [-119.38952, 36.32157], [-119.38896, 36.3217], [-119.38874, 36.32178], [-119.38849, 36.32193], [-119.38828, 36.32212], [-119.38817, 36.32228], [-119.38808, 36.32248], [-119.3877, 36.32389], [-119.3877, 36.32402], [-119.38774, 36.32416], [-119.38802, 36.32477], [-119.3881, 36.32488], [-119.38818, 36.32496], [-119.38839, 36.32509], [-119.38864, 36.32517], [-119.38891, 36.32519], [-119.38914, 36.32514], [-119.38954, 36.32498], [-119.38968, 36.32496], [-119.38995, 36.32496], [-119.3898, 36.32615], [-119.38881, 36.32651], [-119.3882, 36.32664], [-119.38769, 36.3267], [-119.38715, 36.32673], [-119.38555, 36.32675], [-119.38466, 36.32696], [-119.38131, 36.32696], [-119.38114, 36.32683], [-119.38113, 36.32424], [-119.38315, 36.32421], [-119.38393, 36.32363], [-119.38553, 36.32297], [-119.39014, 36.32073], [-119.39013, 36.32072], [-119.39, 36.32078], [-119.38553, 36.32294], [-119.38391, 36.32361], [-119.38313, 36.32419], [-119.38113, 36.32421], [-119.3811, 36.31994], [-119.38099, 36.31272], [-119.38131, 36.31274], [-119.38155, 36.31279], [-119.38178, 36.3129], [-119.38549, 36.31585], [-119.38569, 36.31605], [-119.38727, 36.3181], [-119.38829, 36.31895], [-119.38855, 36.31913], [-119.38879, 36.31924], [-119.38901, 36.31932], [-119.38949, 36.31943], [-119.38976, 36.31954], [-119.39004, 36.31974], [-119.3902, 36.31992], [-119.3903, 36.32009], [-119.39038, 36.32034], [-119.39039, 36.3206]]]} | Restricted Access 2 | Valley Oaks Golf Course | 32996 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 215.344 | Valley Oaks GC | ||
873 | 873 | 872 | {"type": "Polygon", "coordinates": [[[-119.36509, 36.35194], [-119.36331, 36.35195], [-119.36331, 36.35173], [-119.36327, 36.3517], [-119.36329, 36.35165], [-119.3633, 36.3516], [-119.36324, 36.35151], [-119.36316, 36.35148], [-119.3631, 36.35147], [-119.36304, 36.35149], [-119.36293, 36.35154], [-119.36271, 36.35155], [-119.36271, 36.35115], [-119.36509, 36.35113], [-119.36509, 36.35194]]]} | Open Access 1 | Lions Park | 32747 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 4.108 | Lions Park | ||
874 | 874 | 873 | {"type": "Polygon", "coordinates": [[[-119.35977, 36.34883], [-119.35927, 36.34978], [-119.3591, 36.35014], [-119.35896, 36.35051], [-119.35885, 36.35089], [-119.35884, 36.34908], [-119.35926, 36.34907], [-119.35929, 36.34912], [-119.35936, 36.34916], [-119.35949, 36.34916], [-119.35958, 36.3491], [-119.35961, 36.34901], [-119.35958, 36.34894], [-119.35948, 36.34887], [-119.35944, 36.34882], [-119.35977, 36.34883]]]} | Open Access 1 | Foxwood Park | 32748 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.62 | Foxwood Park | ||
10133 | 10133 | 10132 | {"type": "Polygon", "coordinates": [[[-119.35845, 36.30491], [-119.35812, 36.30491], [-119.35813, 36.30483], [-119.35808, 36.30476], [-119.35794, 36.30469], [-119.35539, 36.30267], [-119.35521, 36.30254], [-119.35495, 36.30239], [-119.3547, 36.30229], [-119.35443, 36.30221], [-119.35415, 36.30216], [-119.35414, 36.30183], [-119.35841, 36.30181], [-119.35845, 36.30491]]]} | Open Access 1 | Sunset Park | 26060 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 17.014 | Sunset Park | ||
11277 | 11277 | 11276 | {"type": "Polygon", "coordinates": [[[-119.34958, 36.33435], [-119.34956, 36.33439], [-119.34951, 36.3344], [-119.34774, 36.33434], [-119.34772, 36.33358], [-119.34958, 36.33356], [-119.34958, 36.33435]]]} | Open Access 1 | Willow Glen Park | 27579 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 3.667 | Willow Glen Park | ||
3128 | 3128 | 3127 | {"type": "Polygon", "coordinates": [[[-119.34929, 36.30185], [-119.34928, 36.30188], [-119.34637, 36.30189], [-119.34623, 36.30204], [-119.34614, 36.3037], [-119.34592, 36.30409], [-119.34458, 36.3041], [-119.34457, 36.30187], [-119.34929, 36.30185]]]} | Open Access 1 | Combs Park | 17558 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 8.931 | Combs Park | ||
3164 | 3164 | 3163 | {"type": "Polygon", "coordinates": [[[-119.34659, 36.32123], [-119.34577, 36.32123], [-119.34577, 36.32019], [-119.34579, 36.32016], [-119.34582, 36.32014], [-119.34658, 36.32014], [-119.34659, 36.32123]]]} | Open Access 1 | Constitution Park | 17600 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.173 | Constitution Park | ||
6233 | 6233 | 6232 | {"type": "Polygon", "coordinates": [[[-119.34315, 36.30141], [-119.34314, 36.30324], [-119.34078, 36.3032], [-119.34078, 36.30277], [-119.34081, 36.30223], [-119.34239, 36.30224], [-119.3424, 36.30142], [-119.34315, 36.30141]]]} | Open Access 1 | Linwood Park | 21309 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 7.236 | Linwood Park | ||
9784 | 9784 | 9783 | {"type": "Polygon", "coordinates": [[[-119.34092, 36.34566], [-119.34091, 36.34637], [-119.3409, 36.3464], [-119.34039, 36.3464], [-119.34037, 36.3468], [-119.33919, 36.34679], [-119.3392, 36.34562], [-119.34087, 36.34561], [-119.3409, 36.34563], [-119.34092, 36.34566]]]} | Open Access 1 | Soroptimist Park | 25630 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 4.469 | Soroptimist Park | ||
7923 | 7923 | 7922 | {"type": "Polygon", "coordinates": [[[-119.3361, 36.32834], [-119.33548, 36.3282], [-119.33497, 36.32802], [-119.33446, 36.32808], [-119.33395, 36.32829], [-119.3334, 36.32801], [-119.333, 36.32823], [-119.333, 36.32775], [-119.33365, 36.32777], [-119.33527, 36.3279], [-119.33595, 36.32792], [-119.33604, 36.328], [-119.3361, 36.32834]]]} | Open Access 1 | Pappas Park | 23397 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.363 | Pappas Park | ||
878 | 878 | 877 | {"type": "Polygon", "coordinates": [[[-119.32391, 36.29146], [-119.32376, 36.29169], [-119.32378, 36.29355], [-119.32307, 36.29357], [-119.32316, 36.29408], [-119.32306, 36.29433], [-119.3229, 36.29447], [-119.32267, 36.29453], [-119.32262, 36.29411], [-119.32249, 36.29357], [-119.32246, 36.29324], [-119.32246, 36.29226], [-119.32249, 36.29199], [-119.32261, 36.29152], [-119.32267, 36.29147], [-119.32391, 36.29146]]]} | Open Access 1 | Perry Family Park | 32750 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 7.787 | Perry Family Park | ||
3331 | 3331 | 3330 | {"type": "Polygon", "coordinates": [[[-119.32356, 36.30552], [-119.32287, 36.30553], [-119.32282, 36.3055], [-119.3228, 36.3045], [-119.32354, 36.30449], [-119.32356, 36.30552]]]} | Open Access 1 | Crestwood Park | 17818 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.875 | Crestwood Park | ||
5266 | 5266 | 5265 | {"type": "Polygon", "coordinates": [[[-119.32059, 36.31705], [-119.31845, 36.31707], [-119.31844, 36.31672], [-119.31846, 36.31669], [-119.3185, 36.31668], [-119.31886, 36.31665], [-119.31915, 36.31658], [-119.31938, 36.31649], [-119.31967, 36.31631], [-119.31972, 36.3163], [-119.31976, 36.31631], [-119.32041, 36.31694], [-119.32059, 36.31705]]]} | Open Access 1 | Houk Park | 20110 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.392 | Houk Park | ||
11394 | 11394 | 11393 | {"type": "Polygon", "coordinates": [[[-119.31991, 36.34516], [-119.31941, 36.3452], [-119.3189, 36.34532], [-119.3191, 36.34604], [-119.31831, 36.34616], [-119.31821, 36.34592], [-119.31813, 36.34563], [-119.31804, 36.34512], [-119.31802, 36.34482], [-119.31803, 36.34452], [-119.31805, 36.3443], [-119.3181, 36.34409], [-119.31853, 36.34412], [-119.31879, 36.34412], [-119.3191, 36.34408], [-119.31943, 36.34402], [-119.31956, 36.34428], [-119.31981, 36.34472], [-119.31988, 36.34495], [-119.31991, 36.34516]]]} | Open Access 1 | Woodland Park | 27725 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 6.579 | Woodland Park | ||
6928 | 6928 | 6927 | {"type": "Polygon", "coordinates": [[[-119.30992, 36.33057], [-119.30889, 36.33058], [-119.30888, 36.33016], [-119.30991, 36.33016], [-119.30992, 36.33057]]]} | Open Access 1 | Memorial Park | 22138 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1.045 | Memorial Park | ||
6784 | 6784 | 6783 | {"type": "Polygon", "coordinates": [[[-119.30991, 36.32998], [-119.30897, 36.32998], [-119.30897, 36.32962], [-119.30898, 36.32964], [-119.30915, 36.32973], [-119.30944, 36.32981], [-119.30991, 36.32996], [-119.30991, 36.32998]]]} | Open Access 1 | Mayors Park | 21981 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 0.39 | Mayors Park | ||
9023 | 9023 | 9022 | {"type": "Polygon", "coordinates": [[[-119.30973, 36.31657], [-119.30811, 36.31656], [-119.30811, 36.31599], [-119.3087, 36.31599], [-119.30871, 36.31591], [-119.30973, 36.31592], [-119.30973, 36.31657]]]} | Open Access 1 | Rotary Park | 24697 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 2.505 | Rotary Park | ||
9993 | 9993 | 9992 | {"type": "Polygon", "coordinates": [[[-119.30678, 36.30204], [-119.30556, 36.30202], [-119.30554, 36.30206], [-119.30455, 36.30206], [-119.30455, 36.30179], [-119.30458, 36.30169], [-119.30456, 36.30161], [-119.3045, 36.30156], [-119.30442, 36.30154], [-119.30425, 36.30158], [-119.30424, 36.30102], [-119.30419, 36.30097], [-119.30423, 36.30092], [-119.30424, 36.30087], [-119.30423, 36.30081], [-119.30419, 36.30076], [-119.30424, 36.30071], [-119.30424, 36.30015], [-119.30526, 36.30015], [-119.30582, 36.30025], [-119.3066, 36.30025], [-119.30664, 36.30027], [-119.30667, 36.3003], [-119.30668, 36.30138], [-119.30664, 36.3015], [-119.30668, 36.30158], [-119.30678, 36.30163], [-119.30678, 36.30204]]]} | Open Access 1 | Stonebrook Park | 25883 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 10.793 | Stonebrook Park |
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]);