superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
13,512 rows where ACCESS_TYP = 1 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 30
- City Agency 9,667
- County Agency 983
- Recreation/Parks District 928
- State Agency 599
- Federal Agency 203
- Community Services District 190
- County Agency - Parks 189
- Open Space District 181
- Non Profit - Land Trust 180
- Water District 93
- Cemetery District 52
- Non Profit - Conservation 48
- Flood District 37
- Non Profit - Other 35
- Port/Harbor District 32
- County Agency - Other 19
- Special District - Other 15
- Irrigation District 14
- Sanitation District 6
- Non Profit - Cemetery District 5
- Commercial 3
- Joint Powers Authority 2
- Other 2
- Conservation District 2
- Non Profit - Education 2
- Airport District 1
- Metropolitan Planning Organization 1
- Utility 1
- Fire District 1
- Transportation Agency 1
MNG_AGENCY >30
- Los Angeles, City of 431
- San Diego, City of 408
- California Department of Fish and Wildlife 252
- California Department of Parks and Recreation 250
- San Jose, City of 247
- San Francisco, City and County of 238
- Sacramento, City of 214
- Los Angeles, County of 149
- Ventura, City of 149
- Mountains Recreation and Conservation Authority 139
- Long Beach, City of 135
- Oakland, City of 122
- Roseville, City of 117
- San Diego, County of 102
- Irvine, City of 97
- Consumnes Community Services District 92
- Fresno, City of 91
- Modesto, City of 78
- Hayward Area Recreation and Park District 77
- Stockton, City of 77
- Huntington Beach, City of 76
- Santa Barbara, County of 75
- Orange, County of 75
- East Bay Regional Park District 73
- Tracy, City of 73
- Santa Rosa, City of 72
- Brentwood, City of 68
- Chula Vista, City of 67
- Valley-Wide Recreation and Park District 66
- Santa Cruz, City of 65
- …
ACCESS_TYP 1
- Open Access · 13,492 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3451 | 3451 | 3450 | {"type": "Polygon", "coordinates": [[[-122.21602, 37.02342], [-122.21509, 37.02378], [-122.2149, 37.02335], [-122.21472, 37.02237], [-122.21561, 37.02182], [-122.21602, 37.02342]]]} | Open Access 1 | Davenport Landing Beach | 17938 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 3.923 | Davenport Landing Beach | |||
3490 | 3490 | 3489 | {"type": "Polygon", "coordinates": [[[-121.66267, 38.17881], [-121.66233, 38.1796], [-121.66183, 38.18015], [-121.66057, 38.18049], [-121.6572, 38.18162], [-121.65543, 38.18198], [-121.65393, 38.18244], [-121.65201, 38.1828], [-121.64803, 38.18428], [-121.64712, 38.17403], [-121.65009, 38.17464], [-121.65383, 38.17571], [-121.65488, 38.1762], [-121.6556, 38.17642], [-121.65777, 38.17653], [-121.6602, 38.17778], [-121.6615, 38.17807], [-121.66216, 38.1784], [-121.66267, 38.17881]]]} | Open Access 1 | Delta Protection | 18074 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Other Federal 13 | 214.904 | Delta Protection | |||
3501 | 3501 | 3500 | {"type": "Polygon", "coordinates": [[[-119.19796, 36.31684], [-119.19795, 36.31782], [-119.19604, 36.31789], [-119.196, 36.31689], [-119.19796, 36.31684]]]} | Open Access 1 | Deep Creek Cemetery | 17988 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 4.704 | Deep Creek Cemetery | |||
3569 | 3569 | 3568 | {"type": "Polygon", "coordinates": [[[-121.6849, 38.55302], [-121.68487, 38.55466], [-121.67577, 38.55668], [-121.67578, 38.5529], [-121.6849, 38.55302]]]} | Open Access 1 | Department of Forestry | 18096 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 59.043 | Department of Forestry | |||
3578 | 3578 | 3577 | {"type": "Polygon", "coordinates": [[[-120.63533, 36.98758], [-120.63434, 36.98758], [-120.63433, 36.98728], [-120.63533, 36.98728], [-120.63533, 36.98758]]]} | Open Access 1 | Des Park | 18106 | 1460 | Dos Palos, City of 190 | City 2 | City Agency 2 | City 2 | 0.735 | Des Park | |||
3830 | 3830 | 3829 | {"type": "Polygon", "coordinates": [[[-120.57104, 34.97032], [-120.57096, 34.97044], [-120.57051, 34.97024], [-120.57058, 34.97012], [-120.57104, 34.97032]]]} | Open Access 1 | Guadalupe holding 10 | 19546 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.174 | Guadalupe holding 10 | |||
3831 | 3831 | 3830 | {"type": "Polygon", "coordinates": [[[-120.58052, 34.96254], [-120.58034, 34.96267], [-120.57983, 34.9626], [-120.57981, 34.9625], [-120.58012, 34.96231], [-120.58041, 34.96249], [-120.58052, 34.96254]]]} | Open Access 1 | Guadalupe holding 2 | 19547 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.371 | Guadalupe holding 2 | |||
3832 | 3832 | 3831 | {"type": "Polygon", "coordinates": [[[-120.5712, 34.97007], [-120.57104, 34.97032], [-120.57058, 34.97012], [-120.5709, 34.96963], [-120.57109, 34.96971], [-120.57095, 34.96996], [-120.5712, 34.97007]]]} | Open Access 1 | Guadalupe holding 3 | 19548 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.517 | Guadalupe holding 3 | |||
3833 | 3833 | 3832 | {"type": "Polygon", "coordinates": [[[-120.57089, 34.97056], [-120.57073, 34.9708], [-120.57028, 34.97061], [-120.57051, 34.97024], [-120.57088, 34.9704], [-120.57082, 34.97051], [-120.57089, 34.97056]]]} | Open Access 1 | Guadalupe holding 4 | 19549 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.501 | Guadalupe holding 4 | |||
3834 | 3834 | 3833 | {"type": "Polygon", "coordinates": [[[-120.58072, 34.9624], [-120.58052, 34.96254], [-120.58041, 34.96249], [-120.58049, 34.96217], [-120.58062, 34.96216], [-120.58072, 34.9624]]]} | Open Access 1 | Guadalupe holding 5 | 19550 | 1126 | Guadalupe, City of 472 | City 2 | City Agency 2 | City 2 | 0.189 | Guadalupe holding 5 | |||
3895 | 3895 | 3894 | {"type": "Polygon", "coordinates": [[[-119.10764, 36.34977], [-119.10762, 36.35107], [-119.1054, 36.35107], [-119.10542, 36.34976], [-119.10764, 36.34977]]]} | Open Access 1 | Hamilton Cemetery | 19616 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 7.138 | Hamilton Cemetery | |||
3903 | 3903 | 3902 | {"type": "Polygon", "coordinates": [[[-118.06813, 34.08258], [-118.0669, 34.08216], [-118.06677, 34.0821], [-118.06668, 34.08205], [-118.06669, 34.0812], [-118.06809, 34.08115], [-118.06813, 34.08258]]]} | Open Access 1 | El Monte Cemetery | 18517 | 3017 | El Monte Cemetery Association 847 | Non Profit 6 | Non Profit - Cemetery District 27 | Non Governmental Organization 10 | 4.134 | El Monte Cemetery | |||
4112 | 4112 | 4111 | {"type": "Polygon", "coordinates": [[[-119.13521, 36.30947], [-119.1351, 36.31147], [-119.13075, 36.31143], [-119.13077, 36.31043], [-119.1323, 36.31043], [-119.13238, 36.30936], [-119.13521, 36.30947]]]} | Open Access 1 | Exeter Cemetery | 18773 | 2033 | Exeter Cemetery District 97 | Special District 4 | Cemetery District 11 | Special District 4 | 18.077 | Exeter Cemetery | |||
4271 | 4271 | 4270 | {"type": "Polygon", "coordinates": [[[-119.62216, 36.57616], [-119.61991, 36.57617], [-119.61986, 36.57615], [-119.61984, 36.57612], [-119.61982, 36.57405], [-119.62216, 36.57616]]]} | Open Access 1 | Floral Memorial Cemetery | 18958 | 2148 | Selma Cemetery District 247 | Special District 4 | Cemetery District 11 | Special District 4 | 6.038 | Floral Memorial Cemetery | |||
4278 | 4278 | 4277 | {"type": "Polygon", "coordinates": [[[-117.04739, 34.89181], [-117.04738, 34.89249], [-117.04398, 34.89336], [-117.04397, 34.89172], [-117.04739, 34.89181]]]} | Open Access 1 | Foglesong Park/Eda Henderson Pool | 18966 | 2203 | Barstow Recreation and Park District 76 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 9.886 | Foglesong Park/Eda Henderson Pool | |||
4348 | 4348 | 4347 | {"type": "Polygon", "coordinates": [[[-119.68461, 36.60967], [-119.68459, 36.61269], [-119.68239, 36.61268], [-119.68238, 36.60964], [-119.68461, 36.60967]]]} | Open Access 1 | Fowler Cemetery | 19028 | 2035 | Fowler Cemetery District 394 | Special District 4 | Cemetery District 11 | Special District 4 | 16.465 | Fowler Cemetery | |||
4367 | 4367 | 4366 | {"type": "Polygon", "coordinates": [[[-118.95592, 36.14627], [-118.95521, 36.14626], [-118.9552, 36.14479], [-118.95589, 36.1448], [-118.95592, 36.14627]]]} | Open Access 1 | Frazier Valley Cemetery | 19071 | 2060 | Lindsay-Strathmore Cemetery District 119 | Special District 4 | Cemetery District 11 | Special District 4 | 2.538 | Frazier Valley Cemetery | |||
4420 | 4420 | 4419 | {"type": "Polygon", "coordinates": [[[-119.71275, 36.9916], [-119.71191, 36.99249], [-119.7112, 36.99207], [-119.71091, 36.99196], [-119.71085, 36.99186], [-119.71077, 36.99183], [-119.71053, 36.99176], [-119.71044, 36.99178], [-119.71062, 36.99139], [-119.71109, 36.99063], [-119.71154, 36.99058], [-119.71275, 36.9916]]]} | Open Access 1 | Friant Cove | 19113 | 299 | Other State 128 | State 5 | State Agency 5 | Other State 5 | 5.884 | Friant Cove | |||
4422 | 4422 | 4421 | {"type": "Polygon", "coordinates": [[[-116.33702, 34.11024], [-116.33643, 34.11074], [-116.33563, 34.11215], [-116.33564, 34.11023], [-116.33702, 34.11024]]]} | Open Access 1 | Friendly Hills Park | 19115 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2.814 | Friendly Hills Park | |||
4465 | 4465 | 4464 | {"type": "Polygon", "coordinates": [[[-123.37488, 41.79526], [-123.37479, 41.79527], [-123.37464, 41.79551], [-123.37252, 41.79546], [-123.37205, 41.79325], [-123.3725, 41.79301], [-123.37448, 41.79406], [-123.37488, 41.79526]]]} | Open Access 1 | Gale Zinc Memorial Park | 19173 | 2226 | Happy Camp Community Services District 958 | Special District 4 | Community Services District 17 | Special District 4 | 10.657 | Gale Zinc Memorial 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]);