superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,352 rows where MNG_AG_LEV = 3 sorted by map descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Los Angeles, County of 171
- San Diego, County of 120
- Santa Barbara, County of 89
- Orange, County of 82
- Los Angeles - Department of Parks and Recreation, County of 63
- Lake, County of 56
- Butte, County of 53
- Santa Cruz, County of 50
- Sonoma County Regional Parks Dept., County of 48
- Sacramento, County of 48
- Kern, County of 47
- Santa Clara County Parks and Recreation Dept., County of 42
- Riverside, County of 39
- Marin County Parks Department, County of 34
- San Luis Obispo, County of 31
- Monterey, County of 31
- Placer, County of 28
- San Mateo County Parks and Recreation Dept., County of 24
- 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
- San Francisco - Public Utilities Commission, City and County of 12
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 11
- El Dorado, County of 9
- …
ACCESS_TYP 4
- Open Access 1,191
- Restricted Access 78
- No Public Access 46
- Unknown Access 37
MNG_AG_TYP 3
- County Agency 1,102
- County Agency - Parks 218
- County Agency - Other 32
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15537 | 15537 | 15536 | {"type": "Polygon", "coordinates": [[[-124.35159, 40.57354], [-124.35147, 40.57383], [-124.35066, 40.57367], [-124.35064, 40.57382], [-124.3494, 40.57383], [-124.34941, 40.57334], [-124.35087, 40.57312], [-124.35077, 40.57344], [-124.35159, 40.57354]]]} | Open Access 1 | Centerville Beach | 17041 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 2.346 | Centerville Beach | ||
1604 | 1604 | 1603 | {"type": "Polygon", "coordinates": [[[-124.23254, 40.26773], [-124.2322, 40.26878], [-124.2322, 40.26882], [-124.23085, 40.26907], [-124.23083, 40.26963], [-124.22952, 40.26963], [-124.22932, 40.26935], [-124.22906, 40.2691], [-124.22878, 40.26892], [-124.22853, 40.2688], [-124.22824, 40.26872], [-124.22783, 40.26872], [-124.22766, 40.26887], [-124.22753, 40.26908], [-124.22742, 40.2694], [-124.22737, 40.26964], [-124.22653, 40.26964], [-124.22663, 40.26911], [-124.22669, 40.2689], [-124.22677, 40.26883], [-124.22696, 40.26874], [-124.22714, 40.26859], [-124.22729, 40.26841], [-124.22743, 40.26818], [-124.22764, 40.26797], [-124.22769, 40.2677], [-124.22769, 40.26741], [-124.22774, 40.26713], [-124.22776, 40.26676], [-124.22796, 40.2665], [-124.22833, 40.26628], [-124.22869, 40.2662], [-124.23016, 40.26621], [-124.23062, 40.26624], [-124.23196, 40.26648], [-124.2323, 40.26669], [-124.23243, 40.2669], [-124.23252, 40.26726], [-124.23254, 40.26773]]]} | Open Access 1 | Arthur W. Way Park | 15641 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 33.388 | Arthur W. Way Park | ||
12055 | 12055 | 12054 | {"type": "Polygon", "coordinates": [[[-124.21445, 40.77156], [-124.2134, 40.7727], [-124.21288, 40.77334], [-124.21022, 40.77332], [-124.21322, 40.77091], [-124.21357, 40.77045], [-124.21445, 40.77156]]]} | Open Access 1 | Samoa Boat Ramp County Park | 30519 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 12.044 | Samoa Boat Ramp County Park | ||
5687 | 5687 | 5686 | {"type": "Polygon", "coordinates": [[[-124.21314, 41.8682], [-124.213, 41.86893], [-124.21297, 41.86902], [-124.21287, 41.86916], [-124.21219, 41.86918], [-124.21116, 41.86925], [-124.21155, 41.8682], [-124.21314, 41.86807], [-124.21314, 41.8682]]]} | Unknown Access 4 | Kellogg Beach | 20579 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 4.007 | Kellogg Beach | ||
5652 | 5652 | 5651 | {"type": "Polygon", "coordinates": [[[-124.20572, 41.97312], [-124.20571, 41.97334], [-124.20565, 41.97363], [-124.20569, 41.97397], [-124.20568, 41.97417], [-124.20317, 41.97415], [-124.20314, 41.9731], [-124.20572, 41.97312]]]} | Open Access 1 | Kamph Memorial Park | 20548 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 6.048 | Kamph Memorial Park | ||
2883 | 2883 | 2882 | {"type": "Polygon", "coordinates": [[[-124.20362, 41.75891], [-124.20165, 41.7589], [-124.20165, 41.75859], [-124.20151, 41.75858], [-124.20151, 41.75823], [-124.20234, 41.75823], [-124.20182, 41.75767], [-124.20212, 41.75756], [-124.20212, 41.75755], [-124.20205, 41.75746], [-124.2025, 41.7572], [-124.20347, 41.75822], [-124.2035, 41.75824], [-124.20362, 41.75824], [-124.20362, 41.75891]]]} | Open Access 1 | Pyke Field | 32981 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 5.197 | Pyke Field | ||
11714 | 11714 | 11713 | {"type": "Polygon", "coordinates": [[[-124.15565, 41.74626], [-124.15565, 41.74659], [-124.15543, 41.7466], [-124.15543, 41.74692], [-124.15471, 41.74692], [-124.15467, 41.74626], [-124.15565, 41.74626]]]} | Open Access 1 | Bertsch Tract Park | 28317 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 1.282 | Bertsch Tract Park | ||
4274 | 4274 | 4273 | {"type": "Polygon", "coordinates": [[[-124.15163, 41.80908], [-124.15102, 41.809], [-124.15049, 41.80888], [-124.1496, 41.80854], [-124.14788, 41.80801], [-124.14838, 41.80521], [-124.15153, 41.80524], [-124.15163, 41.80908]]]} | Open Access 1 | Florence Keller Park | 18961 | 347 | Del Norte County Parks, County of 661 | County 3 | County Agency - Parks 7 | http://www.dnco.org/ | County 3 | 26.848 | Florence Keller Park | ||
6504 | 6504 | 6503 | {"type": "Polygon", "coordinates": [[[-124.1405, 40.9168], [-124.13948, 40.91945], [-124.13918, 40.92099], [-124.13862, 40.92235], [-124.13723, 40.92536], [-124.1361, 40.92829], [-124.13591, 40.92864], [-124.13588, 40.92955], [-124.1358, 40.93084], [-124.13559, 40.93173], [-124.13514, 40.93311], [-124.135, 40.93361], [-124.13459, 40.93468], [-124.13456, 40.93442], [-124.13006, 40.93436], [-124.13004, 40.93449], [-124.12991, 40.9342], [-124.12991, 40.93361], [-124.12993, 40.93336], [-124.12993, 40.93311], [-124.13003, 40.93278], [-124.13008, 40.93251], [-124.13002, 40.93218], [-124.12999, 40.93184], [-124.12972, 40.9315], [-124.12972, 40.9312], [-124.12966, 40.93091], [-124.12956, 40.92928], [-124.12961, 40.92819], [-124.12975, 40.92698], [-124.13003, 40.92698], [-124.12996, 40.9278], [-124.12996, 40.92821], [-124.13014, 40.92835], [-124.13075, 40.92864], [-124.13105, 40.92873], [-124.13128, 40.92879], [-124.13189, 40.92884], [-124.13227, 40.92893], [-124.13306, 40.9292], [-124.13326, 40.92933], [-124.13342, 40.9295], [-124.13357, 40.92927], [-124.13413, 40.92957], [-124.13494, 40.9274], [-124.13702, 40.92214], [-124.1392, 40.91654], [-124.1405, 40.9168]]]} | Open Access 1 | Mad River County Park | 21640 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 116.363 | Mad River County Park | ||
11715 | 11715 | 11714 | {"type": "Polygon", "coordinates": [[[-124.13354, 41.16255], [-124.1334, 41.16295], [-124.13222, 41.1637], [-124.13198, 41.1638], [-124.13182, 41.16385], [-124.13171, 41.16386], [-124.13145, 41.16382], [-124.13112, 41.16353], [-124.13059, 41.16298], [-124.13059, 41.16293], [-124.13063, 41.16285], [-124.13182, 41.16266], [-124.13212, 41.1625], [-124.13219, 41.16248], [-124.13249, 41.16255], [-124.13277, 41.16255], [-124.13325, 41.16251], [-124.13354, 41.16255]]]} | Open Access 1 | Big Lagoon Park | http://www.redwoods.info/showrecord.asp?id=1581 | 28318 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 5.584 | Big Lagoon Park | |
13240 | 13240 | 13239 | {"type": "Polygon", "coordinates": [[[-124.05116, 40.7557], [-124.05103, 40.75618], [-124.04968, 40.75812], [-124.04942, 40.75783], [-124.0492, 40.75749], [-124.04903, 40.75714], [-124.04894, 40.75682], [-124.04935, 40.75622], [-124.04958, 40.75585], [-124.04974, 40.75546], [-124.04981, 40.75519], [-124.0507, 40.75519], [-124.05116, 40.7557]]]} | Open Access 1 | Freshwater Park | http://co.humboldt.ca.us/portal/living/county_parks/default.asp?parkID=FP | 30520 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 8.276 | Freshwater Park | |
4812 | 4812 | 4811 | {"type": "Polygon", "coordinates": [[[-123.99351, 40.88039], [-123.99291, 40.88117], [-123.99172, 40.88062], [-123.99228, 40.87997], [-123.99351, 40.88039]]]} | Open Access 1 | Gymkhana Field | 19579 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 2.641 | Gymkhana Field | ||
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-123.98647, 40.49898], [-123.98241, 40.49898], [-123.97734, 40.49932], [-123.9773, 40.4995], [-123.97607, 40.49958], [-123.97481, 40.49962], [-123.97472, 40.49964], [-123.97325, 40.4994], [-123.97166, 40.49876], [-123.97059, 40.49784], [-123.97027, 40.49748], [-123.96992, 40.49649], [-123.96947, 40.49486], [-123.96915, 40.49332], [-123.96936, 40.49281], [-123.96941, 40.49162], [-123.96928, 40.4893], [-123.96926, 40.48925], [-123.96865, 40.48863], [-123.9678, 40.48728], [-123.96424, 40.48356], [-123.96509, 40.48276], [-123.96537, 40.48234], [-123.96645, 40.48135], [-123.96749, 40.48067], [-123.96847, 40.4811], [-123.96835, 40.48206], [-123.96841, 40.48325], [-123.96842, 40.48452], [-123.96814, 40.48582], [-123.9682, 40.48695], [-123.96855, 40.48777], [-123.96878, 40.48789], [-123.97058, 40.48784], [-123.9724, 40.48728], [-123.97416, 40.48663], [-123.97595, 40.48657], [-123.97741, 40.48698], [-123.97872, 40.48785], [-123.97866, 40.48895], [-123.9771, 40.48895], [-123.97454, 40.48917], [-123.9726, 40.49005], [-123.97195, 40.49104], [-123.97175, 40.49173], [-123.97174, 40.49269], [-123.97193, 40.49387], [-123.9721, 40.49487], [-123.97299, 40.49584], [-123.974, 40.49668], [-123.97488, 40.49748], [-123.97611, 40.49812], [-123.97683, 40.4987], [-123.97767, 40.49848], [-123.97942, 40.49699], [-123.98167, 40.49559], [-123.98244, 40.49577], [-123.98336, 40.49653], [-123.98467, 40.49758], [-123.98544, 40.49776], [-123.98593, 40.49717], [-123.98641, 40.49678], [-123.98651, 40.49858], [-123.98647, 40.49898]]]} | Open Access 1 | Van Duzen Park | http://www.humboldtgov.org/1592/County-Parks-Facilities | 4515 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 212.15 | Van Duzen Park | |
14334 | 14334 | 14333 | {"type": "Polygon", "coordinates": [[[-123.96182, 40.47601], [-123.96157, 40.47625], [-123.96067, 40.47662], [-123.95893, 40.478], [-123.95764, 40.47896], [-123.95666, 40.48], [-123.95668, 40.4767], [-123.95728, 40.4765], [-123.95804, 40.47633], [-123.9587, 40.47616], [-123.95966, 40.47599], [-123.96182, 40.47601]]]} | Restricted Access 2 | Unnamed site - Humboldt, County of | 29996 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 19.487 | |||
10388 | 10388 | 10387 | {"type": "Polygon", "coordinates": [[[-123.79899, 40.09038], [-123.79816, 40.09043], [-123.79723, 40.09053], [-123.79654, 40.09066], [-123.79587, 40.09113], [-123.79544, 40.08958], [-123.79611, 40.08922], [-123.79668, 40.08901], [-123.79717, 40.08896], [-123.79765, 40.0889], [-123.79809, 40.08892], [-123.79853, 40.08904], [-123.79868, 40.08913], [-123.79883, 40.08954], [-123.79898, 40.09026], [-123.79899, 40.09038]]]} | Open Access 1 | Tooby Memorial Park | 26400 | 348 | Humboldt, County of 545 | County 3 | County Agency 3 | http://co.humboldt.ca.us/portal/living/county_parks/cpdefault.asp | County 3 | 11.824 | Tooby Memorial Park | ||
12995 | 12995 | 12994 | {"type": "Polygon", "coordinates": [[[-123.7721, 39.56968], [-123.77167, 39.5697], [-123.77145, 39.56927], [-123.771, 39.56816], [-123.77128, 39.56814], [-123.77136, 39.56839], [-123.77169, 39.56866], [-123.77174, 39.56906], [-123.77186, 39.56918], [-123.7721, 39.56968]]]} | Open Access 1 | Coastal View Point | 30237 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 1.452 | Coastal View Point | ||
2178 | 2178 | 2177 | {"type": "Polygon", "coordinates": [[[-123.5325, 38.79904], [-123.53139, 38.79955], [-123.5307, 38.799], [-123.53039, 38.79909], [-123.52955, 38.7979], [-123.52979, 38.79762], [-123.53088, 38.79674], [-123.5325, 38.79904]]]} | Open Access 1 | Bower Park | 16307 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 9.996 | Bower Park | ||
9584 | 9584 | 9583 | {"type": "Polygon", "coordinates": [[[-123.4743, 38.7297], [-123.47379, 38.7302], [-123.47355, 38.72996], [-123.47404, 38.72949], [-123.4743, 38.7297]]]} | Open Access 1 | Shell Beach | 25387 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 0.556 | Shell Beach | ||
9433 | 9433 | 9432 | {"type": "Polygon", "coordinates": [[[-123.46324, 38.71823], [-123.46307, 38.71844], [-123.46268, 38.71853], [-123.462, 38.7182], [-123.46154, 38.718], [-123.46092, 38.71756], [-123.46035, 38.71794], [-123.46014, 38.71771], [-123.46061, 38.71734], [-123.46034, 38.71712], [-123.46071, 38.7168], [-123.46039, 38.71654], [-123.45998, 38.71683], [-123.45938, 38.71635], [-123.459, 38.71634], [-123.45843, 38.71686], [-123.45836, 38.71741], [-123.45924, 38.71795], [-123.45973, 38.71755], [-123.46009, 38.71788], [-123.4596, 38.71821], [-123.46124, 38.71936], [-123.46154, 38.71944], [-123.46112, 38.71959], [-123.45775, 38.71717], [-123.45965, 38.71544], [-123.45979, 38.71563], [-123.46029, 38.71609], [-123.46042, 38.71632], [-123.46077, 38.71656], [-123.46122, 38.71694], [-123.46083, 38.71715], [-123.46083, 38.71717], [-123.46142, 38.7175], [-123.46185, 38.7175], [-123.4625, 38.71806], [-123.46311, 38.71809], [-123.46324, 38.71823]]]} | Open Access 1 | Sea Ranch Trail Access | 25235 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 10.405 | Sea Ranch Trail Access | ||
9951 | 9951 | 9950 | {"type": "Polygon", "coordinates": [[[-123.45916, 38.71589], [-123.45775, 38.71717], [-123.45715, 38.71765], [-123.45648, 38.71675], [-123.45595, 38.71631], [-123.4566, 38.71574], [-123.45706, 38.71605], [-123.45741, 38.71585], [-123.4565, 38.71505], [-123.45634, 38.71501], [-123.45631, 38.71486], [-123.45642, 38.71479], [-123.4566, 38.71486], [-123.45662, 38.71498], [-123.45735, 38.71555], [-123.45755, 38.71542], [-123.45757, 38.71526], [-123.45656, 38.71442], [-123.45616, 38.71442], [-123.4556, 38.71483], [-123.45522, 38.71454], [-123.45544, 38.71435], [-123.45544, 38.71433], [-123.45328, 38.71253], [-123.45404, 38.7124], [-123.45461, 38.71221], [-123.45484, 38.71259], [-123.4547, 38.7131], [-123.45507, 38.71341], [-123.45618, 38.71372], [-123.45651, 38.71397], [-123.4573, 38.71397], [-123.45798, 38.71439], [-123.4584, 38.7147], [-123.45916, 38.71589]], [[-123.45789, 38.71568], [-123.45723, 38.71617], [-123.45748, 38.71643], [-123.45818, 38.71591], [-123.45841, 38.71567], [-123.4585, 38.71535], [-123.45848, 38.71506], [-123.45832, 38.71477], [-123.45776, 38.71433], [-123.45729, 38.71411], [-123.45699, 38.71407], [-123.45684, 38.71429], [-123.45715, 38.71446], [-123.45723, 38.71441], [-123.45741, 38.71443], [-123.45782, 38.71475], [-123.45794, 38.71492], [-123.458, 38.71515], [-123.458, 38.71542], [-123.45789, 38.71568]]]} | Open Access 1 | Stengel Beach | 25827 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 17.139 | Stengel Beach |
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]);