units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where COUNTY = 4, MNG_AGENCY = 25, MNG_AG_TYP = 5 and YR_EST = 0
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 2
ACCESS_TYP 2
MNG_AG_TYP 1
- State Agency · 10 ✖
MNG_AGENCY 1
- California Department of Fish and Wildlife · 10 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
3678 | 3678 | 3677 | {"type": "Polygon", "coordinates": [[[-117.17431, 33.05469], [-117.17231, 33.05468], [-117.17229, 33.05456], [-117.17224, 33.05445], [-117.17216, 33.05434], [-117.17206, 33.05426], [-117.17194, 33.05419], [-117.17181, 33.05416], [-117.17142, 33.05413], [-117.17121, 33.05407], [-117.17104, 33.05396], [-117.17068, 33.05363], [-117.17054, 33.05374], [-117.17047, 33.05382], [-117.1704, 33.05399], [-117.17038, 33.05408], [-117.1704, 33.05417], [-117.17059, 33.05467], [-117.17004, 33.05467], [-117.16999, 33.05106], [-117.172, 33.05106], [-117.17202, 33.0523], [-117.17429, 33.0523], [-117.17431, 33.05469]]]} | No Public Access 3 | 44356 | Escondido Creek | 32162 | 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 | 29.504 | Escondido Creek | 0 | State Resource Management Area 55 | 3 | |
6243 | 6243 | 6242 | {"type": "Polygon", "coordinates": [[[-116.96211, 32.96295], [-116.95351, 32.96324], [-116.95342, 32.95961], [-116.94888, 32.95974], [-116.94878, 32.95602], [-116.94045, 32.9561], [-116.94043, 32.95977], [-116.93185, 32.95964], [-116.93185, 32.95601], [-116.92761, 32.95596], [-116.92763, 32.95203], [-116.93186, 32.95198], [-116.93182, 32.94121], [-116.92765, 32.94122], [-116.92248, 32.94033], [-116.9225, 32.94032], [-116.92218, 32.93627], [-116.92764, 32.93755], [-116.92764, 32.93401], [-116.93615, 32.93378], [-116.93618, 32.93562], [-116.94046, 32.93556], [-116.94047, 32.93366], [-116.9447, 32.93354], [-116.94886, 32.93352], [-116.94892, 32.94093], [-116.95334, 32.9409], [-116.9534, 32.94251], [-116.95366, 32.94251], [-116.95404, 32.94257], [-116.95419, 32.94253], [-116.95424, 32.9425], [-116.95433, 32.94237], [-116.95436, 32.94199], [-116.95436, 32.94189], [-116.95434, 32.94179], [-116.95417, 32.94158], [-116.95413, 32.94147], [-116.95414, 32.94141], [-116.95421, 32.94125], [-116.9543, 32.94118], [-116.95462, 32.94098], [-116.95478, 32.94093], [-116.9549, 32.9409], [-116.95518, 32.94089], [-116.95541, 32.94094], [-116.95553, 32.94095], [-116.95568, 32.94125], [-116.95518, 32.94132], [-116.95504, 32.94139], [-116.95494, 32.94146], [-116.95486, 32.94158], [-116.95481, 32.94169], [-116.95481, 32.94184], [-116.95484, 32.94192], [-116.95488, 32.94211], [-116.95483, 32.94232], [-116.95478, 32.94241], [-116.9547, 32.94251], [-116.95461, 32.94259], [-116.95445, 32.94268], [-116.95429, 32.94272], [-116.95411, 32.94274], [-116.95366, 32.94268], [-116.95324, 32.94271], [-116.95308, 32.94269], [-116.95286, 32.94263], [-116.9527, 32.94263], [-116.95253, 32.94268], [-116.9524, 32.94276], [-116.9513, 32.94378], [-116.95115, 32.94389], [-116.95109, 32.94392], [-116.95165, 32.94469], [-116.94886, 32.94473], [-116.94889, 32.95222], [-116.95298, 32.9522], [-116.95323, 32.95222], [-116.95318, 32.94851], [-116.95783, 32.94845], [-116.95798, 32.95947], [-116.96207, 32.95939], [-116.96211, 32.96295]]]} | No Public Access 3 | 1316 | San Vicente Highlands | 32296 | 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 | 1545.08 | San Vicente Highlands | 0 | State Resource Management Area 55 | 3 | |
7770 | 7770 | 7769 | {"type": "MultiPolygon", "coordinates": [[[[-117.23873, 32.9777], [-117.23873, 32.97825], [-117.23589, 32.97824], [-117.23589, 32.97769], [-117.23873, 32.9777]]], [[[-117.25998, 32.96757], [-117.25996, 32.96761], [-117.25982, 32.96761], [-117.25966, 32.96764], [-117.25895, 32.96787], [-117.25875, 32.96792], [-117.25836, 32.96797], [-117.25808, 32.96798], [-117.25597, 32.96796], [-117.25596, 32.96753], [-117.24944, 32.96745], [-117.24862, 32.96463], [-117.24826, 32.96383], [-117.25164, 32.96386], [-117.25164, 32.96252], [-117.25179, 32.96252], [-117.25257, 32.96267], [-117.2527, 32.96273], [-117.25298, 32.96294], [-117.25311, 32.96301], [-117.2535, 32.96312], [-117.25362, 32.96313], [-117.25382, 32.96311], [-117.25466, 32.96292], [-117.25492, 32.96291], [-117.25509, 32.96295], [-117.25578, 32.96322], [-117.25651, 32.96401], [-117.25644, 32.96406], [-117.25671, 32.96465], [-117.25696, 32.96493], [-117.2575, 32.96525], [-117.25778, 32.9656], [-117.25788, 32.9657], [-117.25801, 32.96577], [-117.25819, 32.96584], [-117.25856, 32.9661], [-117.25869, 32.96652], [-117.259, 32.96693], [-117.25942, 32.96726], [-117.25998, 32.96757]]]]} | Restricted Access 2 | 29610 | San Dieguito Lagoon Ecological Reserve | 24866 | 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 | 102.535 | San Dieguito Lagoon ER | 0 | State Conservation Area 8 | 2 | |
9875 | 9875 | 9874 | {"type": "Polygon", "coordinates": [[[-116.92472, 33.30781], [-116.9243, 33.30807], [-116.92002, 33.31102], [-116.91534, 33.31417], [-116.90798, 33.31919], [-116.9001, 33.31615], [-116.90138, 33.31462], [-116.90169, 33.31428], [-116.90255, 33.31327], [-116.90259, 33.31326], [-116.91226, 33.30202], [-116.91289, 33.3024], [-116.9132, 33.30251], [-116.91339, 33.30251], [-116.91357, 33.30246], [-116.9137, 33.3024], [-116.91383, 33.30228], [-116.91391, 33.30216], [-116.91394, 33.30203], [-116.91395, 33.30125], [-116.9139, 33.30096], [-116.91366, 33.30042], [-116.91412, 33.29992], [-116.91452, 33.30019], [-116.91469, 33.30037], [-116.91483, 33.30054], [-116.91525, 33.30125], [-116.91538, 33.3014], [-116.91555, 33.3015], [-116.9157, 33.30152], [-116.9158, 33.30151], [-116.91599, 33.30144], [-116.91708, 33.3031], [-116.91724, 33.30377], [-116.91759, 33.30506], [-116.91361, 33.30706], [-116.91334, 33.3069], [-116.91329, 33.30691], [-116.91257, 33.30685], [-116.91224, 33.30687], [-116.91212, 33.30722], [-116.91201, 33.30831], [-116.91242, 33.30841], [-116.91292, 33.30861], [-116.9133, 33.30875], [-116.91369, 33.30885], [-116.91378, 33.30859], [-116.91457, 33.30832], [-116.91452, 33.30776], [-116.91453, 33.30775], [-116.91491, 33.30756], [-116.91526, 33.30744], [-116.91529, 33.30745], [-116.91544, 33.30741], [-116.91603, 33.30748], [-116.9163, 33.30723], [-116.91691, 33.30711], [-116.91724, 33.30707], [-116.91734, 33.30676], [-116.91757, 33.30649], [-116.91778, 33.30638], [-116.91768, 33.30626], [-116.91788, 33.30613], [-116.91827, 33.30753], [-116.92101, 33.30709], [-116.92362, 33.30718], [-116.92413, 33.30746], [-116.92472, 33.30781]], [[-116.91622, 33.30369], [-116.91648, 33.30389], [-116.91698, 33.30386], [-116.91698, 33.30384], [-116.91676, 33.30355], [-116.91605, 33.30315], [-116.9151, 33.30326], [-116.91509, 33.30331], [-116.91454, 33.30336], [-116.91429, 33.30327], [-116.91332, 33.30301], [-116.913, 33.3028], [-116.91252, 33.30272], [-116.91272, 33.30309], [-116.91295, 33.30328], [-116.91303, 33.30345], [-116.91315, 33.304], [-116.91341, 33.30416], [-116.91438, 33.30421], [-116.91487, 33.3042], [-116.91539, 33.3041], [-116.91542, 33.3038], [-116.91602, 33.30367], [-116.91622, 33.30369]]]} | Restricted Access 2 | 5341 | Plaisted Creek Ecological Reserve | 23767 | 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 | 463.609 | Plaisted Creek ER | 0 | State Conservation Area 8 | 2 | |
10233 | 10233 | 10232 | {"type": "MultiPolygon", "coordinates": [[[[-117.11031, 32.77957], [-117.11031, 32.77985], [-117.11022, 32.77985], [-117.10974, 32.77983], [-117.1093, 32.77979], [-117.10739, 32.77953], [-117.10841, 32.77919], [-117.10972, 32.77926], [-117.11031, 32.77957]]], [[[-117.11031, 32.78139], [-117.10939, 32.78129], [-117.10874, 32.78124], [-117.1081, 32.78124], [-117.10775, 32.78126], [-117.10736, 32.78131], [-117.10694, 32.78141], [-117.10659, 32.78152], [-117.10623, 32.78166], [-117.1059, 32.78182], [-117.10555, 32.78203], [-117.10524, 32.78226], [-117.10493, 32.78253], [-117.10466, 32.78283], [-117.10441, 32.78318], [-117.10419, 32.78357], [-117.10401, 32.78361], [-117.10399, 32.78228], [-117.104, 32.78071], [-117.10652, 32.77982], [-117.10701, 32.77966], [-117.10938, 32.77999], [-117.10979, 32.78019], [-117.11029, 32.78049], [-117.11027, 32.78101], [-117.11031, 32.78139]]]]} | Restricted Access 2 | 12831 | San Diego River Ecological Reserve | 24863 | 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 | 30.386 | San Diego River ER | 0 | State Conservation Area 8 | 2 | |
10237 | 10237 | 10236 | {"type": "MultiPolygon", "coordinates": [[[[-117.16249, 32.94601], [-117.16193, 32.94655], [-117.16192, 32.94675], [-117.1617, 32.94675], [-117.16137, 32.94705], [-117.16098, 32.94731], [-117.16097, 32.94751], [-117.16067, 32.94766], [-117.15867, 32.94845], [-117.15687, 32.94843], [-117.15688, 32.94911], [-117.1564, 32.9493], [-117.15598, 32.9494], [-117.15555, 32.94946], [-117.15305, 32.94959], [-117.15308, 32.94837], [-117.16054, 32.94596], [-117.16236, 32.94606], [-117.16249, 32.94601]]], [[[-117.16302, 32.94555], [-117.16283, 32.94568], [-117.16267, 32.94582], [-117.16234, 32.94595], [-117.16052, 32.94585], [-117.15309, 32.94825], [-117.1531, 32.94812], [-117.15431, 32.94641], [-117.15674, 32.94598], [-117.15711, 32.94613], [-117.15848, 32.94538], [-117.16225, 32.94328], [-117.163, 32.94474], [-117.16302, 32.94555]]], [[[-117.16592, 32.94474], [-117.16478, 32.94513], [-117.16443, 32.94477], [-117.16477, 32.9446], [-117.16552, 32.94434], [-117.16592, 32.94474]]], [[[-117.16772, 32.94614], [-117.16715, 32.94642], [-117.16635, 32.94573], [-117.16514, 32.94549], [-117.16488, 32.94522], [-117.16604, 32.94483], [-117.16641, 32.94543], [-117.16748, 32.94568], [-117.16772, 32.94614]]], [[[-117.17456, 32.92332], [-117.17351, 32.92332], [-117.17166, 32.92388], [-117.17167, 32.92357], [-117.17186, 32.92346], [-117.17186, 32.92294], [-117.17158, 32.92262], [-117.17207, 32.92214], [-117.17286, 32.92209], [-117.1733, 32.92236], [-117.1735, 32.92254], [-117.17329, 32.92266], [-117.17329, 32.92268], [-117.17456, 32.92332]]]]} | Restricted Access 2 | 13076 | Del Mar Mesa -- Lopez Ridge Ecological Reserve | 18031 | 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 | 84.095 | Del Mar Mesa -- Lopez Ridge ER | 0 | State Conservation Area 8 | 2 | |
11552 | 11552 | 11551 | {"type": "Polygon", "coordinates": [[[-116.66912, 32.98862], [-116.65988, 32.98873], [-116.65991, 32.98773], [-116.66058, 32.98745], [-116.66904, 32.98739], [-116.66912, 32.98862]]]} | Restricted Access 2 | 23593 | Boulder Creek Ecological Reserve | 16294 | 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 | 29.218 | Boulder Creek ER | 0 | State Conservation Area 8 | 2 | |
12161 | 12161 | 12160 | {"type": "MultiPolygon", "coordinates": [[[[-116.89905, 32.95333], [-116.89, 32.95344], [-116.88151, 32.95355], [-116.8816, 32.96148], [-116.88116, 32.9615], [-116.88115, 32.96152], [-116.885, 32.9652], [-116.88908, 32.96899], [-116.88886, 32.96915], [-116.88806, 32.96953], [-116.88748, 32.96988], [-116.88714, 32.97015], [-116.88637, 32.97047], [-116.88496, 32.97038], [-116.88394, 32.97102], [-116.88384, 32.97134], [-116.88348, 32.97175], [-116.88356, 32.97201], [-116.88313, 32.97251], [-116.88289, 32.97259], [-116.88262, 32.97308], [-116.88259, 32.97326], [-116.88268, 32.9735], [-116.8831, 32.97377], [-116.88302, 32.97416], [-116.883, 32.9744], [-116.88309, 32.97464], [-116.88333, 32.97482], [-116.88365, 32.97502], [-116.88396, 32.9752], [-116.8848, 32.97528], [-116.88502, 32.97532], [-116.88523, 32.97541], [-116.8854, 32.97555], [-116.88529, 32.97581], [-116.88538, 32.97593], [-116.88558, 32.97612], [-116.88559, 32.97621], [-116.88546, 32.97641], [-116.88497, 32.9773], [-116.88513, 32.97767], [-116.88546, 32.97779], [-116.88569, 32.97807], [-116.88589, 32.97851], [-116.88585, 32.97869], [-116.88572, 32.97887], [-116.88574, 32.97923], [-116.88615, 32.98011], [-116.88646, 32.98026], [-116.88664, 32.98061], [-116.88691, 32.98074], [-116.88704, 32.98091], [-116.8871, 32.98113], [-116.88712, 32.98177], [-116.88739, 32.98276], [-116.88724, 32.98301], [-116.88737, 32.98363], [-116.88727, 32.98413], [-116.88743, 32.98493], [-116.88738, 32.98527], [-116.88734, 32.98618], [-116.88744, 32.98643], [-116.88739, 32.98664], [-116.88719, 32.98685], [-116.88719, 32.98709], [-116.88736, 32.98767], [-116.88731, 32.98807], [-116.8875, 32.98843], [-116.88729, 32.98881], [-116.88741, 32.98924], [-116.88717, 32.98984], [-116.88666, 32.99058], [-116.88661, 32.99098], [-116.88658, 32.99111], [-116.88666, 32.99133], [-116.88665, 32.9917], [-116.88654, 32.99221], [-116.88662, 32.99234], [-116.8864, 32.9939], [-116.87774, 32.99394], [-116.87771, 32.99394], [-116.8777, 32.99389], [-116.87565, 32.99388], [-116.87531, 32.98531], [-116.86673, 32.98548], [-116.86689, 32.99385], [-116.85049, 32.99367], [-116.85066, 32.99357], [-116.85055, 32.99344], [-116.85028, 32.99359], [-116.85006, 32.99368], [-116.8499, 32.99368], [-116.84983, 32.99285], [-116.84955, 32.98892], [-116.8484, 32.98898], [-116.84841, 32.98896], [-116.84841, 32.98895], [-116.84131, 32.98865], [-116.84128, 32.97835], [-116.84039, 32.96417], [-116.84829, 32.96324], [-116.84847, 32.94951], [-116.85033, 32.95109], [-116.85343, 32.95285], [-116.8537, 32.95281], [-116.85377, 32.95285], [-116.85671, 32.95243], [-116.85752, 32.95367], [-116.85831, 32.95552], [-116.85917, 32.95623], [-116.85986, 32.95615], [-116.86132, 32.95637], [-116.86287, 32.95522], [-116.86398, 32.95328], [-116.8659, 32.95241], [-116.86586, 32.95523], [-116.8735, 32.95511], [-116.87459, 32.95514], [-116.88011, 32.94845], [-116.87784, 32.94618], [-116.88568, 32.94618], [-116.88564, 32.94202], [-116.88949, 32.94174], [-116.89438, 32.94175], [-116.8944, 32.94591], [-116.89892, 32.94576], [-116.89905, 32.95333]], [[-116.85013, 32.98801], [-116.85065, 32.98657], [-116.84949, 32.98657], [-116.84954, 32.98837], [-116.84974, 32.98835], [-116.84991, 32.98827], [-116.85005, 32.98815], [-116.85013, 32.98801]]], [[[-116.90039, 32.98023], [-116.89618, 32.98029], [-116.89653, 32.98476], [-116.89236, 32.98489], [-116.89283, 32.98927], [-116.89317, 32.99393], [-116.88879, 32.99392], [-116.88686, 32.9939], [-116.88696, 32.99365], [-116.88691, 32.99352], [-116.88678, 32.9933], [-116.88692, 32.99229], [-116.88684, 32.99216], [-116.88694, 32.99173], [-116.88695, 32.9913], [-116.88688, 32.9911], [-116.88694, 32.99065], [-116.88743, 32.98995], [-116.88772, 32.98926], [-116.8876, 32.98884], [-116.88782, 32.98844], [-116.88761, 32.98803], [-116.88766, 32.98766], [-116.88748, 32.98706], [-116.88748, 32.98694], [-116.88767, 32.98674], [-116.88774, 32.98642], [-116.88764, 32.98615], [-116.88768, 32.98529], [-116.88772, 32.98492], [-116.88757, 32.98413], [-116.88767, 32.98363], [-116.88754, 32.98305], [-116.8877, 32.98279], [-116.88741, 32.98174], [-116.88739, 32.98111], [-116.88732, 32.98082], [-116.88711, 32.98055], [-116.88687, 32.98044], [-116.88669, 32.98009], [-116.88639, 32.97994], [-116.88603, 32.97917], [-116.88601, 32.97894], [-116.88614, 32.97878], [-116.88619, 32.97848], [-116.88595, 32.97795], [-116.88565, 32.97759], [-116.88537, 32.97748], [-116.88529, 32.97731], [-116.88572, 32.97653], [-116.88585, 32.97632], [-116.88591, 32.97618], [-116.88589, 32.97611], [-116.88568, 32.97589], [-116.88562, 32.97577], [-116.88574, 32.97564], [-116.88576, 32.97544], [-116.88552, 32.97514], [-116.88519, 32.97496], [-116.88454, 32.97497], [-116.88416, 32.97491], [-116.88367, 32.97459], [-116.88342, 32.97445], [-116.88331, 32.97435], [-116.88341, 32.97379], [-116.88335, 32.97365], [-116.88297, 32.97336], [-116.88293, 32.97329], [-116.88292, 32.97323], [-116.88293, 32.97317], [-116.88313, 32.97282], [-116.88333, 32.97276], [-116.8839, 32.97204], [-116.88384, 32.97183], [-116.88416, 32.9715], [-116.88425, 32.97121], [-116.88509, 32.97067], [-116.88647, 32.97077], [-116.88707, 32.97049], [-116.88737, 32.97033], [-116.88772, 32.97009], [-116.88829, 32.96974], [-116.88913, 32.96933], [-116.88931, 32.9692], [-116.89119, 32.97093], [-116.89186, 32.97159], [-116.89141, 32.97351], [-116.89084, 32.97584], [-116.9001, 32.97586], [-116.90039, 32.98023]]]]} | No Public Access 3 | 25240 | Canada de San Vicente | 32091 | 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 | 4998.226 | Canada de San Vicente | 0 | State Resource Management Area 55 | 3 | |
15618 | 15618 | 15617 | {"type": "Polygon", "coordinates": [[[-117.10664, 33.07422], [-117.10657, 33.07428], [-117.10628, 33.07556], [-117.10504, 33.07516], [-117.1052, 33.07405], [-117.10423, 33.07384], [-117.10423, 33.07312], [-117.10319, 33.072], [-117.10339, 33.07187], [-117.10339, 33.07186], [-117.10243, 33.0711], [-117.10269, 33.07041], [-117.10371, 33.07007], [-117.10564, 33.07143], [-117.10596, 33.07398], [-117.10664, 33.07422]]]} | Restricted Access 2 | 23594 | Lake Hodges Ecological Reserve | 20894 | 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 | 24.606 | Lake Hodges ER | 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]);