superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where YR_EST = 2017 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13113 | 13113 | 13112 | {"type": "Polygon", "coordinates": [[[-117.29467, 34.11611], [-117.29454, 34.11613], [-117.29453, 34.11634], [-117.2943, 34.11635], [-117.29429, 34.11591], [-117.29467, 34.11591], [-117.29467, 34.11611]]]} | Open Access 1 | Jon Cole Skate Park | 31759 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 0.337 | Jon Cole Skate Park | 2017 | |
13506 | 13506 | 13505 | {"type": "Polygon", "coordinates": [[[-118.31128, 33.78746], [-118.31096, 33.78747], [-118.31095, 33.78696], [-118.31128, 33.78696], [-118.31128, 33.78746]]]} | Open Access 1 | Louis and William J. Teuchert Park | http://www.lomita.com/cityhall/government/parksrec/index.cfm?p=Teuchert/Teuchert.cfm&h=m | 32662 | 1182 | Lomita, City of 454 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm | City 2 | 0.42 | Louis and William J. Teuchert Park | 2017 |
14050 | 14050 | 14049 | {"type": "Polygon", "coordinates": [[[-116.46046, 33.95158], [-116.4604, 33.95167], [-116.45955, 33.95175], [-116.45948, 33.95163], [-116.45951, 33.95157], [-116.45952, 33.9515], [-116.4595, 33.95145], [-116.45946, 33.95142], [-116.45931, 33.95138], [-116.45924, 33.95117], [-116.45937, 33.95129], [-116.45982, 33.9515], [-116.46046, 33.95158]]]} | Open Access 1 | Rotary Dog Park | 32625 | 1670 | Desert Hot Springs, City of 630 | City 2 | City Agency 2 | http://www.cityofdhs.org/ | City 2 | 0.555 | Rotary Dog Park | 2017 | |
875 | 875 | 874 | {"type": "Polygon", "coordinates": [[[-119.29982, 36.32794], [-119.29965, 36.32791], [-119.2994, 36.32779], [-119.29924, 36.32763], [-119.29911, 36.32757], [-119.29892, 36.32754], [-119.29892, 36.32746], [-119.29982, 36.32746], [-119.29982, 36.32794]]]} | Open Access 1 | Miki City Park | 32749 | 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.631 | Miki City Park | 2017 | |
13098 | 13098 | 13097 | {"type": "Polygon", "coordinates": [[[-118.33945, 33.91357], [-118.33843, 33.91357], [-118.33843, 33.91322], [-118.33945, 33.91321], [-118.33945, 33.91357]]]} | Open Access 1 | Bicentennial Park | 33375 | 1130 | Hawthorne, City of 295 | City 2 | City Agency 2 | http://www.cityofhawthorne.com/ | City 2 | 0.91 | Bicentennial Park | 2017 | |
52 | 52 | 51 | {"type": "Polygon", "coordinates": [[[-122.41621, 37.76434], [-122.41588, 37.76436], [-122.41587, 37.76447], [-122.41537, 37.7645], [-122.41531, 37.76377], [-122.41615, 37.76372], [-122.41621, 37.76434]]]} | Open Access 1 | In Chan Kaajal Park | http://sfrecpark.org/project/proposed-park-site-at-17th-and-folsom/ | 31768 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1.398 | In Chan Kaajal Park | 2017 |
7023 | 7023 | 7022 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31456], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | Tamien Park | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | 33676 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.591 | Tamien Park | 2017 |
13501 | 13501 | 13500 | {"type": "Polygon", "coordinates": [[[-117.8668, 34.11468], [-117.86563, 34.11468], [-117.86563, 34.11404], [-117.86679, 34.11404], [-117.8668, 34.11468]]]} | Open Access 1 | Arboretum And Botanic Garden | 32644 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 1.866 | Arboretum And Botanic Garden | 2017 | |
14439 | 14439 | 14438 | {"type": "Polygon", "coordinates": [[[-121.28222, 38.81572], [-121.28171, 38.81595], [-121.28168, 38.81588], [-121.28158, 38.8158], [-121.28132, 38.81542], [-121.28105, 38.81507], [-121.28097, 38.81499], [-121.28084, 38.81488], [-121.2808, 38.81481], [-121.28072, 38.81477], [-121.28065, 38.81477], [-121.28057, 38.81481], [-121.28053, 38.81488], [-121.28047, 38.81488], [-121.28041, 38.8148], [-121.28124, 38.81442], [-121.28222, 38.81572]]]} | Open Access 1 | Wickman Park | 33742 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 2.226 | Wickman Park | 2017 | |
13923 | 13923 | 13922 | {"type": "Polygon", "coordinates": [[[-118.46481, 34.02853], [-118.4639, 34.02872], [-118.46352, 34.02864], [-118.46131, 34.02909], [-118.46102, 34.02931], [-118.46054, 34.02941], [-118.46045, 34.02911], [-118.46466, 34.02825], [-118.46471, 34.02825], [-118.46473, 34.02828], [-118.46481, 34.02853]]]} | Open Access 1 | Ishihara Park | https://www.smgov.net/Departments/CCS/content.aspx?id=53687098200 | 32517 | 1323 | Santa Monica, City of 180 | City 2 | City Agency 2 | http://santa-monica.org/departments/ccs/content.aspx?id=32599 | City 2 | 2.359 | Ishihara Park | 2017 |
11558 | 11558 | 11557 | {"type": "Polygon", "coordinates": [[[-119.63172, 36.30132], [-119.63125, 36.30132], [-119.63131, 36.30113], [-119.63134, 36.30093], [-119.63132, 36.29873], [-119.63169, 36.29874], [-119.63172, 36.30132]]]} | Open Access 1 | Home Garden Community Park | 28022 | 2342 | Home Garden Community Services District 1075 | Special District 4 | Community Services District 17 | http://www.cset.org/ | Special District 4 | 2.423 | Home Garden Community Park | 2017 | |
35 | 35 | 34 | {"type": "Polygon", "coordinates": [[[-117.29529, 34.117], [-117.29481, 34.11701], [-117.29479, 34.11703], [-117.2943, 34.11703], [-117.2943, 34.11635], [-117.29453, 34.11634], [-117.29454, 34.11612], [-117.29467, 34.1161], [-117.29467, 34.11591], [-117.29529, 34.1159], [-117.29529, 34.117]]]} | Open Access 1 | Bryce Edward Hanes Park | 31758 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 2.453 | Bryce Edward Hanes Park | 2017 | |
13981 | 13981 | 13980 | {"type": "Polygon", "coordinates": [[[-117.61755, 34.09674], [-117.61753, 34.09759], [-117.61599, 34.09759], [-117.61599, 34.09673], [-117.61755, 34.09674]]]} | Open Access 1 | Los Amigos Park | http://www.cityofrc.us/cityhall/cs/parkdev/whatsnew/southwest_cucamonga_pk.asp | 32565 | 1263 | Rancho Cucamonga, City of 192 | City 2 | City Agency 2 | http://www.cityofrc.us/cityhall/cs/parks/default.asp | City 2 | 3.358 | Los Amigos Park | 2017 |
1314 | 1314 | 1313 | {"type": "Polygon", "coordinates": [[[-119.07586, 34.2234], [-119.0758, 34.22343], [-119.0747, 34.22344], [-119.07468, 34.22175], [-119.07578, 34.22175], [-119.07584, 34.22177], [-119.07586, 34.22181], [-119.07586, 34.2234]]]} | Open Access 1 | Mel Vincent Park | http://www.pvrpd.org/parks/park_list/mel_vincent_park.asp | 32939 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 4.981 | Mel Vincent Park | 2017 |
12494 | 12494 | 12493 | {"type": "Polygon", "coordinates": [[[-118.37777, 34.01479], [-118.37753, 34.0148], [-118.37747, 34.01477], [-118.37741, 34.01476], [-118.37599, 34.0148], [-118.37598, 34.01451], [-118.37593, 34.01451], [-118.37619, 34.01404], [-118.37647, 34.01384], [-118.37662, 34.01349], [-118.37761, 34.01347], [-118.37774, 34.01366], [-118.37777, 34.01479]]]} | Open Access 1 | Stoneview Park | 29580 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 5.018 | Stoneview Park | 2017 | |
13892 | 13892 | 13891 | {"type": "Polygon", "coordinates": [[[-122.72799, 38.42185], [-122.72623, 38.4222], [-122.72621, 38.42201], [-122.72615, 38.42201], [-122.72601, 38.42086], [-122.7278, 38.42042], [-122.72799, 38.42185]]]} | Open Access 1 | Bayer Neighborhood Park and Gardens | 32509 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 6.16 | Bayer Neighborhood Park and Gardens | 2017 | |
5432 | 5432 | 5431 | {"type": "Polygon", "coordinates": [[[-121.21194, 37.76483], [-121.21187, 37.76508], [-121.21159, 37.76556], [-121.21149, 37.76586], [-121.21144, 37.76588], [-121.21108, 37.76588], [-121.21081, 37.76585], [-121.21064, 37.76579], [-121.21042, 37.76566], [-121.2103, 37.76555], [-121.21018, 37.76536], [-121.21014, 37.76514], [-121.21014, 37.76454], [-121.21015, 37.7644], [-121.21024, 37.7642], [-121.21033, 37.76408], [-121.21046, 37.76397], [-121.2106, 37.76389], [-121.21085, 37.76381], [-121.21153, 37.76374], [-121.21157, 37.76377], [-121.21178, 37.76409], [-121.21187, 37.76427], [-121.21194, 37.76454], [-121.21194, 37.76483]]]} | Open Access 1 | Evans Estates Park | 33014 | 1195 | Manteca, City of 481 | City 2 | City Agency 2 | http://www.ci.manteca.ca.us/parks/ | City 2 | 7.541 | Evans Estates Park | 2017 | |
14206 | 14206 | 14205 | {"type": "Polygon", "coordinates": [[[-122.28869, 37.78989], [-122.28434, 37.79], [-122.28434, 37.78999], [-122.2844, 37.78926], [-122.28472, 37.78911], [-122.28521, 37.78928], [-122.28706, 37.78929], [-122.28729, 37.78923], [-122.28753, 37.78908], [-122.28867, 37.78906], [-122.28869, 37.78989]]]} | Open Access 1 | Estuary Park | https://www.alamedaca.gov/Departments/Recreation-Parks/Estuary-Park | 33465 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 7.718 | Estuary Park | 2017 |
13812 | 13812 | 13811 | {"type": "Polygon", "coordinates": [[[-117.78951, 33.897], [-117.78951, 33.89703], [-117.78906, 33.89703], [-117.78901, 33.8971], [-117.7886, 33.89748], [-117.78854, 33.89749], [-117.78841, 33.89747], [-117.7883, 33.89754], [-117.78819, 33.89755], [-117.78811, 33.89754], [-117.78792, 33.89757], [-117.78781, 33.89755], [-117.78775, 33.89748], [-117.78745, 33.89731], [-117.78725, 33.89726], [-117.787, 33.89721], [-117.78661, 33.8972], [-117.78637, 33.89713], [-117.78623, 33.89704], [-117.78613, 33.89701], [-117.78606, 33.89696], [-117.78618, 33.89673], [-117.78635, 33.89649], [-117.78655, 33.89626], [-117.78678, 33.89605], [-117.78703, 33.89585], [-117.7873, 33.89567], [-117.78785, 33.89538], [-117.78789, 33.89625], [-117.78889, 33.89625], [-117.78888, 33.89644], [-117.78889, 33.89654], [-117.78894, 33.89666], [-117.789, 33.89674], [-117.78919, 33.89691], [-117.78939, 33.89697], [-117.78951, 33.897]]]} | Open Access 1 | Mustang Fields | 31336 | 1384 | Yorba Linda, City of 62 | City 2 | City Agency 2 | http://www.ci.yorba-linda.ca.us/index.php/city-departments/recreation-community-services | City 2 | 9.255 | Mustang Fields | 2017 | |
999 | 999 | 998 | {"type": "Polygon", "coordinates": [[[-117.16241, 33.61242], [-117.1624, 33.61284], [-117.16228, 33.61379], [-117.16221, 33.61385], [-117.16188, 33.6139], [-117.1617, 33.61363], [-117.16145, 33.61359], [-117.16111, 33.61345], [-117.16091, 33.61348], [-117.16081, 33.61344], [-117.16072, 33.61329], [-117.16046, 33.61319], [-117.16035, 33.61333], [-117.1599, 33.61332], [-117.15984, 33.61328], [-117.15979, 33.61327], [-117.15972, 33.61328], [-117.15966, 33.61332], [-117.15918, 33.61331], [-117.15917, 33.61311], [-117.15856, 33.61278], [-117.15849, 33.61233], [-117.16234, 33.61236], [-117.16241, 33.61242]]]} | Open Access 1 | Alderwood Park (West) | 33166 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 10.099 | Alderwood Park (West) | 2017 |
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]);