units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
144 rows where LAYER = 13 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, YR_EST, GAP_STS
DES_TP >30
- Recreation Management Area 36
- Resource Management Area 25
- Federal Other or Unknown 23
- State Recreation Area 12
- Local Park 7
- State Conservation Area 7
- Local Recreation Area 5
- Local Conservation Area 1
- Conservation Area 1
- None 1
- None 1
- National Wildlife Refuge 1
- Research or Educational Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AGENCY 20
- United States Army Corps of Engineers 52
- United States Bureau of Reclamation 29
- Other Federal 19
- California Department of Parks and Recreation 12
- United States Coast Guard 8
- California Department of Fish and Wildlife 7
- East Bay Regional Park District 2
- Needles, City of 2
- San Bernardino, County of 2
- United States Bureau of Land Management 1
- San Diego, City of 1
- Santa Barbara, County of 1
- Los Angeles, County of 1
- Los Angeles - Department of Parks and Recreation, County of 1
- Pico Rivera, City of 1
- Auburn Area Recreation and Park District 1
- Port San Luis Harbor District 1
- Palos Verdes Peninsula Land Conservancy 1
- Kare Youth League 1
- Colusa, County of 1
MNG_AG_TYP 9
ACCESS_TYP 4
- Open Access 111
- Restricted Access 19
- No Public Access 13
- Unknown Access 1
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
356 | 356 | 355 | {"type": "Polygon", "coordinates": [[[-122.49396, 38.11519], [-122.49396, 38.11668], [-122.49389, 38.11699], [-122.49376, 38.11735], [-122.49339, 38.11788], [-122.49311, 38.11825], [-122.49275, 38.11856], [-122.49241, 38.1189], [-122.49231, 38.1192], [-122.49228, 38.11936], [-122.49071, 38.12038], [-122.48879, 38.12141], [-122.48651, 38.12238], [-122.47257, 38.12807], [-122.47183, 38.12772], [-122.48389, 38.1232], [-122.49205, 38.11836], [-122.49375, 38.11703], [-122.49245, 38.11561], [-122.4906, 38.11561], [-122.49396, 38.11519]]]} | Restricted Access 2 | 982 | Sonoma Baylands | 25608 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Sonoma 16 | 37.517 | Sonoma Baylands | None 36 | |||
710 | 710 | 709 | {"type": "Polygon", "coordinates": [[[-122.49778, 38.11503], [-122.49513, 38.11705], [-122.49391, 38.11801], [-122.49231, 38.1192], [-122.49241, 38.1189], [-122.49275, 38.11856], [-122.49311, 38.11825], [-122.49339, 38.11787], [-122.49376, 38.11735], [-122.49389, 38.11699], [-122.49396, 38.11668], [-122.49396, 38.11519], [-122.49778, 38.11503]]]} | No Public Access 3 | 4004 | Sonoma Baylands | 25607 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Sonoma 16 | 14.555 | Sonoma Baylands | None 66 | |||
2309 | 2309 | 2308 | {"type": "Polygon", "coordinates": [[[-121.93508, 36.63686], [-121.9352, 36.63631], [-121.93434, 36.63622], [-121.93403, 36.63597], [-121.93388, 36.63682], [-121.93373, 36.6367], [-121.93358, 36.63661], [-121.93345, 36.63655], [-121.93323, 36.63651], [-121.93265, 36.63645], [-121.93242, 36.63646], [-121.93198, 36.63652], [-121.93186, 36.63652], [-121.93169, 36.63648], [-121.93134, 36.63634], [-121.93112, 36.63628], [-121.93293, 36.63126], [-121.93296, 36.63122], [-121.93303, 36.63118], [-121.93313, 36.63118], [-121.93652, 36.63197], [-121.93658, 36.63201], [-121.93667, 36.63215], [-121.93684, 36.63233], [-121.93807, 36.63346], [-121.93815, 36.63355], [-121.9382, 36.63364], [-121.93822, 36.63377], [-121.93822, 36.63386], [-121.9382, 36.63394], [-121.93815, 36.63403], [-121.93806, 36.63412], [-121.93782, 36.63431], [-121.93772, 36.63442], [-121.93748, 36.63485], [-121.93724, 36.63514], [-121.93701, 36.63548], [-121.93691, 36.63556], [-121.93657, 36.63575], [-121.93643, 36.63587], [-121.93631, 36.63603], [-121.93599, 36.63655], [-121.93587, 36.63669], [-121.93578, 36.63676], [-121.93565, 36.63681], [-121.93508, 36.63686]]]} | Restricted Access 2 | 18342 | Pacific Grove Golf Links / Lighthouse Reservation | 33065 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Monterey 14 | 63.831 | Pacific Grove Golf Links / Lighthouse Reservation | None 192 | |||
3092 | 3092 | 3091 | {"type": "MultiPolygon", "coordinates": [[[[-122.50346, 40.63652], [-122.50346, 40.63912], [-122.50327, 40.63918], [-122.50131, 40.63907], [-122.49859, 40.63901], [-122.49788, 40.63902], [-122.49787, 40.63908], [-122.49371, 40.63742], [-122.49382, 40.63681], [-122.50346, 40.63652]]], [[[-122.52689, 40.65487], [-122.52646, 40.6586], [-122.52177, 40.65854], [-122.52219, 40.65493], [-122.52469, 40.65491], [-122.52521, 40.65444], [-122.5266, 40.65469], [-122.52689, 40.65487]]]]} | Open Access 1 | 25177 | Ash Creek WA | 15647 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Shasta 27 | 87.712 | Ash Creek WA | None 251 | |||
3130 | 3130 | 3129 | {"type": "MultiPolygon", "coordinates": [[[[-120.12091, 37.14841], [-120.1202, 37.1484], [-120.12022, 37.14807], [-120.11991, 37.14744], [-120.11891, 37.14665], [-120.11848, 37.14651], [-120.11311, 37.14264], [-120.11265, 37.14235], [-120.11132, 37.14138], [-120.11132, 37.14127], [-120.11243, 37.14128], [-120.11915, 37.14615], [-120.11933, 37.14643], [-120.12079, 37.1475], [-120.12091, 37.14841]]], [[[-120.12237, 37.15854], [-120.12117, 37.15884], [-120.12026, 37.15686], [-120.12025, 37.15548], [-120.11762, 37.15546], [-120.11901, 37.15433], [-120.12017, 37.1543], [-120.12019, 37.14857], [-120.12097, 37.14857], [-120.12092, 37.15196], [-120.12093, 37.15573], [-120.12146, 37.15765], [-120.12237, 37.15854]]]]} | Open Access 1 | 25781 | Madera Canal | 21650 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Madera 48 | 43.907 | Madera Canal | None 256 | |||
3619 | 3619 | 3618 | {"type": "Polygon", "coordinates": [[[-124.15279, 41.05272], [-124.15266, 41.05284], [-124.15272, 41.05295], [-124.15099, 41.05294], [-124.14977, 41.0522], [-124.14791, 41.0522], [-124.14804, 41.05204], [-124.15015, 41.05077], [-124.15132, 41.05109], [-124.15127, 41.05121], [-124.15209, 41.05174], [-124.15279, 41.05272]]]} | Open Access 1 | 29668 | Coastal Access | 17464 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Humboldt 45 | 12.649 | Coastal Access | None 302 | |||
3683 | 3683 | 3682 | {"type": "Polygon", "coordinates": [[[-121.5054, 38.33521], [-121.50491, 38.33521], [-121.50369, 38.32789], [-121.50242, 38.32788], [-121.5012, 38.32057], [-121.50296, 38.32058], [-121.5054, 38.33521]]]} | Open Access 1 | 44405 | Sun River Project | 25977 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Sacramento 41 | 39.49 | Sun River Project | None 308 | |||
4297 | 4297 | 4296 | {"type": "Polygon", "coordinates": [[[-118.29942, 33.77494], [-118.29942, 33.77696], [-118.29939, 33.77872], [-118.29927, 33.77873], [-118.2993, 33.77912], [-118.29933, 33.77926], [-118.29899, 33.77937], [-118.29847, 33.77958], [-118.29817, 33.77974], [-118.29789, 33.77991], [-118.29756, 33.78016], [-118.29733, 33.78036], [-118.29719, 33.7805], [-118.29689, 33.78086], [-118.29653, 33.78039], [-118.29642, 33.78022], [-118.29629, 33.77995], [-118.2962, 33.77972], [-118.29612, 33.77939], [-118.29609, 33.77919], [-118.29609, 33.77886], [-118.29607, 33.77885], [-118.2962, 33.77664], [-118.29621, 33.77606], [-118.29618, 33.77577], [-118.29613, 33.77548], [-118.29607, 33.77519], [-118.296, 33.77494], [-118.29942, 33.77494]]]} | Restricted Access 2 | 45339 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | 18014 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 3052 | Palos Verdes Peninsula Land Conservancy 727 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 41.501 | Defense Fuel Supply Point (DFSP) - Hab. Restoration | None 377 | ||||
6150 | 6150 | 6149 | {"type": "Polygon", "coordinates": [[[-117.97651, 34.11555], [-117.97637, 34.11573], [-117.97627, 34.11571], [-117.97575, 34.11619], [-117.97526, 34.11658], [-117.97501, 34.11677], [-117.97438, 34.11716], [-117.97327, 34.11691], [-117.97332, 34.11662], [-117.97332, 34.11632], [-117.97327, 34.11607], [-117.9731, 34.11575], [-117.97295, 34.11554], [-117.97288, 34.1153], [-117.97216, 34.11418], [-117.97253, 34.11436], [-117.97307, 34.11458], [-117.97392, 34.11484], [-117.9745, 34.11498], [-117.9751, 34.11509], [-117.97581, 34.11516], [-117.97581, 34.11527], [-117.97631, 34.11528], [-117.97649, 34.11546], [-117.97651, 34.11555]]]} | Open Access 1 | 48340 | Kare Park | 32904 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 7025 | Kare Youth League 808 | Non Profit 6 | Non Profit - Other 20 | https://kyl.org/KarePark/ | Los Angeles 6 | 14.769 | Kare Park | 2017 | None 496 | |
6356 | 6356 | 6355 | {"type": "Polygon", "coordinates": [[[-120.06436, 36.10851], [-120.06462, 36.10843], [-120.06472, 36.1081], [-120.06474, 36.10732], [-120.06459, 36.10624], [-120.06428, 36.1054], [-120.06369, 36.10452], [-120.06335, 36.10411], [-120.063, 36.10402], [-120.06158, 36.10285], [-120.06294, 36.10181], [-120.06367, 36.10233], [-120.06466, 36.10355], [-120.06547, 36.10478], [-120.06571, 36.10522], [-120.06631, 36.10758], [-120.06636, 36.10886], [-120.06624, 36.10917], [-120.06596, 36.10943], [-120.06593, 36.11201], [-120.06592, 36.11647], [-120.06594, 36.1184], [-120.06585, 36.12112], [-120.06563, 36.12228], [-120.0651, 36.12381], [-120.06458, 36.12488], [-120.06321, 36.12693], [-120.06263, 36.1277], [-120.06199, 36.12863], [-120.06084, 36.13019], [-120.05989, 36.13156], [-120.05912, 36.13284], [-120.05892, 36.13375], [-120.05887, 36.13603], [-120.05892, 36.13662], [-120.05907, 36.13692], [-120.05954, 36.13801], [-120.05943, 36.13826], [-120.05921, 36.13848], [-120.05879, 36.14024], [-120.05644, 36.1436], [-120.05485, 36.14574], [-120.05292, 36.14839], [-120.05151, 36.15028], [-120.05072, 36.15122], [-120.05045, 36.15212], [-120.05075, 36.15246], [-120.05147, 36.15253], [-120.05035, 36.15321], [-120.0502, 36.15351], [-120.05025, 36.15883], [-120.05021, 36.1629], [-120.05022, 36.16702], [-120.05008, 36.17477], [-120.0501, 36.17897], [-120.05013, 36.18062], [-120.05103, 36.18127], [-120.05105, 36.18162], [-120.05002, 36.18159], [-120.0484, 36.18167], [-120.04838, 36.18015], [-120.04846, 36.17576], [-120.04852, 36.16708], [-120.04862, 36.16683], [-120.04875, 36.1641], [-120.04886, 36.15717], [-120.04889, 36.15422], [-120.04888, 36.15293], [-120.04895, 36.15202], [-120.04918, 36.15121], [-120.04973, 36.15034], [-120.05174, 36.14754], [-120.05277, 36.14615], [-120.05514, 36.14305], [-120.05724, 36.14018], [-120.05761, 36.13949], [-120.05773, 36.13865], [-120.05742, 36.13805], [-120.05723, 36.13745], [-120.05725, 36.13538], [-120.05728, 36.13042], [-120.05881, 36.13046], [-120.05996, 36.12893], [-120.06172, 36.12649], [-120.06322, 36.12415], [-120.06351, 36.12334], [-120.06378, 36.12273], [-120.0641, 36.12137], [-120.06437, 36.11999], [-120.06441, 36.11734], [-120.06443, 36.10946], [-120.06437, 36.1091], [-120.06422, 36.10884], [-120.06436, 36.10851]]]} | Restricted Access 2 | 1709 | San Luis Canal | 24929 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Fresno 9 | 327.822 | San Luis Canal | None 515 | |||
6977 | 6977 | 6976 | {"type": "Polygon", "coordinates": [[[-118.41157, 33.74115], [-118.41151, 33.74127], [-118.41156, 33.74174], [-118.41107, 33.74267], [-118.411, 33.74311], [-118.41042, 33.74286], [-118.40949, 33.74479], [-118.40945, 33.74479], [-118.40949, 33.74466], [-118.40952, 33.74448], [-118.40953, 33.74416], [-118.40949, 33.74392], [-118.40945, 33.74375], [-118.40938, 33.74359], [-118.40928, 33.74339], [-118.40898, 33.74301], [-118.4087, 33.74277], [-118.40857, 33.74268], [-118.40821, 33.74249], [-118.40792, 33.74239], [-118.40764, 33.7423], [-118.40706, 33.74218], [-118.40653, 33.74213], [-118.40563, 33.74215], [-118.4052, 33.74214], [-118.4052, 33.74212], [-118.40655, 33.74204], [-118.40774, 33.74166], [-118.40774, 33.74164], [-118.40704, 33.74132], [-118.40726, 33.74131], [-118.40832, 33.74109], [-118.40952, 33.74099], [-118.41079, 33.74097], [-118.41157, 33.74115]]]} | Restricted Access 2 | 5900 | Point Vicente Lighthouse | 23867 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 20.729 | Point Vicente Lighthouse | None 570 | |||
7012 | 7012 | 7011 | {"type": "Polygon", "coordinates": [[[-118.29494, 33.706], [-118.29474, 33.70626], [-118.29296, 33.7054], [-118.29347, 33.70526], [-118.2937, 33.70507], [-118.29383, 33.7049], [-118.29412, 33.70493], [-118.29436, 33.70513], [-118.29437, 33.70542], [-118.29462, 33.70546], [-118.29464, 33.70561], [-118.29494, 33.706]]]} | Open Access 1 | 5950 | Point Fermin Lighthouse | 23849 | 104 | United States Coast Guard 511 | Federal 1 | Federal Agency 1 | http://www.uscg.mil/ | Other Federal 13 | 104 | United States Coast Guard 503 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 2.92 | Point Fermin Lighthouse | None 572 | |||
7280 | 7280 | 7279 | {"type": "MultiPolygon", "coordinates": [[[[-118.07223, 34.05905], [-118.07151, 34.05982], [-118.07104, 34.06086], [-118.07094, 34.06104], [-118.06981, 34.06232], [-118.06997, 34.06256], [-118.06964, 34.06256], [-118.07093, 34.06059], [-118.07092, 34.06052], [-118.06959, 34.06256], [-118.06763, 34.06256], [-118.06906, 34.06137], [-118.06934, 34.06104], [-118.06956, 34.06068], [-118.06965, 34.06049], [-118.06976, 34.06012], [-118.07026, 34.05725], [-118.07195, 34.05724], [-118.0719, 34.05755], [-118.07187, 34.05754], [-118.07164, 34.05893], [-118.07223, 34.05893], [-118.07223, 34.05905]]], [[[-118.06908, 34.06284], [-118.06876, 34.06313], [-118.06883, 34.06321], [-118.06867, 34.06332], [-118.06859, 34.06326], [-118.0681, 34.06363], [-118.06805, 34.06415], [-118.06797, 34.06422], [-118.06775, 34.06427], [-118.06774, 34.06391], [-118.06773, 34.0639], [-118.06717, 34.06433], [-118.06717, 34.06434], [-118.06721, 34.06437], [-118.06718, 34.06438], [-118.06632, 34.06357], [-118.06714, 34.06297], [-118.06715, 34.06292], [-118.06725, 34.06284], [-118.06908, 34.06284]]], [[[-118.06672, 34.06464], [-118.06662, 34.06466], [-118.06572, 34.06519], [-118.0656, 34.06508], [-118.06526, 34.06526], [-118.0646, 34.06571], [-118.06381, 34.06571], [-118.06493, 34.06491], [-118.06518, 34.06471], [-118.06559, 34.06431], [-118.06572, 34.06421], [-118.06605, 34.064], [-118.06672, 34.06464]]], [[[-118.06408, 34.06584], [-118.06348, 34.06628], [-118.06328, 34.06608], [-118.06362, 34.06584], [-118.06408, 34.06584]]]]} | Open Access 1 | 6565 | Rio Hondo | 24379 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 33.327 | Rio Hondo | 0 | None 601 | ||
7293 | 7293 | 7292 | {"type": "MultiPolygon", "coordinates": [[[[-118.01784, 34.03317], [-118.01637, 34.03369], [-118.01597, 34.03343], [-118.01578, 34.03332], [-118.01537, 34.03313], [-118.01494, 34.03296], [-118.01452, 34.03284], [-118.01405, 34.03273], [-118.0137, 34.03268], [-118.01324, 34.03264], [-118.01251, 34.03265], [-118.00974, 34.03282], [-118.00678, 34.03311], [-118.00624, 34.03311], [-118.00493, 34.03305], [-118.00415, 34.03306], [-118.0047, 34.03204], [-118.00526, 34.03207], [-118.00593, 34.03205], [-118.01346, 34.0313], [-118.01347, 34.03152], [-118.014, 34.03159], [-118.01473, 34.03174], [-118.01539, 34.03193], [-118.01594, 34.03213], [-118.01646, 34.03237], [-118.01676, 34.03253], [-118.01784, 34.03317]]], [[[-118.02359, 34.03666], [-118.0233, 34.03661], [-118.02246, 34.03717], [-118.01999, 34.03569], [-118.01964, 34.03556], [-118.019, 34.03519], [-118.01847, 34.03488], [-118.01846, 34.03483], [-118.01676, 34.03384], [-118.01816, 34.03334], [-118.02047, 34.03471], [-118.02066, 34.03491], [-118.02335, 34.0365], [-118.02359, 34.03666]]]]} | Open Access 1 | 6572 | San Jose Creek | 24914 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Los Angeles 6 | 55.286 | San Jose Creek | None 603 | ||
7773 | 7773 | 7772 | {"type": "Polygon", "coordinates": [[[-117.13155, 32.60871], [-117.13082, 32.60779], [-117.1306, 32.6076], [-117.1302, 32.60762], [-117.12999, 32.60766], [-117.12894, 32.60764], [-117.12851, 32.60758], [-117.1281, 32.60746], [-117.12761, 32.60717], [-117.12702, 32.60667], [-117.12658, 32.60618], [-117.1259, 32.60554], [-117.12564, 32.60545], [-117.12498, 32.60536], [-117.12444, 32.60519], [-117.12507, 32.60517], [-117.12808, 32.60599], [-117.1287, 32.60621], [-117.12921, 32.60642], [-117.1296, 32.60663], [-117.12996, 32.60686], [-117.13025, 32.60707], [-117.1305, 32.60731], [-117.13071, 32.60753], [-117.13153, 32.60854], [-117.13155, 32.60871]]]} | No Public Access 3 | 47652 | South Bay Marine Biological Study Area | 31395 | 110 | United States Navy 876 | Federal 1 | Federal Agency 1 | http://www.navy.mil/ | Other Federal 13 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 12.569 | South Bay Marine Biological Study Area | None 645 | |||
7939 | 7939 | 7938 | {"type": "Polygon", "coordinates": [[[-117.95634, 33.63093], [-117.95288, 33.64311], [-117.95175, 33.64313], [-117.95345, 33.63665], [-117.95199, 33.63459], [-117.95135, 33.63437], [-117.95087, 33.63372], [-117.95103, 33.63333], [-117.94856, 33.63291], [-117.94753, 33.63218], [-117.94809, 33.6321], [-117.94897, 33.63202], [-117.94984, 33.6315], [-117.95035, 33.63024], [-117.95123, 33.6295], [-117.95193, 33.62931], [-117.9528, 33.62956], [-117.95343, 33.62978], [-117.95493, 33.63058], [-117.95634, 33.63093]]]} | Open Access 1 | 10770 | Salt Marsh Restoration | 24811 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Orange 3 | 101.681 | Salt Marsh Restoration | None 660 | |||
8001 | 8001 | 8000 | {"type": "Polygon", "coordinates": [[[-122.51612, 38.78782], [-122.51607, 38.78848], [-122.51598, 38.78899], [-122.51594, 38.7894], [-122.5158, 38.78991], [-122.51562, 38.79035], [-122.51537, 38.7908], [-122.51516, 38.79114], [-122.51473, 38.79152], [-122.51393, 38.79201], [-122.51347, 38.79227], [-122.51293, 38.79235], [-122.51216, 38.79226], [-122.51186, 38.79219], [-122.51069, 38.79201], [-122.51012, 38.79196], [-122.51012, 38.79106], [-122.50107, 38.79096], [-122.49151, 38.7907], [-122.49123, 38.79432], [-122.48652, 38.7942], [-122.48671, 38.79057], [-122.48194, 38.79044], [-122.48188, 38.79214], [-122.48129, 38.79189], [-122.48107, 38.79177], [-122.48088, 38.79164], [-122.4807, 38.79145], [-122.48046, 38.79125], [-122.48022, 38.7911], [-122.48001, 38.79093], [-122.47977, 38.79071], [-122.47962, 38.79051], [-122.47943, 38.79033], [-122.47741, 38.79023], [-122.47748, 38.7866], [-122.48204, 38.78678], [-122.48216, 38.78314], [-122.49496, 38.77032], [-122.49673, 38.7718], [-122.50565, 38.77269], [-122.50628, 38.77324], [-122.51133, 38.77737], [-122.51504, 38.78693], [-122.51612, 38.78782]]]} | Open Access 1 | 11115 | Department of Defense | 18095 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Lake 40 | 1307.764 | Department of Defense | None 668 | |||
8114 | 8114 | 8113 | {"type": "MultiPolygon", "coordinates": [[[[-118.49444, 34.16485], [-118.49256, 34.16484], [-118.49252, 34.16479], [-118.49252, 34.16402], [-118.49444, 34.16402], [-118.49444, 34.16485]]], [[[-118.49868, 34.16866], [-118.49868, 34.16878], [-118.49696, 34.16775], [-118.49431, 34.16604], [-118.49381, 34.16578], [-118.4935, 34.16564], [-118.49295, 34.16543], [-118.49252, 34.1653], [-118.49253, 34.16504], [-118.49257, 34.16501], [-118.49601, 34.16502], [-118.49602, 34.16639], [-118.49867, 34.16641], [-118.49868, 34.16866]]]]} | Open Access 1 | 12239 | Sepulveda Garden Center | 25304 | 100 | United States Army Corps of Engineers 146 | Federal 1 | Federal Agency 1 | http://www.usace.army.mil/ | Other Federal 13 | 100 | United States Army Corps of Engineers 142 | Federal 1 | Federal Agency 1 | Los Angeles 6 | 24.1 | Sepulveda Garden Ctr. | None 677 | |||
8369 | 8369 | 8368 | {"type": "MultiPolygon", "coordinates": [[[[-116.0092, 33.42654], [-116.00913, 33.44087], [-115.9918, 33.44094], [-115.9916, 33.45547], [-115.97409, 33.4555], [-115.97389, 33.47011], [-115.99134, 33.4701], [-115.99114, 33.48451], [-115.97371, 33.48456], [-115.97378, 33.49917], [-115.99115, 33.49919], [-115.99146, 33.51068], [-115.97404, 33.51079], [-115.97378, 33.49918], [-115.95644, 33.49917], [-115.9563, 33.5002], [-115.95651, 33.50987], [-115.95652, 33.51085], [-115.93931, 33.51084], [-115.93905, 33.49918], [-115.92182, 33.49937], [-115.92185, 33.48464], [-115.93918, 33.4846], [-115.93924, 33.47014], [-115.92192, 33.47016], [-115.92195, 33.45559], [-115.90464, 33.45563], [-115.90466, 33.44096], [-115.88727, 33.44099], [-115.88723, 33.42704], [-115.9044, 33.42691], [-115.90469, 33.4272], [-115.90467, 33.44096], [-115.92196, 33.44092], [-115.92198, 33.44091], [-115.9221, 33.42682], [-115.92217, 33.42678], [-115.93945, 33.42674], [-115.93938, 33.44093], [-115.95682, 33.44096], [-115.95683, 33.44095], [-115.95693, 33.42693], [-115.95702, 33.42689], [-115.97434, 33.42665], [-115.97441, 33.42673], [-115.97423, 33.44094], [-115.99179, 33.44093], [-115.99202, 33.42654], [-116.0, 33.42649], [-116.00001, 33.42663], [-116.0092, 33.42654]], [[-115.92931, 33.44093], [-115.92197, 33.44093], [-115.92196, 33.45558], [-115.9393, 33.45555], [-115.93937, 33.44094], [-115.92931, 33.44093]], [[-115.95644, 33.48457], [-115.95219, 33.48457], [-115.9523, 33.48127], [-115.95229, 33.48126], [-115.94785, 33.48133], [-115.94782, 33.48458], [-115.93919, 33.4846], [-115.93906, 33.49918], [-115.95643, 33.49916], [-115.95644, 33.48457]], [[-115.95657, 33.47012], [-115.95672, 33.45555], [-115.9393, 33.45555], [-115.93925, 33.47013], [-115.95657, 33.47012]], [[-115.9737, 33.48456], [-115.97388, 33.47012], [-115.95658, 33.47012], [-115.95644, 33.48456], [-115.9737, 33.48456]], [[-115.97423, 33.44095], [-115.97422, 33.44094], [-115.95682, 33.44096], [-115.95672, 33.45554], [-115.9741, 33.45548], [-115.97423, 33.44095]]], [[[-115.89915, 33.48471], [-115.89576, 33.48471], [-115.89558, 33.48097], [-115.89558, 33.48097], [-115.89915, 33.48471]]], [[[-116.07001, 33.51275], [-116.06976, 33.51285], [-116.06933, 33.51281], [-116.06921, 33.51272], [-116.06837, 33.51274], [-116.06779, 33.51297], [-116.06738, 33.51334], [-116.06708, 33.514], [-116.06692, 33.51581], [-116.06645, 33.51597], [-116.06585, 33.51606], [-116.06519, 33.51574], [-116.0638, 33.51462], [-116.06339, 33.5146], [-116.06219, 33.51483], [-116.06118, 33.51482], [-116.06114, 33.51058], [-116.06996, 33.51054], [-116.07001, 33.51275]]]]} | Open Access 1 | 12968 | Salton Sea - Bureau of Rec | 13839 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Riverside 10 | 9406.511 | Salton Sea - Bureau of Rec | None 700 | |||
8382 | 8382 | 8381 | {"type": "MultiPolygon", "coordinates": [[[[-115.9801, 33.42661], [-115.97443, 33.42663], [-115.97442, 33.42664], [-115.97441, 33.42673], [-115.97434, 33.42665], [-115.95702, 33.42689], [-115.95693, 33.42693], [-115.95692, 33.42668], [-115.93946, 33.42674], [-115.92217, 33.42678], [-115.9221, 33.42682], [-115.92209, 33.4268], [-115.92157, 33.4268], [-115.9047, 33.42682], [-115.90469, 33.4272], [-115.9044, 33.42691], [-115.88723, 33.42704], [-115.88723, 33.42687], [-115.8872, 33.42684], [-115.87437, 33.42686], [-115.86954, 33.42685], [-115.86953, 33.4268], [-115.85711, 33.42683], [-115.8523, 33.42677], [-115.83855, 33.42687], [-115.83863, 33.41583], [-115.83444, 33.4159], [-115.83431, 33.4122], [-115.82237, 33.41239], [-115.82216, 33.40829], [-115.805, 33.40829], [-115.8046, 33.40309], [-115.80427, 33.39806], [-115.80417, 33.39805], [-115.79478, 33.39803], [-115.79427, 33.39009], [-115.78673, 33.39007], [-115.78666, 33.38349], [-115.77783, 33.38352], [-115.77784, 33.37563], [-115.7695, 33.37556], [-115.76961, 33.36901], [-115.77388, 33.36893], [-115.77389, 33.36892], [-115.77377, 33.36468], [-115.76965, 33.36466], [-115.76973, 33.35429], [-115.73443, 33.3544], [-115.73443, 33.34813], [-115.73448, 33.34815], [-115.73457, 33.33953], [-115.75236, 33.33955], [-115.75246, 33.32209], [-115.75082, 33.32207], [-115.73575, 33.32203], [-115.73573, 33.32261], [-115.73445, 33.33953], [-115.71712, 33.33982], [-115.71842, 33.32266], [-115.71842, 33.32201], [-115.70109, 33.32203], [-115.69967, 33.3396], [-115.71685, 33.33967], [-115.71677, 33.35435], [-115.69959, 33.3546], [-115.69947, 33.33984], [-115.68235, 33.33986], [-115.68391, 33.32199], [-115.66668, 33.322], [-115.66671, 33.30727], [-115.68387, 33.30725], [-115.68388, 33.30724], [-115.68377, 33.29269], [-115.66664, 33.29271], [-115.66663, 33.27821], [-115.68376, 33.2782], [-115.68377, 33.27819], [-115.68372, 33.26365], [-115.66654, 33.26369], [-115.66655, 33.25004], [-115.66651, 33.24915], [-115.68367, 33.24914], [-115.68375, 33.25004], [-115.68373, 33.26364], [-115.701, 33.2637], [-115.70108, 33.25005], [-115.70102, 33.24916], [-115.70103, 33.24913], [-115.71817, 33.24918], [-115.71823, 33.25005], [-115.71823, 33.26373], [-115.73556, 33.26381], [-115.73558, 33.2638], [-115.73558, 33.25003], [-115.73557, 33.24921], [-115.73559, 33.2492], [-115.7356, 33.24917], [-115.75081, 33.24922], [-115.75249, 33.24929], [-115.75256, 33.25004], [-115.75251, 33.26379], [-115.76992, 33.26536], [-115.76993, 33.26535], [-115.77001, 33.25062], [-115.78727, 33.25067], [-115.78726, 33.26543], [-115.80454, 33.26546], [-115.80455, 33.26545], [-115.80456, 33.25073], [-115.8218, 33.25074], [-115.8218, 33.26548], [-115.83918, 33.2655], [-115.83919, 33.26549], [-115.83917, 33.25073], [-115.85637, 33.25077], [-115.85634, 33.26547], [-115.8392, 33.2655], [-115.83925, 33.28014], [-115.85631, 33.28015], [-115.85623, 33.29485], [-115.8744, 33.29468], [-115.87406, 33.30937], [-115.89231, 33.30941], [-115.89218, 33.29486], [-115.90977, 33.29499], [-115.90982, 33.3022], [-115.9098, 33.30221], [-115.90987, 33.30952], [-115.92741, 33.30958], [-115.92745, 33.32395], [-115.93775, 33.32398], [-115.93888, 33.32469], [-115.93952, 33.32598], [-115.93964, 33.32635], [-115.93994, 33.32682], [-115.94011, 33.32694], [-115.94065, 33.32664], [-115.94254, 33.32529], [-115.94291, 33.32552], [-115.94202, 33.32621], [-115.94144, 33.32669], [-115.94089, 33.32685], [-115.94032, 33.32744], [-115.94032, 33.32802], [-115.94016, 33.32835], [-115.94054, 33.32829], [-115.94087, 33.32813], [-115.94098, 33.32754], [-115.94133, 33.32717], [-115.94234, 33.3265], [-115.94292, 33.32634], [-115.94384, 33.32635], [-115.94417, 33.32651], [-115.94412, 33.32699], [-115.94387, 33.32778], [-115.94291, 33.32804], [-115.94273, 33.32822], [-115.94256, 33.32879], [-115.94227, 33.329], [-115.94183, 33.32895], [-115.94125, 33.32866], [-115.94087, 33.32866], [-115.94062, 33.32877], [-115.94005, 33.32886], [-115.94003, 33.32931], [-115.94215, 33.32951], [-115.94368, 33.33008], [-115.94451, 33.33059], [-115.94493, 33.33105], [-115.94494, 33.33904], [-115.95674, 33.33897], [-115.9588, 33.33993], [-115.95951, 33.34061], [-115.96082, 33.34249], [-115.96208, 33.34588], [-115.96235, 33.34717], [-115.96252, 33.34744], [-115.96261, 33.34751], [-115.96262, 33.35358], [-115.96832, 33.35358], [-115.96893, 33.35413], [-115.96964, 33.3544], [-115.97019, 33.35447], [-115.97076, 33.35442], [-115.97142, 33.35397], [-115.97161, 33.35399], [-115.97166, 33.35459], [-115.97248, 33.35577], [-115.97295, 33.35619], [-115.97325, 33.3563], [-115.97472, 33.35644], [-115.97521, 33.35669], [-115.97622, 33.35777], [-115.97649, 33.35775], [-115.97704, 33.35733], [-115.97764, 33.35729], [-115.9781, 33.35738], [-115.97865, 33.35779], [-115.97952, 33.358], [-115.97987, 33.3582], [-115.97988, 33.36828], [-115.96262, 33.36831], [-115.96261, 33.35359], [-115.94492, 33.35362], [-115.94493, 33.36832], [-115.9626, 33.36832], [-115.96255, 33.38288], [-115.97992, 33.38278], [-115.97998, 33.39751], [-115.96255, 33.39761], [-115.96255, 33.41241], [-115.96256, 33.41242], [-115.98005, 33.41199], [-115.9801, 33.42661]], [[-115.68378, 33.29267], [-115.70106, 33.29273], [-115.70107, 33.27824], [-115.68377, 33.2782], [-115.68378, 33.29267]], [[-115.70108, 33.32203], [-115.70116, 33.30733], [-115.68388, 33.30725], [-115.68392, 33.32199], [-115.70108, 33.32203]], [[-115.71823, 33.26374], [-115.70101, 33.26371], [-115.70108, 33.27823], [-115.71832, 33.27827], [-115.71823, 33.26374]], [[-115.73573, 33.32203], [-115.73574, 33.32202], [-115.73572, 33.30752], [-115.7525, 33.30765], [-115.75252, 33.29293], [-115.75082, 33.29293], [-115.73564, 33.29284], [-115.73563, 33.27832], [-115.71833, 33.27827], [-115.71836, 33.29279], [-115.70106, 33.29274], [-115.70116, 33.30733], [-115.71845, 33.30744], [-115.71843, 33.322], [-115.73573, 33.32203]], [[-115.73563, 33.27831], [-115.75083, 33.27839], [-115.75248, 33.27837], [-115.75251, 33.2638], [-115.73558, 33.26381], [-115.73563, 33.27831]], [[-115.76993, 33.32338], [-115.76994, 33.32337], [-115.76998, 33.30876], [-115.75251, 33.30766], [-115.75247, 33.32209], [-115.76993, 33.32338]], [[-115.7525, 33.27838], [-115.75249, 33.27838], [-115.75252, 33.29292], [-115.76998, 33.29428], [-115.76996, 33.27998], [-115.7525, 33.27838]], [[-115.80397, 33.35408], [-115.80408, 33.33952], [-115.7871, 33.33961], [-115.78723, 33.32344], [-115.76995, 33.32338], [-115.76982, 33.3397], [-115.76973, 33.35342], [-115.76974, 33.35428], [-115.78659, 33.35416], [-115.80397, 33.35408]], [[-115.76997, 33.27997], [-115.78724, 33.28006], [-115.78726, 33.26544], [-115.76993, 33.26536], [-115.76997, 33.27997]], [[-115.78725, 33.30887], [-115.78726, 33.30886], [-115.78725, 33.29442], [-115.76999, 33.29428], [-115.76998, 33.30875], [-115.78725, 33.30887]], [[-115.78676, 33.37472], [-115.78678, 33.37471], [-115.78684, 33.3687], [-115.77808, 33.36886], [-115.77808, 33.36888], [-115.77903, 33.36936], [-115.77997, 33.37002], [-115.78015, 33.37084], [-115.78068, 33.3708], [-115.7812, 33.37082], [-115.78199, 33.37129], [-115.78256, 33.37194], [-115.7841, 33.37243], [-115.78523, 33.37354], [-115.78542, 33.37436], [-115.78631, 33.37446], [-115.78676, 33.37472]], [[-115.79099, 33.38348], [-115.791, 33.38347], [-115.79088, 33.37926], [-115.78672, 33.37925], [-115.78667, 33.38348], [-115.79099, 33.38348]], [[-115.80421, 33.3235], [-115.8043, 33.309], [-115.78726, 33.30887], [-115.78723, 33.32343], [-115.80421, 33.3235]], [[-115.78725, 33.28006], [-115.78724, 33.28007], [-115.78725, 33.29442], [-115.8044, 33.29454], [-115.80452, 33.2801], [-115.78725, 33.28006]], [[-115.80392, 33.38348], [-115.79734, 33.38347], [-115.79733, 33.38348], [-115.79921, 33.38516], [-115.79984, 33.38568], [-115.80013, 33.38599], [-115.80133, 33.38701], [-115.80156, 33.38715], [-115.80282, 33.3883], [-115.80405, 33.38956], [-115.80406, 33.38955], [-115.80392, 33.38348]], [[-115.82122, 33.36848], [-115.8213, 33.35429], [-115.80398, 33.35407], [-115.80395, 33.36857], [-115.82122, 33.36848]], [[-115.82155, 33.32358], [-115.82154, 33.32357], [-115.80422, 33.3235], [-115.8041, 33.33951], [-115.82146, 33.33939], [-115.82155, 33.32358]], [[-115.83908, 33.29477], [-115.83924, 33.28014], [-115.82177, 33.28013], [-115.82174, 33.29467], [-115.8044, 33.29454], [-115.80431, 33.30899], [-115.82162, 33.30907], [-115.82155, 33.32357], [-115.83896, 33.32365], [-115.839, 33.30915], [-115.85614, 33.30924], [-115.85622, 33.29486], [-115.85621, 33.29485], [-115.83908, 33.29477]], [[-115.80452, 33.28009], [-115.80453, 33.2801], [-115.82176, 33.28012], [-115.82179, 33.26548], [-115.80455, 33.26547], [-115.80452, 33.28009]], [[-115.81409, 33.40009], [-115.81411, 33.40008], [-115.8141, 33.40006], [-115.81409, 33.40007], [-115.81409, 33.40009]], [[-115.85645, 33.39822], [-115.85646, 33.39821], [-115.85586, 33.38346], [-115.83857, 33.38348], [-115.83855, 33.36875], [-115.82124, 33.36848], [-115.82121, 33.37503], [-115.82123, 33.38362], [-115.82163, 33.39779], [-115.82237, 33.39779], [-115.82238, 33.39801], [-115.83906, 33.39793], [-115.85645, 33.39822]], [[-115.83898, 33.32365], [-115.83881, 33.3393], [-115.84797, 33.33927], [-115.85604, 33.33922], [-115.8561, 33.3237], [-115.83898, 33.32365]], [[-115.87405, 33.30938], [-115.87404, 33.30937], [-115.85614, 33.30925], [-115.85611, 33.32369], [-115.87393, 33.32376], [-115.87405, 33.30938]], [[-115.86509, 33.40499], [-115.86468, 33.39821], [-115.85646, 33.39822], [-115.85703, 33.41234], [-115.87441, 33.41234], [-115.87442, 33.40541], [-115.86509, 33.40499]], [[-115.87395, 33.32377], [-115.87371, 33.33912], [-115.89243, 33.33909], [-115.89239, 33.32388], [-115.87395, 33.32377]], [[-115.89245, 33.35369], [-115.89243, 33.35368], [-115.87414, 33.35374], [-115.87451, 33.36866], [-115.89245, 33.36836], [-115.89245, 33.35369]], [[-115.89239, 33.32387], [-115.90996, 33.32391], [-115.90986, 33.30953], [-115.89232, 33.30942], [-115.89239, 33.32387]], [[-115.90997, 33.35365], [-115.90996, 33.33911], [-115.89243, 33.3391], [-115.89245, 33.35368], [-115.90997, 33.35365]], [[-115.89246, 33.36837], [-115.89245, 33.36838], [-115.89257, 33.38356], [-115.90995, 33.38314], [-115.90998, 33.36836], [-115.89246, 33.36837]], [[-115.90996, 33.38314], [-115.90995, 33.38315], [-115.90998, 33.39104], [-115.92745, 33.39088], [-115.92746, 33.38307], [-115.90996, 33.38314]], [[-115.90997, 33.32391], [-115.90996, 33.32392], [-115.90997, 33.33911], [-115.92745, 33.33906], [-115.92745, 33.32396], [-115.90997, 33.32391]], [[-115.92746, 33.35362], [-115.92745, 33.35361], [-115.90998, 33.35365], [-115.90999, 33.36836], [-115.92745, 33.36835], [-115.92746, 33.36833], [-115.92746, 33.35362]], [[-115.94491, 33.35361], [-115.94491, 33.33905], [-115.92745, 33.33907], [-115.92745, 33.35361], [-115.94491, 33.35361]], [[-115.94493, 33.36833], [-115.92745, 33.36835], [-115.92747, 33.38307], [-115.94509, 33.38298], [-115.94495, 33.37032], [-115.94495, 33.36834], [-115.94493, 33.36833]], [[-115.96255, 33.38289], [-115.96254, 33.38288], [-115.9451, 33.38299], [-115.9451, 33.39771], [-115.96254, 33.39762], [-115.96255, 33.38289]]], [[[-116.0247, 33.4117], [-116.01556, 33.41177], [-116.01558, 33.40443], [-116.02458, 33.40421], [-116.0247, 33.4117]]]]} | Open Access 1 | 12967 | Salton Sea - Bureau of Rec | 13839 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Imperial 20 | 57001.771 | Salton Sea - Bureau of Rec | None 702 |
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]);