units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
452 rows where ACCESS_TYP = 1 and AGNCY_TYP = 1 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP >30
- National Forest 96
- National Public Lands 64
- Recreation Management Area 50
- National Recreation Area 35
- National Park 22
- National Wildlife Refuge 21
- National Monument or Landmark 20
- Resource Management Area 20
- State Recreation Area 17
- Federal Other or Unknown 14
- State Conservation Area 11
- Local Park 7
- Conservation Area 6
- State Park 6
- Wilderness Area 6
- Area of Critical Environmental Concern 6
- Local Recreation Area 5
- Historic or Cultural Area 5
- Local Conservation Area 4
- Research or Educational Area 2
- State Historic or Cultural Area 1
- None 1
- National Lakeshore or Seashore 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 1
- Open Access · 452 ✖
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
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 | |
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 | |||
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 | |||
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 |
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]);