units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
70 rows where DES_TP = 104 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, LAYER, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 13
- California Department of Transportation 21
- California Department of General Services 11
- California Department of Fish and Wildlife 10
- Other State 9
- California Department of Parks and Recreation 5
- California Wildlife Conservation Board 4
- California Department of Water Resources 2
- California State University 2
- California Tahoe Conservancy 2
- University of California 1
- California State Lands Commission 1
- San Joaquin River Parkway and Conservation Trust 1
- Coachella Valley Mountains Conservancy 1
AGNCY_WEB 12 ✖
- http://www.dot.ca.gov/ 21
- http://www.dgs.ca.gov/default.htm 11
- https://www.wildlife.ca.gov/ 10
- http://www.parks.ca.gov/ 5
- http://www.wcb.ca.gov/ 4
- http://tahoe.ca.gov/ 2
- http://www.calstate.edu/ 2
- http://www.water.ca.gov/ 2
- http://nrs.ucop.edu/ 1
- http://sjrc.ca.gov/ 1
- http://www.cvmc.ca.gov/ 1
- http://www.slc.ca.gov/ 1
ACCESS_TYP 4
MNG_AG_TYP 2
MNG_AG_LEV 2 ✖
- State 69
- Non Profit 1
DES_TP 1
- State Other or Unknown · 70 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3744 | 3744 | 3743 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56116], [-117.00554, 32.56472], [-117.00446, 32.56471], [-117.00445, 32.56601], [-117.00443, 32.56603], [-117.00418, 32.566], [-117.00401, 32.56588], [-117.00338, 32.56582], [-117.00337, 32.56469], [-117.00123, 32.56466], [-117.00126, 32.56109], [-117.00555, 32.56116]]]} | No Public Access 3 | 44877 | Anderprises TransNet Environmental Mitigation | 32283 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 42.881 | Anderprises TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
4229 | 4229 | 4228 | {"type": "Polygon", "coordinates": [[[-117.00555, 32.56025], [-117.00555, 32.56116], [-117.00126, 32.56109], [-117.00126, 32.56018], [-117.00555, 32.56025]]]} | Unknown Access 4 | 45096 | Anderprizes Mitigation Site | 15474 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 10.024 | Anderprizes Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
14621 | 14621 | 14620 | {"type": "Polygon", "coordinates": [[[-117.2959, 33.08404], [-117.29591, 33.08449], [-117.29589, 33.08457], [-117.29581, 33.08472], [-117.29571, 33.08486], [-117.29559, 33.08498], [-117.29544, 33.08509], [-117.29545, 33.08513], [-117.29301, 33.08641], [-117.29248, 33.08662], [-117.29177, 33.08681], [-117.2917, 33.08409], [-117.2959, 33.08404]]]} | Unknown Access 4 | 44854 | Ayoub Mitigation Site | 15736 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 20.055 | Ayoub Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
1157 | 1157 | 1156 | {"type": "Polygon", "coordinates": [[[-116.91384, 32.82128], [-116.9136, 32.82217], [-116.91351, 32.82247], [-116.91325, 32.82312], [-116.91306, 32.82352], [-116.91285, 32.82388], [-116.91253, 32.82436], [-116.91234, 32.8246], [-116.91137, 32.82546], [-116.91041, 32.8248], [-116.9096, 32.82296], [-116.90946, 32.82252], [-116.90948, 32.82219], [-116.91047, 32.82103], [-116.91059, 32.82076], [-116.91384, 32.82128]]]} | Open Access 1 | 7356 | CalTrans TransNet Environmental Mitigation | 16740 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 33.902 | CalTrans TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
2095 | 2095 | 2094 | {"type": "Polygon", "coordinates": [[[-121.70681, 38.27679], [-121.69559, 38.279], [-121.69594, 38.27864], [-121.69605, 38.27822], [-121.69594, 38.27776], [-121.69591, 38.27776], [-121.69526, 38.27319], [-121.69496, 38.27168], [-121.6945, 38.26631], [-121.69503, 38.266], [-121.69541, 38.26585], [-121.69632, 38.26585], [-121.69693, 38.26661], [-121.69714, 38.2671], [-121.69799, 38.2678], [-121.69895, 38.26831], [-121.69965, 38.26846], [-121.69988, 38.26865], [-121.70056, 38.26926], [-121.70453, 38.27349], [-121.70503, 38.27408], [-121.70574, 38.27512], [-121.70586, 38.27551], [-121.70622, 38.27614], [-121.70681, 38.27679]]]} | No Public Access 3 | 15834 | DWR Mitigation | 18327 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Solano 26 | 213.26 | DWR Mitigation | 0 | State Other or Unknown 104 | 4 | |
7566 | 7566 | 7565 | {"type": "MultiPolygon", "coordinates": [[[[-118.79086, 34.75249], [-118.7905, 34.75269], [-118.78995, 34.75282], [-118.78833, 34.75304], [-118.7856, 34.75305], [-118.78493, 34.75343], [-118.7845, 34.75351], [-118.78357, 34.75316], [-118.78272, 34.7538], [-118.78126, 34.75417], [-118.78017, 34.75394], [-118.77903, 34.75547], [-118.77894, 34.75664], [-118.77779, 34.75756], [-118.77848, 34.758], [-118.77841, 34.75986], [-118.77886, 34.75987], [-118.77913, 34.76202], [-118.77761, 34.76518], [-118.77755, 34.76574], [-118.77634, 34.76582], [-118.77522, 34.7637], [-118.77346, 34.76262], [-118.77195, 34.76241], [-118.77418, 34.76093], [-118.7718, 34.76016], [-118.7718, 34.75988], [-118.77251, 34.75988], [-118.77253, 34.75986], [-118.77541, 34.75987], [-118.77538, 34.75716], [-118.76641, 34.75721], [-118.76641, 34.7563], [-118.76211, 34.75628], [-118.76217, 34.75101], [-118.76215, 34.74996], [-118.76216, 34.74903], [-118.74905, 34.74906], [-118.74903, 34.74547], [-118.74904, 34.73837], [-118.75789, 34.73825], [-118.75783, 34.7453], [-118.75784, 34.74543], [-118.76664, 34.74538], [-118.76648, 34.75269], [-118.78437, 34.75246], [-118.79086, 34.75249]]], [[[-118.81161, 34.69934], [-118.80281, 34.69927], [-118.80282, 34.70238], [-118.80001, 34.70204], [-118.79731, 34.7014], [-118.79715, 34.70135], [-118.79688, 34.70122], [-118.79659, 34.70101], [-118.79636, 34.70072], [-118.79535, 34.69892], [-118.79396, 34.69519], [-118.79373, 34.69386], [-118.79362, 34.6936], [-118.79348, 34.69334], [-118.7933, 34.69308], [-118.7926, 34.69251], [-118.79179, 34.69207], [-118.79171, 34.69193], [-118.79408, 34.69176], [-118.80275, 34.69201], [-118.80714, 34.69205], [-118.80718, 34.69567], [-118.81157, 34.69571], [-118.81161, 34.69934]]], [[[-118.7954, 34.74528], [-118.79529, 34.74598], [-118.79517, 34.74694], [-118.79477, 34.7469], [-118.79447, 34.74857], [-118.79437, 34.74895], [-118.79362, 34.75118], [-118.79356, 34.75131], [-118.79347, 34.75144], [-118.79333, 34.75159], [-118.79322, 34.75168], [-118.79317, 34.74518], [-118.7953, 34.74521], [-118.7954, 34.74528]]]]} | No Public Access 3 | 7259 | DWR Mitigation -- L.A. Property | 32152 | 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 | Los Angeles 6 | 999.598 | DWR Mitigation -- L.A. Property | 0 | State Other or Unknown 104 | 4 | |
14336 | 14336 | 14335 | {"type": "Polygon", "coordinates": [[[-122.00031, 40.43185], [-122.00029, 40.43226], [-121.99983, 40.4321], [-121.99906, 40.4325], [-121.99844, 40.43331], [-121.99657, 40.43358], [-121.99441, 40.43303], [-121.99419, 40.433], [-121.9926, 40.43265], [-121.99119, 40.43195], [-121.99124, 40.42927], [-121.99732, 40.42914], [-121.99734, 40.42833], [-122.00029, 40.42825], [-122.00031, 40.43185]]]} | Open Access 1 | 44352 | Darrah Springs Fish Hatchery | 32144 | 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 | 85.045 | Darrah Springs Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
14573 | 14573 | 14572 | {"type": "Polygon", "coordinates": [[[-117.24569, 32.9638], [-117.24306, 32.96378], [-117.24305, 32.96017], [-117.24531, 32.9602], [-117.24558, 32.96169], [-117.24569, 32.9638]]]} | Unknown Access 4 | 44878 | Dean Family Trust TransNet Environmental Mitigation | 17977 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 23.121 | Dean Family Trust TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
14627 | 14627 | 14626 | {"type": "Polygon", "coordinates": [[[-117.1923, 32.94906], [-117.191, 32.94919], [-117.19013, 32.94942], [-117.18969, 32.94958], [-117.1895, 32.94982], [-117.19051, 32.94991], [-117.19179, 32.94988], [-117.18881, 32.95146], [-117.18726, 32.95215], [-117.18661, 32.95216], [-117.18604, 32.95168], [-117.1852, 32.95166], [-117.18365, 32.9519], [-117.18288, 32.95212], [-117.18285, 32.94953], [-117.18356, 32.94954], [-117.18489, 32.94924], [-117.18599, 32.94907], [-117.18671, 32.94907], [-117.1883, 32.94888], [-117.18953, 32.94857], [-117.18983, 32.94848], [-117.19089, 32.94847], [-117.1916, 32.9486], [-117.1923, 32.94906]]]} | Open Access 1 | 44879 | Deer Canyon Environmental Mitigation | 17991 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 54.189 | Deer Canyon Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
10166 | 10166 | 10165 | {"type": "Polygon", "coordinates": [[[-121.50965, 38.26426], [-121.504, 38.26799], [-121.50354, 38.26776], [-121.49741, 38.2718], [-121.49714, 38.27079], [-121.49718, 38.27056], [-121.49735, 38.27044], [-121.49739, 38.27031], [-121.49769, 38.27006], [-121.49778, 38.26953], [-121.49789, 38.2695], [-121.49772, 38.26927], [-121.4976, 38.26904], [-121.49618, 38.27013], [-121.49636, 38.27139], [-121.49639, 38.27268], [-121.49826, 38.27354], [-121.49845, 38.27456], [-121.49793, 38.27673], [-121.4954, 38.27672], [-121.49517, 38.27538], [-121.4951, 38.27483], [-121.49506, 38.27443], [-121.49502, 38.27373], [-121.49502, 38.27313], [-121.49508, 38.27226], [-121.49523, 38.27126], [-121.49541, 38.27047], [-121.49531, 38.27045], [-121.49556, 38.2696], [-121.49584, 38.26887], [-121.49583, 38.26885], [-121.49576, 38.26885], [-121.49617, 38.26803], [-121.49757, 38.26552], [-121.49751, 38.26545], [-121.49743, 38.26543], [-121.49724, 38.26541], [-121.49715, 38.26534], [-121.49699, 38.26526], [-121.49701, 38.2652], [-121.4968, 38.26514], [-121.4967, 38.26509], [-121.49661, 38.26509], [-121.49571, 38.26502], [-121.49553, 38.26473], [-121.49532, 38.26455], [-121.49523, 38.26454], [-121.49511, 38.26435], [-121.49489, 38.26415], [-121.49478, 38.26414], [-121.4945, 38.2639], [-121.49426, 38.26356], [-121.49412, 38.26323], [-121.49401, 38.26242], [-121.49388, 38.26202], [-121.49327, 38.26127], [-121.49309, 38.26093], [-121.49298, 38.26063], [-121.49294, 38.25993], [-121.49297, 38.25961], [-121.49309, 38.25931], [-121.49341, 38.25904], [-121.4938, 38.25889], [-121.4939, 38.25893], [-121.49429, 38.25876], [-121.49445, 38.25876], [-121.49481, 38.25864], [-121.49524, 38.25847], [-121.49556, 38.25815], [-121.49606, 38.25758], [-121.49621, 38.25729], [-121.4963, 38.25716], [-121.49746, 38.25638], [-121.49789, 38.25614], [-121.49806, 38.25609], [-121.49821, 38.25602], [-121.49851, 38.25559], [-121.49843, 38.25518], [-121.4982, 38.25464], [-121.49814, 38.25443], [-121.49806, 38.25399], [-121.49802, 38.25353], [-121.49797, 38.25326], [-121.49795, 38.25286], [-121.4979, 38.25256], [-121.49773, 38.25179], [-121.49772, 38.25147], [-121.50104, 38.25101], [-121.50156, 38.25114], [-121.5038, 38.25083], [-121.50375, 38.25063], [-121.50339, 38.25068], [-121.5027, 38.24588], [-121.50353, 38.24609], [-121.5037, 38.24612], [-121.50384, 38.24617], [-121.50863, 38.24741], [-121.50921, 38.24635], [-121.50958, 38.24651], [-121.5081, 38.24892], [-121.50797, 38.24894], [-121.50805, 38.24901], [-121.50763, 38.24968], [-121.50783, 38.25006], [-121.50797, 38.25004], [-121.50312, 38.25795], [-121.5029, 38.25787], [-121.50269, 38.25821], [-121.50498, 38.25966], [-121.5073, 38.26083], [-121.50771, 38.26135], [-121.5083, 38.26215], [-121.50965, 38.26426]]]} | No Public Access 3 | 20470 | Delta Meadows Park Property | 18073 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | Sacramento 41 | 533.415 | Delta Meadows Park Property | 1985 | State Other or Unknown 104 | 4 | |
3679 | 3679 | 3678 | {"type": "Polygon", "coordinates": [[[-118.88648, 34.3927], [-118.88616, 34.39362], [-118.88606, 34.39361], [-118.88569, 34.39465], [-118.88193, 34.39395], [-118.88215, 34.39142], [-118.88648, 34.3927]]]} | Open Access 1 | 44358 | Fillmore Fish Hatchery | 32165 | 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 | Ventura 8 | 24.109 | Fillmore Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
14640 | 14640 | 14639 | {"type": "Polygon", "coordinates": [[[-117.23926, 33.28549], [-117.23926, 33.28909], [-117.23491, 33.28917], [-117.23491, 33.28905], [-117.2349, 33.28905], [-117.23474, 33.28918], [-117.23415, 33.29054], [-117.23405, 33.29043], [-117.23392, 33.29033], [-117.23377, 33.29024], [-117.23361, 33.29018], [-117.23148, 33.28969], [-117.23111, 33.28962], [-117.23055, 33.28956], [-117.23055, 33.28559], [-117.22838, 33.28563], [-117.22837, 33.28929], [-117.22772, 33.2893], [-117.22737, 33.28923], [-117.2265, 33.28895], [-117.22601, 33.28878], [-117.22595, 33.28872], [-117.22575, 33.28868], [-117.22571, 33.28792], [-117.22516, 33.28706], [-117.22519, 33.28669], [-117.22535, 33.28629], [-117.22535, 33.28602], [-117.22514, 33.28568], [-117.22551, 33.28334], [-117.22564, 33.28297], [-117.22601, 33.28228], [-117.22622, 33.28194], [-117.22668, 33.2815], [-117.22671, 33.28162], [-117.22676, 33.28169], [-117.22686, 33.28177], [-117.2269, 33.28184], [-117.22711, 33.28231], [-117.22773, 33.2829], [-117.22847, 33.28203], [-117.22846, 33.28202], [-117.22816, 33.28203], [-117.22708, 33.28113], [-117.22784, 33.28019], [-117.22798, 33.28008], [-117.22965, 33.279], [-117.22998, 33.27881], [-117.2345, 33.27683], [-117.23471, 33.27672], [-117.23494, 33.27658], [-117.23493, 33.28186], [-117.23731, 33.28182], [-117.23731, 33.2832], [-117.23567, 33.28324], [-117.23567, 33.2855], [-117.23923, 33.28544], [-117.23923, 33.28549], [-117.23926, 33.28549]]]} | Unknown Access 4 | 44885 | Groves Property TransNet Mitigation | 19537 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 281.423 | Groves Property TransNet Mitigation | 0 | State Other or Unknown 104 | 4 | |
14639 | 14639 | 14638 | {"type": "MultiPolygon", "coordinates": [[[[-117.30789, 33.14718], [-117.30772, 33.14736], [-117.30771, 33.14776], [-117.30743, 33.14776], [-117.30737, 33.14766], [-117.30705, 33.14753], [-117.30696, 33.14783], [-117.30706, 33.148], [-117.30683, 33.14848], [-117.30683, 33.14853], [-117.30595, 33.14884], [-117.30597, 33.14857], [-117.30597, 33.1483], [-117.30577, 33.14828], [-117.30574, 33.14806], [-117.30489, 33.14809], [-117.3046, 33.14818], [-117.30433, 33.14833], [-117.30412, 33.14849], [-117.30391, 33.14872], [-117.30376, 33.14923], [-117.30349, 33.14922], [-117.3037, 33.14814], [-117.30373, 33.14817], [-117.3073, 33.14696], [-117.30741, 33.14684], [-117.30789, 33.14718]]], [[[-117.3193, 33.14321], [-117.31899, 33.14379], [-117.31831, 33.14345], [-117.3183, 33.14347], [-117.31839, 33.14363], [-117.31815, 33.14354], [-117.31788, 33.14349], [-117.31604, 33.14329], [-117.31607, 33.14321], [-117.31607, 33.1432], [-117.31432, 33.143], [-117.31446, 33.14269], [-117.31497, 33.14275], [-117.31528, 33.14261], [-117.31575, 33.14215], [-117.31581, 33.14205], [-117.31585, 33.14202], [-117.31617, 33.14201], [-117.31631, 33.14205], [-117.31636, 33.14211], [-117.31637, 33.14234], [-117.3164, 33.14236], [-117.3166, 33.14232], [-117.31679, 33.1423], [-117.31684, 33.14228], [-117.31686, 33.14225], [-117.31696, 33.14196], [-117.317, 33.14192], [-117.31707, 33.1419], [-117.31748, 33.14197], [-117.31758, 33.14202], [-117.31763, 33.14209], [-117.31765, 33.14216], [-117.31757, 33.14238], [-117.31757, 33.14241], [-117.31791, 33.14259], [-117.31795, 33.1426], [-117.31799, 33.14258], [-117.31807, 33.14237], [-117.31814, 33.14231], [-117.31823, 33.14231], [-117.31849, 33.14237], [-117.31855, 33.1424], [-117.31858, 33.14246], [-117.31862, 33.14272], [-117.31852, 33.14303], [-117.31853, 33.14311], [-117.31855, 33.14318], [-117.31855, 33.14322], [-117.31857, 33.14324], [-117.31866, 33.14328], [-117.3188, 33.14331], [-117.319, 33.14317], [-117.31919, 33.14308], [-117.31925, 33.14311], [-117.31927, 33.14319], [-117.3193, 33.14321]]]]} | Unknown Access 4 | 44880 | Hallmark Transnet Environmental Mitigation | 19611 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 19.35 | Hallmark Transnet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
10013 | 10013 | 10012 | {"type": "Polygon", "coordinates": [[[-121.0344, 37.04936], [-121.02559, 37.04938], [-121.02568, 37.04211], [-121.02537, 37.0413], [-121.02528, 37.04058], [-121.02522, 37.04034], [-121.03435, 37.04041], [-121.03434, 37.04218], [-121.0344, 37.04936]]]} | No Public Access 3 | 17275 | Jasper Sears Mitigation Parcel | 32192 | 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 | Merced 37 | 192.527 | Jasper Sears Mitigation Parcel | 0 | State Other or Unknown 104 | 4 | |
14748 | 14748 | 14747 | {"type": "MultiPolygon", "coordinates": [[[[-117.2483, 33.24507], [-117.24833, 33.24558], [-117.24831, 33.24561], [-117.24827, 33.24564], [-117.24827, 33.24579], [-117.24833, 33.24583], [-117.24834, 33.24606], [-117.2485, 33.24653], [-117.24854, 33.24677], [-117.24852, 33.24699], [-117.24841, 33.24737], [-117.24838, 33.2476], [-117.24839, 33.24781], [-117.24846, 33.24825], [-117.24847, 33.24864], [-117.24846, 33.24868], [-117.24839, 33.24871], [-117.2469, 33.24873], [-117.24645, 33.24865], [-117.24604, 33.24863], [-117.24565, 33.24867], [-117.24515, 33.24879], [-117.24508, 33.24877], [-117.24498, 33.24859], [-117.24493, 33.2451], [-117.2483, 33.24507]]], [[[-117.24931, 33.25309], [-117.24829, 33.25358], [-117.24817, 33.25368], [-117.24651, 33.25308], [-117.24637, 33.25305], [-117.246, 33.25299], [-117.24564, 33.25296], [-117.24533, 33.25296], [-117.24499, 33.25298], [-117.24498, 33.24895], [-117.24509, 33.24899], [-117.24517, 33.24899], [-117.2454, 33.2489], [-117.24562, 33.24884], [-117.24606, 33.24879], [-117.24646, 33.24882], [-117.2469, 33.2489], [-117.24928, 33.24886], [-117.24931, 33.25309]]]]} | Unknown Access 4 | 45093 | Jeffries Ranch Mitigation Site | 20385 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 79.98 | Jeffries Ranch Mitigation Site | 0 | State Other or Unknown 104 | 4 | |
7862 | 7862 | 7861 | {"type": "MultiPolygon", "coordinates": [[[[-116.94813, 32.58902], [-116.9452, 32.5891], [-116.94513, 32.5821], [-116.94581, 32.58211], [-116.9458, 32.58217], [-116.94582, 32.58248], [-116.94603, 32.58271], [-116.94635, 32.58283], [-116.94672, 32.58291], [-116.94705, 32.58296], [-116.94715, 32.58293], [-116.94748, 32.58333], [-116.94808, 32.58424], [-116.94542, 32.58527], [-116.94582, 32.58582], [-116.947, 32.58786], [-116.94813, 32.58902]]], [[[-116.96324, 32.58239], [-116.96221, 32.58238], [-116.96223, 32.58109], [-116.96255, 32.58146], [-116.96287, 32.58187], [-116.96324, 32.58239]]], [[[-116.97107, 32.58246], [-116.96665, 32.58242], [-116.96664, 32.58433], [-116.9656, 32.58432], [-116.96528, 32.5838], [-116.96527, 32.58366], [-116.96504, 32.58323], [-116.96479, 32.58282], [-116.96439, 32.58227], [-116.96379, 32.5813], [-116.96318, 32.58026], [-116.96293, 32.57991], [-116.96267, 32.57957], [-116.96225, 32.57912], [-116.96225, 32.57881], [-116.96235, 32.5788], [-116.96238, 32.57507], [-116.97088, 32.57514], [-116.97107, 32.58246]]]]} | No Public Access 3 | 47715 | Lonestar Ridge TransNet Environmental Mitigation | 31496 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 191.623 | Lonestar Ridge TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
13226 | 13226 | 13225 | {"type": "Polygon", "coordinates": [[[-117.23056, 33.28559], [-117.23055, 33.28926], [-117.23037, 33.28927], [-117.23036, 33.28955], [-117.22971, 33.28951], [-117.22837, 33.28938], [-117.22838, 33.28563], [-117.23056, 33.28559]]]} | Unknown Access 4 | 45245 | Lueng/Lowe TransNet Environmental Mitigation | 21587 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 21.401 | Lueng/Lowe TransNet Environmental Mitigation | 0 | State Other or Unknown 104 | 4 | |
3676 | 3676 | 3675 | {"type": "Polygon", "coordinates": [[[-123.9944, 40.85728], [-123.98793, 40.85729], [-123.98823, 40.85355], [-123.99083, 40.85359], [-123.991, 40.85206], [-123.99205, 40.85205], [-123.99208, 40.8536], [-123.99105, 40.85359], [-123.99104, 40.8536], [-123.99158, 40.85448], [-123.99209, 40.85481], [-123.99433, 40.85721], [-123.9944, 40.85728]]]} | Open Access 1 | 44354 | Mad River Fish Hatchery | 32212 | 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 | 43.3 | Mad River Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
3680 | 3680 | 3679 | {"type": "Polygon", "coordinates": [[[-117.26286, 34.48019], [-117.26032, 34.48127], [-117.25982, 34.48047], [-117.25985, 34.47881], [-117.25943, 34.47781], [-117.26087, 34.47739], [-117.26169, 34.47931], [-117.26221, 34.47915], [-117.26286, 34.48019]]]} | Open Access 1 | 44360 | Mojave River Fish Hatchery | 32227 | 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 Bernardino 22 | 17.666 | Mojave River Fish Hatchery | 0 | State Other or Unknown 104 | 4 | |
14734 | 14734 | 14733 | {"type": "Polygon", "coordinates": [[[-117.1954, 33.31432], [-117.19505, 33.31429], [-117.19404, 33.31474], [-117.19356, 33.31463], [-117.1905, 33.31328], [-117.18794, 33.31349], [-117.18526, 33.31418], [-117.1771, 33.31479], [-117.17421, 33.31628], [-117.17383, 33.31428], [-117.19121, 33.31078], [-117.19489, 33.31006], [-117.19536, 33.30995], [-117.1954, 33.31432]]]} | Unknown Access 4 | 45101 | Morrison Mitigation Site | 22497 | 205 | California Department of Transportation 283 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | San Diego 4 | 123.583 | Morrison Mitigation Site | 0 | State Other or Unknown 104 | 4 |
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]);