units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
517 rows where MNG_AG_TYP = 1 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP
These facets timed out: GAP_STS
DES_TP >30
- National Forest 96
- National Public Lands 75
- National Wildlife Refuge 70
- Recreation Management Area 61
- National Recreation Area 34
- National Park 26
- Resource Management Area 26
- National Monument or Landmark 24
- Federal Other or Unknown 24
- Conservation Area 14
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Research or Educational Area 3
- None 1
- None 1
- None 1
- None 1
- National Lakeshore or Seashore 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 9
- United States Bureau of Land Management 121
- United States Forest Service 111
- United States National Park Service 89
- United States Fish and Wildlife Service 82
- United States Army Corps of Engineers 52
- United States Bureau of Reclamation 29
- Other Federal 19
- United States Coast Guard 8
- United States Department of Defense 6
ACCESS_TYP 4
- Open Access 397
- Restricted Access 81
- No Public Access 33
- Unknown Access 6
MNG_AG_TYP 1
- Federal Agency · 517 ✖
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 | |||
2310 | 2310 | 2309 | {"type": "Polygon", "coordinates": [[[-121.92312, 36.5969], [-121.92318, 36.59762], [-121.92312, 36.59806], [-121.923, 36.5986], [-121.92255, 36.59947], [-121.92183, 36.60013], [-121.92095, 36.60074], [-121.91985, 36.60141], [-121.91903, 36.6018], [-121.91822, 36.60194], [-121.91724, 36.60199], [-121.9165, 36.60184], [-121.91586, 36.60158], [-121.91552, 36.60131], [-121.91559, 36.60065], [-121.91543, 36.60044], [-121.91448, 36.59989], [-121.91381, 36.60021], [-121.91357, 36.60054], [-121.91197, 36.60164], [-121.91157, 36.60177], [-121.91126, 36.60175], [-121.92118, 36.59454], [-121.92106, 36.59486], [-121.92103, 36.59512], [-121.92104, 36.59525], [-121.92109, 36.59544], [-121.92121, 36.59564], [-121.92132, 36.59575], [-121.92143, 36.59583], [-121.92312, 36.5969]]]} | Open Access 1 | 16954 | Huckleberry Hill Nature Preserve - Presidio/City | 20132 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | Monterey 14 | 91.68 | Huckleberry Hill Nature Preserve - Presidio/City | None 193 | |||
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 | |||
4084 | 4084 | 4083 | {"type": "MultiPolygon", "coordinates": [[[[-122.03164, 39.13731], [-122.0316, 39.14464], [-122.02224, 39.14472], [-122.02224, 39.14435], [-122.02345, 39.1363], [-122.02339, 39.1337], [-122.02331, 39.12774], [-122.0233, 39.12454], [-122.02322, 39.12155], [-122.02277, 39.12083], [-122.01898, 39.11595], [-122.01871, 39.11506], [-122.02706, 39.11517], [-122.02695, 39.13731], [-122.03164, 39.13731]]], [[[-122.04109, 39.12263], [-122.04106, 39.12648], [-122.03629, 39.1264], [-122.03642, 39.11969], [-122.04109, 39.12263]]]]} | Restricted Access 2 | 44500 | North Central Valley Wildlife Refuge | 22811 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Colusa 49 | 445.735 | North Central Valley Wildlife Refuge | None 353 | |||
4155 | 4155 | 4154 | {"type": "Polygon", "coordinates": [[[-120.4371, 39.25133], [-120.43698, 39.25857], [-120.41847, 39.25868], [-120.41863, 39.25142], [-120.42787, 39.25136], [-120.4371, 39.25133]]]} | Open Access 1 | 44724 | Devil's Peak | 14015 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | Placer 35 | 317.682 | Devil's Peak | None 359 | |||
4446 | 4446 | 4445 | {"type": "Polygon", "coordinates": [[[-118.34314, 34.39392], [-118.34303, 34.40124], [-118.32543, 34.401], [-118.32549, 34.39781], [-118.33435, 34.39794], [-118.33442, 34.39379], [-118.34314, 34.39392]]]} | Open Access 1 | 48982 | Southern California Edison mitigation | 33677 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | https://cordobacorp.com/projects/southern-california-edison-tehachapi-renewable-transmission-project/ | Los Angeles 6 | 232.391 | Southern California Edison mitigation | 2017 | None 397 | |
4822 | 4822 | 4821 | {"type": "Polygon", "coordinates": [[[-121.83228, 36.63102], [-121.83235, 36.63119], [-121.83237, 36.63144], [-121.83233, 36.63172], [-121.83214, 36.63209], [-121.83126, 36.63335], [-121.83034, 36.63271], [-121.82997, 36.63238], [-121.83091, 36.63158], [-121.83117, 36.63142], [-121.83217, 36.63099], [-121.83228, 36.63102]]]} | Open Access 1 | 48913 | Unknown park - United States Department of Defense | 33634 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 198 | United States Department of Defense 504 | Federal 1 | Federal Agency 1 | Monterey 14 | 7.047 | None 404 | ||||
6000 | 6000 | 5999 | {"type": "MultiPolygon", "coordinates": [[[[-119.90427, 38.00765], [-119.90155, 38.00769], [-119.90426, 38.00764], [-119.90417, 37.99681], [-119.89503, 37.99692], [-119.90419, 37.9968], [-119.9043, 38.00737], [-119.90427, 38.00765]]], [[[-119.89967, 38.00773], [-119.89967, 38.00761], [-119.89962, 38.00049], [-119.89963, 38.00049], [-119.89967, 38.00773]]], [[[-119.91335, 38.00029], [-119.90878, 38.00036], [-119.90882, 38.00455], [-119.90877, 38.00035], [-119.91335, 38.00029]]], [[[-119.91747, 38.00745], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91346, 38.00751], [-119.91747, 38.00745]]], [[[-119.91643, 38.00385], [-119.91643, 38.00385], [-119.91388, 38.00389], [-119.91641, 38.00384], [-119.91643, 38.00385]]]]} | Open Access 1 | 647 | Hetch Hetchy Water and Power | 19887 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | Tuolumne 21 | 1.045 | Hetch Hetchy Water and Power | None 483 | |||
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 | |||
6506 | 6506 | 6505 | {"type": "Polygon", "coordinates": [[[-117.3335, 35.30333], [-117.33291, 35.30939], [-117.32491, 35.31041], [-117.32488, 35.30386], [-117.3335, 35.30333]]]} | Open Access 1 | 2426 | US Dept of Interior | 26742 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 130.198 | US Dept of Interior | None 525 | |||
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 | ||
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 |
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]);