units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
356 rows where AGNCY_TYP = 5 and DES_TP = 8 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, LAYER, MNG_AG_ID
MNG_AGENCY 12
- California Department of Fish and Wildlife 285
- University of California 35
- California Department of Parks and Recreation 21
- San Diego State University 3
- Other State 2
- Santa Monica Mountains Conservancy 2
- California Department of Water Resources 2
- Coachella Valley Mountains Conservancy 2
- The Nature Conservancy 1
- California State University Sonoma 1
- Napa Valley College 1
- California State Coastal Conservancy 1
ACCESS_TYP 3
- Open Access 238
- Restricted Access 96
- No Public Access 22
MNG_AG_TYP 2
DES_TP 1
- State Conservation Area · 356 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
402 | 402 | 401 | {"type": "Polygon", "coordinates": [[[-118.76991, 36.21538], [-118.76991, 36.21538], [-118.76726, 36.21538], [-118.76735, 36.21517], [-118.76842, 36.21452], [-118.76948, 36.21436], [-118.76989, 36.21437], [-118.76991, 36.21538]]]} | Restricted Access 2 | 1556 | Springville Ecological Reserve | 25751 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 4.947 | Springville ER | 0 | State Conservation Area 8 | 2 | |
467 | 467 | 466 | {"type": "Polygon", "coordinates": [[[-122.16678, 41.6422], [-122.16586, 41.64234], [-122.15522, 41.64335], [-122.15336, 41.64329], [-122.15338, 41.6426], [-122.15402, 41.64246], [-122.15464, 41.64228], [-122.15675, 41.64146], [-122.15726, 41.64123], [-122.15778, 41.64105], [-122.15814, 41.64095], [-122.15861, 41.64084], [-122.15908, 41.64077], [-122.15956, 41.64072], [-122.16013, 41.64069], [-122.16071, 41.64071], [-122.16118, 41.64076], [-122.16164, 41.64083], [-122.16305, 41.64119], [-122.16522, 41.64179], [-122.16586, 41.64201], [-122.16678, 41.6422]]]} | Restricted Access 2 | 921 | Grass Lake Wildlife Area | 19448 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 44.169 | Grass Lake Wildlife Area | 0 | State Conservation Area 8 | 2 | |
631 | 631 | 630 | {"type": "Polygon", "coordinates": [[[-122.25462, 39.99416], [-122.2544, 40.00129], [-122.25096, 40.00128], [-122.24748, 40.00133], [-122.24757, 39.99403], [-122.24456, 39.99402], [-122.23507, 39.99405], [-122.23535, 39.98688], [-122.23987, 39.98679], [-122.2466, 39.98672], [-122.25062, 39.98668], [-122.25422, 39.9867], [-122.25416, 39.99039], [-122.25416, 39.99414], [-122.25462, 39.99416]]]} | Restricted Access 2 | 4792 | Thomes Creek Ecological Reserve | 26310 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tehama 18 | 442.371 | Thomes Creek ER | 0 | State Conservation Area 8 | 2 | |
820 | 820 | 819 | {"type": "Polygon", "coordinates": [[[-122.46024, 38.4015], [-122.45904, 38.40373], [-122.45593, 38.40443], [-122.45662, 38.40573], [-122.45384, 38.40685], [-122.45383, 38.40697], [-122.45093, 38.40569], [-122.45012, 38.40836], [-122.44677, 38.40831], [-122.44613, 38.40284], [-122.44659, 38.40275], [-122.44716, 38.40269], [-122.44742, 38.40261], [-122.44761, 38.40251], [-122.44766, 38.40247], [-122.44768, 38.40235], [-122.44764, 38.4023], [-122.44757, 38.40227], [-122.44797, 38.40183], [-122.44828, 38.40157], [-122.46024, 38.4015]]]} | Open Access 1 | 4582 | Bumpy Camp Nature Preserve | 16503 | 223 | Napa Valley College 268 | State 5 | State Agency 5 | http://www.napavalley.edu/ | Other State 5 | 223 | Napa Valley College 263 | State 5 | State Agency 5 | Napa 11 | 148.027 | Bumpy Camp Nature Preserve | 0 | State Conservation Area 8 | 2 | |
1331 | 1331 | 1330 | {"type": "Polygon", "coordinates": [[[-117.30505, 33.972], [-117.30065, 33.97196], [-117.30065, 33.97556], [-117.29645, 33.97552], [-117.2965, 33.96463], [-117.30083, 33.96465], [-117.30087, 33.96815], [-117.30505, 33.96813], [-117.30505, 33.972]]]} | No Public Access 3 | 47644 | Box Springs Reserve | 31388 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | http://www.ucnrs.org/reserves/box-springs-reserve.html | Riverside 10 | 159.828 | Box Springs Reserve | 0 | State Conservation Area 8 | 2 |
1332 | 1332 | 1331 | {"type": "Polygon", "coordinates": [[[-116.45768, 34.14968], [-116.45334, 34.1497], [-116.45333, 34.15015], [-116.45115, 34.15016], [-116.45115, 34.14929], [-116.44898, 34.1493], [-116.44892, 34.13524], [-116.45764, 34.13534], [-116.45767, 34.14247], [-116.45768, 34.14968]], [[-116.45762, 34.14811], [-116.45654, 34.14811], [-116.45653, 34.14608], [-116.45332, 34.1461], [-116.45333, 34.14699], [-116.45654, 34.14833], [-116.45761, 34.14833], [-116.45762, 34.14811]]]} | No Public Access 3 | 47645 | Burns Piñon Ridge Reserve | 31389 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | http://www.ucnrs.org/reserves/burns-pinon-ridge-reserve.html | San Bernardino 22 | 304.422 | Burns Piñon Ridge Reserve | 0 | State Conservation Area 8 | 2 |
1522 | 1522 | 1521 | {"type": "Polygon", "coordinates": [[[-117.23496, 33.27233], [-117.23496, 33.27267], [-117.23179, 33.27604], [-117.23077, 33.27536], [-117.2336, 33.27235], [-117.23496, 33.27233]]]} | Restricted Access 2 | 12834 | San Luis Rey River Ecological Reserve | 24942 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Diego 4 | 14.153 | San Luis Rey River ER | 0 | State Conservation Area 8 | 2 | |
1947 | 1947 | 1946 | {"type": "MultiPolygon", "coordinates": [[[[-118.98159, 36.05067], [-118.98137, 36.05079], [-118.9727, 36.05085], [-118.9718, 36.05081], [-118.97127, 36.05076], [-118.9708, 36.0507], [-118.97091, 36.0439], [-118.98041, 36.04394], [-118.98036, 36.04846], [-118.98039, 36.04883], [-118.98043, 36.04901], [-118.98052, 36.04928], [-118.98064, 36.04953], [-118.98074, 36.0497], [-118.98091, 36.04994], [-118.98105, 36.05009], [-118.98123, 36.05026], [-118.98148, 36.05046], [-118.98159, 36.05067]]], [[[-118.98205, 36.04396], [-118.98203, 36.04531], [-118.98196, 36.05048], [-118.98172, 36.05031], [-118.98148, 36.05012], [-118.98129, 36.04993], [-118.9811, 36.0497], [-118.98094, 36.04945], [-118.98084, 36.04924], [-118.98075, 36.04901], [-118.98068, 36.04874], [-118.98065, 36.04846], [-118.9807, 36.04394], [-118.98205, 36.04396]]]]} | Restricted Access 2 | 29177 | Yaudanchi Ecological Reserve | 27765 | 220 | California Department of Health Services 459 | State 5 | State Agency 5 | http://www.dhcs.ca.gov/Pages/default.aspx | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Tulare 29 | 184.306 | Yaudanchi ER | 0 | State Conservation Area 8 | 2 | |
2404 | 2404 | 2403 | {"type": "Polygon", "coordinates": [[[-117.40831, 35.8391], [-117.39902, 35.8391], [-117.39889, 35.83547], [-117.38952, 35.83547], [-117.38912, 35.82822], [-117.38435, 35.82822], [-117.38411, 35.82459], [-117.37971, 35.82454], [-117.37972, 35.82089], [-117.38414, 35.82092], [-117.38891, 35.82093], [-117.38892, 35.82458], [-117.39372, 35.82458], [-117.39389, 35.82821], [-117.40341, 35.82821], [-117.4035, 35.83184], [-117.40815, 35.83184], [-117.40831, 35.8391]]]} | Open Access 1 | 7378 | Indian Joe Spring Ecological Reserve | 32189 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Indian-Joe-Springs-ER | Inyo 43 | 550.369 | Indian Joe Spring ER | 0 | State Conservation Area 8 | 2 |
2631 | 2631 | 2630 | {"type": "Polygon", "coordinates": [[[-121.49959, 37.6491], [-121.49457, 37.649], [-121.49018, 37.64886], [-121.49073, 37.64768], [-121.49079, 37.6476], [-121.49097, 37.64704], [-121.49108, 37.64648], [-121.49155, 37.63993], [-121.4916, 37.63962], [-121.49221, 37.6393], [-121.4944, 37.63887], [-121.49444, 37.63989], [-121.4952, 37.64234], [-121.49679, 37.64307], [-121.49847, 37.64757], [-121.49959, 37.6491]], [[-121.49355, 37.64011], [-121.49277, 37.64012], [-121.49267, 37.64151], [-121.49369, 37.64277], [-121.49423, 37.64241], [-121.49463, 37.64166], [-121.49429, 37.64112], [-121.49355, 37.64011]]]} | No Public Access 3 | 18038 | Corral Hollow Ecological Reserve | 32134 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | San Joaquin 39 | 125.166 | Corral Hollow ER | 0 | State Conservation Area 8 | 2 | |
2637 | 2637 | 2636 | {"type": "Polygon", "coordinates": [[[-122.93426, 38.43681], [-122.93107, 38.43684], [-122.92903, 38.43689], [-122.92899, 38.4368], [-122.92897, 38.4367], [-122.92903, 38.43623], [-122.92908, 38.43609], [-122.92928, 38.43568], [-122.92964, 38.43476], [-122.92971, 38.43446], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93271, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} | Restricted Access 2 | 3289 | Harrison Grade Ecological Reserve | 19698 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Sonoma 16 | 31.802 | Harrison Grade ER | 0 | State Conservation Area 8 | 2 | |
2782 | 2782 | 2781 | {"type": "Polygon", "coordinates": [[[-123.95018, 40.54432], [-123.95, 40.54774], [-123.95168, 40.56229], [-123.94988, 40.57504], [-123.93142, 40.57538], [-123.91977, 40.57531], [-123.91927, 40.56181], [-123.91363, 40.56177], [-123.91412, 40.55814], [-123.91933, 40.55809], [-123.91986, 40.5472], [-123.92568, 40.54733], [-123.92481, 40.53266], [-123.92997, 40.53268], [-123.94513, 40.53325], [-123.94448, 40.54416], [-123.95018, 40.54432]]]} | Restricted Access 2 | 21606 | Owl Creek Ecological Reserve | 23278 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Humboldt 45 | 2772.208 | Owl Creek ER | 0 | State Conservation Area 8 | 2 | |
2891 | 2891 | 2890 | {"type": "Polygon", "coordinates": [[[-122.27421, 40.4766], [-122.26995, 40.47661], [-122.27039, 40.47569], [-122.26864, 40.47525], [-122.26863, 40.47425], [-122.26907, 40.47419], [-122.26994, 40.47387], [-122.27012, 40.47395], [-122.27418, 40.4704], [-122.27421, 40.4766]]]} | Restricted Access 2 | 18920 | Clover Creek Ecological Reserve | 17434 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Shasta 27 | 46.643 | Clover Creek ER | 0 | State Conservation Area 8 | 2 | |
3108 | 3108 | 3107 | {"type": "MultiPolygon", "coordinates": [[[[-121.46234, 38.2686], [-121.46231, 38.26876], [-121.46161, 38.26911], [-121.46002, 38.26922], [-121.45923, 38.26938], [-121.45839, 38.2697], [-121.45775, 38.26965], [-121.45753, 38.26953], [-121.45774, 38.2673], [-121.45781, 38.26714], [-121.4579, 38.2664], [-121.45801, 38.26606], [-121.4583, 38.26581], [-121.45862, 38.26576], [-121.45932, 38.26588], [-121.46083, 38.2659], [-121.46118, 38.26624], [-121.46112, 38.26713], [-121.46132, 38.26782], [-121.46167, 38.26823], [-121.46211, 38.2684], [-121.46234, 38.2686]]], [[[-121.68459, 38.14478], [-121.68456, 38.14487], [-121.68445, 38.14505], [-121.68418, 38.14541], [-121.68404, 38.14611], [-121.68393, 38.14638], [-121.68387, 38.14656], [-121.68386, 38.14674], [-121.68389, 38.14684], [-121.6838, 38.14733], [-121.68366, 38.14777], [-121.68363, 38.148], [-121.68355, 38.14839], [-121.68327, 38.14912], [-121.68318, 38.14929], [-121.68312, 38.1493], [-121.68345, 38.14644], [-121.68406, 38.14476], [-121.68459, 38.14478]]]]} | Restricted Access 2 | 25288 | Cosumnes River Preserve | 17678 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Sacramento 41 | 35.364 | Cosumnes River Preserve | 0 | State Conservation Area 8 | 2 | ||
3143 | 3143 | 3142 | {"type": "Polygon", "coordinates": [[[-123.31692, 41.78208], [-123.31238, 41.78212], [-123.31239, 41.78306], [-123.31239, 41.78456], [-123.31192, 41.78442], [-123.31147, 41.78461], [-123.31048, 41.78493], [-123.30981, 41.7853], [-123.30965, 41.78553], [-123.30965, 41.78579], [-123.30984, 41.78586], [-123.31041, 41.78733], [-123.31076, 41.7877], [-123.31092, 41.78773], [-123.31167, 41.78838], [-123.3121, 41.7889], [-123.31224, 41.78911], [-123.3121, 41.79128], [-123.30773, 41.79128], [-123.30674, 41.7913], [-123.30302, 41.79125], [-123.30307, 41.78826], [-123.30306, 41.78463], [-123.30294, 41.78141], [-123.30779, 41.78136], [-123.30782, 41.78299], [-123.31011, 41.78297], [-123.31011, 41.78135], [-123.31238, 41.78128], [-123.31236, 41.77967], [-123.31684, 41.77957], [-123.31692, 41.78208]]]} | Restricted Access 2 | 21593 | China Point Ecological Reserve | 17203 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 209.418 | China Point ER | 0 | State Conservation Area 8 | 2 | |
3441 | 3441 | 3440 | {"type": "Polygon", "coordinates": [[[-120.25813, 38.62982], [-120.25788, 38.63346], [-120.25343, 38.63333], [-120.25308, 38.63683], [-120.24397, 38.63654], [-120.2445, 38.63308], [-120.24896, 38.63318], [-120.2494, 38.62968], [-120.25813, 38.62982]]]} | No Public Access 3 | 25249 | Leek Springs Ecological Reserve | 32201 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | El Dorado 34 | 151.078 | Leek Springs ER | 0 | State Conservation Area 8 | 2 | |
3803 | 3803 | 3802 | {"type": "MultiPolygon", "coordinates": [[[[-122.10658, 38.5004], [-122.09761, 38.50035], [-122.09774, 38.50434], [-122.09775, 38.50723], [-122.09305, 38.50723], [-122.093, 38.50397], [-122.09232, 38.49092], [-122.09697, 38.4909], [-122.09687, 38.4893], [-122.09688, 38.48804], [-122.0969, 38.48794], [-122.09688, 38.4865], [-122.09693, 38.48236], [-122.10164, 38.48238], [-122.10165, 38.48207], [-122.10631, 38.48211], [-122.10633, 38.48923], [-122.1065, 38.49317], [-122.10655, 38.49628], [-122.10658, 38.5004]]], [[[-122.1064, 38.50769], [-122.10633, 38.50813], [-122.10619, 38.50846], [-122.1061, 38.5086], [-122.10598, 38.5087], [-122.10582, 38.50877], [-122.10572, 38.50879], [-122.10561, 38.50879], [-122.10518, 38.50894], [-122.10504, 38.50897], [-122.10464, 38.50918], [-122.10452, 38.50932], [-122.10427, 38.5095], [-122.1042, 38.50947], [-122.10212, 38.50969], [-122.10231, 38.50753], [-122.10582, 38.50758], [-122.1064, 38.50769]]]]} | Restricted Access 2 | 35111 | Stebbins Cold Canyon Reserve | 25816 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Solano 26 | 606.446 | Stebbins Cold Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
4914 | 4914 | 4913 | {"type": "Polygon", "coordinates": [[[-118.75013, 34.21604], [-118.74396, 34.21753], [-118.74395, 34.21755], [-118.74379, 34.21759], [-118.71671, 34.22411], [-118.70271, 34.20235], [-118.70369, 34.20128], [-118.7043, 34.2001], [-118.70453, 34.198], [-118.70277, 34.19497], [-118.70015, 34.19575], [-118.69796, 34.19647], [-118.69598, 34.19654], [-118.69504, 34.19617], [-118.69462, 34.19603], [-118.6924, 34.19678], [-118.69155, 34.19742], [-118.6875, 34.19926], [-118.68622, 34.19868], [-118.68537, 34.19882], [-118.68444, 34.1987], [-118.68384, 34.19834], [-118.68315, 34.19807], [-118.68191, 34.19798], [-118.68059, 34.19866], [-118.66803, 34.19964], [-118.66808, 34.19518], [-118.66804, 34.19517], [-118.66818, 34.18989], [-118.66816, 34.17549], [-118.66818, 34.16821], [-118.67781, 34.16834], [-118.67953, 34.16838], [-118.67961, 34.16836], [-118.68853, 34.16848], [-118.69167, 34.16853], [-118.69454, 34.1686], [-118.70339, 34.16862], [-118.70344, 34.16872], [-118.70689, 34.16866], [-118.71199, 34.16864], [-118.71639, 34.16834], [-118.71664, 34.16909], [-118.71647, 34.17044], [-118.7164, 34.17137], [-118.71474, 34.17481], [-118.71619, 34.17737], [-118.71689, 34.18046], [-118.71936, 34.18209], [-118.71891, 34.18415], [-118.71927, 34.18714], [-118.71886, 34.18763], [-118.71899, 34.18926], [-118.72, 34.19074], [-118.71961, 34.19119], [-118.71982, 34.19311], [-118.72145, 34.19322], [-118.72327, 34.196], [-118.72439, 34.19621], [-118.73201, 34.20859], [-118.74178, 34.21116], [-118.75013, 34.21604]]]} | Open Access 1 | 1662 | Upper Las Virgenes Open Space Preserve / Ahmanson | 12211 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | http://lamountains.com/parks.asp?parkid=28 | Ventura 8 | 5428.251 | Upper Las Virgenes OSP / Ahmanson | 0 | State Conservation Area 8 | 2 |
5503 | 5503 | 5502 | {"type": "MultiPolygon", "coordinates": [[[[-117.24645, 33.15192], [-117.24325, 33.15203], [-117.24295, 33.1512], [-117.24431, 33.15105], [-117.24644, 33.15036], [-117.24645, 33.15192]]], [[[-117.26182, 33.14925], [-117.26138, 33.14958], [-117.25936, 33.14941], [-117.25864, 33.14971], [-117.2584, 33.14977], [-117.25816, 33.14977], [-117.25744, 33.14967], [-117.25731, 33.14967], [-117.25716, 33.14971], [-117.25701, 33.14979], [-117.25667, 33.15004], [-117.25655, 33.15019], [-117.25648, 33.15037], [-117.25635, 33.1512], [-117.25631, 33.1513], [-117.25622, 33.15142], [-117.25586, 33.15176], [-117.25562, 33.15211], [-117.25053, 33.15267], [-117.25006, 33.1537], [-117.24851, 33.15389], [-117.24842, 33.1523], [-117.24819, 33.15211], [-117.24806, 33.15211], [-117.24804, 33.15188], [-117.24906, 33.14891], [-117.24789, 33.14895], [-117.24624, 33.14851], [-117.24658, 33.14758], [-117.24459, 33.14705], [-117.24455, 33.14478], [-117.24659, 33.1439], [-117.24672, 33.1458], [-117.26179, 33.1458], [-117.26182, 33.14925]]]]} | Restricted Access 2 | 12865 | Dawson Los Monos Canyon Reserve | 17958 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | San Diego 4 | 231.903 | Dawson Los Monos Canyon Reserve | 0 | State Conservation Area 8 | 2 | |
5616 | 5616 | 5615 | {"type": "Polygon", "coordinates": [[[-121.98643, 41.98971], [-121.98471, 41.98982], [-121.98397, 41.98981], [-121.98405, 41.98862], [-121.98362, 41.98838], [-121.98299, 41.98775], [-121.98219, 41.98654], [-121.98206, 41.9848], [-121.98209, 41.98398], [-121.98344, 41.98364], [-121.98392, 41.98368], [-121.98459, 41.98424], [-121.98537, 41.98492], [-121.98567, 41.98547], [-121.98574, 41.9857], [-121.98581, 41.98656], [-121.98605, 41.98813], [-121.98625, 41.98891], [-121.98643, 41.98971]]]} | Restricted Access 2 | 2421 | Mud Lake Wildlife Area | 22583 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Siskiyou 28 | 40.351 | Mud Lake Wildlife Area | 0 | State Conservation Area 8 | 2 |
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]);