units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,212 rows where GAP_STS = 4 and MNG_AG_LEV = 3 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, LAYER
MNG_AGENCY >30
- Los Angeles, County of 138
- Santa Barbara, County of 100
- San Diego, County of 80
- Orange, County of 71
- Los Angeles - Department of Parks and Recreation, County of 59
- Lake, County of 55
- Butte, County of 53
- Kern, County of 45
- Santa Cruz, County of 42
- El Dorado, County of 42
- Santa Clara County Parks and Recreation Dept., County of 42
- Monterey, County of 41
- Sonoma County Regional Parks Dept., County of 38
- Riverside, County of 29
- Marin County Parks Department, County of 26
- San Luis Obispo, County of 25
- Ventura, County of 24
- Stanislaus, County of 24
- Placer, County of 22
- Sacramento, County of 22
- San Mateo County Parks and Recreation Dept., County of 21
- San Joaquin, County of 20
- San Bernardino, County of 18
- Merced, County of 15
- Yolo, County of 15
- Tulare, County of 14
- Fresno, County of 14
- Humboldt, County of 12
- Contra Costa County Public Works Dept., County of 8
- Mono, County of 7
- …
DES_TP 4
ACCESS_TYP 4
- Open Access 1,131
- Restricted Access 45
- No Public Access 21
- Unknown Access 15
MNG_AG_TYP 3
- County Agency 1,003
- County Agency - Parks 192
- County Agency - Other 17
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3654 | 3654 | 3653 | {"type": "Polygon", "coordinates": [[[-117.11836, 33.00338], [-117.1183, 33.00374], [-117.11756, 33.00369], [-117.11751, 33.00406], [-117.11703, 33.00401], [-117.11707, 33.00365], [-117.11615, 33.00356], [-117.11606, 33.00392], [-117.11566, 33.00389], [-117.11564, 33.00395], [-117.11496, 33.0039], [-117.11475, 33.00393], [-117.11456, 33.00399], [-117.11441, 33.00379], [-117.11455, 33.00346], [-117.11463, 33.00323], [-117.1147, 33.00315], [-117.11495, 33.00295], [-117.11527, 33.00298], [-117.11538, 33.00296], [-117.11553, 33.00327], [-117.11583, 33.00319], [-117.11718, 33.00331], [-117.11741, 33.00327], [-117.11754, 33.0033], [-117.11808, 33.00337], [-117.11836, 33.00338]]]} | Open Access 1 | 29594 | 4S Ranch Community Park | 29225 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | San Diego 4 | 5.809 | 4S Ranch Community Park | 0 | Local Park 2 | 4 |
6239 | 6239 | 6238 | {"type": "Polygon", "coordinates": [[[-117.11773, 33.01502], [-117.1175, 33.01584], [-117.11707, 33.01618], [-117.11694, 33.01675], [-117.11621, 33.01663], [-117.11619, 33.01662], [-117.11626, 33.01623], [-117.11629, 33.01582], [-117.11618, 33.01481], [-117.11619, 33.01477], [-117.11623, 33.01474], [-117.11639, 33.01475], [-117.11773, 33.01502]]]} | Open Access 1 | 1304 | 4S Ranch Heritage Park | 29226 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.39 | 4S Ranch Heritage Park | 0 | Local Park 2 | 4 |
15157 | 15157 | 15156 | {"type": "Polygon", "coordinates": [[[-117.11743, 33.01151], [-117.11752, 33.01172], [-117.11755, 33.01187], [-117.11753, 33.01206], [-117.11751, 33.01214], [-117.11748, 33.01217], [-117.11743, 33.01217], [-117.11666, 33.01201], [-117.11662, 33.01199], [-117.11658, 33.01192], [-117.11651, 33.01189], [-117.11645, 33.01189], [-117.11638, 33.01191], [-117.11618, 33.0117], [-117.11606, 33.01182], [-117.11597, 33.01213], [-117.11604, 33.01169], [-117.11601, 33.0116], [-117.11591, 33.01148], [-117.11611, 33.0115], [-117.11631, 33.01148], [-117.11653, 33.01149], [-117.1168, 33.01156], [-117.11707, 33.01159], [-117.11743, 33.01151]]]} | Open Access 1 | 46006 | 4S Ranch Homestead Park | 29267 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchLiberty.html | San Diego 4 | 1.801 | 4S Ranch Homestead Park | 0 | Local Park 2 | 4 |
15150 | 15150 | 15149 | {"type": "Polygon", "coordinates": [[[-117.11446, 33.0364], [-117.11431, 33.03678], [-117.1142, 33.03696], [-117.11407, 33.03715], [-117.11377, 33.0375], [-117.11362, 33.03763], [-117.11341, 33.03775], [-117.11311, 33.03738], [-117.1126, 33.03682], [-117.11261, 33.03678], [-117.11303, 33.03641], [-117.11347, 33.0359], [-117.11376, 33.03607], [-117.11436, 33.03631], [-117.11446, 33.0364]]]} | Open Access 1 | 45993 | 4S Ranch Liberty Park | 29187 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 4.774 | 4S Ranch Liberty Park | 0 | Local Park 2 | 4 |
15156 | 15156 | 15155 | {"type": "Polygon", "coordinates": [[[-117.10945, 33.02613], [-117.1071, 33.02507], [-117.10729, 33.02431], [-117.10808, 33.02445], [-117.10808, 33.02453], [-117.10813, 33.02459], [-117.10823, 33.02463], [-117.10995, 33.02563], [-117.10997, 33.02568], [-117.10993, 33.02573], [-117.10955, 33.02601], [-117.10945, 33.02613]]]} | Open Access 1 | 46005 | 4S Ranch Patriot Park | 29266 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks.html | San Diego 4 | 5.762 | 4S Ranch Patriot Park | 0 | Local Park 2 | 4 |
15159 | 15159 | 15158 | {"type": "Polygon", "coordinates": [[[-117.12105, 33.004], [-117.12098, 33.00409], [-117.12083, 33.00424], [-117.12067, 33.00451], [-117.12062, 33.00467], [-117.12064, 33.00492], [-117.12061, 33.00507], [-117.12023, 33.00568], [-117.11995, 33.00557], [-117.1199, 33.00545], [-117.11984, 33.00535], [-117.11975, 33.00525], [-117.11963, 33.00516], [-117.11942, 33.00505], [-117.1192, 33.00497], [-117.11907, 33.00495], [-117.11894, 33.00495], [-117.11842, 33.00502], [-117.11826, 33.00516], [-117.11817, 33.00485], [-117.11819, 33.00445], [-117.1182, 33.00431], [-117.11831, 33.00418], [-117.11838, 33.00401], [-117.11835, 33.00386], [-117.11829, 33.00382], [-117.11836, 33.00338], [-117.11849, 33.00338], [-117.11855, 33.00336], [-117.11859, 33.00332], [-117.11865, 33.00322], [-117.11868, 33.00319], [-117.11929, 33.00323], [-117.11993, 33.00317], [-117.1201, 33.0032], [-117.12038, 33.00331], [-117.12105, 33.00331], [-117.12111, 33.00375], [-117.1211, 33.00387], [-117.12105, 33.004]]]} | Open Access 1 | 46007 | 4S Ranch Sports Park | 29269 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/4SRanchParks/4SRanchSports.html | San Diego 4 | 12.833 | 4S Ranch Sports Park | 0 | Local Recreation Area 3 | 4 |
15073 | 15073 | 15072 | {"type": "Polygon", "coordinates": [[[-118.18749, 33.88301], [-118.18743, 33.88376], [-118.18718, 33.88544], [-118.18669, 33.88544], [-118.18708, 33.88292], [-118.18749, 33.88301]]]} | Open Access 1 | 45852 | 72nd Street Equestrian Park | 32687 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/72nd-street-equestrian-park/ | Los Angeles 6 | 2.957 | 72nd Street Equestrian Park | 0 | Local Recreation Area 3 | 4 |
9650 | 9650 | 9649 | {"type": "MultiPolygon", "coordinates": [[[[-119.3271, 35.23519], [-119.32338, 35.23601], [-119.32338, 35.23601], [-119.32338, 35.23584], [-119.32375, 35.23573], [-119.32462, 35.23517], [-119.3271, 35.23519]]], [[[-119.33225, 35.24252], [-119.32342, 35.24243], [-119.32339, 35.23627], [-119.32797, 35.23524], [-119.32799, 35.2355], [-119.32807, 35.23593], [-119.32811, 35.23606], [-119.32814, 35.23626], [-119.32815, 35.23644], [-119.32805, 35.23711], [-119.32806, 35.23749], [-119.32808, 35.23762], [-119.32819, 35.23794], [-119.32822, 35.2381], [-119.32822, 35.23837], [-119.32819, 35.23859], [-119.32812, 35.23877], [-119.32833, 35.23876], [-119.32839, 35.23862], [-119.32841, 35.23845], [-119.32841, 35.23804], [-119.32836, 35.2378], [-119.32825, 35.2375], [-119.32824, 35.23712], [-119.32827, 35.237], [-119.32834, 35.23645], [-119.32834, 35.23621], [-119.3282, 35.23556], [-119.32817, 35.23519], [-119.33068, 35.23462], [-119.33067, 35.23521], [-119.33113, 35.23521], [-119.33114, 35.23607], [-119.33218, 35.23608], [-119.33225, 35.24252]]]]} | Open Access 1 | 16269 | A. W. Noon Park | 15225 | 303 | Kern, County of 399 | County 3 | County Agency 3 | http://www.co.kern.ca.us/parks/ | County 3 | 303 | Kern, County of 393 | County 3 | County Agency 3 | Kern 36 | 154.121 | A. W. Noon Park | 0 | Local Park 2 | 4 | |
4330 | 4330 | 4329 | {"type": "Polygon", "coordinates": [[[-118.20079, 34.47351], [-118.1974, 34.47353], [-118.19737, 34.47181], [-118.19937, 34.4718], [-118.19969, 34.47185], [-118.1999, 34.4719], [-118.20024, 34.47204], [-118.20055, 34.47224], [-118.20078, 34.47245], [-118.20079, 34.47351]]]} | Open Access 1 | 45479 | Acton Park | 32464 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Acton_Park | Los Angeles 6 | 13.925 | Acton Park | 0 | Local Park 2 | 4 |
9586 | 9586 | 9585 | {"type": "Polygon", "coordinates": [[[-122.51646, 38.01272], [-122.51615, 38.01311], [-122.51571, 38.01298], [-122.51568, 38.01286], [-122.5156, 38.01274], [-122.51562, 38.0127], [-122.51608, 38.01244], [-122.51646, 38.01272]]]} | Open Access 1 | 16115 | Adrian Rosall Park | 15275 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 0.826 | Adrian Rosall Park | 0 | Local Park 2 | 4 | |
6180 | 6180 | 6179 | {"type": "Polygon", "coordinates": [[[-118.03777, 33.94223], [-118.03775, 33.94226], [-118.03456, 33.94387], [-118.03448, 33.94386], [-118.0328, 33.9427], [-118.03497, 33.94159], [-118.03576, 33.94213], [-118.03685, 33.94158], [-118.03773, 33.94218], [-118.03774, 33.94222], [-118.03776, 33.94222], [-118.03777, 33.94223]]]} | Open Access 1 | 1282 | Adventure Park | 15277 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 14.559 | Adventure Park | 0 | Local Park 2 | 4 | |
2482 | 2482 | 2481 | {"type": "MultiPolygon", "coordinates": [[[[-122.71352, 37.90015], [-122.71308, 37.9004], [-122.71226, 37.89978], [-122.71205, 37.89957], [-122.71194, 37.89942], [-122.7113, 37.8982], [-122.71119, 37.89809], [-122.71104, 37.89801], [-122.71091, 37.89799], [-122.71077, 37.89799], [-122.7106, 37.89803], [-122.71049, 37.89808], [-122.71041, 37.89816], [-122.71024, 37.8984], [-122.71022, 37.89851], [-122.71026, 37.89864], [-122.70994, 37.89875], [-122.71006, 37.89899], [-122.71012, 37.89919], [-122.71009, 37.8992], [-122.71, 37.89905], [-122.70983, 37.89892], [-122.70962, 37.89883], [-122.70944, 37.8988], [-122.70946, 37.89864], [-122.70969, 37.89854], [-122.70981, 37.89846], [-122.70995, 37.89832], [-122.71007, 37.89814], [-122.71013, 37.89793], [-122.71013, 37.89779], [-122.71011, 37.89765], [-122.71005, 37.89751], [-122.70991, 37.89733], [-122.70955, 37.89753], [-122.70938, 37.89742], [-122.70905, 37.89729], [-122.70883, 37.89717], [-122.70862, 37.89699], [-122.70807, 37.89619], [-122.70791, 37.89605], [-122.70774, 37.89593], [-122.70819, 37.89543], [-122.70925, 37.89589], [-122.71022, 37.89622], [-122.71056, 37.89674], [-122.71082, 37.89717], [-122.71098, 37.89748], [-122.71124, 37.89769], [-122.71126, 37.89779], [-122.71136, 37.89796], [-122.71136, 37.89802], [-122.71147, 37.89821], [-122.71194, 37.89883], [-122.71208, 37.89908], [-122.71235, 37.89934], [-122.71258, 37.89954], [-122.71285, 37.89969], [-122.71345, 37.90008], [-122.71352, 37.90015]]], [[[-122.71035, 37.90018], [-122.71029, 37.90026], [-122.71004, 37.90051], [-122.70995, 37.90066], [-122.70992, 37.90061], [-122.70991, 37.90044], [-122.70986, 37.9003], [-122.7098, 37.90028], [-122.71004, 37.8995], [-122.71008, 37.89957], [-122.71007, 37.89976], [-122.70999, 37.90011], [-122.71003, 37.90026], [-122.71035, 37.90018]]]]} | Open Access 1 | 17481 | Agate Beach | 15284 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 13.699 | Agate Beach | 0 | Local Park 2 | 4 | |
16318 | 16318 | 16317 | {"type": "Polygon", "coordinates": [[[-116.31206, 32.9622], [-116.31195, 32.96223], [-116.30382, 32.96232], [-116.29498, 32.9623], [-116.29506, 32.95855], [-116.28653, 32.95866], [-116.28678, 32.95114], [-116.29521, 32.951], [-116.29529, 32.94721], [-116.30306, 32.94726], [-116.31135, 32.94726], [-116.31206, 32.9622]]]} | Open Access 1 | 5247 | Agua Caliente Regional Park | 29024 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/AguaCaliente.html | San Diego 4 | 802.564 | Agua Caliente RP | 0 | Local Park 2 | 4 |
4433 | 4433 | 4432 | {"type": "MultiPolygon", "coordinates": [[[[-118.2896, 34.44511], [-118.28959, 34.44876], [-118.2854, 34.44869], [-118.28535, 34.44505], [-118.2896, 34.44511]]], [[[-118.29626, 34.44876], [-118.29406, 34.44876], [-118.29404, 34.44571], [-118.29402, 34.44509], [-118.29623, 34.44508], [-118.29626, 34.44876]]], [[[-118.32311, 34.4672], [-118.32304, 34.46725], [-118.32117, 34.46822], [-118.32115, 34.46719], [-118.32311, 34.4672]]]]} | Open Access 1 | 46400 | Agua Dulce Canyon Parkland | 29553 | 1319 | Santa Clarita, City of 325 | City 2 | City Agency 2 | http://www.santa-clarita.com/index.aspx?page=186 | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 61.59 | Agua Dulce Canyon Parkland | 0 | Local Park 2 | 4 | |
10361 | 10361 | 10360 | {"type": "Polygon", "coordinates": [[[-120.11686, 34.66391], [-120.11686, 34.66443], [-120.11666, 34.66443], [-120.11667, 34.6639], [-120.11686, 34.66391]]]} | Open Access 1 | 18384 | Alamo Pintado Creek | 15318 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.262 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | |
1463 | 1463 | 1462 | {"type": "Polygon", "coordinates": [[[-122.5538, 38.41058], [-122.55368, 38.41107], [-122.5537, 38.41226], [-122.55207, 38.41085], [-122.55355, 38.40986], [-122.5538, 38.41058]]]} | Open Access 1 | 9872 | Alder Park | 15346 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 4.856 | Alder Park | 1968 | Local Park 2 | 4 | |
6135 | 6135 | 6134 | {"type": "Polygon", "coordinates": [[[-121.81009, 36.98721], [-121.80994, 36.98711], [-121.80897, 36.98712], [-121.80907, 36.98747], [-121.80915, 36.98801], [-121.80804, 36.98783], [-121.80804, 36.98741], [-121.80794, 36.98713], [-121.80693, 36.98714], [-121.80692, 36.98712], [-121.80828, 36.9871], [-121.8081, 36.98657], [-121.80874, 36.98643], [-121.80896, 36.98709], [-121.81004, 36.98708], [-121.81009, 36.98721]]]} | Open Access 1 | 1127 | Aldridge Lane Park | 15351 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 3.265 | Aldridge Lane Park | 0 | Local Park 2 | 4 | |
9462 | 9462 | 9461 | {"type": "MultiPolygon", "coordinates": [[[[-117.74571, 33.5005], [-117.74518, 33.50106], [-117.74514, 33.50106], [-117.74485, 33.50091], [-117.74481, 33.50074], [-117.74412, 33.50007], [-117.74386, 33.49969], [-117.7435, 33.49927], [-117.74351, 33.49913], [-117.74349, 33.49904], [-117.74345, 33.49895], [-117.74339, 33.49893], [-117.7433, 33.49884], [-117.74307, 33.49878], [-117.74292, 33.49866], [-117.74284, 33.49857], [-117.7427, 33.49868], [-117.74249, 33.49863], [-117.74215, 33.49859], [-117.74161, 33.49828], [-117.7411, 33.49784], [-117.74078, 33.49745], [-117.7407, 33.49706], [-117.74067, 33.49704], [-117.74064, 33.49695], [-117.74062, 33.49684], [-117.74057, 33.49666], [-117.7405, 33.49662], [-117.7404, 33.49647], [-117.74038, 33.49641], [-117.74009, 33.49624], [-117.73991, 33.49625], [-117.73944, 33.49564], [-117.73923, 33.49529], [-117.7391, 33.4947], [-117.73927, 33.49442], [-117.73917, 33.4941], [-117.7398, 33.49355], [-117.7398, 33.4936], [-117.73988, 33.49366], [-117.73988, 33.49377], [-117.73981, 33.49388], [-117.73962, 33.49414], [-117.7396, 33.49427], [-117.73966, 33.4944], [-117.73968, 33.49451], [-117.73982, 33.49466], [-117.7399, 33.4948], [-117.73992, 33.49489], [-117.73997, 33.49495], [-117.74019, 33.4951], [-117.74024, 33.4952], [-117.74028, 33.49532], [-117.74029, 33.49544], [-117.74032, 33.49552], [-117.74047, 33.49575], [-117.7409, 33.49587], [-117.74107, 33.49585], [-117.74114, 33.49589], [-117.74121, 33.49598], [-117.74119, 33.49611], [-117.74106, 33.4963], [-117.74106, 33.49657], [-117.7411, 33.4967], [-117.74121, 33.49697], [-117.74125, 33.49703], [-117.74137, 33.4971], [-117.74167, 33.49735], [-117.742, 33.49752], [-117.74226, 33.49769], [-117.74235, 33.49778], [-117.74246, 33.4978], [-117.74252, 33.49786], [-117.7427, 33.49797], [-117.74289, 33.49803], [-117.74306, 33.49812], [-117.74318, 33.49821], [-117.74336, 33.49824], [-117.7435, 33.49806], [-117.74359, 33.49803], [-117.7437, 33.49795], [-117.74379, 33.49795], [-117.74383, 33.49803], [-117.7438, 33.49809], [-117.74365, 33.4982], [-117.74361, 33.49827], [-117.74364, 33.49831], [-117.74379, 33.49835], [-117.74393, 33.49845], [-117.7441, 33.49841], [-117.74421, 33.49843], [-117.74428, 33.49846], [-117.74424, 33.49855], [-117.74418, 33.49865], [-117.74415, 33.49879], [-117.74423, 33.49891], [-117.74425, 33.49898], [-117.74426, 33.49919], [-117.74453, 33.49948], [-117.74474, 33.49963], [-117.74503, 33.4998], [-117.74519, 33.49993], [-117.74528, 33.50003], [-117.74542, 33.5001], [-117.74547, 33.50016], [-117.74549, 33.50025], [-117.74558, 33.50032], [-117.74566, 33.50048], [-117.74571, 33.5005]]], [[[-117.74679, 33.50232], [-117.74662, 33.5025], [-117.74653, 33.50254], [-117.74643, 33.50256], [-117.74628, 33.50236], [-117.74632, 33.50231], [-117.74634, 33.50223], [-117.74628, 33.50198], [-117.74607, 33.50188], [-117.74596, 33.50173], [-117.74592, 33.50157], [-117.74593, 33.50147], [-117.74607, 33.50138], [-117.74615, 33.50145], [-117.74615, 33.50151], [-117.74641, 33.50162], [-117.74654, 33.50154], [-117.74666, 33.50154], [-117.74669, 33.50163], [-117.7467, 33.50176], [-117.74666, 33.50191], [-117.74666, 33.502], [-117.74673, 33.50211], [-117.74675, 33.50222], [-117.74679, 33.50232]]], [[[-117.75133, 33.50794], [-117.75119, 33.50797], [-117.75105, 33.50804], [-117.75095, 33.50794], [-117.75085, 33.50768], [-117.75078, 33.50756], [-117.75069, 33.50724], [-117.75045, 33.50702], [-117.75017, 33.50705], [-117.74972, 33.50692], [-117.74954, 33.50672], [-117.74923, 33.50647], [-117.74899, 33.50617], [-117.74885, 33.50594], [-117.74865, 33.50579], [-117.74834, 33.50551], [-117.748, 33.50525], [-117.74786, 33.50474], [-117.74764, 33.50458], [-117.74744, 33.50427], [-117.7473, 33.50414], [-117.74726, 33.5038], [-117.74684, 33.50356], [-117.74705, 33.50331], [-117.74744, 33.50365], [-117.74756, 33.50389], [-117.74759, 33.504], [-117.74765, 33.50406], [-117.74776, 33.50414], [-117.74796, 33.50422], [-117.74809, 33.50436], [-117.74819, 33.5045], [-117.74827, 33.50466], [-117.7483, 33.5048], [-117.74838, 33.5049], [-117.74849, 33.50493], [-117.74865, 33.5051], [-117.74887, 33.50529], [-117.74889, 33.50538], [-117.74893, 33.50548], [-117.74898, 33.50555], [-117.74906, 33.50559], [-117.74931, 33.50586], [-117.74947, 33.50598], [-117.74964, 33.50608], [-117.74984, 33.50633], [-117.74988, 33.50641], [-117.7502, 33.50658], [-117.75036, 33.50673], [-117.75045, 33.50677], [-117.75055, 33.50678], [-117.75067, 33.50673], [-117.75078, 33.50667], [-117.75093, 33.50663], [-117.75107, 33.50665], [-117.75114, 33.50673], [-117.75118, 33.50689], [-117.75117, 33.50707], [-117.75126, 33.50722], [-117.75122, 33.50729], [-117.75124, 33.5077], [-117.75133, 33.50794]]], [[[-117.75269, 33.51143], [-117.75257, 33.51156], [-117.75251, 33.51167], [-117.75246, 33.51185], [-117.75247, 33.51199], [-117.75245, 33.5121], [-117.75238, 33.51226], [-117.75219, 33.51236], [-117.75198, 33.51242], [-117.74989, 33.51241], [-117.74968, 33.51243], [-117.74962, 33.51202], [-117.74932, 33.51168], [-117.74996, 33.51147], [-117.7502, 33.51164], [-117.75062, 33.51162], [-117.75087, 33.51145], [-117.75107, 33.51119], [-117.7512, 33.51111], [-117.75127, 33.5112], [-117.75133, 33.51136], [-117.75139, 33.51142], [-117.75146, 33.51145], [-117.75159, 33.51145], [-117.75204, 33.51131], [-117.75212, 33.51127], [-117.75222, 33.51118], [-117.75225, 33.51117], [-117.75253, 33.5113], [-117.75269, 33.51143]]], [[[-117.75603, 33.51286], [-117.75547, 33.51286], [-117.75541, 33.51285], [-117.75535, 33.51276], [-117.75531, 33.51274], [-117.75524, 33.51266], [-117.75502, 33.51258], [-117.75489, 33.51238], [-117.75449, 33.51197], [-117.75426, 33.51178], [-117.754, 33.51162], [-117.75374, 33.51189], [-117.75372, 33.51187], [-117.75397, 33.5116], [-117.75351, 33.51121], [-117.7529, 33.51086], [-117.75295, 33.51076], [-117.75302, 33.5107], [-117.75302, 33.51058], [-117.75308, 33.5105], [-117.75312, 33.51038], [-117.75318, 33.51028], [-117.75327, 33.51019], [-117.75332, 33.51016], [-117.75342, 33.51017], [-117.75361, 33.51037], [-117.75379, 33.51045], [-117.75409, 33.51076], [-117.75428, 33.51091], [-117.75446, 33.51112], [-117.75493, 33.5116], [-117.75532, 33.51215], [-117.75572, 33.51257], [-117.75586, 33.51275], [-117.75603, 33.51286]]]]} | Open Access 1 | 15813 | Aliso Beach Park | 32092 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.ocparks.com/beaches/aliso/ | Orange 3 | 39.83 | Aliso Beach Park | 0 | Local Park 2 | 4 |
11312 | 11312 | 11311 | {"type": "Polygon", "coordinates": [[[-117.73018, 33.55145], [-117.73007, 33.55132], [-117.72978, 33.55133], [-117.72939, 33.55053], [-117.72916, 33.55018], [-117.72897, 33.54996], [-117.72876, 33.54976], [-117.72853, 33.54958], [-117.72827, 33.54942], [-117.72799, 33.54928], [-117.72755, 33.54911], [-117.72752, 33.54904], [-117.72746, 33.54902], [-117.72745, 33.54903], [-117.72738, 33.54901], [-117.72731, 33.54903], [-117.72704, 33.54898], [-117.72655, 33.54894], [-117.72607, 33.54895], [-117.72575, 33.549], [-117.72543, 33.54907], [-117.72512, 33.54917], [-117.72468, 33.54936], [-117.72441, 33.54952], [-117.72416, 33.54971], [-117.72393, 33.54991], [-117.72373, 33.55013], [-117.72359, 33.55033], [-117.7234, 33.55064], [-117.72207, 33.55341], [-117.72199, 33.55343], [-117.72127, 33.55319], [-117.72092, 33.55312], [-117.72067, 33.5531], [-117.72063, 33.55307], [-117.7206, 33.55302], [-117.72044, 33.55301], [-117.72053, 33.55288], [-117.72059, 33.55272], [-117.72067, 33.55258], [-117.72097, 33.55223], [-117.72098, 33.55213], [-117.72095, 33.55209], [-117.7209, 33.55205], [-117.72162, 33.55112], [-117.72088, 33.55051], [-117.72113, 33.55036], [-117.72217, 33.55008], [-117.72278, 33.54928], [-117.72298, 33.54867], [-117.72267, 33.548], [-117.72316, 33.54718], [-117.72349, 33.54598], [-117.7245, 33.54554], [-117.72578, 33.54423], [-117.72935, 33.54504], [-117.7294, 33.54846], [-117.72929, 33.54921], [-117.72978, 33.54978], [-117.73, 33.55017], [-117.72998, 33.55076], [-117.73018, 33.55145]]]} | Open Access 1 | 22037 | Aliso Canyon Community Park | 15369 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | http://www.cityofalisoviejo.com/location/aliso-canyon-community-park/ | Orange 3 | 90.084 | Aliso Canyon Community Park | 0 | Local Park 2 | 4 |
5200 | 5200 | 5199 | {"type": "MultiPolygon", "coordinates": [[[[-117.67339, 33.63513], [-117.67274, 33.63562], [-117.67252, 33.63583], [-117.67227, 33.63618], [-117.67222, 33.63633], [-117.67221, 33.63656], [-117.67246, 33.63654], [-117.67268, 33.63669], [-117.67244, 33.63722], [-117.6725, 33.63728], [-117.67219, 33.6375], [-117.67205, 33.63786], [-117.67164, 33.63811], [-117.67151, 33.63824], [-117.67119, 33.63911], [-117.67077, 33.63963], [-117.67087, 33.6397], [-117.67099, 33.6397], [-117.67073, 33.63992], [-117.67073, 33.63982], [-117.67051, 33.63964], [-117.67033, 33.63966], [-117.66992, 33.64057], [-117.66954, 33.64096], [-117.66945, 33.64111], [-117.66885, 33.64158], [-117.66848, 33.64251], [-117.66832, 33.64266], [-117.66798, 33.64287], [-117.66827, 33.64325], [-117.66818, 33.64358], [-117.66789, 33.64361], [-117.66762, 33.64368], [-117.66672, 33.64404], [-117.66673, 33.64407], [-117.66671, 33.64409], [-117.66663, 33.64436], [-117.66654, 33.64454], [-117.66653, 33.64478], [-117.66671, 33.64513], [-117.66644, 33.64529], [-117.66621, 33.6455], [-117.66576, 33.64614], [-117.66609, 33.64631], [-117.66561, 33.64698], [-117.66528, 33.64684], [-117.665, 33.64719], [-117.6645, 33.64762], [-117.6641, 33.64793], [-117.66394, 33.64812], [-117.66366, 33.64852], [-117.66336, 33.64919], [-117.66328, 33.64947], [-117.66326, 33.64975], [-117.66333, 33.65004], [-117.66269, 33.6505], [-117.66179, 33.65181], [-117.66136, 33.65233], [-117.66137, 33.65234], [-117.66167, 33.65252], [-117.66134, 33.6529], [-117.66134, 33.65292], [-117.66102, 33.65276], [-117.66085, 33.65298], [-117.66065, 33.65342], [-117.66055, 33.65389], [-117.66055, 33.65437], [-117.66061, 33.6548], [-117.66, 33.65484], [-117.65976, 33.65482], [-117.65968, 33.65519], [-117.65928, 33.65561], [-117.65938, 33.65626], [-117.65867, 33.65672], [-117.65831, 33.6571], [-117.65831, 33.65768], [-117.65798, 33.65901], [-117.6576, 33.65927], [-117.65734, 33.65879], [-117.65697, 33.65874], [-117.657, 33.65856], [-117.6572, 33.65837], [-117.65731, 33.65822], [-117.65742, 33.65803], [-117.65754, 33.65771], [-117.65792, 33.65713], [-117.65795, 33.65704], [-117.65875, 33.65555], [-117.65935, 33.65425], [-117.6601, 33.65256], [-117.66033, 33.65196], [-117.66043, 33.65158], [-117.66057, 33.65085], [-117.66076, 33.65005], [-117.66086, 33.64976], [-117.66102, 33.64943], [-117.66128, 33.64905], [-117.66152, 33.64873], [-117.66183, 33.6484], [-117.66393, 33.64652], [-117.66437, 33.64608], [-117.66523, 33.64506], [-117.66547, 33.64484], [-117.66577, 33.64461], [-117.66577, 33.64459], [-117.66548, 33.64438], [-117.66545, 33.64438], [-117.66567, 33.6442], [-117.66566, 33.64374], [-117.66572, 33.64358], [-117.66587, 33.64342], [-117.66625, 33.6431], [-117.6666, 33.64292], [-117.66687, 33.64298], [-117.66717, 33.64284], [-117.66729, 33.64269], [-117.66785, 33.64256], [-117.66798, 33.64247], [-117.66821, 33.64209], [-117.66812, 33.64196], [-117.66796, 33.64192], [-117.66805, 33.64171], [-117.66802, 33.64162], [-117.66807, 33.64159], [-117.66811, 33.64152], [-117.66814, 33.64135], [-117.66831, 33.64116], [-117.66842, 33.6411], [-117.66876, 33.64094], [-117.66886, 33.64086], [-117.66935, 33.64026], [-117.66943, 33.64], [-117.66943, 33.6396], [-117.6695, 33.63936], [-117.66957, 33.63925], [-117.66977, 33.63906], [-117.66982, 33.63904], [-117.66988, 33.63904], [-117.67001, 33.63894], [-117.67, 33.63892], [-117.66998, 33.63894], [-117.66997, 33.63892], [-117.66999, 33.63889], [-117.67037, 33.63855], [-117.67046, 33.63843], [-117.67051, 33.63831], [-117.67053, 33.63818], [-117.67052, 33.63791], [-117.67054, 33.6378], [-117.67058, 33.6377], [-117.67066, 33.63759], [-117.67085, 33.6374], [-117.67092, 33.63729], [-117.671, 33.6371], [-117.67106, 33.63699], [-117.6712, 33.63685], [-117.67138, 33.63672], [-117.67148, 33.63663], [-117.67155, 33.63652], [-117.67161, 33.63639], [-117.67164, 33.63626], [-117.67164, 33.63614], [-117.67158, 33.63589], [-117.67158, 33.63579], [-117.67161, 33.63567], [-117.67173, 33.63547], [-117.67182, 33.63538], [-117.67193, 33.63531], [-117.67206, 33.63526], [-117.67235, 33.63519], [-117.6725, 33.63512], [-117.67257, 33.63507], [-117.6726, 33.635], [-117.67261, 33.63493], [-117.6726, 33.63486], [-117.67254, 33.63481], [-117.67278, 33.63461], [-117.67339, 33.63513]]], [[[-117.65995, 33.65983], [-117.65924, 33.66003], [-117.65848, 33.66011], [-117.65819, 33.66003], [-117.65767, 33.65947], [-117.65796, 33.65928], [-117.65824, 33.65925], [-117.65828, 33.65934], [-117.65852, 33.65956], [-117.65987, 33.65959], [-117.65995, 33.65983]]], [[[-117.65959, 33.65875], [-117.65959, 33.65888], [-117.65889, 33.65885], [-117.65891, 33.65877], [-117.65895, 33.65874], [-117.65959, 33.65875]]], [[[-117.68678, 33.6252], [-117.68659, 33.62536], [-117.68659, 33.62543], [-117.68657, 33.62543], [-117.6865, 33.62548], [-117.68648, 33.62556], [-117.68633, 33.62556], [-117.68596, 33.62587], [-117.68596, 33.62595], [-117.68587, 33.62599], [-117.68582, 33.62606], [-117.68573, 33.62605], [-117.68526, 33.62643], [-117.68532, 33.62649], [-117.6852, 33.62658], [-117.6852, 33.62666], [-117.68522, 33.6267], [-117.68503, 33.62686], [-117.68514, 33.62696], [-117.68497, 33.62711], [-117.68497, 33.62718], [-117.68491, 33.62718], [-117.68483, 33.62723], [-117.68481, 33.62727], [-117.68481, 33.62734], [-117.68486, 33.6274], [-117.68446, 33.62773], [-117.68449, 33.62782], [-117.6844, 33.62787], [-117.68438, 33.62792], [-117.68439, 33.628], [-117.68436, 33.62801], [-117.68428, 33.62816], [-117.68412, 33.62838], [-117.68425, 33.62864], [-117.68444, 33.62881], [-117.6843, 33.62881], [-117.68415, 33.62878], [-117.68372, 33.62864], [-117.6836, 33.62862], [-117.68339, 33.62862], [-117.68323, 33.62865], [-117.68151, 33.62911], [-117.68136, 33.62913], [-117.68106, 33.62924], [-117.67999, 33.63011], [-117.67993, 33.63022], [-117.67988, 33.63034], [-117.67987, 33.63061], [-117.67992, 33.63077], [-117.68004, 33.63097], [-117.67952, 33.63048], [-117.67922, 33.63072], [-117.67927, 33.6308], [-117.67924, 33.63082], [-117.67922, 33.63086], [-117.67908, 33.63084], [-117.67885, 33.63102], [-117.67886, 33.63105], [-117.67863, 33.63124], [-117.67868, 33.63134], [-117.67862, 33.63138], [-117.67861, 33.63143], [-117.67849, 33.63141], [-117.67825, 33.63159], [-117.67834, 33.63168], [-117.67811, 33.63188], [-117.67811, 33.63192], [-117.67802, 33.63196], [-117.678, 33.63201], [-117.67792, 33.632], [-117.67767, 33.63219], [-117.6777, 33.63223], [-117.67752, 33.6324], [-117.67757, 33.63256], [-117.67752, 33.63258], [-117.67747, 33.63264], [-117.67747, 33.63268], [-117.67753, 33.63274], [-117.67752, 33.63277], [-117.67754, 33.63279], [-117.67746, 33.63292], [-117.67756, 33.63303], [-117.67736, 33.63326], [-117.67738, 33.63333], [-117.67733, 33.63335], [-117.67728, 33.63341], [-117.67728, 33.63347], [-117.67732, 33.63351], [-117.67726, 33.63356], [-117.67694, 33.63395], [-117.67628, 33.63376], [-117.67616, 33.63382], [-117.67608, 33.63378], [-117.67598, 33.63378], [-117.6759, 33.63385], [-117.6758, 33.63381], [-117.67533, 33.63387], [-117.67534, 33.63383], [-117.67638, 33.633], [-117.67634, 33.63293], [-117.67668, 33.63278], [-117.67654, 33.63259], [-117.67676, 33.63247], [-117.67682, 33.63237], [-117.67692, 33.63222], [-117.67707, 33.63206], [-117.67732, 33.63185], [-117.67736, 33.63187], [-117.67755, 33.63172], [-117.67752, 33.63169], [-117.67758, 33.63163], [-117.67741, 33.6315], [-117.67752, 33.6313], [-117.67762, 33.631], [-117.67774, 33.63077], [-117.67784, 33.63066], [-117.67822, 33.63049], [-117.67843, 33.63045], [-117.67858, 33.63041], [-117.67873, 33.63033], [-117.67922, 33.62995], [-117.67936, 33.62983], [-117.67953, 33.62966], [-117.67974, 33.62941], [-117.67996, 33.6291], [-117.68007, 33.62885], [-117.68026, 33.62851], [-117.68036, 33.6284], [-117.68043, 33.6283], [-117.68046, 33.62814], [-117.68045, 33.62796], [-117.68041, 33.62781], [-117.68036, 33.62767], [-117.68023, 33.6275], [-117.68052, 33.62727], [-117.68196, 33.62851], [-117.68348, 33.62728], [-117.68366, 33.62698], [-117.68422, 33.62639], [-117.68449, 33.62599], [-117.68467, 33.62614], [-117.68476, 33.62613], [-117.68482, 33.62606], [-117.68492, 33.62614], [-117.6866, 33.62477], [-117.68678, 33.6252]]], [[[-117.68005, 33.63097], [-117.68008, 33.631], [-117.68008, 33.63101], [-117.68008, 33.63101], [-117.68005, 33.63097]]], [[[-117.6958, 33.61292], [-117.69566, 33.61315], [-117.69531, 33.6131], [-117.69534, 33.61303], [-117.69537, 33.61282], [-117.69535, 33.6126], [-117.69529, 33.6124], [-117.69517, 33.6122], [-117.695, 33.61203], [-117.69481, 33.61188], [-117.69458, 33.61178], [-117.69392, 33.61163], [-117.69373, 33.61158], [-117.69351, 33.61149], [-117.69334, 33.6114], [-117.6932, 33.61128], [-117.69295, 33.61101], [-117.69265, 33.61115], [-117.69293, 33.611], [-117.69283, 33.61082], [-117.69273, 33.61049], [-117.69274, 33.61034], [-117.69272, 33.60982], [-117.69276, 33.60956], [-117.69286, 33.60933], [-117.69371, 33.60809], [-117.69478, 33.60647], [-117.69406, 33.60611], [-117.69396, 33.60604], [-117.69397, 33.60564], [-117.69405, 33.6057], [-117.69417, 33.60568], [-117.6942, 33.60573], [-117.69427, 33.60577], [-117.69435, 33.60577], [-117.69441, 33.60573], [-117.69449, 33.60587], [-117.69489, 33.60609], [-117.69498, 33.60608], [-117.69501, 33.60616], [-117.69508, 33.6062], [-117.69518, 33.6062], [-117.6952, 33.60618], [-117.69553, 33.60618], [-117.69519, 33.60656], [-117.69537, 33.60666], [-117.6946, 33.60724], [-117.69315, 33.60938], [-117.69309, 33.60949], [-117.69303, 33.60965], [-117.69301, 33.60987], [-117.69302, 33.61041], [-117.69306, 33.61064], [-117.69316, 33.61084], [-117.6933, 33.61103], [-117.69349, 33.61119], [-117.6937, 33.61131], [-117.69395, 33.6114], [-117.69456, 33.61153], [-117.69472, 33.61159], [-117.69488, 33.61165], [-117.69503, 33.61174], [-117.69525, 33.6119], [-117.69539, 33.61206], [-117.69554, 33.61229], [-117.69562, 33.61252], [-117.69566, 33.61279], [-117.6958, 33.61292]]], [[[-117.69774, 33.60765], [-117.6977, 33.60775], [-117.69716, 33.60756], [-117.69725, 33.60735], [-117.69747, 33.6071], [-117.6976, 33.60676], [-117.69762, 33.60675], [-117.69765, 33.60675], [-117.69772, 33.60697], [-117.69768, 33.60698], [-117.69764, 33.60702], [-117.69761, 33.60709], [-117.69752, 33.60709], [-117.6973, 33.60734], [-117.69774, 33.60765]]], [[[-117.70033, 33.60529], [-117.6999, 33.60538], [-117.69965, 33.60541], [-117.69945, 33.60555], [-117.69944, 33.60551], [-117.69969, 33.60533], [-117.69981, 33.6053], [-117.69995, 33.60531], [-117.69999, 33.6053], [-117.70005, 33.60525], [-117.70006, 33.60516], [-117.70033, 33.60529]]], [[[-117.71085, 33.59544], [-117.71082, 33.59549], [-117.71058, 33.59556], [-117.71037, 33.59593], [-117.71035, 33.59601], [-117.71028, 33.5976], [-117.71024, 33.59776], [-117.71014, 33.59793], [-117.70997, 33.5981], [-117.70937, 33.5984], [-117.70891, 33.5987], [-117.70874, 33.59888], [-117.70816, 33.59962], [-117.70764, 33.60037], [-117.70749, 33.60051], [-117.70706, 33.60056], [-117.70696, 33.6006], [-117.70696, 33.60061], [-117.70704, 33.60069], [-117.70466, 33.60241], [-117.70299, 33.60304], [-117.70259, 33.60311], [-117.70246, 33.60262], [-117.70286, 33.60255], [-117.70332, 33.60226], [-117.70443, 33.60183], [-117.70473, 33.60156], [-117.70501, 33.6009], [-117.70616, 33.60032], [-117.70682, 33.60018], [-117.70777, 33.59954], [-117.70807, 33.59917], [-117.70852, 33.59842], [-117.70868, 33.5984], [-117.70907, 33.59813], [-117.70966, 33.59784], [-117.70974, 33.59778], [-117.70981, 33.59767], [-117.70985, 33.59756], [-117.70993, 33.59575], [-117.71015, 33.59517], [-117.71085, 33.59544]]]]} | Open Access 1 | 15865 | Aliso Creek Greenbelt | 15372 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 138.055 | Aliso Creek Greenbelt | 0 | Local Recreation Area 3 | 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]);