superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,102 rows where MNG_AG_TYP = 3 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AGENCY >30
- Los Angeles, County of 171
- San Diego, County of 120
- Santa Barbara, County of 89
- Orange, County of 82
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 50
- Sacramento, County of 48
- Kern, County of 47
- Riverside, County of 39
- San Luis Obispo, County of 31
- Monterey, County of 31
- Placer, County of 28
- Stanislaus, County of 24
- San Joaquin, County of 21
- Ventura, County of 20
- San Bernardino, County of 18
- Fresno, County of 17
- Merced, County of 16
- Yolo, County of 16
- Tulare, County of 15
- Humboldt, County of 12
- El Dorado, County of 9
- Mono, County of 7
- Tehama, County of 7
- Mendocino, County of 7
- Mariposa, County of 6
- Lassen, County of 6
- Imperial, County of 5
- Napa, County of 5
- …
ACCESS_TYP 4
- Open Access 983
- Restricted Access 57
- Unknown Access 36
- No Public Access 26
MNG_AG_TYP 1
- County Agency · 1,102 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14434 | 14434 | 14433 | {"type": "Polygon", "coordinates": [[[-120.81909, 39.02277], [-120.81495, 39.02381], [-120.81432, 39.02209], [-120.81557, 39.02184], [-120.81585, 39.02263], [-120.81673, 39.02246], [-120.81674, 39.02244], [-120.81647, 39.02165], [-120.81844, 39.02125], [-120.81899, 39.02269], [-120.81909, 39.02277]]]} | Open Access 1 | Foresthill Leroy E. Botts Memorial Park | https://www.placer.ca.gov/6000/Foresthill-Leroy-E-Botts-Memorial-Park | 33725 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 15.356 | Foresthill Leroy E. Botts Memorial Park | |
14433 | 14433 | 14432 | {"type": "Polygon", "coordinates": [[[-121.09452, 38.93839], [-121.09416, 38.93839], [-121.09416, 38.93785], [-121.09416, 38.93785], [-121.09452, 38.93839]]]} | Open Access 1 | Auburn Plaza Park | https://www.placer.ca.gov/6005/Plaza-Park | 33724 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 0.231 | Auburn Plaza Park | |
14432 | 14432 | 14431 | {"type": "Polygon", "coordinates": [[[-121.96932, 38.8863], [-121.9688, 38.88631], [-121.9688, 38.88594], [-121.96932, 38.88593], [-121.96932, 38.8863]]]} | Open Access 1 | Dunnigan Park | 33723 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 0.457 | Dunnigan Park | ||
10328 | 10328 | 10327 | {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44048, 39.05966], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.43951, 39.06053], [-123.43949, 39.06058], [-123.4393, 39.06079], [-123.43906, 39.06087], [-123.43892, 39.06095], [-123.43876, 39.06095], [-123.43795, 39.06072], [-123.43766, 39.0607], [-123.4375, 39.06076], [-123.43727, 39.06098], [-123.43715, 39.06109], [-123.43686, 39.06123], [-123.43655, 39.06093], [-123.43605, 39.06052], [-123.43589, 39.0604], [-123.43528, 39.06002], [-123.43639, 39.05958], [-123.43805, 39.05866], [-123.4405, 39.05938]]]} | Open Access 1 | Indian Creek County Park | https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek | 33715 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 17.437 | Indian Creek County Park | 1973 |
14406 | 14406 | 14405 | {"type": "MultiPolygon", "coordinates": [[[[-114.72351, 33.36382], [-114.72351, 33.36382], [-114.72214, 33.36582], [-114.7221, 33.36382], [-114.72351, 33.36382]]], [[[-114.73058, 33.37111], [-114.72656, 33.37111], [-114.7265, 33.36719], [-114.72216, 33.36718], [-114.72215, 33.36635], [-114.72389, 33.36382], [-114.73052, 33.36382], [-114.73058, 33.37111]]], [[[-114.73064, 33.37842], [-114.72848, 33.37842], [-114.72845, 33.3749], [-114.73062, 33.3749], [-114.73064, 33.37842]]], [[[-114.74359, 33.38218], [-114.74357, 33.38602], [-114.73924, 33.38605], [-114.73926, 33.38223], [-114.74359, 33.38218]]], [[[-114.75277, 33.39501], [-114.75277, 33.39725], [-114.75115, 33.39723], [-114.75113, 33.39677], [-114.74792, 33.39672], [-114.74793, 33.39445], [-114.7506, 33.39452], [-114.75062, 33.39407], [-114.75223, 33.39411], [-114.75224, 33.39499], [-114.75277, 33.39501]]]]} | Open Access 1 | Unnamed Site - Imperial, County of | 33710 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 202.853 | |||
9615 | 9615 | 9614 | {"type": "Polygon", "coordinates": [[[-123.4074, 39.00408], [-123.40742, 39.00624], [-123.40739, 39.00777], [-123.40276, 39.00769], [-123.40285, 39.004], [-123.4074, 39.00408]]]} | Open Access 1 | Faulkner Park | https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park | 33709 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 40.359 | Faulkner Park | 1930 |
9513 | 9513 | 9512 | {"type": "Polygon", "coordinates": [[[-121.11612, 38.79796], [-121.116, 38.79929], [-121.11489, 38.79929], [-121.11488, 38.79915], [-121.11491, 38.79901], [-121.11497, 38.79887], [-121.11506, 38.79875], [-121.11524, 38.7986], [-121.11567, 38.79837], [-121.11582, 38.79828], [-121.11598, 38.79813], [-121.11612, 38.79796]]]} | Open Access 1 | Sterling Pointe Park | 33705 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 2.222 | Sterling Pointe Park | ||
9373 | 9373 | 9372 | {"type": "Polygon", "coordinates": [[[-118.93429, 34.23097], [-118.93156, 34.2316], [-118.93117, 34.23166], [-118.93075, 34.23168], [-118.93077, 34.2258], [-118.93428, 34.22579], [-118.93429, 34.23097]]]} | Open Access 1 | Santa Rosa Valley Park | 33703 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 49.624 | Santa Rosa Valley Park | ||
14140 | 14140 | 14139 | {"type": "Polygon", "coordinates": [[[-121.17178, 38.78981], [-121.1705, 38.79009], [-121.17044, 38.79009], [-121.17038, 38.79007], [-121.17033, 38.79002], [-121.1699, 38.7888], [-121.17148, 38.78877], [-121.17178, 38.78981]]]} | Open Access 1 | Franklin Community School Park | https://www.placer.ca.gov/6045/Franklin-Community-School-Park | 33699 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 4.348 | Franklin Community School Park | |
14403 | 14403 | 14402 | {"type": "Polygon", "coordinates": [[[-120.78357, 37.42217], [-120.78354, 37.42276], [-120.78299, 37.42273], [-120.78253, 37.42266], [-120.78176, 37.42243], [-120.78172, 37.42236], [-120.78187, 37.42206], [-120.78357, 37.42217]]]} | Open Access 1 | Unknown park - Merced, County of | 33652 | 308 | Merced, County of 469 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 2.298 | |||
14398 | 14398 | 14397 | {"type": "Polygon", "coordinates": [[[-122.03058, 38.69336], [-122.03047, 38.69379], [-122.02642, 38.69321], [-122.02628, 38.69316], [-122.02622, 38.69315], [-122.02613, 38.69318], [-122.02608, 38.69321], [-122.02606, 38.69327], [-122.02575, 38.69323], [-122.02592, 38.69252], [-122.03058, 38.69336]]]} | Open Access 1 | Unknown park - Yolo, County of | 33612 | 332 | Yolo, County of 538 | County 3 | County Agency 3 | http://www.yolocounty.org/general-government/general-government-departments/parks | County 3 | 6.062 | |||
14397 | 14397 | 14396 | {"type": "Polygon", "coordinates": [[[-119.31269, 36.05787], [-119.31226, 36.05793], [-119.31221, 36.0577], [-119.31261, 36.05762], [-119.31269, 36.05787]]]} | Open Access 1 | Unknown park - Tulare, County of | 33611 | 330 | Tulare, County of 94 | County 3 | County Agency 3 | http://www.tularecounty.ca.gov/cao/index.cfm/general-services/parks-and-recreation/county-parks/ | County 3 | 0.259 | |||
1135 | 1135 | 1134 | {"type": "Polygon", "coordinates": [[[-120.91097, 37.55865], [-120.91094, 37.56187], [-120.91083, 37.56198], [-120.91056, 37.56195], [-120.9103, 37.56185], [-120.91004, 37.5617], [-120.91003, 37.56159], [-120.91014, 37.56136], [-120.9102, 37.56113], [-120.91018, 37.56085], [-120.91011, 37.56065], [-120.90964, 37.55999], [-120.90964, 37.55861], [-120.90972, 37.55856], [-120.91088, 37.55856], [-120.91097, 37.55865]]]} | Open Access 1 | Bonita Ranch Park | 33610 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 8.734 | Bonita Ranch Park | ||
14094 | 14094 | 14093 | {"type": "Polygon", "coordinates": [[[-121.9128, 36.9767], [-121.91215, 36.97675], [-121.91216, 36.97584], [-121.91275, 36.97583], [-121.91271, 36.97617], [-121.9128, 36.9767]]]} | Open Access 1 | Seacliff Village Park (McGregor) | http://www.scparks.com/Home/Parks/ListofAllCountyParks.aspx | 33609 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 1.282 | Seacliff Village Park (McGregor) | |
14396 | 14396 | 14395 | {"type": "Polygon", "coordinates": [[[-117.11962, 34.07215], [-117.11962, 34.07266], [-117.11928, 34.07265], [-117.11927, 34.07296], [-117.11886, 34.07295], [-117.1188, 34.07289], [-117.11881, 34.07271], [-117.11885, 34.07252], [-117.11904, 34.07221], [-117.11909, 34.07203], [-117.11911, 34.0719], [-117.11918, 34.07183], [-117.11931, 34.07184], [-117.1193, 34.07215], [-117.11962, 34.07215]]]} | Open Access 1 | Unknown park - San Bernardino, County of | 33607 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 1.403 | |||
1111 | 1111 | 1110 | {"type": "Polygon", "coordinates": [[[-117.16681, 34.26338], [-117.16664, 34.26378], [-117.16602, 34.26364], [-117.16582, 34.26364], [-117.16565, 34.26368], [-117.16544, 34.26397], [-117.1656, 34.26429], [-117.16547, 34.26476], [-117.16468, 34.26443], [-117.1646, 34.26442], [-117.16448, 34.26446], [-117.16438, 34.26446], [-117.16421, 34.26389], [-117.16432, 34.26385], [-117.16458, 34.26379], [-117.16488, 34.26381], [-117.16506, 34.26384], [-117.16535, 34.26381], [-117.16551, 34.26367], [-117.1656, 34.26353], [-117.16568, 34.26347], [-117.16605, 34.26342], [-117.16681, 34.26338]]]} | Open Access 1 | MacKay Park | 33606 | 318 | San Bernardino, County of 363 | County 3 | County Agency 3 | http://cms.sbcounty.gov/parks/Home.aspx | County 3 | 3.157 | MacKay Park | ||
1018 | 1018 | 1017 | {"type": "Polygon", "coordinates": [[[-121.24447, 38.2956], [-121.24433, 38.29571], [-121.24395, 38.2959], [-121.24332, 38.29626], [-121.24327, 38.29627], [-121.24321, 38.29625], [-121.24323, 38.29563], [-121.24327, 38.29546], [-121.24333, 38.29535], [-121.24343, 38.29529], [-121.24365, 38.29521], [-121.24382, 38.29521], [-121.24402, 38.29524], [-121.24425, 38.29534], [-121.24431, 38.29542], [-121.24444, 38.29556], [-121.24447, 38.2956]]]} | Open Access 1 | Herald Park | https://regionalparks.saccounty.net/SpecialEventsReservations/Pages/HeraldPark.aspx | 33605 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 1.953 | Herald Park | |
14395 | 14395 | 14394 | {"type": "Polygon", "coordinates": [[[-121.29822, 38.56886], [-121.29831, 38.56987], [-121.29827, 38.56998], [-121.29811, 38.57016], [-121.29803, 38.57031], [-121.29801, 38.57042], [-121.29796, 38.57085], [-121.29785, 38.57059], [-121.29782, 38.57044], [-121.29777, 38.57032], [-121.29766, 38.57021], [-121.29744, 38.57006], [-121.29737, 38.56997], [-121.29734, 38.5699], [-121.29716, 38.5679], [-121.29813, 38.56784], [-121.29822, 38.56886]]]} | Open Access 1 | Unknown park - Sacramento, County of | 33604 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 5.538 | |||
1007 | 1007 | 1006 | {"type": "Polygon", "coordinates": [[[-117.47088, 33.75654], [-117.47089, 33.75734], [-117.47087, 33.75752], [-117.47083, 33.75766], [-117.47078, 33.75779], [-117.47069, 33.75793], [-117.47059, 33.75805], [-117.47046, 33.75817], [-117.47029, 33.75828], [-117.47011, 33.75837], [-117.46993, 33.75843], [-117.46972, 33.75847], [-117.46952, 33.75849], [-117.46907, 33.75844], [-117.46903, 33.7584], [-117.469, 33.75799], [-117.46894, 33.75779], [-117.46891, 33.75762], [-117.46891, 33.75742], [-117.46893, 33.75725], [-117.46899, 33.75702], [-117.46946, 33.75622], [-117.47088, 33.75654]]]} | Open Access 1 | Coral Canyon Park | https://rivcoccsd.org/new-page-2 | 33603 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 9.03 | Coral Canyon Park | |
1008 | 1008 | 1007 | {"type": "Polygon", "coordinates": [[[-117.46707, 33.74589], [-117.46683, 33.74759], [-117.46525, 33.74744], [-117.46517, 33.7471], [-117.46503, 33.74677], [-117.46348, 33.7442], [-117.46334, 33.744], [-117.4632, 33.74382], [-117.4632, 33.74376], [-117.46365, 33.74339], [-117.46373, 33.74335], [-117.46383, 33.74332], [-117.46405, 33.74329], [-117.46541, 33.7433], [-117.46601, 33.74403], [-117.46707, 33.74589]]]} | Open Access 1 | Deleo Regional Sports Park | https://rivcoccsd.org/new-page-2 | 33602 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 24.913 | Deleo Reg. Sports 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]);