units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,203 rows where ACCESS_TYP = 2 sorted by AGNCY_TYP descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER, MNG_AG_LEV, GAP_STS
MNG_AGENCY >30
- California Department of Fish and Wildlife 71
- University of California 47
- United States Fish and Wildlife Service 41
- Woodbridge Village Association 31
- Home Owners Association - Unknown Name 27
- Sacramento, County of 23
- Los Angeles, City of 20
- Whittier, City of 20
- East Bay Regional Park District 19
- Rancho Santa Margarita Landscape and Recreation Corporation 18
- Sempervirens Fund 16
- Los Angeles Unified School District 16
- San Ramon, City of 15
- Los Angeles, County of 14
- The Nature Conservancy 14
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- United States Bureau of Land Management 12
- California Department of Parks and Recreation 11
- San Diego, City of 10
- San Francisco - Public Utilities Commission, City and County of 10
- Sonoma Land Trust 9
- Long Beach, City of 9
- United States National Park Service 8
- Arcadia, City of 8
- Sonoma County Agricultural Preservation and Open Space District 8
- Manhattan Beach, City of 8
- Santa Cruz, City of 7
- Hayward Area Recreation and Park District 7
- Amerige Heights Community Association 7
- …
DES_TP >30
- Local Recreation Area 220
- Local Park 210
- Private Recreation or Education 194
- Private Conservation 154
- State Conservation Area 109
- Local Conservation Area 47
- National Wildlife Refuge 36
- Local Other or Unknown 31
- National Public Lands 9
- Recreation Management Area 9
- State Resource Management Area 7
- Private Other or Unknown 7
- Federal Other or Unknown 6
- Conservation Area 5
- State Park 4
- National Park 4
- State Recreation Area 4
- Local Resource Management Area 4
- Private Agricultural 4
- Local Historic or Cultural Area 3
- National Recreation Area 2
- Resource Management Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Wilderness Area 1
- …
MNG_AG_TYP 25
- City Agency 363
- Home Owners Association 202
- State Agency 149
- Non Profit - Land Trust 139
- Federal Agency 81
- Recreation/Parks District 64
- County Agency 59
- School District 38
- Non Profit - Conservation 20
- Water District 14
- County Agency - Other 12
- County Agency - Parks 11
- Commercial 9
- Non Profit - Other 8
- Open Space District 7
- Joint Powers Authority 6
- Community Services District 4
- Flood District 3
- Irrigation District 3
- Other 3
- Conservation District 3
- Sanitation District 2
- Metropolitan Planning Organization 1
- Home Owners Associatin 1
- Non Profit - Education 1
ACCESS_TYP 1
- Restricted Access · 1,203 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9926 | 9926 | 9925 | {"type": "MultiPolygon", "coordinates": [[[[-122.24863, 37.40116], [-122.24858, 37.40128], [-122.24857, 37.40138], [-122.2485, 37.40152], [-122.24845, 37.40167], [-122.24843, 37.40184], [-122.24838, 37.40196], [-122.24814, 37.40227], [-122.248, 37.40263], [-122.24802, 37.40288], [-122.24775, 37.40305], [-122.24701, 37.40248], [-122.24627, 37.40217], [-122.24622, 37.40169], [-122.24555, 37.40159], [-122.24558, 37.40139], [-122.24559, 37.40123], [-122.24568, 37.40119], [-122.2457, 37.40102], [-122.24567, 37.40079], [-122.24557, 37.40042], [-122.24546, 37.40022], [-122.24524, 37.39994], [-122.24512, 37.39983], [-122.24499, 37.39966], [-122.24488, 37.39948], [-122.24475, 37.39923], [-122.24472, 37.39914], [-122.24469, 37.39889], [-122.24471, 37.3988], [-122.24475, 37.39874], [-122.24485, 37.39867], [-122.24494, 37.39863], [-122.24508, 37.39861], [-122.24518, 37.39855], [-122.24521, 37.3985], [-122.24532, 37.39847], [-122.24545, 37.39847], [-122.24599, 37.39871], [-122.24622, 37.39874], [-122.24635, 37.39886], [-122.24674, 37.39905], [-122.2469, 37.39916], [-122.24718, 37.39927], [-122.24757, 37.39946], [-122.24777, 37.3996], [-122.24793, 37.39978], [-122.2483, 37.40012], [-122.24839, 37.40026], [-122.24857, 37.40076], [-122.24863, 37.40116]]], [[[-122.24529, 37.40123], [-122.24527, 37.40141], [-122.24523, 37.40157], [-122.24487, 37.40162], [-122.24438, 37.40227], [-122.24487, 37.40246], [-122.24445, 37.40353], [-122.24437, 37.40389], [-122.24434, 37.40427], [-122.24438, 37.40469], [-122.24449, 37.40511], [-122.24525, 37.40675], [-122.24532, 37.40694], [-122.24535, 37.40714], [-122.24536, 37.40739], [-122.24531, 37.40764], [-122.24524, 37.40782], [-122.24516, 37.40798], [-122.24504, 37.40815], [-122.24477, 37.40841], [-122.2445, 37.40859], [-122.24344, 37.40915], [-122.24206, 37.41025], [-122.24059, 37.41156], [-122.23918, 37.41055], [-122.23716, 37.41093], [-122.23668, 37.41129], [-122.23635, 37.41141], [-122.23611, 37.4113], [-122.23599, 37.41092], [-122.2355, 37.41083], [-122.2349, 37.4106], [-122.23481, 37.41057], [-122.23472, 37.41053], [-122.23464, 37.41052], [-122.23463, 37.41051], [-122.23448, 37.41019], [-122.23354, 37.41013], [-122.23311, 37.41], [-122.23218, 37.41013], [-122.23167, 37.41053], [-122.23147, 37.41094], [-122.23116, 37.4112], [-122.2308, 37.41132], [-122.22947, 37.41164], [-122.22907, 37.41168], [-122.22818, 37.41115], [-122.22785, 37.41111], [-122.22753, 37.41117], [-122.22722, 37.41137], [-122.22683, 37.41146], [-122.22633, 37.4118], [-122.22613, 37.41218], [-122.22603, 37.41253], [-122.22307, 37.41289], [-122.22287, 37.41276], [-122.22282, 37.41269], [-122.2228, 37.41261], [-122.2227, 37.41248], [-122.22264, 37.41244], [-122.22259, 37.41233], [-122.22251, 37.41226], [-122.22211, 37.41161], [-122.22178, 37.41133], [-122.2216, 37.41122], [-122.22134, 37.4111], [-122.22116, 37.41105], [-122.22079, 37.411], [-122.22043, 37.41093], [-122.22015, 37.41084], [-122.21996, 37.41075], [-122.21978, 37.41065], [-122.21962, 37.41051], [-122.21952, 37.41038], [-122.21951, 37.41032], [-122.21941, 37.41018], [-122.21936, 37.41002], [-122.2193, 37.40994], [-122.21931, 37.40974], [-122.21917, 37.40951], [-122.21903, 37.40916], [-122.21891, 37.40896], [-122.21881, 37.40888], [-122.21867, 37.40881], [-122.21866, 37.40879], [-122.21854, 37.40855], [-122.21848, 37.40832], [-122.21839, 37.40815], [-122.21836, 37.40809], [-122.21836, 37.40803], [-122.21832, 37.40793], [-122.21811, 37.40767], [-122.21803, 37.40754], [-122.21793, 37.40742], [-122.21785, 37.40734], [-122.21767, 37.40722], [-122.21751, 37.40715], [-122.21734, 37.40711], [-122.21679, 37.40702], [-122.21655, 37.40693], [-122.2165, 37.40689], [-122.21626, 37.4068], [-122.21587, 37.40658], [-122.21592, 37.40631], [-122.21379, 37.40504], [-122.21035, 37.40363], [-122.20976, 37.40446], [-122.20482, 37.40185], [-122.20647, 37.40132], [-122.21002, 37.40039], [-122.21896, 37.39775], [-122.23376, 37.39344], [-122.23394, 37.39365], [-122.23369, 37.3937], [-122.2336, 37.39371], [-122.23356, 37.39391], [-122.2337, 37.39394], [-122.23375, 37.39398], [-122.23374, 37.39409], [-122.23345, 37.39409], [-122.23344, 37.39411], [-122.23353, 37.3943], [-122.23406, 37.39415], [-122.23417, 37.39436], [-122.23403, 37.39459], [-122.23412, 37.39473], [-122.23366, 37.39494], [-122.23376, 37.3951], [-122.23397, 37.39505], [-122.23397, 37.39538], [-122.23421, 37.39545], [-122.23423, 37.39555], [-122.23411, 37.39557], [-122.23405, 37.39576], [-122.23442, 37.39592], [-122.23433, 37.39605], [-122.23414, 37.39596], [-122.23399, 37.39597], [-122.23393, 37.39614], [-122.23425, 37.39626], [-122.23428, 37.39637], [-122.2344, 37.39645], [-122.23427, 37.39658], [-122.23411, 37.39655], [-122.23369, 37.39674], [-122.23354, 37.39662], [-122.23344, 37.39663], [-122.23335, 37.39678], [-122.23345, 37.39688], [-122.23335, 37.39694], [-122.23312, 37.397], [-122.23317, 37.39726], [-122.23339, 37.39724], [-122.2336, 37.3971], [-122.23427, 37.39735], [-122.23451, 37.39735], [-122.235, 37.39731], [-122.23527, 37.39734], [-122.23561, 37.39733], [-122.23578, 37.39712], [-122.23579, 37.39676], [-122.23621, 37.39646], [-122.23653, 37.39604], [-122.23747, 37.39598], [-122.23778, 37.39551], [-122.23809, 37.39599], [-122.23812, 37.396], [-122.238, 37.39605], [-122.23796, 37.39633], [-122.23787, 37.39651], [-122.23766, 37.39678], [-122.23773, 37.39703], [-122.23752, 37.39773], [-122.23775, 37.39814], [-122.23789, 37.39864], [-122.23783, 37.39914], [-122.23828, 37.39983], [-122.23844, 37.39983], [-122.23851, 37.39948], [-122.23892, 37.39915], [-122.23929, 37.39907], [-122.23952, 37.39911], [-122.23977, 37.39905], [-122.24024, 37.3987], [-122.2405, 37.39863], [-122.24071, 37.39855], [-122.24084, 37.39854], [-122.24138, 37.39859], [-122.24144, 37.39866], [-122.24181, 37.39875], [-122.24211, 37.39911], [-122.24239, 37.39914], [-122.2426, 37.3987], [-122.24249, 37.39866], [-122.24231, 37.39851], [-122.24235, 37.39835], [-122.24252, 37.39837], [-122.2441, 37.39833], [-122.24412, 37.39879], [-122.24417, 37.39884], [-122.24421, 37.39911], [-122.2443, 37.39936], [-122.24436, 37.39949], [-122.24443, 37.39955], [-122.2446, 37.40001], [-122.24471, 37.40011], [-122.24511, 37.40077], [-122.24521, 37.40105], [-122.24529, 37.40116], [-122.24529, 37.40123]]]]} | Restricted Access 2 | 17067 | Jasper Ridge Reserve | 20369 | 3346 | Stanford University 938 | Non Profit 6 | Non Profit - Education 34 | http://jrbp.stanford.edu/ | Non Governmental Organization 10 | 3346 | Stanford University 911 | Non Profit 6 | Non Profit - Education 32 | San Mateo 15 | 1095.659 | Jasper Ridge Reserve | 0 | Private Conservation 16 | 2 | |
9390 | 9390 | 9389 | {"type": "Polygon", "coordinates": [[[-120.15384, 39.14012], [-120.15376, 39.14043], [-120.15368, 39.14056], [-120.15361, 39.14109], [-120.15352, 39.14139], [-120.15335, 39.14156], [-120.15315, 39.14172], [-120.15285, 39.14206], [-120.15275, 39.14225], [-120.1527, 39.14246], [-120.15268, 39.14162], [-120.1528, 39.14158], [-120.15291, 39.14152], [-120.15298, 39.14145], [-120.15303, 39.14135], [-120.15304, 39.14125], [-120.153, 39.14107], [-120.153, 39.14086], [-120.15305, 39.14047], [-120.15318, 39.14001], [-120.15368, 39.14001], [-120.15369, 39.14012], [-120.15384, 39.14012]]]} | Restricted Access 2 | 49025 | Tahoe Park | 33726 | 6140 | Lake Tahoe Park Association 908 | Private 7 | Home Owners Associatin 33 | https://www.laketahoeparkassociation.com/ | Private 14 | 6140 | Lake Tahoe Park Association 881 | Private 7 | Home Owners Associatin 31 | https://www.laketahoeparkassociation.com/sub_category_list.asp?category=9&title=Park+and+Beach+General+Policies | Placer 35 | 2.739 | Tahoe Park | 0 | Private Recreation or Education 65 | 4 |
7380 | 7380 | 7379 | {"type": "MultiPolygon", "coordinates": [[[[-118.02362, 34.03786], [-118.02295, 34.03812], [-118.02142, 34.03872], [-118.02185, 34.03849], [-118.02227, 34.03822], [-118.02267, 34.03795], [-118.02315, 34.03758], [-118.02362, 34.03786]]], [[[-118.02425, 34.03824], [-118.01421, 34.04219], [-118.01399, 34.04191], [-118.02388, 34.03802], [-118.02425, 34.03824]]], [[[-118.01723, 34.04177], [-118.01626, 34.04227], [-118.01533, 34.04283], [-118.01464, 34.04327], [-118.0137, 34.04395], [-118.01315, 34.04438], [-118.01261, 34.04483], [-118.01196, 34.04542], [-118.01122, 34.04617], [-118.01112, 34.0462], [-118.01097, 34.0462], [-118.01088, 34.04618], [-118.01064, 34.04602], [-118.01062, 34.04603], [-118.01055, 34.04599], [-118.01434, 34.04296], [-118.01442, 34.04302], [-118.01471, 34.04276], [-118.01723, 34.04177]]], [[[-118.00813, 34.04674], [-118.00572, 34.05101], [-118.00492, 34.05209], [-118.0047, 34.05243], [-118.0044, 34.0526], [-118.00459, 34.05168], [-118.00483, 34.05171], [-118.00497, 34.05149], [-118.00512, 34.0508], [-118.00515, 34.05058], [-118.00476, 34.0505], [-118.0049, 34.04995], [-118.0053, 34.05002], [-118.00522, 34.05038], [-118.00569, 34.05046], [-118.00621, 34.04858], [-118.00572, 34.04847], [-118.00597, 34.04755], [-118.00643, 34.04763], [-118.00676, 34.04715], [-118.00676, 34.0471], [-118.00614, 34.04697], [-118.00621, 34.04672], [-118.00813, 34.04674]]], [[[-118.01108, 34.04633], [-118.01063, 34.04683], [-118.01023, 34.0473], [-118.00996, 34.04766], [-118.00948, 34.04832], [-118.00896, 34.04913], [-118.00849, 34.04996], [-118.00809, 34.05077], [-118.00783, 34.05135], [-118.00756, 34.05209], [-118.00753, 34.05213], [-118.00733, 34.05273], [-118.00733, 34.05251], [-118.00732, 34.0525], [-118.00646, 34.054], [-118.0063, 34.05548], [-118.00608, 34.05535], [-118.00619, 34.05523], [-118.00629, 34.055], [-118.00632, 34.05481], [-118.0063, 34.05459], [-118.00622, 34.05439], [-118.00584, 34.0537], [-118.00577, 34.05354], [-118.00572, 34.05337], [-118.00571, 34.05316], [-118.00576, 34.05288], [-118.00613, 34.05187], [-118.00634, 34.05139], [-118.00709, 34.04998], [-118.00954, 34.04563], [-118.00964, 34.04567], [-118.00967, 34.04563], [-118.01026, 34.04597], [-118.0095, 34.04674], [-118.00951, 34.04683], [-118.01046, 34.04607], [-118.01087, 34.0463], [-118.01098, 34.04633], [-118.01108, 34.04633]]], [[[-118.00544, 34.05569], [-118.00531, 34.05604], [-118.00476, 34.05566], [-118.00479, 34.05563], [-118.00491, 34.05568], [-118.00516, 34.05571], [-118.00544, 34.05569]]]]} | Restricted Access 2 | 6780 | Duck Farm Property | 18295 | 2177 | Watershed Conservation Authority 860 | Special District 4 | Conservation District 31 | https://www.wca.ca.gov/ | Special District 4 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | Los Angeles 6 | 59.863 | Duck Farm Property | 0 | Local Other or Unknown 14 | 4 | |
12675 | 12675 | 12674 | {"type": "Polygon", "coordinates": [[[-118.17772, 33.93261], [-118.1772, 33.93362], [-118.17654, 33.93439], [-118.17624, 33.93465], [-118.17643, 33.93338], [-118.17627, 33.93335], [-118.17638, 33.93265], [-118.17663, 33.93236], [-118.17674, 33.93177], [-118.17687, 33.93092], [-118.177, 33.93101], [-118.1771, 33.93112], [-118.17768, 33.93213], [-118.17772, 33.93261]]]} | Restricted Access 2 | 29572 | Parque Dos Rios | 23480 | 2177 | Watershed Conservation Authority 860 | Special District 4 | Conservation District 31 | https://www.wca.ca.gov/ | Special District 4 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | Los Angeles 6 | 7.01 | Parque Dos Rios | None 1101 | |||
16193 | 16193 | 16192 | {"type": "Polygon", "coordinates": [[[-117.8387, 34.08748], [-117.83645, 34.08844], [-117.83671, 34.08887], [-117.83579, 34.08925], [-117.83468, 34.0888], [-117.83422, 34.08815], [-117.8299, 34.08931], [-117.82966, 34.08906], [-117.82897, 34.08923], [-117.82825, 34.08925], [-117.82779, 34.09009], [-117.82414, 34.09106], [-117.82236, 34.0914], [-117.82146, 34.09037], [-117.82932, 34.08826], [-117.82932, 34.08848], [-117.82926, 34.08877], [-117.82967, 34.08891], [-117.82981, 34.08893], [-117.82997, 34.08875], [-117.83024, 34.08881], [-117.83059, 34.08863], [-117.83098, 34.08845], [-117.83139, 34.08831], [-117.83181, 34.08819], [-117.83225, 34.08809], [-117.83269, 34.08803], [-117.83313, 34.08799], [-117.8335, 34.08798], [-117.83349, 34.08776], [-117.83355, 34.08758], [-117.83341, 34.08717], [-117.83793, 34.08595], [-117.8387, 34.08748]]]} | Restricted Access 2 | 29514 | Walnut Creek Habitat & Open Space | 27225 | 2177 | Watershed Conservation Authority 860 | Special District 4 | Conservation District 31 | https://www.wca.ca.gov/ | Special District 4 | 2177 | Watershed Conservation Authority 838 | Special District 4 | Conservation District 30 | Los Angeles 6 | 53.623 | Walnut Creek Habitat & OS | 0 | Local Recreation Area 3 | 4 | |
4808 | 4808 | 4807 | {"type": "MultiPolygon", "coordinates": [[[[-115.78321, 33.44046], [-115.77392, 33.44108], [-115.77379, 33.43758], [-115.78294, 33.4371], [-115.78321, 33.44046]]], [[[-116.06984, 33.53319], [-116.06976, 33.54008], [-116.06173, 33.54013], [-116.06184, 33.5332], [-116.06984, 33.53319]]], [[[-116.07016, 33.54381], [-116.06187, 33.54384], [-116.0618, 33.54029], [-116.07006, 33.54025], [-116.07016, 33.54381]]], [[[-116.07025, 33.52194], [-116.07021, 33.52554], [-116.06587, 33.52555], [-116.06592, 33.52195], [-116.07025, 33.52194]]], [[[-116.07884, 33.54003], [-116.07005, 33.54008], [-116.07018, 33.5293], [-116.07878, 33.52922], [-116.07884, 33.54003]]], [[[-116.08351, 33.52921], [-116.07898, 33.52923], [-116.07896, 33.52627], [-116.08048, 33.52731], [-116.0814, 33.52791], [-116.08233, 33.5285], [-116.08351, 33.52921]]], [[[-116.0877, 33.56202], [-116.08765, 33.56926], [-116.0833, 33.56925], [-116.08334, 33.56386], [-116.08121, 33.56385], [-116.08123, 33.56203], [-116.0877, 33.56202]]], [[[-116.08997, 33.5328], [-116.08539, 33.53282], [-116.08537, 33.53101], [-116.08323, 33.53101], [-116.08341, 33.52924], [-116.08353, 33.52924], [-116.08618, 33.53071], [-116.08938, 33.5324], [-116.08966, 33.53257], [-116.08997, 33.5328]]], [[[-116.08549, 33.5593], [-116.08548, 33.5602], [-116.08328, 33.56019], [-116.08328, 33.55931], [-116.08549, 33.5593]]], [[[-116.10722, 33.56925], [-116.09547, 33.56926], [-116.09556, 33.55473], [-116.09612, 33.55585], [-116.09672, 33.5569], [-116.09739, 33.55791], [-116.09787, 33.55857], [-116.09832, 33.55915], [-116.09885, 33.55978], [-116.10621, 33.56821], [-116.10722, 33.56925]]]]} | Restricted Access 2 | 48605 | Unnamed Site - Coachella Valley Association of Governments | 33314 | 2018 | Coachella Valley Association of Governments 788 | Special District 4 | Metropolitan Planning Organization 27 | http://www.cvag.org/ | Special District 4 | 2018 | Coachella Valley Association of Governments 767 | Special District 4 | Metropolitan Planning Organization 25 | http://www.cvag.org | Riverside 10 | 909.041 | 0 | Local Other or Unknown 14 | 4 | |
15427 | 15427 | 15426 | {"type": "Polygon", "coordinates": [[[-116.96631, 32.65277], [-116.96564, 32.6533], [-116.96602, 32.65375], [-116.96606, 32.65404], [-116.96482, 32.65413], [-116.96359, 32.65388], [-116.96354, 32.65344], [-116.96469, 32.65281], [-116.96408, 32.6518], [-116.9643, 32.65168], [-116.96476, 32.65241], [-116.96542, 32.65319], [-116.96614, 32.65261], [-116.96631, 32.65277]]]} | Restricted Access 2 | 46691 | Scobee Park | 30036 | 6103 | Private Landowner 584 | Private 7 | Other 25 | Private 14 | 6103 | Private Landowner 774 | Private 7 | Other 26 | San Diego 4 | 7.196 | Scobee Park | 0 | Private Recreation or Education 65 | 4 | ||
2587 | 2587 | 2586 | {"type": "Polygon", "coordinates": [[[-121.6993, 37.1374], [-121.69927, 37.13758], [-121.69925, 37.13763], [-121.69897, 37.1379], [-121.69889, 37.13803], [-121.69886, 37.13818], [-121.69891, 37.13845], [-121.69887, 37.13856], [-121.69879, 37.13863], [-121.69835, 37.13886], [-121.69819, 37.13898], [-121.69812, 37.13906], [-121.69804, 37.13918], [-121.698, 37.13927], [-121.69798, 37.1394], [-121.69502, 37.13925], [-121.69459, 37.14231], [-121.69775, 37.14279], [-121.69751, 37.1432], [-121.69747, 37.14338], [-121.69749, 37.14349], [-121.69753, 37.14359], [-121.69773, 37.14385], [-121.69774, 37.1439], [-121.6977, 37.14408], [-121.69774, 37.14423], [-121.69782, 37.14433], [-121.69793, 37.14441], [-121.69814, 37.14449], [-121.6985, 37.14457], [-121.69858, 37.14461], [-121.69862, 37.14465], [-121.69873, 37.14492], [-121.69878, 37.145], [-121.69885, 37.14507], [-121.69906, 37.14521], [-121.69907, 37.14526], [-121.69904, 37.1453], [-121.69893, 37.14534], [-121.69881, 37.14534], [-121.69868, 37.14529], [-121.6984, 37.14513], [-121.69831, 37.1451], [-121.69784, 37.14504], [-121.69732, 37.1449], [-121.69711, 37.14489], [-121.69657, 37.14502], [-121.69609, 37.1451], [-121.69592, 37.14514], [-121.69575, 37.14523], [-121.69534, 37.14556], [-121.69429, 37.14477], [-121.69077, 37.14709], [-121.68949, 37.14741], [-121.6883, 37.14735], [-121.68766, 37.14771], [-121.68593, 37.14831], [-121.68474, 37.14958], [-121.6848, 37.15033], [-121.68234, 37.15043], [-121.68145, 37.15097], [-121.68134, 37.15101], [-121.68069, 37.15066], [-121.67969, 37.1506], [-121.6794, 37.15055], [-121.67913, 37.15046], [-121.67887, 37.15036], [-121.67862, 37.15023], [-121.67818, 37.15011], [-121.67231, 37.14686], [-121.67232, 37.14683], [-121.67103, 37.14611], [-121.67103, 37.14609], [-121.67071, 37.14589], [-121.67035, 37.14558], [-121.67011, 37.1453], [-121.68383, 37.13848], [-121.69306, 37.1338], [-121.69859, 37.13656], [-121.69832, 37.13693], [-121.6993, 37.1374]]]} | Restricted Access 2 | 49052 | Baird Open Space Regional Reserve | 33794 | 503 | Santa Clara Valley Habitat Agency 536 | Joint 8 | Joint Powers Authority 24 | https://www.scv-habitatagency.org/ | Special District 4 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Santa Clara 19 | 597.843 | Baird OS RR | None 211 | ||
2588 | 2588 | 2587 | {"type": "Polygon", "coordinates": [[[-121.68265, 37.13906], [-121.67601, 37.14237], [-121.67267, 37.13922], [-121.67394, 37.13832], [-121.67414, 37.13831], [-121.67414, 37.13825], [-121.67417, 37.13816], [-121.67413, 37.13806], [-121.67415, 37.138], [-121.67421, 37.13787], [-121.67433, 37.13771], [-121.6747, 37.13788], [-121.67611, 37.13687], [-121.67571, 37.13647], [-121.67744, 37.13531], [-121.67854, 37.13499], [-121.68054, 37.1365], [-121.68265, 37.13906]]]} | Restricted Access 2 | 49053 | Davidson Open Space Regional Reserve | 33795 | 503 | Santa Clara Valley Habitat Agency 536 | Joint 8 | Joint Powers Authority 24 | https://www.scv-habitatagency.org/ | Special District 4 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Santa Clara 19 | 93.914 | Davidson OS RR | None 212 | ||
9815 | 9815 | 9814 | {"type": "MultiPolygon", "coordinates": [[[[-118.0981, 33.75518], [-118.09806, 33.75524], [-118.09723, 33.75729], [-118.09712, 33.75727], [-118.09712, 33.7574], [-118.09718, 33.75742], [-118.09712, 33.75756], [-118.09679, 33.75796], [-118.09678, 33.7574], [-118.09397, 33.75741], [-118.0981, 33.75518]]], [[[-118.10823, 33.7587], [-118.10791, 33.75879], [-118.10789, 33.75877], [-118.10682, 33.75905], [-118.10565, 33.75931], [-118.10521, 33.75938], [-118.10477, 33.75942], [-118.10433, 33.75944], [-118.10388, 33.75944], [-118.10387, 33.7595], [-118.09897, 33.75948], [-118.09898, 33.75944], [-118.09888, 33.75943], [-118.09766, 33.75943], [-118.09756, 33.75944], [-118.09753, 33.75948], [-118.09711, 33.75947], [-118.09713, 33.75927], [-118.09719, 33.75906], [-118.09855, 33.75569], [-118.0987, 33.75543], [-118.09888, 33.75522], [-118.0991, 33.75502], [-118.09928, 33.75491], [-118.10004, 33.75448], [-118.10066, 33.75425], [-118.10133, 33.7539], [-118.1015, 33.75378], [-118.10179, 33.75355], [-118.10197, 33.75343], [-118.10391, 33.75239], [-118.1039, 33.75304], [-118.10392, 33.75305], [-118.10544, 33.75188], [-118.10505, 33.75144], [-118.10335, 33.75235], [-118.10275, 33.75234], [-118.10578, 33.75071], [-118.10581, 33.75113], [-118.10588, 33.75155], [-118.10546, 33.75189], [-118.10624, 33.75276], [-118.10496, 33.75373], [-118.10575, 33.75452], [-118.10487, 33.7551], [-118.10823, 33.7587]]], [[[-118.1037, 33.76073], [-118.10224, 33.76073], [-118.10201, 33.76064], [-118.10203, 33.75976], [-118.10363, 33.75977], [-118.10369, 33.75982], [-118.1037, 33.76073]]], [[[-118.1044, 33.76679], [-118.10413, 33.76701], [-118.10379, 33.76693], [-118.10378, 33.76689], [-118.10341, 33.76687], [-118.10336, 33.76683], [-118.1034, 33.76645], [-118.10346, 33.76609], [-118.1044, 33.76679]]], [[[-118.11507, 33.76323], [-118.11475, 33.7634], [-118.11459, 33.76373], [-118.11427, 33.76414], [-118.11409, 33.76433], [-118.11382, 33.76457], [-118.11347, 33.76479], [-118.11321, 33.76491], [-118.1129, 33.76502], [-118.1124, 33.76514], [-118.1115, 33.76493], [-118.11152, 33.76491], [-118.11151, 33.7649], [-118.11107, 33.76499], [-118.11113, 33.76522], [-118.10929, 33.76562], [-118.10921, 33.76539], [-118.10584, 33.76612], [-118.10538, 33.76627], [-118.10496, 33.76644], [-118.10362, 33.76543], [-118.10389, 33.76452], [-118.10395, 33.76416], [-118.10399, 33.76388], [-118.104, 33.7635], [-118.10401, 33.76043], [-118.104, 33.7599], [-118.10408, 33.7599], [-118.10408, 33.75983], [-118.10459, 33.75981], [-118.10511, 33.75977], [-118.10561, 33.7597], [-118.10597, 33.75963], [-118.10599, 33.75965], [-118.10654, 33.75953], [-118.10656, 33.75946], [-118.10676, 33.75945], [-118.10678, 33.75947], [-118.10725, 33.75935], [-118.10805, 33.75914], [-118.10805, 33.75911], [-118.10954, 33.7587], [-118.10954, 33.75868], [-118.11055, 33.75842], [-118.11056, 33.75844], [-118.1106, 33.75844], [-118.11072, 33.75876], [-118.11112, 33.75891], [-118.11151, 33.75866], [-118.11346, 33.76076], [-118.11388, 33.76125], [-118.11425, 33.76177], [-118.11479, 33.76278], [-118.11483, 33.76277], [-118.11507, 33.76323]]], [[[-118.1102, 33.76604], [-118.10804, 33.76789], [-118.10525, 33.76728], [-118.10565, 33.76708], [-118.10606, 33.76694], [-118.1102, 33.76604]]], [[[-118.11134, 33.76537], [-118.11087, 33.76547], [-118.11087, 33.76547], [-118.11104, 33.76532], [-118.11134, 33.76537]]]]} | Restricted Access 2 | 47917 | Los Cerritos Wetlands | 32016 | 2418 | Los Cerritos Wetland Authority 929 | Special District 4 | Joint Powers Authority 24 | http://intoloscerritoswetlands.org | Special District 4 | 2418 | Los Cerritos Wetland Authority 902 | Special District 4 | Joint Powers Authority 23 | http://intoloscerritoswetlands.org/ | Los Angeles 6 | 311.339 | Los Cerritos Wetlands | 2006 | Local Conservation Area 4 | 2 |
9865 | 9865 | 9864 | {"type": "Polygon", "coordinates": [[[-118.10578, 33.7507], [-118.10168, 33.75292], [-118.10147, 33.75304], [-118.1011, 33.75333], [-118.10089, 33.75347], [-118.10032, 33.75377], [-118.09988, 33.75392], [-118.09965, 33.75401], [-118.09891, 33.75441], [-118.09869, 33.75454], [-118.09849, 33.7547], [-118.09831, 33.75488], [-118.09809, 33.75518], [-118.09198, 33.75848], [-118.09204, 33.75945], [-118.09112, 33.75945], [-118.09164, 33.75896], [-118.09157, 33.75739], [-118.09158, 33.75387], [-118.08764, 33.75239], [-118.08918, 33.75013], [-118.08922, 33.7501], [-118.08929, 33.7501], [-118.08955, 33.75023], [-118.08964, 33.75031], [-118.08979, 33.75034], [-118.08981, 33.75036], [-118.08981, 33.75039], [-118.08968, 33.75066], [-118.08941, 33.75105], [-118.08933, 33.7512], [-118.08928, 33.75135], [-118.08892, 33.7513], [-118.08888, 33.7515], [-118.0888, 33.75161], [-118.08872, 33.75167], [-118.08845, 33.75179], [-118.08832, 33.75191], [-118.08825, 33.75207], [-118.08825, 33.75224], [-118.08832, 33.75239], [-118.0884, 33.75248], [-118.08851, 33.75255], [-118.08863, 33.7526], [-118.08876, 33.75262], [-118.08888, 33.75261], [-118.08905, 33.75257], [-118.08918, 33.75249], [-118.08938, 33.75251], [-118.08938, 33.7526], [-118.0894, 33.75269], [-118.08945, 33.7528], [-118.08953, 33.75288], [-118.08963, 33.75295], [-118.08975, 33.753], [-118.08987, 33.75303], [-118.09001, 33.75303], [-118.0903, 33.75291], [-118.09037, 33.75284], [-118.09043, 33.75276], [-118.09054, 33.7525], [-118.09066, 33.75228], [-118.09075, 33.7521], [-118.0908, 33.75192], [-118.09083, 33.75172], [-118.09086, 33.75163], [-118.09109, 33.75129], [-118.09134, 33.75085], [-118.09161, 33.75067], [-118.09171, 33.75057], [-118.09192, 33.75029], [-118.09201, 33.75014], [-118.09208, 33.75006], [-118.09226, 33.74999], [-118.09225, 33.74995], [-118.09219, 33.74988], [-118.09207, 33.74981], [-118.09207, 33.7498], [-118.09274, 33.75002], [-118.09392, 33.75049], [-118.09404, 33.75021], [-118.0943, 33.75006], [-118.09489, 33.75005], [-118.09567, 33.74976], [-118.09748, 33.74977], [-118.09918, 33.74999], [-118.09978, 33.74999], [-118.10013, 33.74989], [-118.10034, 33.74971], [-118.10036, 33.74943], [-118.10071, 33.74928], [-118.10082, 33.74891], [-118.1013, 33.74875], [-118.10131, 33.74888], [-118.10216, 33.74867], [-118.10286, 33.74859], [-118.10307, 33.74855], [-118.10332, 33.74869], [-118.1034, 33.74872], [-118.10342, 33.74871], [-118.10352, 33.74876], [-118.10373, 33.74893], [-118.10379, 33.74891], [-118.10399, 33.74944], [-118.10574, 33.74945], [-118.10578, 33.7507]]]} | Restricted Access 2 | 47918 | Los Cerritos Wetlands | 32016 | 2418 | Los Cerritos Wetland Authority 929 | Special District 4 | Joint Powers Authority 24 | http://intoloscerritoswetlands.org | Special District 4 | 2418 | Los Cerritos Wetland Authority 902 | Special District 4 | Joint Powers Authority 23 | http://intoloscerritoswetlands.org/ | Orange 3 | 196.293 | Los Cerritos Wetlands | 2006 | Local Conservation Area 4 | 2 |
10243 | 10243 | 10242 | {"type": "Polygon", "coordinates": [[[-121.75635, 37.21971], [-121.75564, 37.22071], [-121.75151, 37.2261], [-121.75121, 37.2259], [-121.75107, 37.22578], [-121.75107, 37.22539], [-121.75109, 37.22526], [-121.75121, 37.225], [-121.74995, 37.22425], [-121.74922, 37.22423], [-121.74873, 37.22405], [-121.74844, 37.22381], [-121.74917, 37.22299], [-121.75427, 37.22089], [-121.75529, 37.22009], [-121.75635, 37.21971]]]} | Restricted Access 2 | 49054 | Tulare Hill Wedge Open Space Regional Reserve | 33796 | 503 | Santa Clara Valley Habitat Agency 536 | Joint 8 | Joint Powers Authority 24 | https://www.scv-habitatagency.org/ | Special District 4 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Santa Clara 19 | 37.498 | Tulare Hill Wedge OS RR | None 890 | ||
16268 | 16268 | 16267 | {"type": "MultiPolygon", "coordinates": [[[[-121.33318, 37.01942], [-121.33188, 37.02043], [-121.33185, 37.02053], [-121.33057, 37.02153], [-121.33035, 37.02153], [-121.32883, 37.02266], [-121.32829, 37.02321], [-121.32786, 37.02394], [-121.32768, 37.02432], [-121.32755, 37.02471], [-121.32745, 37.0251], [-121.32742, 37.02652], [-121.32737, 37.0269], [-121.32722, 37.02747], [-121.32709, 37.02784], [-121.32692, 37.0282], [-121.32672, 37.02855], [-121.32649, 37.02888], [-121.32623, 37.02921], [-121.3252, 37.03042], [-121.32465, 37.03112], [-121.32441, 37.03131], [-121.32412, 37.03164], [-121.32389, 37.03184], [-121.32365, 37.03202], [-121.3234, 37.03219], [-121.32313, 37.03235], [-121.32284, 37.03249], [-121.32254, 37.03261], [-121.31959, 37.03369], [-121.31926, 37.03379], [-121.3186, 37.03397], [-121.31804, 37.03408], [-121.3177, 37.03412], [-121.31603, 37.03443], [-121.31486, 37.03474], [-121.31471, 37.03445], [-121.3168, 37.03364], [-121.31661, 37.03311], [-121.31967, 37.03186], [-121.31922, 37.03113], [-121.32124, 37.03039], [-121.32143, 37.0303], [-121.3216, 37.0302], [-121.32172, 37.0301], [-121.32223, 37.0296], [-121.32263, 37.02907], [-121.32378, 37.02772], [-121.32397, 37.02745], [-121.32412, 37.02716], [-121.32424, 37.02686], [-121.32431, 37.02656], [-121.32434, 37.02635], [-121.3244, 37.02473], [-121.32454, 37.02415], [-121.32474, 37.02358], [-121.32499, 37.02302], [-121.32573, 37.02181], [-121.32578, 37.02182], [-121.32633, 37.02319], [-121.32831, 37.02267], [-121.32847, 37.02224], [-121.32838, 37.02221], [-121.32871, 37.02123], [-121.33079, 37.01895], [-121.33135, 37.01868], [-121.33202, 37.0188], [-121.33318, 37.01942]]], [[[-121.3394, 37.01452], [-121.33674, 37.01658], [-121.3366, 37.01662], [-121.33598, 37.01721], [-121.33518, 37.01785], [-121.33503, 37.01782], [-121.33494, 37.01789], [-121.33498, 37.01801], [-121.33349, 37.01917], [-121.33146, 37.01808], [-121.33411, 37.01517], [-121.33462, 37.01488], [-121.33712, 37.01426], [-121.3394, 37.01452]]]]} | Restricted Access 2 | 49051 | Pacheco Creek Open Space Regional Reserve | 33793 | 503 | Santa Clara Valley Habitat Agency 536 | Joint 8 | Joint Powers Authority 24 | https://www.scv-habitatagency.org/ | Special District 4 | 503 | Santa Clara Valley Habitat Agency 529 | Joint 8 | Joint Powers Authority 23 | https://www.scv-habitatagency.org/ | Santa Clara 19 | 162.38 | Pacheco Creek OS RR | None 1397 | ||
2398 | 2398 | 2397 | {"type": "MultiPolygon", "coordinates": [[[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]], [[[-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19604, 33.42917], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795]]]]} | Restricted Access 2 | 7255 | Santa Margarita Ecological Reserve | 33342 | 3065 | San Diego State University Foundation 524 | Non Profit 6 | Non Profit - Other 22 | http://www.foundation.sdsu.edu/index.html | Non Governmental Organization 10 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | San Diego 4 | 88.83 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
4471 | 4471 | 4470 | {"type": "Polygon", "coordinates": [[[-116.62024, 32.8546], [-116.62023, 32.85532], [-116.61829, 32.85533], [-116.61829, 32.85491], [-116.618, 32.85491], [-116.61799, 32.85435], [-116.61875, 32.85434], [-116.61914, 32.85341], [-116.61924, 32.85343], [-116.6193, 32.85399], [-116.61991, 32.8542], [-116.6198, 32.85446], [-116.62024, 32.8546]]]} | Restricted Access 2 | 1199 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 6.306 | 0 | Private Other or Unknown 399 | 4 | |||
4472 | 4472 | 4471 | {"type": "Polygon", "coordinates": [[[-116.31558, 33.3251], [-116.31551, 33.33963], [-116.29816, 33.3395], [-116.29841, 33.32503], [-116.31558, 33.3251]]]} | Restricted Access 2 | 1208 | Unnamed site - Nonprofit Organization - Unknown | 28649 | 3048 | Nonprofit Organization - Unknown 765 | Non Profit 6 | Non Profit - Other 22 | Non Governmental Organization 10 | 3048 | Nonprofit Organization - Unknown 746 | Non Profit 6 | Non Profit - Other 20 | San Diego 4 | 638.799 | 0 | Private Other or Unknown 399 | 4 | |||
5753 | 5753 | 5752 | {"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]} | Restricted Access 2 | 3683 | Kingsburg Historical Park | 32675 | 3138 | Kingsburg Historical Society 817 | Non Profit 6 | Non Profit - Other 22 | http://www.kingsburghistoricalpark.org/ | Non Governmental Organization 10 | 3138 | Kingsburg Historical Society 795 | Non Profit 6 | Non Profit - Other 20 | http://kingsburghistoricalpark.org/ | Fresno 9 | 4.887 | Kingsburg Historical Park | 0 | Private Recreation or Education 65 | 4 |
5847 | 5847 | 5846 | {"type": "MultiPolygon", "coordinates": [[[[-117.16733, 33.46176], [-117.16524, 33.46316], [-117.16477, 33.46349], [-117.16432, 33.46385], [-117.1639, 33.46423], [-117.16319, 33.46492], [-117.16317, 33.46482], [-117.16297, 33.46465], [-117.16293, 33.46136], [-117.1584, 33.46141], [-117.1583, 33.458], [-117.16286, 33.458], [-117.16294, 33.46135], [-117.16732, 33.46153], [-117.16733, 33.46176]]], [[[-117.17572, 33.43595], [-117.17572, 33.43673], [-117.17535, 33.43751], [-117.17514, 33.43806], [-117.17463, 33.43969], [-117.17358, 33.44319], [-117.1625, 33.4434], [-117.16239, 33.43974], [-117.17142, 33.43963], [-117.17137, 33.43602], [-117.17572, 33.43595]]], [[[-117.17577, 33.44315], [-117.17438, 33.44318], [-117.17551, 33.43984], [-117.17574, 33.43904], [-117.17577, 33.44315]]], [[[-117.1801, 33.45033], [-117.17584, 33.45044], [-117.1758, 33.44675], [-117.18006, 33.44666], [-117.1801, 33.45033]]], [[[-117.20651, 33.43216], [-117.20649, 33.43578], [-117.19766, 33.43577], [-117.1976, 33.43937], [-117.19315, 33.43935], [-117.1932, 33.43576], [-117.18876, 33.43575], [-117.18441, 33.43581], [-117.18444, 33.43223], [-117.18882, 33.43217], [-117.20651, 33.43216]]]]} | Restricted Access 2 | 21992 | Santa Margarita Ecological Reserve | 33342 | 3065 | San Diego State University Foundation 524 | Non Profit 6 | Non Profit - Other 22 | http://www.foundation.sdsu.edu/index.html | Non Governmental Organization 10 | 221 | San Diego State University 378 | State 5 | State Agency 5 | https://fsp.sdsu.edu/about-us/ | Riverside 10 | 493.628 | Santa Margarita ER | 1962 | State Conservation Area 8 | 2 |
11517 | 11517 | 11516 | {"type": "Polygon", "coordinates": [[[-117.24714, 33.20982], [-117.24712, 33.21018], [-117.2451, 33.21017], [-117.2451, 33.20897], [-117.24589, 33.20902], [-117.24596, 33.20884], [-117.24679, 33.20904], [-117.24684, 33.20979], [-117.24714, 33.20982]]]} | Restricted Access 2 | 48224 | Linda Rhoades Recreation Center | 32840 | 3385 | Educational Enrichment Systems Incorporated 983 | Non Profit 6 | Non Profit - Other 22 | http://www.educ-enrichment.org/ | Non Governmental Organization 10 | 2426 | Vista Unified School District 946 | Special District 4 | School District 21 | San Diego 4 | 5.644 | Linda Rhoades Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
12587 | 12587 | 12586 | {"type": "Polygon", "coordinates": [[[-117.18941, 33.5381], [-117.18772, 33.53937], [-117.1867, 33.53844], [-117.18884, 33.53681], [-117.1892, 33.53738], [-117.18941, 33.5381]]]} | Restricted Access 2 | 48772 | Murrieta Valley Pony Baseball | 33498 | 3397 | Murrieta Valley PONY Baseball, Inc 1031 | Non Profit 6 | Non Profit - Other 22 | https://www.mvpb.org/ | Non Governmental Organization 10 | 3397 | Murrieta Valley PONY Baseball, Inc 992 | Non Profit 6 | Non Profit - Other 20 | https://www.mvpb.org/ | Riverside 10 | 8.519 | Murrieta Valley Pony Baseball | 0 | Private Conservation 16 | 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]);