units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2,391 rows where LAYER = 4 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 275
- East Bay Regional Park District 130
- Consumnes Community Services District 92
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 58
- Rancho Simi Recreation and Park District 53
- Conejo Recreation and Park District 50
- Yuba County Water Agency 50
- Midpeninsula Regional Open Space District 49
- Conejo Open Space Conservation Agency 43
- Southgate Recreation and Park District 41
- Marin County Open Space District 40
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 30
- Fresno Metropolitan Flood Control District 29
- Las Virgenes Municipal Water District 28
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 25
- El Dorado Hills Community Service District 25
- Los Angeles County Flood Control District 23
- Olivehurst Public Utility District 23
- Santa Clara Valley Open Space Authority 22
- Natomas Basin Conservancy 22
- Santa Barbara Flood Control and Water Conserv. District 21
- Sonoma County Agricultural Preservation and Open Space District 21
- Isla Vista Recreation and Park District 18
- Whittier, City of 18
- Jurupa Area Recreation and Park District 18
- …
DES_TP >30
- Local Park 1,141
- Local Recreation Area 402
- Local Other or Unknown 286
- Local Conservation Area 210
- Local Historic or Cultural Area 57
- Local Resource Management Area 10
- National Monument or Landmark 2
- State Conservation Area 1
- State Park 1
- None 1
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- National Wildlife Refuge 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 23
- Recreation/Parks District 1,099
- Open Space District 342
- Water District 233
- Community Services District 195
- City Agency 162
- Flood District 107
- Cemetery District 62
- Irrigation District 49
- School District 37
- Port/Harbor District 30
- Special District - Other 15
- County Agency - Parks 12
- Sanitation District 9
- Joint Powers Authority 9
- County Agency 7
- Non Profit - Land Trust 5
- Conservation District 5
- Transportation Agency 5
- State Agency 2
- Non Profit - Conservation 2
- Metropolitan Planning Organization 2
- Airport District 1
- Fire District 1
ACCESS_TYP 4
- Open Access 1,663
- No Public Access 262
- Restricted Access 256
- Unknown Access 210
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4727 | 4727 | 4726 | {"type": "Polygon", "coordinates": [[[-118.50367, 34.09732], [-118.50364, 34.09732], [-118.50363, 34.09721], [-118.50366, 34.09721], [-118.50367, 34.09732]]]} | Unknown Access 4 | 46347 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.009 | 0 | Local Other or Unknown 14 | 4 | ||
1274 | 1274 | 1273 | {"type": "Polygon", "coordinates": [[[-118.23627, 33.89605], [-118.23616, 33.89604], [-118.23608, 33.89598], [-118.2362, 33.89598], [-118.23627, 33.89605]]]} | Open Access 1 | 7201 | Compton Creek & Bike Path | 17572 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 0.02 | Compton Creek & Bike Path | 0 | Local Recreation Area 3 | 4 | |
7492 | 7492 | 7491 | {"type": "Polygon", "coordinates": [[[-120.94993, 40.13923], [-120.94987, 40.13929], [-120.94983, 40.13929], [-120.94982, 40.13916], [-120.94993, 40.13923]]]} | Open Access 1 | 48943 | Triangle Park | 33659 | 2229 | Indian Valley Community Services District 869 | Special District 4 | Community Services District 19 | Special District 4 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | Plumas 57 | 0.02 | Triangle Park | 0 | Local Park 2 | 4 | |
9013 | 9013 | 9012 | {"type": "Polygon", "coordinates": [[[-118.65507, 34.12838], [-118.65499, 34.12848], [-118.65493, 34.12846], [-118.65501, 34.12835], [-118.65507, 34.12838]]]} | No Public Access 3 | 12414 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.022 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
5079 | 5079 | 5078 | {"type": "Polygon", "coordinates": [[[-119.01469, 34.22393], [-119.01462, 34.2239], [-119.01463, 34.22384], [-119.01461, 34.22379], [-119.01469, 34.22376], [-119.01469, 34.22393]]]} | Open Access 1 | 15062 | Pleasant Valley Recreation and Park District | 23802 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.025 | Pleasant Valley Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
9463 | 9463 | 9462 | {"type": "Polygon", "coordinates": [[[-118.7507, 34.16758], [-118.75065, 34.16768], [-118.75057, 34.16764], [-118.75062, 34.16755], [-118.7507, 34.16758]]]} | No Public Access 3 | 12424 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.027 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
15921 | 15921 | 15920 | {"type": "Polygon", "coordinates": [[[-122.34943, 37.42376], [-122.34901, 37.4238], [-122.34867, 37.42379], [-122.34867, 37.42379], [-122.34943, 37.42376]]]} | Open Access 1 | 17888 | Purisima Creek Redwoods Open Space Preserve | 6528 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_purisima.asp | San Mateo 15 | 0.029 | Purisima Creek Redwoods OSP | 1982 | Local Conservation Area 4 | 2 |
1629 | 1629 | 1628 | {"type": "Polygon", "coordinates": [[[-118.63073, 34.13978], [-118.63062, 34.1398], [-118.63058, 34.13967], [-118.63066, 34.13966], [-118.63073, 34.13978]]]} | No Public Access 3 | 12421 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.034 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
15489 | 15489 | 15488 | {"type": "Polygon", "coordinates": [[[-118.32033, 34.23499], [-118.32019, 34.2351], [-118.32013, 34.23505], [-118.32027, 34.23494], [-118.32033, 34.23499]]]} | Unknown Access 4 | 46153 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.034 | 0 | Local Other or Unknown 14 | 4 | ||
16990 | 16990 | 16989 | {"type": "Polygon", "coordinates": [[[-118.23978, 34.20471], [-118.23978, 34.2048], [-118.23976, 34.20488], [-118.23962, 34.20472], [-118.23978, 34.20471]]]} | Open Access 1 | 46460 | Verdugo Mountains Open Space Preserve | 29734 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.036 | Verdugo Mtns. OSP | 0 | Local Conservation Area 4 | 2 | |
11403 | 11403 | 11402 | {"type": "Polygon", "coordinates": [[[-122.26076, 37.8998], [-122.26076, 37.8998], [-122.2605, 37.89989], [-122.26062, 37.89973], [-122.26076, 37.8998]]]} | Open Access 1 | 23017 | Tilden Regional Park | 3324 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/tilden | Alameda 17 | 0.038 | Tilden RP | 1936 | Local Park 2 | 4 |
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-118.89482, 34.22828], [-118.89475, 34.22845], [-118.8946, 34.2284], [-118.8946, 34.22839], [-118.89482, 34.22828]]]} | Open Access 1 | 15581 | Conejo Recreation and Park District | 17586 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 0.041 | Conejo Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
7220 | 7220 | 7219 | {"type": "Polygon", "coordinates": [[[-118.3724, 34.10748], [-118.37214, 34.10757], [-118.3721, 34.1075], [-118.37219, 34.10747], [-118.37231, 34.10745], [-118.3724, 34.10748]]]} | Open Access 1 | 6885 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.045 | 0 | Local Other or Unknown 14 | 4 | ||
9404 | 9404 | 9403 | {"type": "Polygon", "coordinates": [[[-118.67423, 34.13343], [-118.67408, 34.13345], [-118.67407, 34.13332], [-118.67422, 34.13331], [-118.67423, 34.13343]]]} | No Public Access 3 | 12423 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.05 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
5641 | 5641 | 5640 | {"type": "Polygon", "coordinates": [[[-118.22852, 34.08438], [-118.2285, 34.0844], [-118.22844, 34.0843], [-118.22835, 34.08422], [-118.22833, 34.08418], [-118.22835, 34.08399], [-118.22852, 34.08438]]]} | Open Access 1 | 46908 | Egret Park | 30449 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.055 | Egret Park | 0 | Local Park 2 | 4 | |
16801 | 16801 | 16800 | {"type": "Polygon", "coordinates": [[[-119.86959, 34.41246], [-119.86959, 34.4126], [-119.86943, 34.41258], [-119.86943, 34.41245], [-119.86959, 34.41246]]]} | Open Access 1 | 13879 | Isla Vista Recreation and Park District | 20280 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.058 | Isla Vista Rec. and Park District | 0 | Local Recreation Area 3 | 4 | |
4495 | 4495 | 4494 | {"type": "Polygon", "coordinates": [[[-118.43891, 34.09306], [-118.43861, 34.0933], [-118.43858, 34.0933], [-118.43856, 34.09326], [-118.43886, 34.09303], [-118.43891, 34.09306]]]} | Open Access 1 | 6391 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.059 | 0 | Local Other or Unknown 14 | 4 | ||
4698 | 4698 | 4697 | {"type": "Polygon", "coordinates": [[[-118.44773, 34.10525], [-118.4477, 34.10553], [-118.44762, 34.10554], [-118.44765, 34.10524], [-118.44773, 34.10525]]]} | Unknown Access 4 | 46110 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.061 | 0 | Local Other or Unknown 14 | 4 | ||
16116 | 16116 | 16115 | {"type": "Polygon", "coordinates": [[[-118.88309, 34.19376], [-118.88277, 34.19389], [-118.88271, 34.19392], [-118.88286, 34.19372], [-118.88309, 34.19376]]]} | Open Access 1 | 15575 | Conejo Open Space Conservation Agency | 17584 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 0.063 | Conejo OS Conservation Agency | None 1383 | |||
4940 | 4940 | 4939 | {"type": "Polygon", "coordinates": [[[-122.02404, 37.66917], [-122.02383, 37.66911], [-122.02395, 37.66891], [-122.02396, 37.66892], [-122.02404, 37.66917]]]} | Restricted Access 2 | 10715 | Chabot - Garin Trail Corridor | 17108 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.064 | Chabot - Garin Trail Corridor | 0 | Local Conservation Area 4 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);