units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
534 rows where COUNTY = 8 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
272 | 272 | 271 | {"type": "Polygon", "coordinates": [[[-119.30083, 34.27437], [-119.30048, 34.27445], [-119.29837, 34.27477], [-119.29821, 34.27482], [-119.29805, 34.27491], [-119.2979, 34.27501], [-119.29779, 34.27512], [-119.29779, 34.27435], [-119.29933, 34.27392], [-119.30016, 34.27382], [-119.30083, 34.27383], [-119.30083, 34.27437]]]} | Open Access 1 | 742 | Surfer's Point | 30395 | 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 | 4.99 | Surfer's Point | None 29 | |||
587 | 587 | 586 | {"type": "Polygon", "coordinates": [[[-119.01482, 34.20968], [-119.01465, 34.21039], [-119.01452, 34.21114], [-119.01418, 34.21111], [-119.014, 34.21118], [-119.01319, 34.21098], [-119.01318, 34.21095], [-119.01357, 34.20947], [-119.01362, 34.20945], [-119.01422, 34.20959], [-119.01433, 34.20959], [-119.01441, 34.20956], [-119.01445, 34.20961], [-119.01482, 34.20968]]]} | Open Access 1 | 1987 | Woodside Park - PVRPD | 27744 | 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 | 5.147 | Woodside Park - PVRPD | None 58 | |||
2628 | 2628 | 2627 | {"type": "Polygon", "coordinates": [[[-118.84231, 34.19564], [-118.84227, 34.19647], [-118.84184, 34.19646], [-118.84183, 34.19631], [-118.84174, 34.19621], [-118.84159, 34.1962], [-118.8415, 34.1963], [-118.84159, 34.19645], [-118.84038, 34.19642], [-118.84035, 34.1963], [-118.84001, 34.19634], [-118.83995, 34.196], [-118.84002, 34.19568], [-118.84038, 34.1958], [-118.84116, 34.19567], [-118.84155, 34.19567], [-118.84231, 34.19564]]]} | Open Access 1 | 18025 | Morrow Circle | 22506 | 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 | 4.053 | Morrow Circle | None 215 | |||
2639 | 2639 | 2638 | {"type": "Polygon", "coordinates": [[[-118.83534, 34.17548], [-118.83489, 34.17589], [-118.83416, 34.17534], [-118.83469, 34.17485], [-118.8349, 34.17502], [-118.83506, 34.17527], [-118.83534, 34.17548]]]} | Open Access 1 | 18131 | North Ranch - Hillcrest Subarea | 22850 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | Ventura 8 | 1.497 | North Ranch - Hillcrest Subarea | None 217 | |||
2699 | 2699 | 2698 | {"type": "Polygon", "coordinates": [[[-118.84721, 34.20202], [-118.8472, 34.20254], [-118.84648, 34.20252], [-118.846, 34.20241], [-118.84562, 34.20243], [-118.84515, 34.20253], [-118.84479, 34.20234], [-118.84429, 34.20217], [-118.84721, 34.20202]]]} | Open Access 1 | 18273 | Old Meadows FC | 23089 | 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 | 2.511 | Old Meadows FC | None 221 | |||
2715 | 2715 | 2714 | {"type": "Polygon", "coordinates": [[[-119.24423, 34.26821], [-119.24402, 34.26824], [-119.24392, 34.26819], [-119.24388, 34.26802], [-119.24397, 34.26778], [-119.2441, 34.26777], [-119.24413, 34.26779], [-119.24423, 34.26821]]]} | Open Access 1 | 18346 | Pacific View Skateboard Bowl | 30404 | 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.303 | Pacific View Skateboard Bowl | None 224 | |||
3193 | 3193 | 3192 | {"type": "Polygon", "coordinates": [[[-119.19405, 34.15613], [-119.1939, 34.15658], [-119.19391, 34.15663], [-119.19397, 34.15665], [-119.19363, 34.15675], [-119.19377, 34.15636], [-119.19376, 34.15635], [-119.19303, 34.15658], [-119.19302, 34.15659], [-119.19316, 34.1569], [-119.19011, 34.15787], [-119.18975, 34.15804], [-119.18954, 34.15817], [-119.18941, 34.15828], [-119.18922, 34.15847], [-119.18905, 34.15871], [-119.18892, 34.15897], [-119.18886, 34.15919], [-119.18882, 34.15944], [-119.18881, 34.16092], [-119.18879, 34.16094], [-119.18613, 34.16092], [-119.1861, 34.16091], [-119.18611, 34.1596], [-119.18644, 34.1596], [-119.18645, 34.15955], [-119.18757, 34.15956], [-119.18782, 34.15915], [-119.18791, 34.15919], [-119.18797, 34.1591], [-119.18796, 34.15909], [-119.18788, 34.15905], [-119.18818, 34.15858], [-119.18926, 34.15752], [-119.19383, 34.15607], [-119.19405, 34.15613]]]} | Open Access 1 | 22118 | Richard Barb Bubbling Springs | 24321 | 1259 | Port Hueneme, City of 593 | City 2 | City Agency 2 | http://www.ci.port-hueneme.ca.us/ | City 2 | 1259 | Port Hueneme, City of 583 | City 2 | City Agency 2 | Ventura 8 | 20.37 | Richard Barb Bubbling Springs | None 263 | |||
5344 | 5344 | 5343 | {"type": "Polygon", "coordinates": [[[-119.0427, 34.22709], [-119.04183, 34.2271], [-119.04183, 34.22684], [-119.04176, 34.22677], [-119.04181, 34.22671], [-119.04183, 34.22664], [-119.04181, 34.22643], [-119.04185, 34.22641], [-119.04264, 34.2264], [-119.04267, 34.22641], [-119.04269, 34.22646], [-119.0427, 34.22709]]]} | Open Access 1 | 17313 | Laurelwood Park - PVRPD | 21108 | 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 | 1.519 | Laurelwood Park - PVRPD | None 435 | |||
5831 | 5831 | 5830 | {"type": "Polygon", "coordinates": [[[-118.82888, 34.17163], [-118.82877, 34.17168], [-118.82845, 34.17117], [-118.82836, 34.1712], [-118.82832, 34.17114], [-118.82839, 34.17108], [-118.82805, 34.17055], [-118.82796, 34.17057], [-118.82791, 34.1705], [-118.828, 34.17046], [-118.82762, 34.16987], [-118.82753, 34.16991], [-118.82743, 34.1698], [-118.82731, 34.1698], [-118.82721, 34.16991], [-118.82716, 34.17], [-118.82701, 34.17006], [-118.82681, 34.17009], [-118.82654, 34.16999], [-118.82545, 34.16942], [-118.8285, 34.16806], [-118.82846, 34.16898], [-118.82843, 34.16933], [-118.82829, 34.1695], [-118.82809, 34.16959], [-118.8279, 34.16955], [-118.82778, 34.16961], [-118.82776, 34.16969], [-118.82779, 34.16976], [-118.82773, 34.16983], [-118.8281, 34.17041], [-118.82819, 34.17039], [-118.82824, 34.17045], [-118.82816, 34.1705], [-118.8285, 34.17104], [-118.82859, 34.17102], [-118.82866, 34.17109], [-118.82856, 34.17112], [-118.82855, 34.17113], [-118.82888, 34.17163]]]} | Open Access 1 | 219 | Russell Park - CRPD | 24741 | 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 | 8.455 | Russell Park - CRPD | None 467 | |||
5865 | 5865 | 5864 | {"type": "MultiPolygon", "coordinates": [[[[-118.82526, 34.16854], [-118.82526, 34.16863], [-118.82445, 34.16861], [-118.82443, 34.16869], [-118.82435, 34.16868], [-118.82433, 34.1686], [-118.8236, 34.16858], [-118.82357, 34.16866], [-118.82351, 34.16866], [-118.82348, 34.16858], [-118.82279, 34.16856], [-118.82279, 34.16846], [-118.82349, 34.16848], [-118.82352, 34.1684], [-118.82359, 34.1684], [-118.82361, 34.16848], [-118.82434, 34.16851], [-118.82436, 34.16843], [-118.82443, 34.16843], [-118.82445, 34.16851], [-118.82526, 34.16854]]], [[[-118.82896, 34.166], [-118.82877, 34.16625], [-118.82884, 34.16631], [-118.8288, 34.16636], [-118.82871, 34.16634], [-118.82832, 34.16685], [-118.82838, 34.16691], [-118.82836, 34.16695], [-118.82826, 34.16693], [-118.82783, 34.1675], [-118.82773, 34.16745], [-118.82816, 34.16688], [-118.82809, 34.16682], [-118.82813, 34.16677], [-118.82822, 34.1668], [-118.82861, 34.16629], [-118.82854, 34.16623], [-118.82858, 34.16617], [-118.82867, 34.1662], [-118.82886, 34.16595], [-118.82896, 34.166]]]]} | Open Access 1 | 212 | Russell Access Strips | 24738 | 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 | 1.277 | Russell Access Strips | None 470 | |||
6209 | 6209 | 6208 | {"type": "Polygon", "coordinates": [[[-119.26813, 34.2416], [-119.26604, 34.24115], [-119.26603, 34.24099], [-119.266, 34.24083], [-119.26594, 34.24068], [-119.26585, 34.24051], [-119.26573, 34.24035], [-119.2656, 34.24023], [-119.26544, 34.2401], [-119.2653, 34.24002], [-119.26568, 34.23968], [-119.26797, 34.23964], [-119.26797, 34.23973], [-119.26816, 34.24048], [-119.26813, 34.2416]]]} | Open Access 1 | 1264 | Surfers Knoll | 26076 | 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 | 10.057 | Surfers Knoll | None 501 | |||
6236 | 6236 | 6235 | {"type": "Polygon", "coordinates": [[[-118.89246, 34.19315], [-118.89175, 34.1939], [-118.89028, 34.19443], [-118.88966, 34.19408], [-118.88906, 34.19476], [-118.88987, 34.19604], [-118.8894, 34.19694], [-118.88972, 34.19697], [-118.88966, 34.19713], [-118.89015, 34.19725], [-118.89006, 34.19751], [-118.89001, 34.19774], [-118.88999, 34.198], [-118.88959, 34.19769], [-118.88879, 34.19745], [-118.88855, 34.19751], [-118.88834, 34.19765], [-118.88824, 34.19794], [-118.88804, 34.19816], [-118.88797, 34.19836], [-118.88738, 34.19819], [-118.88725, 34.19844], [-118.88696, 34.19837], [-118.88709, 34.19803], [-118.88613, 34.1978], [-118.88581, 34.19769], [-118.88563, 34.19762], [-118.88526, 34.19732], [-118.88448, 34.19616], [-118.88486, 34.19595], [-118.88521, 34.19571], [-118.8855, 34.19543], [-118.886, 34.19466], [-118.88615, 34.19447], [-118.88644, 34.1942], [-118.88685, 34.1946], [-118.88875, 34.19472], [-118.89055, 34.19262], [-118.89102, 34.19164], [-118.89122, 34.1917], [-118.891, 34.19217], [-118.89246, 34.19315]], [[-118.88823, 34.19625], [-118.88823, 34.19623], [-118.88779, 34.19566], [-118.88733, 34.19589], [-118.88775, 34.1965], [-118.88823, 34.19625]]]} | Open Access 1 | 1296 | Tarantula Hill | 26188 | 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 | 45.359 | Tarantula Hill | None 504 | |||
6270 | 6270 | 6269 | {"type": "Polygon", "coordinates": [[[-118.87703, 34.21508], [-118.87645, 34.21466], [-118.87557, 34.21452], [-118.87486, 34.21462], [-118.87459, 34.21496], [-118.87384, 34.21499], [-118.87344, 34.21466], [-118.87295, 34.2147], [-118.8727, 34.21454], [-118.87223, 34.21473], [-118.87187, 34.21497], [-118.87153, 34.21493], [-118.87125, 34.21476], [-118.87094, 34.21475], [-118.87054, 34.2148], [-118.87016, 34.21479], [-118.86963, 34.21485], [-118.86949, 34.21492], [-118.86936, 34.21507], [-118.86896, 34.2152], [-118.86854, 34.21519], [-118.86852, 34.21476], [-118.86856, 34.21447], [-118.86849, 34.21409], [-118.86846, 34.21305], [-118.87414, 34.21307], [-118.87414, 34.21362], [-118.87702, 34.21363], [-118.87703, 34.21508]]]} | Open Access 1 | 1363 | Thousand Oaks | 26324 | 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 | 33.506 | Thousand Oaks | None 507 | |||
7951 | 7951 | 7950 | {"type": "Polygon", "coordinates": [[[-118.88577, 34.2375], [-118.88101, 34.2362], [-118.881, 34.23473], [-118.88338, 34.23472], [-118.88338, 34.23321], [-118.88457, 34.23321], [-118.88457, 34.23461], [-118.88419, 34.23471], [-118.88468, 34.23472], [-118.88423, 34.23516], [-118.88335, 34.23583], [-118.88577, 34.23649], [-118.88577, 34.2375]]]} | Open Access 1 | 49005 | Mount Clef Ridge Open Space - COSCA | 22524 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/mt.-clef.html | Ventura 8 | 23.22 | Mount Clef Ridge OS - COSCA | None 663 | ||
8143 | 8143 | 8142 | {"type": "Polygon", "coordinates": [[[-118.96447, 34.16851], [-118.96427, 34.16919], [-118.9638, 34.16917], [-118.96314, 34.16943], [-118.96249, 34.16866], [-118.9617, 34.16812], [-118.96204, 34.16722], [-118.96404, 34.16787], [-118.96447, 34.16851]]]} | Open Access 1 | 12323 | Cypress Park - CRPD | 17882 | 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 | 8.864 | Cypress Park - CRPD | None 681 | |||
8417 | 8417 | 8416 | {"type": "Polygon", "coordinates": [[[-118.97218, 34.08094], [-118.96782, 34.08094], [-118.96786, 34.08027], [-118.96938, 34.08025], [-118.96951, 34.08007], [-118.97, 34.08001], [-118.97217, 34.08], [-118.97218, 34.08094]]]} | Open Access 1 | 13047 | Deer Creek - Denman | 17992 | 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 | Ventura 8 | 9.164 | Deer Creek - Denman | None 705 | |||
8955 | 8955 | 8954 | {"type": "Polygon", "coordinates": [[[-118.84318, 34.17165], [-118.84311, 34.1721], [-118.84218, 34.17297], [-118.84216, 34.17297], [-118.84216, 34.17295], [-118.84101, 34.17208], [-118.84132, 34.17181], [-118.84163, 34.17167], [-118.8419, 34.1716], [-118.84222, 34.17156], [-118.84268, 34.17158], [-118.84318, 34.17165]]]} | Open Access 1 | 14754 | El Parque de la Paz | 18525 | 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 | 4.586 | El Parque de la Paz | None 746 | |||
9235 | 9235 | 9234 | {"type": "MultiPolygon", "coordinates": [[[[-118.88576, 34.23321], [-118.881, 34.23322], [-118.881, 34.23224], [-118.8811, 34.23224], [-118.88115, 34.23255], [-118.88141, 34.23278], [-118.88219, 34.23278], [-118.8822, 34.23275], [-118.88353, 34.23275], [-118.88371, 34.2323], [-118.88396, 34.23237], [-118.88404, 34.23257], [-118.88512, 34.23304], [-118.88576, 34.23304], [-118.88576, 34.23321]]], [[[-118.88576, 34.23082], [-118.88556, 34.23053], [-118.88537, 34.23037], [-118.88477, 34.23019], [-118.88449, 34.23019], [-118.8852, 34.23005], [-118.8855, 34.22966], [-118.88575, 34.22907], [-118.88576, 34.23082]]], [[[-118.88575, 34.22841], [-118.8856, 34.22808], [-118.88507, 34.22768], [-118.8846, 34.22743], [-118.88455, 34.22691], [-118.88499, 34.22658], [-118.88527, 34.22651], [-118.88575, 34.22624], [-118.88575, 34.22841]]]]} | Open Access 1 | 49006 | Mount Clef Ridge Open Space - COSCA | 22524 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/mt.-clef.html | Ventura 8 | 10.644 | Mount Clef Ridge OS - COSCA | None 762 | ||
9236 | 9236 | 9235 | {"type": "Polygon", "coordinates": [[[-118.86839, 34.23962], [-118.86645, 34.23963], [-118.86644, 34.23733], [-118.86838, 34.23732], [-118.86838, 34.23869], [-118.86831, 34.23864], [-118.86823, 34.23862], [-118.86815, 34.23861], [-118.86806, 34.23863], [-118.86799, 34.23866], [-118.86793, 34.23872], [-118.86789, 34.23878], [-118.86788, 34.23885], [-118.86791, 34.23925], [-118.86838, 34.23912], [-118.86839, 34.23962]]]} | Open Access 1 | 49007 | Mount Clef Ridge Open Space - COSCA | 22524 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/mt.-clef.html | Ventura 8 | 10.569 | Mount Clef Ridge OS - COSCA | None 763 | ||
9332 | 9332 | 9331 | {"type": "Polygon", "coordinates": [[[-118.75742, 34.17567], [-118.75707, 34.17573], [-118.75691, 34.17574], [-118.75619, 34.17573], [-118.75599, 34.1757], [-118.75601, 34.17562], [-118.75621, 34.17564], [-118.75699, 34.17566], [-118.75718, 34.17563], [-118.7574, 34.17562], [-118.75742, 34.17567]]]} | Open Access 1 | 15567 | 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.27 | Conejo OS Conservation Agency | None 766 |
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]);