units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
534 rows where COUNTY = 8 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, MNG_AG_LEV, YR_EST, GAP_STS
MNG_AGENCY >30
- Ventura, City of 151
- Rancho Simi Recreation and Park District 53
- Conejo Recreation and Park District 50
- Conejo Open Space Conservation Agency 50
- Oxnard, City of 41
- Pleasant Valley Recreation and Park District 30
- Ventura, County of 24
- Moorpark, City of 19
- Thousand Oaks, City of 19
- Mountains Recreation and Conservation Authority 15
- United States National Park Service 10
- Ojai, City of 9
- Santa Paula, City of 9
- Fillmore, City of 8
- Ojai Valley Land Conservancy 8
- California Department of Parks and Recreation 7
- Port Hueneme, City of 6
- The Nature Conservancy 3
- Conejo Valley Unified School District 3
- California Department of Fish and Wildlife 2
- United States Fish and Wildlife Service 2
- Santa Monica Mountains Conservancy 2
- Rancho Simi Open Space Conservation Agency 2
- United States Bureau of Land Management 1
- United States Forest Service 1
- United States Bureau of Reclamation 1
- Bardsdale Cemetery District 1
- Serra Cross Conservancy 1
- Simi Valley Public Cemetery District 1
- Piru Cemetery District 1
- …
DES_TP >30
- Local Park 227
- Local Other or Unknown 124
- Local Recreation Area 92
- Private Conservation 11
- State Park 7
- National Recreation Area 7
- Local Historic or Cultural Area 6
- Local Conservation Area 4
- Recreation Management Area 3
- State Conservation Area 2
- National Wildlife Refuge 2
- National Public Lands 1
- National Forest 1
- National Park 1
- None 1
- State Recreation Area 1
- None 1
- Private Recreation or Education 1
- State Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 12
ACCESS_TYP 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13220 | 13220 | 13219 | {"type": "Polygon", "coordinates": [[[-119.19521, 34.28644], [-119.19519, 34.28644], [-119.19511, 34.28596], [-119.19513, 34.28596], [-119.19521, 34.28644]]]} | Open Access 1 | 35264 | Ventura holding 58 | 26938 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.019 | Ventura holding 58 | 0 | Local Other or Unknown 14 | 4 | |
13576 | 13576 | 13575 | {"type": "Polygon", "coordinates": [[[-118.88253, 34.28657], [-118.88237, 34.28657], [-118.88234, 34.28652], [-118.88242, 34.28649], [-118.88245, 34.28654], [-118.88247, 34.28653], [-118.88253, 34.28657]]]} | Open Access 1 | 35905 | Moorpark holding 2 | 22464 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 0.02 | Moorpark holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13317 | 13317 | 13316 | {"type": "Polygon", "coordinates": [[[-119.19475, 34.28398], [-119.19474, 34.28399], [-119.19465, 34.28374], [-119.19455, 34.28353], [-119.19455, 34.2835], [-119.19456, 34.28346], [-119.19456, 34.2835], [-119.19469, 34.28379], [-119.19475, 34.28398]]]} | Open Access 1 | 35384 | Ventura holding 22 | 26899 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.021 | Ventura holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13228 | 13228 | 13227 | {"type": "Polygon", "coordinates": [[[-119.1911, 34.28234], [-119.19107, 34.28236], [-119.19083, 34.28244], [-119.19075, 34.28238], [-119.19073, 34.28229], [-119.19076, 34.28229], [-119.19078, 34.28238], [-119.19083, 34.28242], [-119.1911, 34.28234]]]} | Open Access 1 | 35269 | Ventura holding 60 | 26941 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.022 | Ventura holding 60 | 0 | Local Other or Unknown 14 | 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 | |
13321 | 13321 | 13320 | {"type": "Polygon", "coordinates": [[[-119.17309, 34.26527], [-119.17306, 34.26529], [-119.17283, 34.26503], [-119.17286, 34.26501], [-119.17309, 34.26527]]]} | Open Access 1 | 35388 | Ventura holding 20 | 26897 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.027 | Ventura holding 20 | 0 | Local Other or Unknown 14 | 4 | |
12427 | 12427 | 12426 | {"type": "Polygon", "coordinates": [[[-119.1914, 34.28159], [-119.19124, 34.2816], [-119.1908, 34.28162], [-119.1912, 34.28156], [-119.1914, 34.28159]]]} | Open Access 1 | 35321 | Ventura holding 107 | 26860 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.034 | Ventura holding 107 | 0 | Local Other or Unknown 14 | 4 | |
13295 | 13295 | 13294 | {"type": "Polygon", "coordinates": [[[-119.19432, 34.28316], [-119.19407, 34.28287], [-119.1938, 34.28262], [-119.19379, 34.28258], [-119.1938, 34.28256], [-119.19381, 34.28257], [-119.1938, 34.28258], [-119.19381, 34.28261], [-119.19402, 34.2828], [-119.19421, 34.283], [-119.19431, 34.28313], [-119.19432, 34.28316]]]} | Open Access 1 | 35349 | Ventura holding 5 | 26929 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.034 | Ventura holding 5 | 0 | Local Other or Unknown 14 | 4 | |
7777 | 7777 | 7776 | {"type": "Polygon", "coordinates": [[[-119.19536, 34.28728], [-119.19535, 34.28728], [-119.1952, 34.28644], [-119.19521, 34.28644], [-119.19536, 34.28728]]]} | Open Access 1 | 35437 | Ventura holding 70 | 26952 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.035 | Ventura holding 70 | 0 | Local Other or Unknown 14 | 4 | |
13934 | 13934 | 13933 | {"type": "Polygon", "coordinates": [[[-119.15013, 34.27654], [-119.15013, 34.27655], [-119.15007, 34.27656], [-119.15004, 34.27659], [-119.14986, 34.27736], [-119.14985, 34.27734], [-119.15003, 34.27659], [-119.15007, 34.27654], [-119.15013, 34.27654]]]} | Open Access 1 | 36540 | Ventura holding 125 | 26880 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.036 | Ventura holding 125 | 0 | Local Other or Unknown 14 | 4 | |
4761 | 4761 | 4760 | {"type": "Polygon", "coordinates": [[[-118.63806, 34.24154], [-118.63783, 34.24155], [-118.63783, 34.24148], [-118.63804, 34.24148], [-118.63806, 34.24154]]]} | Unknown Access 4 | 46669 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Ventura 8 | 0.038 | 0 | Local Other or Unknown 14 | 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 | |
13351 | 13351 | 13350 | {"type": "Polygon", "coordinates": [[[-119.15826, 34.27089], [-119.15766, 34.27124], [-119.15716, 34.27146], [-119.15714, 34.27145], [-119.15759, 34.27126], [-119.15821, 34.2709], [-119.15826, 34.27089]]]} | Open Access 1 | 35430 | Ventura holding 53 | 26933 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.045 | Ventura holding 53 | 0 | Local Other or Unknown 14 | 4 | |
3584 | 3584 | 3583 | {"type": "Polygon", "coordinates": [[[-119.17467, 34.27812], [-119.17461, 34.27816], [-119.17442, 34.27794], [-119.17446, 34.27792], [-119.1745, 34.27793], [-119.17467, 34.27812]]]} | Open Access 1 | 36691 | Ventura holding 106 | 26859 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.046 | Ventura holding 106 | 0 | Local Other or Unknown 14 | 4 | |
4990 | 4990 | 4989 | {"type": "Polygon", "coordinates": [[[-119.19623, 34.28781], [-119.19547, 34.28778], [-119.19543, 34.28773], [-119.19535, 34.28731], [-119.19537, 34.28731], [-119.19544, 34.28773], [-119.19547, 34.28777], [-119.19623, 34.2878], [-119.19623, 34.28781]]]} | Open Access 1 | 35438 | Ventura holding 71 | 26953 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.047 | Ventura holding 71 | 0 | Local Other or Unknown 14 | 4 | |
13252 | 13252 | 13251 | {"type": "Polygon", "coordinates": [[[-119.15969, 34.27006], [-119.15962, 34.2701], [-119.15848, 34.27077], [-119.15851, 34.27073], [-119.15963, 34.27008], [-119.15969, 34.27006]]]} | Open Access 1 | 35297 | Ventura holding 104 | 26857 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.051 | Ventura holding 104 | 0 | Local Other or Unknown 14 | 4 | |
13988 | 13988 | 13987 | {"type": "Polygon", "coordinates": [[[-119.17705, 34.27796], [-119.17699, 34.27793], [-119.17693, 34.27794], [-119.17623, 34.27829], [-119.17578, 34.27854], [-119.17577, 34.27853], [-119.17622, 34.27828], [-119.17693, 34.27792], [-119.177, 34.27792], [-119.17705, 34.27796]]]} | Open Access 1 | 36671 | Ventura holding 115 | 26869 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.051 | Ventura holding 115 | 0 | Local Other or Unknown 14 | 4 | |
13316 | 13316 | 13315 | {"type": "Polygon", "coordinates": [[[-119.17251, 34.27173], [-119.17245, 34.27175], [-119.17223, 34.27152], [-119.17231, 34.27149], [-119.17251, 34.27173]]]} | Open Access 1 | 35383 | Ventura holding 15 | 26891 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.054 | Ventura holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13425 | 13425 | 13424 | {"type": "Polygon", "coordinates": [[[-118.88255, 34.28664], [-118.88239, 34.2867], [-118.88234, 34.28667], [-118.88234, 34.2866], [-118.88237, 34.28657], [-118.88253, 34.28657], [-118.88255, 34.28664]]]} | Open Access 1 | 35567 | Moorpark holding 1 | 22463 | 1214 | Moorpark, City of 172 | City 2 | City Agency 2 | http://www.moorparkca.gov/199/Recreation | City 2 | 1214 | Moorpark, City of 168 | City 2 | City Agency 2 | Ventura 8 | 0.054 | Moorpark holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13282 | 13282 | 13281 | {"type": "Polygon", "coordinates": [[[-119.15094, 34.27517], [-119.15067, 34.27547], [-119.15043, 34.27579], [-119.1503, 34.27601], [-119.15018, 34.27624], [-119.15015, 34.27633], [-119.15016, 34.27636], [-119.15019, 34.27638], [-119.15019, 34.27639], [-119.15016, 34.27638], [-119.15013, 34.27635], [-119.15013, 34.2763], [-119.15025, 34.27606], [-119.15042, 34.27578], [-119.1507, 34.27541], [-119.15093, 34.27517], [-119.15094, 34.27517]]]} | Open Access 1 | 35337 | Ventura holding 118 | 26872 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.058 | Ventura holding 118 | 0 | Local Other or Unknown 14 | 4 |
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]);