units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
534 rows where COUNTY = 8 sorted by AGNCY_WEB
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1307 | 1307 | 1306 | {"type": "MultiPolygon", "coordinates": [[[[-118.63657, 34.26504], [-118.63633, 34.26516], [-118.63617, 34.26526], [-118.63601, 34.2654], [-118.63587, 34.26558], [-118.6358, 34.26572], [-118.63574, 34.26588], [-118.63571, 34.26605], [-118.63569, 34.26628], [-118.63564, 34.26647], [-118.63554, 34.26667], [-118.63539, 34.26684], [-118.63447, 34.26759], [-118.63418, 34.26779], [-118.63386, 34.26798], [-118.63327, 34.26823], [-118.63273, 34.2646], [-118.63657, 34.26504]]], [[[-118.63485, 34.26765], [-118.63449, 34.26821], [-118.63372, 34.26845], [-118.63334, 34.26871], [-118.63329, 34.2684], [-118.6338, 34.26819], [-118.63416, 34.26801], [-118.63449, 34.2678], [-118.63477, 34.26758], [-118.63485, 34.26765]]], [[[-118.65762, 34.27232], [-118.65772, 34.2726], [-118.65771, 34.27281], [-118.65769, 34.27297], [-118.65755, 34.27344], [-118.65753, 34.27346], [-118.65749, 34.27338], [-118.65642, 34.27257], [-118.65573, 34.27221], [-118.6555, 34.27195], [-118.65574, 34.27169], [-118.65574, 34.27168], [-118.65499, 34.27151], [-118.65408, 34.27081], [-118.65349, 34.27065], [-118.65242, 34.27019], [-118.65185, 34.27015], [-118.65094, 34.26998], [-118.65002, 34.26966], [-118.65006, 34.26918], [-118.64922, 34.26888], [-118.64886, 34.26879], [-118.64705, 34.26807], [-118.64679, 34.26814], [-118.64604, 34.26809], [-118.6458, 34.26796], [-118.64547, 34.26785], [-118.64495, 34.26758], [-118.64462, 34.26755], [-118.64414, 34.26724], [-118.64391, 34.26694], [-118.64358, 34.26675], [-118.64244, 34.26649], [-118.64221, 34.26578], [-118.64205, 34.2657], [-118.64022, 34.26616], [-118.63857, 34.266], [-118.63825, 34.26619], [-118.63802, 34.26604], [-118.63773, 34.26595], [-118.63661, 34.26612], [-118.63614, 34.26631], [-118.6356, 34.26704], [-118.6354, 34.2672], [-118.63532, 34.26713], [-118.6356, 34.26688], [-118.6357, 34.26676], [-118.63579, 34.26662], [-118.63588, 34.26636], [-118.63591, 34.26604], [-118.63594, 34.26588], [-118.636, 34.26574], [-118.63609, 34.2656], [-118.63624, 34.26544], [-118.63642, 34.2653], [-118.63663, 34.2652], [-118.63687, 34.26513], [-118.63725, 34.26529], [-118.63763, 34.2653], [-118.63817, 34.26541], [-118.6387, 34.26529], [-118.64734, 34.26629], [-118.64784, 34.26632], [-118.6482, 34.2663], [-118.64863, 34.26625], [-118.64905, 34.26617], [-118.64946, 34.26604], [-118.64985, 34.26589], [-118.65022, 34.26569], [-118.65061, 34.26543], [-118.65172, 34.26447], [-118.65208, 34.26407], [-118.65307, 34.2632], [-118.65352, 34.26283], [-118.65404, 34.26249], [-118.65458, 34.26292], [-118.65468, 34.26296], [-118.65481, 34.26299], [-118.65467, 34.26301], [-118.65448, 34.26298], [-118.6544, 34.26301], [-118.65435, 34.26305], [-118.65433, 34.2631], [-118.65433, 34.26316], [-118.65435, 34.2632], [-118.65288, 34.26389], [-118.65201, 34.26446], [-118.65231, 34.26447], [-118.65299, 34.26403], [-118.65496, 34.2631], [-118.65568, 34.26311], [-118.6557, 34.26352], [-118.65602, 34.26352], [-118.65602, 34.26311], [-118.65619, 34.26311], [-118.65614, 34.26652], [-118.6561, 34.2667], [-118.65643, 34.26684], [-118.65636, 34.26695], [-118.65626, 34.2677], [-118.65595, 34.26773], [-118.65595, 34.26945], [-118.6562, 34.26962], [-118.65629, 34.26981], [-118.65688, 34.27019], [-118.65701, 34.27046], [-118.65718, 34.27077], [-118.65734, 34.27095], [-118.6567, 34.2711], [-118.65679, 34.2714], [-118.65666, 34.27168], [-118.65762, 34.27232]]]]} | Open Access 1 | 10485 | Corriganville Park | 8979 | 2117 | Rancho Simi Open Space Conservation Agency 345 | Special District 4 | Open Space District 6 | Special District 4 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | http://www.rsrpd.org/park/corrignavilleparkandtrail/corrignavilleparkandtrail.html | Ventura 8 | 178.572 | Corriganville Park | 0 | Local Park 2 | 4 | |
5217 | 5217 | 5216 | {"type": "Polygon", "coordinates": [[[-118.76793, 34.2654], [-118.76793, 34.26719], [-118.76722, 34.26733], [-118.76684, 34.26739], [-118.76684, 34.26455], [-118.76694, 34.26455], [-118.76694, 34.2654], [-118.76793, 34.2654]]]} | Open Access 1 | 818 | Simi Cemetery | 25504 | 2151 | Simi Valley Public Cemetery District 798 | Special District 4 | Cemetery District 11 | Special District 4 | 2151 | Simi Valley Public Cemetery District 778 | Special District 4 | Cemetery District 11 | Ventura 8 | 5.453 | Simi Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
7176 | 7176 | 7175 | {"type": "Polygon", "coordinates": [[[-118.80554, 34.41483], [-118.80553, 34.41552], [-118.8039, 34.41551], [-118.8039, 34.41481], [-118.80554, 34.41483]]]} | Open Access 1 | 18596 | Piru Cemetery | 23745 | 2110 | Piru Cemetery District 851 | Special District 4 | Cemetery District 11 | Special District 4 | 2110 | Piru Cemetery District 830 | Special District 4 | Cemetery District 11 | Ventura 8 | 2.875 | Piru Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | ||
16671 | 16671 | 16670 | {"type": "MultiPolygon", "coordinates": [[[[-118.63435, 34.26451], [-118.63268, 34.26432], [-118.63255, 34.26343], [-118.63255, 34.26335], [-118.63296, 34.26341], [-118.633, 34.26352], [-118.63309, 34.26362], [-118.63412, 34.26439], [-118.63421, 34.26445], [-118.63435, 34.26451]]], [[[-118.63408, 34.26421], [-118.63317, 34.26353], [-118.63313, 34.26349], [-118.6331, 34.26343], [-118.63408, 34.26421]]], [[[-118.64241, 34.26544], [-118.64241, 34.26544], [-118.63966, 34.26513], [-118.64075, 34.26487], [-118.64116, 34.26472], [-118.6416, 34.26474], [-118.64193, 34.26496], [-118.64241, 34.26544]]], [[[-118.65257, 34.26332], [-118.65037, 34.26526], [-118.65009, 34.26548], [-118.64982, 34.26565], [-118.64952, 34.2658], [-118.64915, 34.26594], [-118.64882, 34.26603], [-118.64848, 34.26609], [-118.6482, 34.26612], [-118.64791, 34.26612], [-118.64756, 34.2661], [-118.64751, 34.2661], [-118.64748, 34.26603], [-118.64283, 34.26549], [-118.64348, 34.26536], [-118.64388, 34.2654], [-118.64427, 34.26536], [-118.645, 34.26547], [-118.64542, 34.26537], [-118.64602, 34.26547], [-118.64696, 34.26521], [-118.64777, 34.26569], [-118.64823, 34.2657], [-118.64884, 34.26588], [-118.64935, 34.26581], [-118.64963, 34.26569], [-118.64982, 34.26558], [-118.65069, 34.2649], [-118.65252, 34.26328], [-118.65257, 34.26332]]], [[[-118.66075, 34.27569], [-118.66053, 34.27645], [-118.66044, 34.27711], [-118.66003, 34.27729], [-118.65944, 34.27707], [-118.65914, 34.27686], [-118.6588, 34.2768], [-118.65854, 34.27652], [-118.65859, 34.27631], [-118.65852, 34.27578], [-118.65856, 34.27569], [-118.65875, 34.27573], [-118.65911, 34.27539], [-118.65935, 34.27507], [-118.65964, 34.27529], [-118.65991, 34.27524], [-118.65992, 34.27576], [-118.66075, 34.27569]]]]} | Open Access 1 | 15137 | Rancho Simi Recreation and Park District | 24178 | 2117 | Rancho Simi Open Space Conservation Agency 345 | Special District 4 | Open Space District 6 | Special District 4 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | Ventura 8 | 18.867 | Rancho Simi Rec. and Park District | 0 | Local Recreation Area 3 | 4 | ||
2337 | 2337 | 2336 | {"type": "Polygon", "coordinates": [[[-118.9423, 34.36055], [-118.9423, 34.36195], [-118.94129, 34.36223], [-118.94129, 34.36118], [-118.93907, 34.36194], [-118.93823, 34.36211], [-118.93755, 34.3607], [-118.93811, 34.3605], [-118.9423, 34.36055]]]} | Open Access 1 | 17047 | Bardsdale Cemetery | 15812 | 2005 | Bardsdale Cemetery District 515 | Special District 4 | Cemetery District 11 | http://bardsdalecemetery.com/ | Special District 4 | 2005 | Bardsdale Cemetery District 508 | Special District 4 | Cemetery District 11 | Ventura 8 | 14.314 | Bardsdale Cemetery | 0 | Local Historic or Cultural Area 19 | 4 | |
4024 | 4024 | 4023 | {"type": "Polygon", "coordinates": [[[-119.29637, 34.28467], [-119.29622, 34.28505], [-119.29605, 34.2852], [-119.29592, 34.28522], [-119.29579, 34.28522], [-119.29576, 34.28518], [-119.29569, 34.28521], [-119.29557, 34.28515], [-119.29543, 34.28497], [-119.29559, 34.28481], [-119.29613, 34.2845], [-119.29628, 34.28453], [-119.29637, 34.28467]]]} | Open Access 1 | 46895 | Serra Cross Park | 30394 | 3369 | San Buenaventura Heritage 711 | Non Profit 6 | Non Profit - Other 22 | http://dudleyhouse.org/ | Non Governmental Organization 10 | 3370 | Serra Cross Conservancy 696 | Non Profit 6 | Non Profit - Conservation 12 | Ventura 8 | 1.051 | Serra Cross Park | 0 | Private Recreation or Education 65 | 4 | |
16796 | 16796 | 16795 | {"type": "Polygon", "coordinates": [[[-118.86603, 34.26242], [-118.86562, 34.26252], [-118.86522, 34.26265], [-118.86394, 34.26316], [-118.86356, 34.26328], [-118.86317, 34.26338], [-118.86264, 34.26347], [-118.86097, 34.26347], [-118.86089, 34.2628], [-118.8609, 34.26237], [-118.86095, 34.26211], [-118.861, 34.2619], [-118.86109, 34.26165], [-118.86118, 34.26145], [-118.86138, 34.26111], [-118.86163, 34.2608], [-118.86183, 34.2606], [-118.86237, 34.26013], [-118.8626, 34.25991], [-118.86281, 34.25968], [-118.86305, 34.25937], [-118.86326, 34.25903], [-118.86447, 34.25686], [-118.86461, 34.25655], [-118.8647, 34.25629], [-118.86476, 34.25603], [-118.86479, 34.2557], [-118.86478, 34.25538], [-118.86473, 34.25506], [-118.86461, 34.25464], [-118.86413, 34.25349], [-118.86405, 34.25324], [-118.86401, 34.25298], [-118.86399, 34.25267], [-118.86401, 34.25241], [-118.86406, 34.2521], [-118.86415, 34.2518], [-118.86428, 34.25151], [-118.86444, 34.25123], [-118.86461, 34.25101], [-118.86483, 34.25076], [-118.86509, 34.25053], [-118.86537, 34.25033], [-118.86568, 34.25015], [-118.86601, 34.25], [-118.86601, 34.25267], [-118.86509, 34.25268], [-118.86509, 34.25349], [-118.86601, 34.2535], [-118.86603, 34.26242]]]} | Open Access 1 | 49014 | Moorpark Watershed, Parks, Recreation and Conservation Authority Open Space | 33712 | 502 | Moorpark Watershed, Parks, Recreation and Conservation Authority 1175 | Joint 8 | Joint Powers Authority 24 | http://smmc.ca.gov/Moorpark%20Watershed%20Parks%20Recreation%20and%20Conservation%20Authority.html | Special District 4 | 502 | Moorpark Watershed, Parks, Recreation and Conservation Authority 1115 | Joint 8 | Joint Powers Authority 23 | Ventura 8 | 80.677 | Moorpark Watershed, Parks, Rec. and Conservation Authority OS | None 1418 | |||
11198 | 11198 | 11197 | {"type": "MultiPolygon", "coordinates": [[[[-118.73232, 34.45647], [-118.73232, 34.45647], [-118.72938, 34.45993], [-118.72917, 34.45633], [-118.73232, 34.45647]]], [[[-118.77496, 34.46532], [-118.77496, 34.46779], [-118.77117, 34.46778], [-118.77204, 34.46532], [-118.77496, 34.46532]]], [[[-118.78789, 34.44718], [-118.78788, 34.44861], [-118.78349, 34.44887], [-118.78351, 34.44482], [-118.78789, 34.44718]]], [[[-118.82325, 34.42628], [-118.82323, 34.42994], [-118.81445, 34.42998], [-118.80552, 34.42997], [-118.80543, 34.4227], [-118.81444, 34.42265], [-118.81446, 34.41902], [-118.81888, 34.41902], [-118.81885, 34.42629], [-118.82325, 34.42628]]], [[[-118.81433, 34.46193], [-118.80996, 34.46192], [-118.80989, 34.45856], [-118.81426, 34.45859], [-118.81433, 34.46193]]], [[[-118.83202, 34.44007], [-118.81437, 34.44095], [-118.81445, 34.43731], [-118.832, 34.4372], [-118.83202, 34.44007]]], [[[-118.83235, 34.36109], [-118.83234, 34.36463], [-118.82791, 34.36467], [-118.82792, 34.36113], [-118.83235, 34.36109]]], [[[-118.84531, 34.42624], [-118.84523, 34.42987], [-118.8406, 34.42988], [-118.8406, 34.43351], [-118.83625, 34.43353], [-118.83619, 34.42625], [-118.84531, 34.42624]]], [[[-118.84976, 34.36449], [-118.8454, 34.36453], [-118.8454, 34.36099], [-118.84105, 34.36102], [-118.84105, 34.35749], [-118.8454, 34.35745], [-118.84541, 34.36099], [-118.84976, 34.36095], [-118.84976, 34.36449]]], [[[-118.84941, 34.44], [-118.84934, 34.44291], [-118.84496, 34.44292], [-118.84502, 34.44002], [-118.84941, 34.44]]], [[[-118.8675, 34.42242], [-118.85424, 34.42256], [-118.85424, 34.41895], [-118.86749, 34.41884], [-118.8675, 34.42242]]], [[[-118.87571, 34.44972], [-118.87571, 34.45271], [-118.87132, 34.45238], [-118.86694, 34.45238], [-118.86693, 34.456], [-118.86256, 34.456], [-118.86256, 34.45237], [-118.85819, 34.45236], [-118.85819, 34.44874], [-118.86694, 34.44923], [-118.86704, 34.44617], [-118.87144, 34.44635], [-118.87133, 34.44947], [-118.87571, 34.44972]]], [[[-118.88534, 34.44359], [-118.86713, 34.44311], [-118.86732, 34.43698], [-118.88521, 34.43687], [-118.88534, 34.44359]]], [[[-118.89826, 34.45439], [-118.89748, 34.46791], [-118.89309, 34.46787], [-118.89329, 34.46454], [-118.88893, 34.46422], [-118.88916, 34.46048], [-118.88482, 34.46008], [-118.88505, 34.45651], [-118.88009, 34.45602], [-118.88009, 34.45304], [-118.89826, 34.45439]]], [[[-118.92845, 34.46541], [-118.92836, 34.46815], [-118.91507, 34.46814], [-118.91164, 34.46811], [-118.913, 34.46592], [-118.91107, 34.46513], [-118.90921, 34.46808], [-118.90187, 34.46794], [-118.90189, 34.46306], [-118.91058, 34.46317], [-118.91077, 34.4595], [-118.91577, 34.45952], [-118.91579, 34.4577], [-118.91798, 34.45772], [-118.91799, 34.46032], [-118.91982, 34.46033], [-118.91974, 34.46192], [-118.92416, 34.4619], [-118.92401, 34.46545], [-118.92845, 34.46541]], [[-118.91962, 34.46422], [-118.91961, 34.46421], [-118.91825, 34.46422], [-118.91825, 34.46741], [-118.91892, 34.46742], [-118.91942, 34.46812], [-118.91962, 34.46422]]], [[[-118.91357, 34.455], [-118.9135, 34.45608], [-118.91148, 34.45618], [-118.91149, 34.45506], [-118.91357, 34.455]]], [[[-118.95576, 34.40292], [-118.95566, 34.4083], [-118.95146, 34.40834], [-118.95146, 34.40834], [-118.95576, 34.40292]]], [[[-119.01219, 34.33513], [-119.0078, 34.33508], [-118.99034, 34.33516], [-118.99033, 34.33175], [-119.0078, 34.33191], [-119.00781, 34.33235], [-119.01219, 34.3324], [-119.01219, 34.33513]]], [[[-119.20254, 34.34002], [-119.20251, 34.34364], [-119.19898, 34.34366], [-119.19898, 34.34366], [-119.20254, 34.34002]]], [[[-119.20686, 34.34723], [-119.20685, 34.34849], [-119.20247, 34.34847], [-119.20248, 34.34721], [-119.20686, 34.34723]]], [[[-119.22436, 34.34732], [-119.22435, 34.34858], [-119.21122, 34.34852], [-119.21123, 34.34725], [-119.22436, 34.34732]]], [[[-119.22443, 34.33656], [-119.22441, 34.34007], [-119.22003, 34.34005], [-119.22006, 34.33653], [-119.22443, 34.33656]]], [[[-119.23318, 34.3366], [-119.23316, 34.34012], [-119.22878, 34.3401], [-119.22881, 34.33658], [-119.23318, 34.3366]]], [[[-119.36981, 34.35576], [-119.36978, 34.35938], [-119.36541, 34.35936], [-119.36544, 34.35573], [-119.36981, 34.35576]]], [[[-119.37833, 34.36306], [-119.37831, 34.36557], [-119.37412, 34.36375], [-119.37412, 34.36303], [-119.37833, 34.36306]]], [[[-119.44064, 34.78482], [-119.44061, 34.78658], [-119.43844, 34.78655], [-119.43839, 34.78833], [-119.43621, 34.78831], [-119.43629, 34.78471], [-119.44064, 34.78482]]], [[[-119.44233, 34.79312], [-119.4423, 34.7963], [-119.44019, 34.79658], [-119.43989, 34.79293], [-119.44233, 34.79312]]], [[[-119.50229, 33.27293], [-119.5022, 33.27296], [-119.5021, 33.27293], [-119.50196, 33.27283], [-119.50191, 33.27278], [-119.50186, 33.27272], [-119.5018, 33.27257], [-119.50181, 33.27252], [-119.50185, 33.27248], [-119.50189, 33.27248], [-119.50214, 33.27259], [-119.50222, 33.27266], [-119.50227, 33.27274], [-119.50229, 33.27284], [-119.50229, 33.27293]]], [[[-119.52818, 33.28579], [-119.52822, 33.28587], [-119.52822, 33.28591], [-119.52818, 33.28599], [-119.52814, 33.28603], [-119.52802, 33.28606], [-119.52792, 33.28605], [-119.52785, 33.28602], [-119.52775, 33.28594], [-119.52773, 33.28589], [-119.52775, 33.28584], [-119.52778, 33.28583], [-119.52792, 33.28584], [-119.52799, 33.28583], [-119.52813, 33.28578], [-119.52818, 33.28579]]], [[[-119.52874, 33.28604], [-119.52872, 33.28607], [-119.52865, 33.28609], [-119.52849, 33.28608], [-119.52842, 33.28604], [-119.52837, 33.28599], [-119.52837, 33.28594], [-119.5285, 33.2859], [-119.52856, 33.28591], [-119.52864, 33.28593], [-119.52869, 33.28597], [-119.52874, 33.28604]]], [[[-119.52915, 33.28694], [-119.52913, 33.28696], [-119.52907, 33.28695], [-119.52892, 33.2869], [-119.52874, 33.2868], [-119.52869, 33.28674], [-119.52868, 33.28672], [-119.52876, 33.28672], [-119.52891, 33.28677], [-119.52909, 33.28687], [-119.52915, 33.28694]]], [[[-119.53004, 33.28718], [-119.52998, 33.28728], [-119.52998, 33.28737], [-119.52996, 33.28742], [-119.52989, 33.28743], [-119.52979, 33.28742], [-119.52972, 33.28739], [-119.52953, 33.2872], [-119.52955, 33.28715], [-119.5296, 33.28712], [-119.52971, 33.28712], [-119.52989, 33.2871], [-119.52997, 33.28713], [-119.53004, 33.28718]]], [[[-119.53089, 33.2883], [-119.53088, 33.28837], [-119.53086, 33.28839], [-119.53076, 33.28837], [-119.53054, 33.28813], [-119.5305, 33.28803], [-119.53056, 33.28801], [-119.53063, 33.28802], [-119.53074, 33.28807], [-119.53086, 33.28822], [-119.53089, 33.2883]]], [[[-119.53435, 33.28625], [-119.53428, 33.28627], [-119.53417, 33.28623], [-119.53409, 33.28616], [-119.53408, 33.28613], [-119.53408, 33.2861], [-119.53414, 33.28609], [-119.53426, 33.28612], [-119.53434, 33.2862], [-119.53435, 33.28625]]], [[[-119.53582, 33.28669], [-119.53587, 33.28671], [-119.53585, 33.28675], [-119.53582, 33.28675], [-119.53579, 33.28673], [-119.53579, 33.28671], [-119.53582, 33.28669]]], [[[-119.53641, 33.28666], [-119.53639, 33.28672], [-119.53631, 33.2867], [-119.53624, 33.28663], [-119.5362, 33.28654], [-119.53621, 33.28642], [-119.53626, 33.28637], [-119.5363, 33.28635], [-119.53634, 33.28638], [-119.53636, 33.28645], [-119.53635, 33.28651], [-119.53638, 33.28655], [-119.53641, 33.28666]]], [[[-119.54303, 33.28211], [-119.54305, 33.28217], [-119.54302, 33.28225], [-119.54295, 33.28231], [-119.54287, 33.28231], [-119.54285, 33.28225], [-119.54288, 33.28217], [-119.54295, 33.28211], [-119.54303, 33.28211]]]]} | Open Access 1 | 21485 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Ventura 8 | 2701.743 | BLM | 1899 | National Public Lands 1 | 3 | |
7261 | 7261 | 7260 | {"type": "Polygon", "coordinates": [[[-118.83515, 34.23259], [-118.83311, 34.24265], [-118.82882, 34.24621], [-118.81532, 34.23954], [-118.81766, 34.23382], [-118.81607, 34.2271], [-118.81847, 34.22638], [-118.8202, 34.22678], [-118.82229, 34.22626], [-118.82297, 34.22618], [-118.82348, 34.22618], [-118.82412, 34.22632], [-118.82474, 34.22653], [-118.82541, 34.22649], [-118.82606, 34.22664], [-118.83021, 34.22816], [-118.8305, 34.22913], [-118.83515, 34.23259]]]} | Restricted Access 2 | 49003 | Calleguas Municipal Water District Open Space | 33702 | 2441 | Calleguas Municipal Water District 855 | Special District 4 | Water District 13 | http://www.calleguas.com/ | Special District 4 | 2441 | Calleguas Municipal Water District 833 | Special District 4 | Water District 13 | Ventura 8 | 702.738 | Calleguas Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
12257 | 12257 | 12256 | {"type": "Polygon", "coordinates": [[[-119.35229, 34.41078], [-119.35226, 34.4194], [-119.3518, 34.41958], [-119.35124, 34.41974], [-119.35067, 34.41984], [-119.35008, 34.41988], [-119.34966, 34.41987], [-119.34245, 34.41945], [-119.34238, 34.41944], [-119.34206, 34.4181], [-119.3442, 34.41774], [-119.34377, 34.41597], [-119.34163, 34.41632], [-119.34155, 34.416], [-119.34397, 34.40998], [-119.34574, 34.4099], [-119.34668, 34.41169], [-119.35204, 34.41071], [-119.35229, 34.41078]]]} | Open Access 1 | 25803 | Lake Casitas Recreation Area | 2124 | 2214 | Casitas Municipal Water District 1017 | Special District 4 | Water District 13 | http://www.casitaswater.org/ | Special District 4 | 2214 | Casitas Municipal Water District 979 | Special District 4 | Water District 13 | http://www.casitaswater.org/department.php?url=lake-casitas-recreation-area | Ventura 8 | 211.004 | Lake Casitas Rec. Area | 0 | Local Recreation Area 3 | 4 |
14605 | 14605 | 14604 | {"type": "MultiPolygon", "coordinates": [[[[-118.99513, 34.22522], [-118.99416, 34.22587], [-118.99396, 34.22605], [-118.99375, 34.22591], [-118.99349, 34.22579], [-118.99331, 34.22595], [-118.99269, 34.2257], [-118.99252, 34.22559], [-118.99243, 34.22558], [-118.99226, 34.2257], [-118.99199, 34.22553], [-118.99167, 34.2255], [-118.99095, 34.22567], [-118.99104, 34.22594], [-118.99101, 34.22595], [-118.9909, 34.22569], [-118.99066, 34.22576], [-118.99043, 34.22585], [-118.99, 34.22607], [-118.9896, 34.22634], [-118.98943, 34.2265], [-118.98911, 34.22683], [-118.98885, 34.22722], [-118.98877, 34.22744], [-118.98843, 34.22754], [-118.98849, 34.22787], [-118.98887, 34.22801], [-118.98902, 34.2282], [-118.98929, 34.22802], [-118.98931, 34.22804], [-118.98905, 34.22823], [-118.98924, 34.22838], [-118.98923, 34.22874], [-118.98912, 34.22905], [-118.98914, 34.22921], [-118.9893, 34.22938], [-118.9895, 34.22947], [-118.98983, 34.22948], [-118.99003, 34.22936], [-118.9921, 34.22992], [-118.99219, 34.22962], [-118.99222, 34.22963], [-118.99214, 34.22993], [-118.99272, 34.23009], [-118.99293, 34.23008], [-118.99093, 34.23081], [-118.9907, 34.23038], [-118.98808, 34.2303], [-118.988, 34.22995], [-118.98796, 34.22918], [-118.98793, 34.22897], [-118.98784, 34.22871], [-118.98762, 34.22825], [-118.9882, 34.22881], [-118.9887, 34.22844], [-118.98783, 34.22762], [-118.98744, 34.2279], [-118.98729, 34.22759], [-118.98807, 34.22714], [-118.98771, 34.22668], [-118.99037, 34.22519], [-118.991, 34.22491], [-118.99138, 34.22482], [-118.99334, 34.22503], [-118.9945, 34.22449], [-118.99463, 34.22466], [-118.99491, 34.22495], [-118.99513, 34.22522]]], [[[-118.99869, 34.2319], [-118.99551, 34.23195], [-118.99551, 34.23225], [-118.99501, 34.23226], [-118.99474, 34.23228], [-118.99444, 34.23234], [-118.99414, 34.23243], [-118.99398, 34.23211], [-118.99401, 34.2316], [-118.99351, 34.23109], [-118.99307, 34.23094], [-118.99266, 34.23108], [-118.99251, 34.23148], [-118.99273, 34.2318], [-118.99282, 34.2321], [-118.99313, 34.23256], [-118.99255, 34.23317], [-118.9928, 34.23352], [-118.99239, 34.23411], [-118.9921, 34.23297], [-118.99215, 34.23248], [-118.99151, 34.23088], [-118.99461, 34.22975], [-118.99494, 34.23038], [-118.99559, 34.2306], [-118.99549, 34.23078], [-118.99589, 34.23105], [-118.99579, 34.23124], [-118.996, 34.23123], [-118.99817, 34.23176], [-118.99866, 34.23174], [-118.99869, 34.2319]]], [[[-119.03767, 34.24169], [-119.03769, 34.24188], [-119.03766, 34.24206], [-119.03755, 34.24226], [-119.03741, 34.2424], [-119.03726, 34.24249], [-119.03712, 34.24254], [-119.03626, 34.24276], [-119.0357, 34.24116], [-119.03624, 34.24102], [-119.0361, 34.24063], [-119.03575, 34.24066], [-119.03573, 34.2406], [-119.03607, 34.24057], [-119.03608, 34.24056], [-119.03505, 34.23759], [-119.03521, 34.23755], [-119.03562, 34.23873], [-119.03601, 34.23864], [-119.03603, 34.23869], [-119.03564, 34.2388], [-119.03622, 34.24044], [-119.03662, 34.24035], [-119.03665, 34.24043], [-119.03625, 34.24054], [-119.03673, 34.24192], [-119.03767, 34.24169]]]]} | Open Access 1 | 48297 | Mission Verde Park | 32869 | 1708 | Camarillo, City of 1117 | City 2 | City Agency 2 | http://www.ci.camarillo.ca.us/ | City 2 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 57.518 | Mission Verde Park | 0 | Local Park 2 | 4 | |
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 | |||
10550 | 10550 | 10549 | {"type": "Polygon", "coordinates": [[[-119.2115, 34.14498], [-119.21144, 34.1451], [-119.21107, 34.14541], [-119.21085, 34.14564], [-119.21076, 34.14577], [-119.21036, 34.14629], [-119.21009, 34.14666], [-119.20999, 34.14675], [-119.20965, 34.14675], [-119.21029, 34.14606], [-119.21007, 34.1459], [-119.21066, 34.1451], [-119.21066, 34.14509], [-119.21019, 34.14498], [-119.20968, 34.14508], [-119.20968, 34.1448], [-119.20939, 34.1449], [-119.20923, 34.14492], [-119.20903, 34.14498], [-119.20848, 34.14505], [-119.20719, 34.14501], [-119.20696, 34.14498], [-119.20618, 34.14493], [-119.20559, 34.14486], [-119.2047, 34.1448], [-119.20412, 34.14471], [-119.20317, 34.14468], [-119.20299, 34.14466], [-119.20291, 34.14496], [-119.20276, 34.14496], [-119.20078, 34.14437], [-119.20039, 34.14443], [-119.20004, 34.1448], [-119.19995, 34.14479], [-119.19953, 34.14467], [-119.19632, 34.14354], [-119.19595, 34.14346], [-119.19551, 34.14345], [-119.19531, 34.14358], [-119.19519, 34.14351], [-119.19504, 34.14345], [-119.19325, 34.14297], [-119.19281, 34.14283], [-119.19253, 34.14272], [-119.19215, 34.14254], [-119.19213, 34.14249], [-119.19217, 34.14241], [-119.19218, 34.14235], [-119.19216, 34.14223], [-119.19207, 34.14206], [-119.19191, 34.14191], [-119.19073, 34.14132], [-119.1907, 34.14133], [-119.19054, 34.14123], [-119.1904, 34.14143], [-119.19008, 34.14182], [-119.18738, 34.14024], [-119.18701, 34.14013], [-119.18703, 34.14009], [-119.18691, 34.14002], [-119.1872, 34.13969], [-119.18842, 34.14039], [-119.18921, 34.13945], [-119.18921, 34.13944], [-119.18897, 34.13931], [-119.19003, 34.1384], [-119.19478, 34.1407], [-119.19691, 34.14178], [-119.19859, 34.14257], [-119.19944, 34.14301], [-119.20034, 34.14353], [-119.2015, 34.14387], [-119.20213, 34.14416], [-119.2024, 34.14424], [-119.20259, 34.14426], [-119.2027, 34.14425], [-119.20296, 34.14417], [-119.20317, 34.14415], [-119.20328, 34.14417], [-119.20346, 34.14424], [-119.20376, 34.14433], [-119.20615, 34.14465], [-119.2073, 34.14478], [-119.20802, 34.14482], [-119.20852, 34.14484], [-119.2088, 34.14481], [-119.20899, 34.14477], [-119.2094, 34.14459], [-119.20952, 34.14456], [-119.2098, 34.14458], [-119.20989, 34.14456], [-119.20992, 34.1445], [-119.21, 34.14444], [-119.21012, 34.1444], [-119.21039, 34.14439], [-119.21049, 34.14443], [-119.21061, 34.14452], [-119.2107, 34.14464], [-119.21095, 34.14479], [-119.21125, 34.14486], [-119.21144, 34.14489], [-119.2115, 34.14498]]]} | Open Access 1 | 18769 | Port Hueneme Beach Park | 23895 | 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 | 84.698 | Port Hueneme Beach Park | 0 | Local Park 2 | 4 | |
10685 | 10685 | 10684 | {"type": "Polygon", "coordinates": [[[-119.19989, 34.14896], [-119.19989, 34.14896], [-119.19806, 34.14897], [-119.19932, 34.1479], [-119.19941, 34.14788], [-119.19989, 34.14788], [-119.19989, 34.14896]]]} | Open Access 1 | 19042 | Dewar Park | 18129 | 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 | 3.254 | Dewar Park | 0 | Local Park 2 | 4 | |
10686 | 10686 | 10685 | {"type": "Polygon", "coordinates": [[[-119.20755, 34.17884], [-119.20754, 34.17904], [-119.20727, 34.17903], [-119.20726, 34.17901], [-119.20656, 34.17901], [-119.20655, 34.17934], [-119.20584, 34.17933], [-119.20584, 34.179], [-119.20515, 34.179], [-119.20513, 34.17902], [-119.20486, 34.17902], [-119.20486, 34.17882], [-119.20545, 34.17882], [-119.20545, 34.17859], [-119.2055, 34.17859], [-119.2055, 34.17882], [-119.20585, 34.17882], [-119.20586, 34.1777], [-119.20655, 34.1777], [-119.20655, 34.17883], [-119.20687, 34.17883], [-119.20688, 34.1786], [-119.20692, 34.1786], [-119.20693, 34.17883], [-119.20755, 34.17884]]]} | Open Access 1 | 19043 | Bolker Park | 16242 | 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 | 3.884 | Bolker Park | 0 | Local Park 2 | 4 | |
14611 | 14611 | 14610 | {"type": "MultiPolygon", "coordinates": [[[[-119.19434, 34.14702], [-119.19433, 34.14707], [-119.19391, 34.14688], [-119.19333, 34.1465], [-119.19303, 34.14638], [-119.19298, 34.14639], [-119.19295, 34.14641], [-119.19288, 34.14663], [-119.19269, 34.14661], [-119.19238, 34.14661], [-119.19236, 34.14658], [-119.19233, 34.14657], [-119.1923, 34.14658], [-119.1923, 34.14662], [-119.192, 34.14662], [-119.19195, 34.1466], [-119.19192, 34.14657], [-119.19185, 34.14631], [-119.19075, 34.14631], [-119.19062, 34.14621], [-119.19072, 34.14603], [-119.19077, 34.14582], [-119.19086, 34.14561], [-119.19091, 34.14537], [-119.19105, 34.14499], [-119.19356, 34.14501], [-119.19357, 34.1463], [-119.19362, 34.14637], [-119.19359, 34.14643], [-119.19359, 34.14649], [-119.19364, 34.14655], [-119.19372, 34.14658], [-119.19386, 34.14673], [-119.194, 34.14684], [-119.19434, 34.14702]]], [[[-119.1912, 34.14742], [-119.19114, 34.14742], [-119.1911, 34.14727], [-119.19113, 34.14727], [-119.19116, 34.14742], [-119.1912, 34.14742]]], [[[-119.19532, 34.14759], [-119.19529, 34.14762], [-119.19438, 34.14762], [-119.19436, 34.1476], [-119.19459, 34.14755], [-119.19487, 34.14743], [-119.19489, 34.14739], [-119.19488, 34.14736], [-119.19466, 34.14714], [-119.19478, 34.14704], [-119.19501, 34.1472], [-119.19508, 34.1472], [-119.19519, 34.14706], [-119.19525, 34.14694], [-119.19529, 34.1468], [-119.19532, 34.14679], [-119.19532, 34.14759]]]]} | Open Access 1 | 48305 | Moranda Park | 32874 | 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 | https://www.ci.port-hueneme.ca.us/553/City-Parks | Ventura 8 | 11.157 | Moranda Park | 0 | Local Park 2 | 4 |
16832 | 16832 | 16831 | {"type": "MultiPolygon", "coordinates": [[[[-119.19078, 34.14223], [-119.19054, 34.14233], [-119.19052, 34.14221], [-119.19013, 34.14195], [-119.18818, 34.1408], [-119.18823, 34.14074], [-119.19078, 34.14223]]], [[[-119.19114, 34.14742], [-119.19055, 34.1474], [-119.19052, 34.14738], [-119.19042, 34.14709], [-119.19037, 34.14681], [-119.19039, 34.14498], [-119.19105, 34.14499], [-119.19091, 34.14537], [-119.19086, 34.14561], [-119.19077, 34.14582], [-119.19072, 34.14603], [-119.19062, 34.14621], [-119.19075, 34.14631], [-119.19072, 34.14676], [-119.19079, 34.1471], [-119.19086, 34.14726], [-119.1911, 34.14727], [-119.19114, 34.14742]]], [[[-119.19156, 34.14326], [-119.1915, 34.14399], [-119.19141, 34.14442], [-119.19124, 34.14492], [-119.19083, 34.14492], [-119.19088, 34.1449], [-119.19105, 34.14436], [-119.19114, 34.14397], [-119.1912, 34.14325], [-119.1912, 34.14286], [-119.1911, 34.14272], [-119.19063, 34.14282], [-119.19047, 34.14276], [-119.19055, 34.14265], [-119.19065, 34.14255], [-119.19081, 34.14247], [-119.19095, 34.14243], [-119.19111, 34.14241], [-119.19126, 34.14243], [-119.19153, 34.14253], [-119.19153, 34.14324], [-119.19156, 34.14326]]], [[[-119.193, 34.15068], [-119.19266, 34.15067], [-119.19241, 34.14991], [-119.1917, 34.14914], [-119.19093, 34.14813], [-119.19068, 34.14772], [-119.19072, 34.14768], [-119.19085, 34.14769], [-119.19099, 34.14796], [-119.19158, 34.14883], [-119.19169, 34.1489], [-119.19182, 34.14912], [-119.19189, 34.14912], [-119.19222, 34.14952], [-119.19238, 34.14967], [-119.19264, 34.15048], [-119.19292, 34.15042], [-119.193, 34.15068]]], [[[-119.19455, 34.15469], [-119.19447, 34.15469], [-119.19448, 34.15466], [-119.19417, 34.1539], [-119.19391, 34.15397], [-119.19298, 34.15167], [-119.1932, 34.15167], [-119.19363, 34.15272], [-119.19366, 34.15272], [-119.19382, 34.15311], [-119.19382, 34.15324], [-119.19397, 34.15325], [-119.19455, 34.15469]]], [[[-119.19426, 34.15496], [-119.19386, 34.15608], [-119.19383, 34.15607], [-119.19422, 34.15496], [-119.19426, 34.15496]]]]} | Open Access 1 | 48306 | Bubbling Springs Recreation Corridor | 32875 | 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 | 8.856 | Bubbling Springs Rec. Corridor | 0 | Local Recreation Area 3 | 4 | |
502 | 502 | 501 | {"type": "Polygon", "coordinates": [[[-119.06104, 34.35542], [-119.06084, 34.35549], [-119.06077, 34.35534], [-119.06097, 34.35527], [-119.06104, 34.35542]]]} | Open Access 1 | 48366 | Moreton Bay Fig Tree Park | 32932 | 1674 | Santa Paula, City of 190 | City 2 | City Agency 2 | http://www.ci.santa-paula.ca.us/ | City 2 | 1674 | Santa Paula, City of 186 | City 2 | City Agency 2 | Ventura 8 | 0.091 | Moreton Bay Fig Tree Park | 0 | Local Park 2 | 4 | |
3412 | 3412 | 3411 | {"type": "Polygon", "coordinates": [[[-119.05243, 34.35374], [-119.05079, 34.35604], [-119.05052, 34.35545], [-119.04998, 34.35562], [-119.04962, 34.35554], [-119.0491, 34.35495], [-119.05114, 34.35351], [-119.05209, 34.35298], [-119.05243, 34.35374]]]} | Open Access 1 | 25016 | Harding Park | 19676 | 1674 | Santa Paula, City of 190 | City 2 | City Agency 2 | http://www.ci.santa-paula.ca.us/ | City 2 | 1674 | Santa Paula, City of 186 | City 2 | City Agency 2 | Ventura 8 | 11.199 | Harding Park | 0 | Local Park 2 | 4 | |
4097 | 4097 | 4096 | {"type": "MultiPolygon", "coordinates": [[[[-119.06075, 34.35593], [-119.05977, 34.35625], [-119.05969, 34.35609], [-119.06068, 34.35577], [-119.06075, 34.35593]]], [[[-119.06339, 34.35513], [-119.06255, 34.35535], [-119.0616, 34.35565], [-119.06157, 34.35561], [-119.06148, 34.35564], [-119.06144, 34.35557], [-119.06095, 34.35574], [-119.06093, 34.35569], [-119.06331, 34.35494], [-119.06339, 34.35513]]]]} | Open Access 1 | 48365 | Railroad Plaza Mini Park | 32931 | 1674 | Santa Paula, City of 190 | City 2 | City Agency 2 | http://www.ci.santa-paula.ca.us/ | City 2 | 1674 | Santa Paula, City of 186 | City 2 | City Agency 2 | Ventura 8 | 1.341 | Railroad Plaza MP | 0 | Local Park 2 | 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]);