units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
584 rows where AGNCY_TYP = 1 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: MNG_AG_LEV
MNG_AGENCY >30
- United States Bureau of Land Management 120
- United States Forest Service 111
- United States National Park Service 89
- United States Fish and Wildlife Service 78
- United States Army Corps of Engineers 52
- United States Bureau of Reclamation 29
- California Department of Parks and Recreation 27
- Other Federal 19
- California Department of Fish and Wildlife 14
- United States Coast Guard 8
- United States Department of Defense 5
- Los Angeles, County of 3
- University of California 3
- San Diego, County of 3
- East Bay Regional Park District 2
- Needles, City of 2
- San Bernardino, County of 2
- San Diego State University 2
- Riverside County Habitat Conservation Agency 2
- San Diego, City of 1
- Santa Barbara, County of 1
- Monterey, City of 1
- Sonoma Land Trust 1
- Los Angeles - Department of Parks and Recreation, County of 1
- Pico Rivera, City of 1
- Auburn Area Recreation and Park District 1
- Conejo Open Space Conservation Agency 1
- Port San Luis Harbor District 1
- Merced Irrigation District 1
- Palos Verdes Peninsula Land Conservancy 1
- …
DES_TP >30
- National Forest 96
- National Public Lands 75
- National Wildlife Refuge 69
- Recreation Management Area 61
- National Recreation Area 37
- National Park 26
- Resource Management Area 26
- Federal Other or Unknown 24
- National Monument or Landmark 23
- State Conservation Area 17
- State Recreation Area 17
- Conservation Area 14
- Local Park 8
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Local Recreation Area 6
- State Park 6
- Local Conservation Area 5
- Historic or Cultural Area 5
- Research or Educational Area 3
- None 1
- None 1
- State Historic or Cultural Area 1
- None 1
- None 1
- National Lakeshore or Seashore 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 11
ACCESS_TYP 4
- Open Access 452
- Restricted Access 90
- No Public Access 36
- Unknown Access 6
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 | |||
3593 | 3593 | 3592 | {"type": "Polygon", "coordinates": [[[-117.85857, 34.66067], [-117.85414, 34.66065], [-117.84525, 34.66054], [-117.84522, 34.65319], [-117.85854, 34.65328], [-117.85857, 34.66067]]]} | Open Access 1 | 29212 | BLM | 16166 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Los Angeles 6 | 247.189 | BLM | None 300 | |||
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 | |||
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 | ||||
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 | |
4555 | 4555 | 4554 | {"type": "MultiPolygon", "coordinates": [[[[-119.00489, 38.20378], [-119.00419, 38.20573], [-119.00401, 38.20569], [-119.00219, 38.20938], [-119.00209, 38.20934], [-119.00386, 38.20563], [-119.00318, 38.20541], [-119.00489, 38.20378]]], [[[-119.01184, 38.20947], [-119.01172, 38.20947], [-119.01177, 38.20938], [-119.01117, 38.20913], [-119.01103, 38.20932], [-119.0114, 38.20947], [-119.01055, 38.20946], [-119.01026, 38.20929], [-119.01015, 38.20939], [-119.00946, 38.20914], [-119.00928, 38.20942], [-119.00931, 38.20944], [-119.00723, 38.20942], [-119.00723, 38.20998], [-119.0066, 38.20972], [-119.00674, 38.20945], [-119.00579, 38.20896], [-119.00696, 38.20699], [-119.00587, 38.20659], [-119.00605, 38.20635], [-119.00579, 38.20617], [-119.00461, 38.20757], [-119.0052, 38.20589], [-119.00684, 38.20645], [-119.00752, 38.20522], [-119.0065, 38.20485], [-119.00744, 38.20338], [-119.00791, 38.20356], [-119.00722, 38.20469], [-119.00753, 38.20482], [-119.00743, 38.20504], [-119.00775, 38.20515], [-119.00885, 38.2033], [-119.00886, 38.20341], [-119.00711, 38.20641], [-119.00738, 38.20653], [-119.00917, 38.20349], [-119.01066, 38.20426], [-119.01115, 38.20197], [-119.01162, 38.20198], [-119.0118, 38.20814], [-119.01122, 38.20895], [-119.01184, 38.2092], [-119.01184, 38.20947]], [[-119.01142, 38.20459], [-119.01142, 38.20457], [-119.01079, 38.20431], [-119.00849, 38.20799], [-119.00849, 38.20801], [-119.00909, 38.20828], [-119.0088, 38.20876], [-119.0088, 38.20878], [-119.00911, 38.20892], [-119.01142, 38.20524], [-119.01142, 38.20523], [-119.01111, 38.20508], [-119.01142, 38.20459]]], [[[-119.00643, 38.21121], [-119.00643, 38.21121], [-119.00571, 38.21158], [-119.00612, 38.21073], [-119.00634, 38.21082], [-119.00643, 38.21121]]], [[[-119.00594, 38.21192], [-119.0051, 38.21333], [-119.00494, 38.21329], [-119.00562, 38.21179], [-119.00594, 38.21192]]], [[[-119.02794, 38.19935], [-119.02742, 38.19971], [-119.02627, 38.20043], [-119.02545, 38.20064], [-119.02451, 38.20112], [-119.0233, 38.20167], [-119.02227, 38.2021], [-119.02178, 38.20228], [-119.02095, 38.20278], [-119.02085, 38.19868], [-119.01375, 38.19859], [-119.01374, 38.19735], [-119.01286, 38.19726], [-119.01296, 38.19642], [-119.0124, 38.19636], [-119.01246, 38.19478], [-119.01214, 38.19478], [-119.01207, 38.19633], [-119.01105, 38.19624], [-119.01169, 38.19597], [-119.01115, 38.19401], [-119.01249, 38.19401], [-119.0131, 38.19144], [-119.01532, 38.19145], [-119.0153, 38.19135], [-119.01509, 38.19115], [-119.01435, 38.19059], [-119.01397, 38.18969], [-119.01339, 38.18926], [-119.01286, 38.1892], [-119.01226, 38.18931], [-119.01187, 38.18955], [-119.01185, 38.19002], [-119.01162, 38.19003], [-119.01135, 38.19028], [-119.01082, 38.19313], [-119.00998, 38.19352], [-119.00987, 38.19162], [-119.00786, 38.19184], [-119.00839, 38.19582], [-119.00786, 38.19573], [-119.00631, 38.19953], [-119.00458, 38.19909], [-119.00298, 38.203], [-119.00298, 38.20301], [-119.00305, 38.20302], [-119.00058, 38.2053], [-119.00217, 38.20642], [-119.00091, 38.20889], [-119.0002, 38.20864], [-118.99802, 38.21142], [-119.00114, 38.21272], [-118.99931, 38.21655], [-118.99745, 38.21582], [-118.99455, 38.21913], [-118.99648, 38.21992], [-118.99542, 38.22108], [-118.99542, 38.22109], [-118.99715, 38.22201], [-118.9969, 38.22227], [-118.9969, 38.22229], [-118.99865, 38.22318], [-118.99827, 38.22362], [-118.99827, 38.22364], [-119.00024, 38.22428], [-119.00264, 38.22131], [-119.00285, 38.22137], [-119.00453, 38.21764], [-119.00464, 38.21767], [-119.00282, 38.2215], [-119.00274, 38.22539], [-119.00218, 38.22574], [-119.00111, 38.22607], [-118.99994, 38.22647], [-118.99818, 38.22622], [-118.99691, 38.22598], [-118.99627, 38.22566], [-118.99588, 38.2254], [-118.99483, 38.22493], [-118.99407, 38.22433], [-118.99349, 38.22363], [-118.99348, 38.22168], [-118.99229, 38.22139], [-118.99212, 38.22179], [-118.99137, 38.2216], [-118.99085, 38.22124], [-118.99062, 38.22094], [-118.98993, 38.2207], [-118.98947, 38.2204], [-118.98899, 38.2199], [-118.98821, 38.21954], [-118.98754, 38.21955], [-118.98685, 38.21939], [-118.98611, 38.21913], [-118.98544, 38.21899], [-118.98389, 38.21894], [-118.98207, 38.2195], [-118.98164, 38.2195], [-118.98143, 38.21664], [-118.97613, 38.21698], [-118.97609, 38.21336], [-118.97145, 38.21334], [-118.97135, 38.20972], [-118.96515, 38.20971], [-118.9652, 38.20843], [-118.96611, 38.20681], [-118.96735, 38.20479], [-118.96995, 38.20248], [-118.97082, 38.20054], [-118.97159, 38.19852], [-118.97214, 38.19728], [-118.97592, 38.19488], [-118.97736, 38.19428], [-118.98323, 38.19353], [-118.98908, 38.19303], [-118.99119, 38.19281], [-118.99366, 38.19313], [-118.99573, 38.19365], [-118.99666, 38.19406], [-118.99668, 38.19461], [-118.99742, 38.19519], [-118.99825, 38.19538], [-118.99976, 38.1952], [-119.0041, 38.19415], [-119.00472, 38.19362], [-119.006, 38.19077], [-119.00741, 38.1891], [-119.01052, 38.18708], [-119.01261, 38.18719], [-119.01405, 38.18747], [-119.01463, 38.18813], [-119.01589, 38.19006], [-119.01623, 38.19087], [-119.01726, 38.19041], [-119.02013, 38.18998], [-119.02507, 38.1923], [-119.02691, 38.19359], [-119.02731, 38.19448], [-119.02756, 38.19608], [-119.02791, 38.19762], [-119.02777, 38.19832], [-119.02794, 38.19935]], [[-118.99686, 38.2162], [-118.99712, 38.21569], [-118.99645, 38.21541], [-118.99833, 38.2125], [-118.99684, 38.21205], [-118.99505, 38.21566], [-118.99686, 38.2162]]], [[[-118.99351, 38.22712], [-118.99042, 38.22521], [-118.98888, 38.22439], [-118.98696, 38.22397], [-118.98538, 38.22383], [-118.98369, 38.22485], [-118.98219, 38.22543], [-118.98081, 38.2259], [-118.98075, 38.2203], [-118.98508, 38.22031], [-118.98508, 38.21928], [-118.98599, 38.21938], [-118.98675, 38.21965], [-118.98742, 38.21979], [-118.98809, 38.21978], [-118.98839, 38.21987], [-118.98901, 38.22034], [-118.98969, 38.22089], [-118.99024, 38.22107], [-118.99033, 38.22121], [-118.99077, 38.22146], [-118.99155, 38.22202], [-118.99221, 38.22243], [-118.99278, 38.22306], [-118.99318, 38.22361], [-118.99349, 38.22405], [-118.99351, 38.22712]]], [[[-119.06995, 38.22688], [-119.06854, 38.22729], [-119.06713, 38.22798], [-119.06582, 38.22868], [-119.06119, 38.22964], [-119.05837, 38.23069], [-119.05581, 38.23213], [-119.05189, 38.23455], [-119.04769, 38.23617], [-119.04704, 38.2362], [-119.04685, 38.23597], [-119.04657, 38.23577], [-119.04617, 38.23565], [-119.04563, 38.23544], [-119.04546, 38.23534], [-119.0453, 38.23521], [-119.04523, 38.2349], [-119.04511, 38.23469], [-119.04486, 38.2344], [-119.04462, 38.2342], [-119.04436, 38.23391], [-119.04386, 38.23305], [-119.04361, 38.2327], [-119.0434, 38.23237], [-119.04313, 38.23218], [-119.04201, 38.23175], [-119.04183, 38.23166], [-119.04164, 38.23147], [-119.04145, 38.23114], [-119.04123, 38.23087], [-119.04107, 38.23059], [-119.04089, 38.23021], [-119.04079, 38.22992], [-119.0406, 38.22961], [-119.04033, 38.2294], [-119.04016, 38.22908], [-119.04003, 38.22866], [-119.03995, 38.22825], [-119.03971, 38.22761], [-119.03962, 38.22685], [-119.03962, 38.22646], [-119.03966, 38.22608], [-119.03971, 38.22584], [-119.03967, 38.2256], [-119.03957, 38.2253], [-119.03938, 38.22485], [-119.03923, 38.22432], [-119.03911, 38.22407], [-119.03906, 38.22278], [-119.03896, 38.22249], [-119.03872, 38.22229], [-119.03838, 38.22219], [-119.03793, 38.22213], [-119.03771, 38.22212], [-119.0366, 38.22183], [-119.03606, 38.22164], [-119.03554, 38.22142], [-119.0345, 38.22108], [-119.0336, 38.22093], [-119.03315, 38.2209], [-119.03286, 38.22094], [-119.03263, 38.22089], [-119.0323, 38.22067], [-119.03205, 38.22056], [-119.03169, 38.2205], [-119.03139, 38.22051], [-119.03119, 38.22049], [-119.03093, 38.22035], [-119.03056, 38.22008], [-119.03023, 38.2199], [-119.02984, 38.21971], [-119.02899, 38.2192], [-119.02791, 38.21829], [-119.02662, 38.21757], [-119.02547, 38.21704], [-119.02487, 38.21681], [-119.02439, 38.21671], [-119.0241, 38.21676], [-119.02378, 38.21674], [-119.02258, 38.21636], [-119.02182, 38.21606], [-119.01987, 38.2152], [-119.01974, 38.21518], [-119.019, 38.21515], [-119.01884, 38.21516], [-119.01859, 38.21509], [-119.01815, 38.21483], [-119.01774, 38.21452], [-119.01656, 38.21401], [-119.01657, 38.21318], [-119.0189, 38.21321], [-119.01886, 38.2115], [-119.01884, 38.21149], [-119.0187, 38.20593], [-119.02102, 38.20596], [-119.02096, 38.20309], [-119.02196, 38.20254], [-119.0239, 38.20177], [-119.02542, 38.20104], [-119.02638, 38.20065], [-119.02788, 38.19978], [-119.02796, 38.19971], [-119.02803, 38.20024], [-119.02881, 38.2028], [-119.02976, 38.20383], [-119.03595, 38.2056], [-119.03855, 38.2071], [-119.04198, 38.20844], [-119.05162, 38.2114], [-119.0635, 38.21928], [-119.06498, 38.22128], [-119.06647, 38.22245], [-119.06779, 38.22315], [-119.06841, 38.22381], [-119.06872, 38.22479], [-119.06941, 38.2257], [-119.06986, 38.22611], [-119.06995, 38.22688]]], [[[-119.04286, 38.23246], [-119.04083, 38.23212], [-119.03695, 38.23253], [-119.03494, 38.23312], [-119.03348, 38.23373], [-119.03231, 38.23411], [-119.03143, 38.2343], [-119.02978, 38.23382], [-119.02896, 38.23337], [-119.02712, 38.2322], [-119.02503, 38.23097], [-119.02373, 38.22966], [-119.02264, 38.22826], [-119.02155, 38.22758], [-119.0205, 38.2275], [-119.01945, 38.22822], [-119.01808, 38.22886], [-119.01697, 38.22931], [-119.01585, 38.22993], [-119.01481, 38.23129], [-119.01373, 38.23356], [-119.0129, 38.23447], [-119.01161, 38.23572], [-119.01061, 38.23621], [-119.00947, 38.2364], [-119.00821, 38.23638], [-119.00735, 38.23631], [-119.00671, 38.23613], [-119.00523, 38.23553], [-119.00014, 38.23564], [-118.99881, 38.23556], [-118.9972, 38.23464], [-118.99647, 38.23343], [-118.99602, 38.23224], [-118.99575, 38.23142], [-118.99549, 38.23], [-118.9947, 38.22873], [-118.99376, 38.22739], [-119.00269, 38.22751], [-119.00274, 38.22578], [-119.00335, 38.22538], [-119.00531, 38.22459], [-119.00602, 38.22414], [-119.00651, 38.22378], [-119.00684, 38.22347], [-119.00709, 38.22287], [-119.0071, 38.22472], [-119.01198, 38.22471], [-119.01199, 38.2221], [-119.0145, 38.22283], [-119.01512, 38.22152], [-119.012, 38.21969], [-119.01196, 38.21697], [-119.01202, 38.21676], [-119.01659, 38.21683], [-119.01643, 38.21426], [-119.01752, 38.21481], [-119.01841, 38.21532], [-119.01862, 38.2154], [-119.01883, 38.21545], [-119.01962, 38.21545], [-119.0199, 38.21554], [-119.02118, 38.21612], [-119.02119, 38.2161], [-119.02203, 38.21646], [-119.02326, 38.21692], [-119.0238, 38.21707], [-119.02426, 38.21708], [-119.02457, 38.21706], [-119.02505, 38.21723], [-119.02581, 38.21754], [-119.02665, 38.21795], [-119.02723, 38.21826], [-119.02827, 38.21905], [-119.02875, 38.21944], [-119.02939, 38.21983], [-119.0299, 38.22008], [-119.0308, 38.22062], [-119.03104, 38.22082], [-119.03129, 38.22083], [-119.03155, 38.22081], [-119.03182, 38.22084], [-119.03205, 38.22089], [-119.03234, 38.22112], [-119.03264, 38.22123], [-119.03298, 38.22123], [-119.03328, 38.22119], [-119.03364, 38.22123], [-119.03414, 38.22132], [-119.03496, 38.22156], [-119.03658, 38.22212], [-119.03714, 38.2223], [-119.03839, 38.2225], [-119.03863, 38.22271], [-119.0387, 38.22296], [-119.03869, 38.2234], [-119.03871, 38.22394], [-119.03878, 38.22431], [-119.03894, 38.22468], [-119.03905, 38.225], [-119.03918, 38.22543], [-119.03926, 38.2258], [-119.03923, 38.22689], [-119.03925, 38.22735], [-119.03937, 38.22774], [-119.03971, 38.22901], [-119.03992, 38.22944], [-119.04017, 38.22971], [-119.04039, 38.22993], [-119.0406, 38.23053], [-119.04075, 38.23081], [-119.04101, 38.23123], [-119.04153, 38.23185], [-119.04183, 38.232], [-119.04225, 38.23215], [-119.04274, 38.23238], [-119.04286, 38.23246]]]]} | Open Access 1 | 29208 | BLM | 16166 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Mono 32 | 5743.897 | BLM | 0 | None 401 | ||
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 | |||
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 | |||
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 |
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]);