superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
30 rows where YR_EST = 2017
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
767 | 767 | 766 | {"type": "Polygon", "coordinates": [[[-117.32813, 34.76673], [-117.32803, 34.7693], [-117.32577, 34.76927], [-117.32577, 34.76773], [-117.32645, 34.76704], [-117.32646, 34.76671], [-117.32813, 34.76673]]]} | Open Access 1 | Helendale Community Park | https://www.helendalecsd.org/parks_facilities.html | 32710 | 2424 | Helendale Community Services District 943 | Special District 4 | Community Services District 17 | https://www.helendalecsd.org/parks_facilities.html | Special District 4 | 13.717 | Helendale Community 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 | |
914 | 914 | 913 | {"type": "Polygon", "coordinates": [[[-123.68414, 40.48042], [-123.67906, 40.48126], [-123.66993, 40.48271], [-123.67004, 40.47815], [-123.6746, 40.47741], [-123.67492, 40.47444], [-123.67959, 40.47359], [-123.67921, 40.47671], [-123.68403, 40.47602], [-123.68414, 40.48042]]]} | No Public Access 3 | McClellan Mountain Peatland | 32798 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 180.455 | McClellan Mtn. Peatland | 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 | |
1213 | 1213 | 1212 | {"type": "Polygon", "coordinates": [[[-117.97651, 34.11555], [-117.97637, 34.11573], [-117.97627, 34.11572], [-117.97575, 34.11619], [-117.97526, 34.11658], [-117.97501, 34.11677], [-117.97438, 34.11716], [-117.97327, 34.11691], [-117.97332, 34.11662], [-117.97332, 34.11632], [-117.97327, 34.11607], [-117.9731, 34.11575], [-117.97296, 34.11554], [-117.97288, 34.1153], [-117.97216, 34.11418], [-117.97253, 34.11436], [-117.97307, 34.11458], [-117.97392, 34.11484], [-117.9745, 34.11498], [-117.9751, 34.11509], [-117.97581, 34.11516], [-117.97582, 34.11527], [-117.97631, 34.11528], [-117.97649, 34.11546], [-117.97651, 34.11555]]]} | Open Access 1 | Kare Park | https://kyl.org/KarePark/ | 32904 | 7025 | Kare Youth League 808 | Non Profit 6 | Non Profit - Other 20 | https://www.kyl.org/news/about/ | Non Governmental Organization 10 | 14.77 | Kare 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 |
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 | |
7022 | 7022 | 7021 | {"type": "Polygon", "coordinates": [[[-121.6464, 36.68763], [-121.64639, 36.6877], [-121.64408, 36.6912], [-121.64363, 36.69113], [-121.64368, 36.69104], [-121.64367, 36.69103], [-121.64272, 36.69088], [-121.64213, 36.69135], [-121.64197, 36.69155], [-121.64198, 36.69158], [-121.64139, 36.69215], [-121.63962, 36.69351], [-121.63892, 36.69423], [-121.63884, 36.69428], [-121.63864, 36.69411], [-121.63991, 36.69024], [-121.63989, 36.69023], [-121.63797, 36.69073], [-121.63845, 36.68718], [-121.64106, 36.6865], [-121.64064, 36.68798], [-121.64637, 36.68758], [-121.6464, 36.68763]]]} | No Public Access 3 | Carr Lake | https://bigsurlandtrust.org/wp-content/uploads/2018/10/CarrLake_PublicMap-2.pdf | 33675 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 72.369 | Carr Lake | 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 |
7031 | 7031 | 7030 | {"type": "Polygon", "coordinates": [[[-118.34314, 34.39392], [-118.34303, 34.40124], [-118.32543, 34.401], [-118.32549, 34.39781], [-118.33435, 34.39794], [-118.33442, 34.39379], [-118.34314, 34.39392]]]} | Open Access 1 | Southern California Edison mitigation | https://cordobacorp.com/projects/southern-california-edison-tehachapi-renewable-transmission-project/ | 33677 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 232.435 | Southern California Edison mitigation | 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 | |
12426 | 12426 | 12425 | {"type": "Polygon", "coordinates": [[[-118.04141, 34.55562], [-118.04139, 34.55792], [-118.03668, 34.55791], [-118.03664, 34.55789], [-118.03665, 34.55766], [-118.03669, 34.5572], [-118.03669, 34.55572], [-118.03703, 34.55572], [-118.03705, 34.55582], [-118.03989, 34.55581], [-118.04119, 34.55562], [-118.04141, 34.55562]]]} | Open Access 1 | Sam Yellen Community Park | 29441 | 1242 | Palmdale, City of 201 | City 2 | City Agency 2 | http://www.cityofpalmdale.org/Residents/Recreation-and-Culture | City 2 | 25.456 | Sam Yellen Community 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 | |
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 | |
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 | |
13139 | 13139 | 13138 | {"type": "Polygon", "coordinates": [[[-121.98023, 37.10818], [-121.98019, 37.11234], [-121.97805, 37.11305], [-121.97636, 37.11305], [-121.97648, 37.11091], [-121.9766, 37.11084], [-121.97674, 37.11057], [-121.97678, 37.11032], [-121.97774, 37.1098], [-121.97746, 37.10877], [-121.97759, 37.1082], [-121.98023, 37.10818]]]} | Open Access 1 | Marywood Property | 31828 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 37.016 | Marywood Property | 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 | |
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 |
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]);