units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where ACCESS_TYP = 2, LAYER = 5 and MNG_AGENCY = 51
This data as json, copyable, CSV (advanced)
Suggested facets: COUNTY, YR_EST, GAP_STS
DES_TP 13
MNG_AG_TYP 1
- State Agency 41
MNG_AGENCY 1
- University of California · 41 ✖
ACCESS_TYP 1
- Restricted Access · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
125 | 125 | 124 | {"type": "Polygon", "coordinates": [[[-122.16054, 37.91443], [-122.15949, 37.91447], [-122.15824, 37.91493], [-122.15833, 37.91517], [-122.15835, 37.9154], [-122.15843, 37.91558], [-122.15855, 37.91562], [-122.1591, 37.91596], [-122.15923, 37.916], [-122.15932, 37.91606], [-122.15944, 37.9161], [-122.15978, 37.91678], [-122.15987, 37.91706], [-122.15989, 37.91733], [-122.15981, 37.91743], [-122.15968, 37.9175], [-122.15952, 37.91752], [-122.1583, 37.91752], [-122.15781, 37.91755], [-122.15781, 37.9177], [-122.15682, 37.91818], [-122.15556, 37.91921], [-122.15437, 37.92001], [-122.15249, 37.92204], [-122.15111, 37.92218], [-122.14987, 37.92221], [-122.14886, 37.92159], [-122.14828, 37.92145], [-122.14816, 37.92139], [-122.14803, 37.92129], [-122.14763, 37.92077], [-122.14752, 37.92071], [-122.14689, 37.92039], [-122.14573, 37.91988], [-122.14487, 37.91881], [-122.14368, 37.91819], [-122.14285, 37.91769], [-122.14266, 37.9176], [-122.14226, 37.91738], [-122.14209, 37.91701], [-122.14195, 37.91666], [-122.14182, 37.91621], [-122.14211, 37.9161], [-122.14325, 37.91561], [-122.14391, 37.91541], [-122.14487, 37.91524], [-122.14541, 37.91512], [-122.14599, 37.91505], [-122.14652, 37.91488], [-122.14719, 37.91472], [-122.14806, 37.91437], [-122.14828, 37.91418], [-122.14845, 37.91387], [-122.14876, 37.91372], [-122.14919, 37.91365], [-122.14961, 37.91369], [-122.14986, 37.91367], [-122.15009, 37.91362], [-122.15051, 37.91345], [-122.15067, 37.91336], [-122.1508, 37.91331], [-122.15093, 37.9132], [-122.15112, 37.91294], [-122.15129, 37.91276], [-122.15141, 37.91268], [-122.15173, 37.91256], [-122.15298, 37.91254], [-122.15334, 37.91257], [-122.15363, 37.91257], [-122.15418, 37.9127], [-122.15462, 37.91292], [-122.15559, 37.91319], [-122.15586, 37.91333], [-122.15636, 37.91343], [-122.15653, 37.91344], [-122.15685, 37.9134], [-122.15756, 37.9135], [-122.15813, 37.9136], [-122.15841, 37.91372], [-122.15882, 37.91396], [-122.15901, 37.91397], [-122.15914, 37.91394], [-122.1593, 37.91388], [-122.15958, 37.91383], [-122.15976, 37.91392], [-122.1601, 37.91419], [-122.16054, 37.91443]]]} | Restricted Access 2 | 315 | Russell Research Station (UC) | 24744 | 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 | Contra Costa 12 | 247.32 | Russell Research Station (UC) | None 17 | |||
2162 | 2162 | 2161 | {"type": "Polygon", "coordinates": [[[-122.1072, 38.49368], [-122.10672, 38.49336], [-122.10649, 38.49316], [-122.10637, 38.49012], [-122.10659, 38.49004], [-122.10674, 38.48989], [-122.10698, 38.4896], [-122.10718, 38.48928], [-122.1072, 38.49368]]]} | Restricted Access 2 | 17585 | Quail Ridge | 24047 | 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 | Napa 11 | 6.615 | Quail Ridge | 1991 | None 178 | ||
3528 | 3528 | 3527 | {"type": "Polygon", "coordinates": [[[-120.73191, 40.62673], [-120.72607, 40.62669], [-120.72666, 40.62644], [-120.72861, 40.62224], [-120.72666, 40.62227], [-120.72674, 40.61939], [-120.72188, 40.61937], [-120.72192, 40.61796], [-120.72202, 40.61567], [-120.72661, 40.61542], [-120.72693, 40.61539], [-120.72841, 40.61537], [-120.73165, 40.6202], [-120.7318, 40.62318], [-120.73191, 40.62673]]]} | Restricted Access 2 | 28071 | Eagle Lake Field Station | 18339 | 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 | Lassen 54 | 147.826 | Eagle Lake Field Station | None 293 | |||
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 | |
4350 | 4350 | 4349 | {"type": "MultiPolygon", "coordinates": [[[[-116.4033, 33.63437], [-116.40313, 33.6346], [-116.40304, 33.63478], [-116.40298, 33.63498], [-116.40295, 33.63518], [-116.40295, 33.63581], [-116.40292, 33.63608], [-116.40286, 33.63631], [-116.40277, 33.63657], [-116.40256, 33.63694], [-116.40226, 33.6373], [-116.40178, 33.63777], [-116.4014, 33.63824], [-116.40107, 33.63875], [-116.40058, 33.63974], [-116.40027, 33.64025], [-116.39983, 33.64081], [-116.39904, 33.64162], [-116.39092, 33.64162], [-116.39091, 33.67062], [-116.3821, 33.67067], [-116.37575, 33.67069], [-116.37657, 33.67462], [-116.37352, 33.67895], [-116.37352, 33.6778], [-116.36487, 33.67777], [-116.36488, 33.67069], [-116.35623, 33.67066], [-116.35622, 33.65615], [-116.33884, 33.65617], [-116.33884, 33.64166], [-116.35622, 33.64164], [-116.3562, 33.62714], [-116.33883, 33.62715], [-116.33882, 33.61264], [-116.3562, 33.61263], [-116.35621, 33.62714], [-116.37349, 33.62716], [-116.39092, 33.62711], [-116.40321, 33.62712], [-116.40314, 33.62853], [-116.40306, 33.62853], [-116.40304, 33.6288], [-116.40311, 33.62883], [-116.40304, 33.62909], [-116.40295, 33.62935], [-116.40284, 33.62959], [-116.40239, 33.63034], [-116.40232, 33.63049], [-116.40224, 33.63081], [-116.40222, 33.63098], [-116.40225, 33.63131], [-116.40236, 33.63163], [-116.4025, 33.63189], [-116.40269, 33.63213], [-116.40291, 33.63232], [-116.40327, 33.63257], [-116.40339, 33.63269], [-116.40349, 33.63281], [-116.40361, 33.63301], [-116.40368, 33.63323], [-116.40371, 33.63346], [-116.40369, 33.63369], [-116.40363, 33.63388], [-116.40355, 33.63406], [-116.40345, 33.6342], [-116.4033, 33.63437]]], [[[-116.46016, 33.61247], [-116.44282, 33.61252], [-116.44282, 33.61006], [-116.44269, 33.61005], [-116.44269, 33.60952], [-116.44294, 33.60951], [-116.44294, 33.60891], [-116.44282, 33.6089], [-116.44283, 33.6044], [-116.44501, 33.6044], [-116.44504, 33.60344], [-116.45248, 33.60347], [-116.45249, 33.59796], [-116.46006, 33.59793], [-116.46016, 33.61247]]]]} | Restricted Access 2 | 48461 | Boyd Deep Canyon Desert Research Center | 33174 | 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 | https://ucnrs.org/reserves/boyd-deep-canyon-desert-research-center/ | Riverside 10 | 6239.662 | Boyd Deep Canyon Desert Research Ctr. | None 384 | ||
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 | |
5751 | 5751 | 5750 | {"type": "MultiPolygon", "coordinates": [[[[-115.64839, 34.81949], [-115.63082, 34.81943], [-115.6308, 34.80941], [-115.62627, 34.80938], [-115.62642, 34.80577], [-115.64835, 34.80584], [-115.64839, 34.81949]]], [[[-115.66529, 34.77683], [-115.66528, 34.78407], [-115.6483, 34.78406], [-115.64827, 34.78408], [-115.6483, 34.79132], [-115.63077, 34.79127], [-115.63075, 34.79129], [-115.63077, 34.77678], [-115.66529, 34.77683]]], [[[-115.68285, 34.81958], [-115.66525, 34.81956], [-115.66531, 34.80578], [-115.68279, 34.80584], [-115.68285, 34.81958]]]]} | Restricted Access 2 | 3199 | Sweeney Granite Mountains Desert Research Center | 26101 | 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 Bernardino 22 | 2193.744 | Sweeney Granite Mtns. Desert Research Ctr. | None 463 | |||
6190 | 6190 | 6189 | {"type": "Polygon", "coordinates": [[[-119.70992, 34.46417], [-119.70991, 34.46472], [-119.70956, 34.46473], [-119.70965, 34.46495], [-119.70989, 34.46535], [-119.70981, 34.46588], [-119.7094, 34.46606], [-119.70917, 34.46612], [-119.70901, 34.46629], [-119.70864, 34.46641], [-119.70706, 34.4664], [-119.70705, 34.46633], [-119.70692, 34.46627], [-119.70661, 34.46602], [-119.70648, 34.46582], [-119.70629, 34.46566], [-119.70606, 34.46556], [-119.70574, 34.46546], [-119.70572, 34.46839], [-119.70153, 34.46838], [-119.7015, 34.47222], [-119.69721, 34.4722], [-119.69734, 34.46472], [-119.70858, 34.46473], [-119.70858, 34.46476], [-119.70865, 34.46494], [-119.70912, 34.46495], [-119.70925, 34.46472], [-119.70939, 34.46472], [-119.70941, 34.46447], [-119.70973, 34.4642], [-119.70992, 34.46417]]]} | Restricted Access 2 | 1555 | UC Reserve System land | 26639 | 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 | Santa Barbara 7 | 133.642 | UC Reserve System land | None 499 | |||
6257 | 6257 | 6256 | {"type": "Polygon", "coordinates": [[[-123.07837, 38.32311], [-123.07836, 38.32325], [-123.07834, 38.32329], [-123.07828, 38.32333], [-123.07823, 38.32327], [-123.07821, 38.32328], [-123.07823, 38.32335], [-123.07809, 38.32338], [-123.07798, 38.32331], [-123.07797, 38.32332], [-123.07798, 38.32336], [-123.07795, 38.32337], [-123.07786, 38.32333], [-123.07781, 38.32336], [-123.07771, 38.32325], [-123.07769, 38.32332], [-123.07764, 38.32332], [-123.0776, 38.32328], [-123.07758, 38.32319], [-123.07751, 38.32318], [-123.0774, 38.32309], [-123.07735, 38.32312], [-123.07735, 38.32317], [-123.07729, 38.32319], [-123.07714, 38.32316], [-123.07706, 38.32319], [-123.07702, 38.32309], [-123.07695, 38.32312], [-123.07686, 38.3231], [-123.07668, 38.32291], [-123.07659, 38.32292], [-123.07642, 38.32283], [-123.07633, 38.32289], [-123.07621, 38.3228], [-123.07614, 38.32268], [-123.07607, 38.32252], [-123.07597, 38.32247], [-123.0759, 38.32241], [-123.07577, 38.32232], [-123.07571, 38.32225], [-123.07485, 38.32245], [-123.07388, 38.323], [-123.06521, 38.31876], [-123.0652, 38.31877], [-123.06519, 38.3231], [-123.06515, 38.32332], [-123.06285, 38.3217], [-123.05888, 38.31954], [-123.05732, 38.31876], [-123.05637, 38.31841], [-123.05631, 38.31831], [-123.0564, 38.31813], [-123.05663, 38.31789], [-123.05696, 38.31739], [-123.05732, 38.31658], [-123.05751, 38.31584], [-123.05778, 38.31536], [-123.05812, 38.31492], [-123.05837, 38.31469], [-123.05885, 38.31437], [-123.05961, 38.31402], [-123.06022, 38.31377], [-123.06103, 38.31335], [-123.06125, 38.31317], [-123.0615, 38.31293], [-123.06169, 38.31255], [-123.06539, 38.31252], [-123.0679, 38.31144], [-123.06859, 38.31127], [-123.06891, 38.31163], [-123.06927, 38.31224], [-123.06952, 38.31261], [-123.0696, 38.31291], [-123.06962, 38.31312], [-123.06976, 38.31336], [-123.06971, 38.31355], [-123.06977, 38.31387], [-123.06988, 38.3141], [-123.07005, 38.3142], [-123.07024, 38.31428], [-123.07041, 38.31424], [-123.07046, 38.31434], [-123.07046, 38.31446], [-123.07043, 38.31452], [-123.07032, 38.31452], [-123.0701, 38.31447], [-123.06998, 38.31454], [-123.06998, 38.3147], [-123.0699, 38.31491], [-123.06943, 38.31527], [-123.06895, 38.31571], [-123.06866, 38.31582], [-123.06863, 38.31599], [-123.06877, 38.31623], [-123.06891, 38.3165], [-123.06949, 38.317], [-123.0697, 38.31714], [-123.07019, 38.31729], [-123.07047, 38.31734], [-123.07082, 38.31725], [-123.07114, 38.31689], [-123.07128, 38.31669], [-123.0715, 38.31657], [-123.07181, 38.31648], [-123.07206, 38.31656], [-123.07239, 38.31694], [-123.07239, 38.31706], [-123.0725, 38.31721], [-123.0725, 38.31733], [-123.07265, 38.31758], [-123.07283, 38.3177], [-123.07321, 38.31802], [-123.07329, 38.31821], [-123.07344, 38.31838], [-123.07359, 38.31866], [-123.07381, 38.3189], [-123.07395, 38.31895], [-123.07408, 38.3192], [-123.07457, 38.31972], [-123.07479, 38.31989], [-123.07489, 38.32], [-123.07521, 38.32017], [-123.07543, 38.32032], [-123.07647, 38.32069], [-123.07679, 38.32083], [-123.07732, 38.32109], [-123.07735, 38.32117], [-123.07731, 38.32124], [-123.07737, 38.32131], [-123.07745, 38.32155], [-123.07732, 38.32161], [-123.07741, 38.32168], [-123.07741, 38.32173], [-123.07749, 38.32171], [-123.07751, 38.32181], [-123.0775, 38.32187], [-123.0774, 38.32191], [-123.07736, 38.32193], [-123.07736, 38.32195], [-123.07739, 38.32197], [-123.07756, 38.322], [-123.07759, 38.32208], [-123.07755, 38.32223], [-123.07761, 38.32236], [-123.07777, 38.32242], [-123.07777, 38.32251], [-123.0777, 38.32259], [-123.07773, 38.32267], [-123.07787, 38.3227], [-123.07801, 38.32275], [-123.07808, 38.32284], [-123.07804, 38.32284], [-123.07803, 38.32286], [-123.07809, 38.32291], [-123.07817, 38.32291], [-123.07822, 38.32299], [-123.0782, 38.32304], [-123.07825, 38.3231], [-123.07832, 38.32307], [-123.07837, 38.32311]]]} | Restricted Access 2 | 1339 | Bodega Marine Reserve | 16219 | 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 | Sonoma 16 | 295.278 | Bodega Marine Reserve | 0 | State Conservation Area 8 | 2 | |
6367 | 6367 | 6366 | {"type": "MultiPolygon", "coordinates": [[[[-122.40288, 38.42006], [-122.39982, 38.42256], [-122.39819, 38.42129], [-122.40153, 38.41858], [-122.40288, 38.42006]]], [[[-122.4118, 38.42984], [-122.41092, 38.43057], [-122.41011, 38.43121], [-122.40947, 38.43071], [-122.40833, 38.42986], [-122.4072, 38.42896], [-122.40913, 38.42735], [-122.4118, 38.42984]]]]} | Restricted Access 2 | 1750 | UC Agricultural Research Station | 26634 | 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 | Napa 11 | 40.126 | UC Agricultural Research Station | None 517 | |||
6470 | 6470 | 6469 | {"type": "Polygon", "coordinates": [[[-122.06987, 36.9535], [-122.06981, 36.95358], [-122.06949, 36.9538], [-122.06941, 36.95398], [-122.06942, 36.95419], [-122.06937, 36.95429], [-122.06901, 36.95456], [-122.06885, 36.95465], [-122.06873, 36.95472], [-122.06864, 36.95469], [-122.06863, 36.95464], [-122.06886, 36.95406], [-122.06891, 36.95388], [-122.06883, 36.95375], [-122.06855, 36.95346], [-122.06841, 36.95338], [-122.06811, 36.95332], [-122.06804, 36.9533], [-122.06796, 36.95323], [-122.06787, 36.95299], [-122.06775, 36.95281], [-122.06759, 36.95271], [-122.06748, 36.95283], [-122.0673, 36.9535], [-122.06718, 36.95371], [-122.06691, 36.95396], [-122.06662, 36.95409], [-122.06652, 36.95425], [-122.06651, 36.95458], [-122.06646, 36.95465], [-122.06596, 36.95498], [-122.06572, 36.95531], [-122.06541, 36.95567], [-122.06527, 36.9558], [-122.06529, 36.95758], [-122.06435, 36.95765], [-122.06252, 36.95783], [-122.06252, 36.95702], [-122.06409, 36.95687], [-122.06393, 36.95661], [-122.06374, 36.95665], [-122.06365, 36.95663], [-122.06346, 36.95664], [-122.06323, 36.9566], [-122.06311, 36.95649], [-122.063, 36.95647], [-122.06279, 36.95648], [-122.06252, 36.9564], [-122.06252, 36.95528], [-122.06283, 36.95494], [-122.06305, 36.95465], [-122.06253, 36.95452], [-122.06255, 36.94931], [-122.06258, 36.9493], [-122.06257, 36.94913], [-122.06265, 36.94914], [-122.06284, 36.9491], [-122.06294, 36.94905], [-122.06297, 36.94899], [-122.06304, 36.94897], [-122.06311, 36.94898], [-122.06313, 36.94902], [-122.06319, 36.9491], [-122.06346, 36.94912], [-122.06352, 36.94905], [-122.06363, 36.94907], [-122.06369, 36.94913], [-122.06379, 36.94913], [-122.06386, 36.94901], [-122.06397, 36.94895], [-122.06405, 36.94886], [-122.06413, 36.94885], [-122.06417, 36.94886], [-122.06427, 36.94894], [-122.06438, 36.94918], [-122.06449, 36.94936], [-122.06451, 36.94945], [-122.06458, 36.94958], [-122.06463, 36.94959], [-122.06467, 36.94957], [-122.06473, 36.94967], [-122.06484, 36.9498], [-122.06485, 36.94984], [-122.06494, 36.9499], [-122.06502, 36.94993], [-122.06509, 36.94994], [-122.06527, 36.94991], [-122.06535, 36.94993], [-122.06539, 36.94995], [-122.0654, 36.94999], [-122.06542, 36.95011], [-122.06543, 36.95141], [-122.0643, 36.95145], [-122.06423, 36.95149], [-122.06419, 36.95157], [-122.06396, 36.95157], [-122.06383, 36.95151], [-122.06371, 36.9515], [-122.0636, 36.95158], [-122.06358, 36.95203], [-122.06371, 36.9521], [-122.06386, 36.95212], [-122.06403, 36.95223], [-122.06409, 36.95232], [-122.06414, 36.95248], [-122.0641, 36.95272], [-122.06406, 36.95279], [-122.06397, 36.95289], [-122.06379, 36.95299], [-122.06356, 36.95303], [-122.06343, 36.95316], [-122.06344, 36.95323], [-122.06341, 36.9534], [-122.06328, 36.95465], [-122.06329, 36.95469], [-122.06335, 36.95477], [-122.06348, 36.95486], [-122.06387, 36.95499], [-122.06439, 36.9552], [-122.06458, 36.95526], [-122.0647, 36.95528], [-122.06483, 36.95523], [-122.06483, 36.95522], [-122.06471, 36.95513], [-122.06466, 36.95499], [-122.0647, 36.95483], [-122.06476, 36.95477], [-122.06499, 36.9547], [-122.06515, 36.95472], [-122.06516, 36.95456], [-122.06519, 36.9545], [-122.06528, 36.95442], [-122.06534, 36.95441], [-122.06539, 36.95463], [-122.06548, 36.95464], [-122.06553, 36.95459], [-122.06564, 36.95458], [-122.06576, 36.9546], [-122.06599, 36.95469], [-122.06607, 36.95464], [-122.06612, 36.95458], [-122.06611, 36.95448], [-122.06589, 36.95435], [-122.06581, 36.95426], [-122.06579, 36.95411], [-122.06583, 36.954], [-122.0661, 36.95379], [-122.06624, 36.95376], [-122.06639, 36.95369], [-122.0665, 36.9536], [-122.06661, 36.95347], [-122.06663, 36.95328], [-122.0666, 36.95316], [-122.06665, 36.95305], [-122.06671, 36.95299], [-122.06669, 36.95278], [-122.06659, 36.95269], [-122.06619, 36.95268], [-122.06601, 36.95256], [-122.06587, 36.95234], [-122.06581, 36.95213], [-122.06577, 36.95205], [-122.0656, 36.95205], [-122.06559, 36.95199], [-122.06559, 36.95186], [-122.06556, 36.95181], [-122.0655, 36.95178], [-122.0655, 36.95052], [-122.06563, 36.95049], [-122.06624, 36.94994], [-122.06635, 36.94985], [-122.06654, 36.94976], [-122.06661, 36.94967], [-122.06662, 36.94961], [-122.06661, 36.94952], [-122.06649, 36.94938], [-122.0663, 36.94924], [-122.06616, 36.94904], [-122.06604, 36.94882], [-122.06589, 36.94877], [-122.06593, 36.94865], [-122.06599, 36.94859], [-122.06601, 36.94849], [-122.06584, 36.94835], [-122.0657, 36.94827], [-122.06557, 36.9483], [-122.06538, 36.94829], [-122.06547, 36.94823], [-122.06588, 36.94807], [-122.06593, 36.94806], [-122.066, 36.94808], [-122.06611, 36.94822], [-122.06617, 36.9484], [-122.06628, 36.94853], [-122.0663, 36.9486], [-122.06635, 36.9486], [-122.0664, 36.94864], [-122.0664, 36.94868], [-122.06645, 36.94873], [-122.06657, 36.94869], [-122.06662, 36.94873], [-122.0667, 36.94871], [-122.06683, 36.94873], [-122.06703, 36.94882], [-122.06728, 36.9489], [-122.06744, 36.94888], [-122.06746, 36.94882], [-122.06749, 36.94881], [-122.06748, 36.94873], [-122.0676, 36.94904], [-122.06791, 36.94952], [-122.06793, 36.9497], [-122.06792, 36.95008], [-122.06804, 36.95042], [-122.06804, 36.95054], [-122.06795, 36.95066], [-122.06777, 36.9507], [-122.0677, 36.95086], [-122.06779, 36.95095], [-122.06811, 36.95111], [-122.0681, 36.95118], [-122.06805, 36.95125], [-122.06788, 36.95128], [-122.06777, 36.95138], [-122.06771, 36.95153], [-122.06771, 36.95165], [-122.06803, 36.95196], [-122.06811, 36.95216], [-122.06816, 36.95233], [-122.0683, 36.95252], [-122.06871, 36.95279], [-122.06896, 36.953], [-122.06919, 36.95329], [-122.06937, 36.95338], [-122.06947, 36.95339], [-122.06979, 36.95341], [-122.06987, 36.9535]]]} | Restricted Access 2 | 2005 | Younger Lagoon Reserve | 27791 | 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 | Santa Cruz 5 | 69.92 | Younger Lagoon Reserve | 0 | State Conservation Area 8 | 2 | |
6642 | 6642 | 6641 | {"type": "MultiPolygon", "coordinates": [[[[-119.52824, 34.39721], [-119.52817, 34.39735], [-119.52732, 34.39804], [-119.52713, 34.39789], [-119.52812, 34.3971], [-119.52824, 34.39721]]], [[[-119.53867, 34.39858], [-119.53863, 34.40505], [-119.53816, 34.40492], [-119.53775, 34.40478], [-119.53696, 34.40448], [-119.5299, 34.40115], [-119.53026, 34.40061], [-119.52943, 34.40021], [-119.53009, 34.39857], [-119.53025, 34.3983], [-119.53107, 34.39724], [-119.53128, 34.39727], [-119.53248, 34.3973], [-119.53281, 34.39735], [-119.53323, 34.39755], [-119.5335, 34.39773], [-119.53403, 34.39803], [-119.53427, 34.39808], [-119.53464, 34.39818], [-119.53497, 34.39818], [-119.53521, 34.39816], [-119.53545, 34.39819], [-119.53573, 34.39815], [-119.5363, 34.39809], [-119.53663, 34.39814], [-119.53683, 34.39811], [-119.53691, 34.39788], [-119.53704, 34.39764], [-119.53709, 34.39747], [-119.53714, 34.39719], [-119.53711, 34.39711], [-119.53711, 34.39706], [-119.53666, 34.39621], [-119.53655, 34.39595], [-119.53674, 34.396], [-119.53724, 34.39633], [-119.53758, 34.39698], [-119.53758, 34.39805], [-119.53867, 34.39858]]]]} | Restricted Access 2 | 4645 | Carpinteria Salt Marsh Reserve - UC Natural Reserve | 16902 | 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 | Santa Barbara 7 | 120.56 | Carpinteria Salt Marsh Reserve - UC Natural Reserve | 0 | State Conservation Area 8 | 2 | |
6872 | 6872 | 6871 | {"type": "MultiPolygon", "coordinates": [[[[-117.24826, 33.80281], [-117.24825, 33.80455], [-117.24606, 33.80457], [-117.24603, 33.8029], [-117.24629, 33.80289], [-117.24664, 33.80296], [-117.2467, 33.80295], [-117.24675, 33.80291], [-117.24679, 33.80281], [-117.24826, 33.80281]]], [[[-117.26806, 33.81916], [-117.26585, 33.81919], [-117.26585, 33.81556], [-117.26579, 33.81188], [-117.26141, 33.81189], [-117.26146, 33.81559], [-117.25705, 33.81565], [-117.25704, 33.81374], [-117.25263, 33.81378], [-117.25261, 33.81197], [-117.24922, 33.81201], [-117.24922, 33.81118], [-117.24944, 33.81116], [-117.24944, 33.81101], [-117.24934, 33.811], [-117.24936, 33.80968], [-117.24914, 33.80927], [-117.24891, 33.80927], [-117.24891, 33.80833], [-117.24841, 33.80795], [-117.24847, 33.80788], [-117.24838, 33.80781], [-117.24813, 33.80745], [-117.24906, 33.8073], [-117.24907, 33.80729], [-117.2488, 33.80702], [-117.24874, 33.80676], [-117.24778, 33.80691], [-117.2474, 33.80529], [-117.24836, 33.80515], [-117.24825, 33.80463], [-117.24993, 33.80461], [-117.25255, 33.80464], [-117.25252, 33.80114], [-117.25412, 33.8011], [-117.25412, 33.79918], [-117.25422, 33.79917], [-117.25422, 33.79849], [-117.25412, 33.79848], [-117.25411, 33.79593], [-117.25253, 33.79592], [-117.25253, 33.79622], [-117.2504, 33.79625], [-117.25039, 33.79599], [-117.25053, 33.79578], [-117.25039, 33.79575], [-117.25038, 33.79556], [-117.24996, 33.79556], [-117.24931, 33.79527], [-117.24881, 33.79534], [-117.24862, 33.79556], [-117.24821, 33.79556], [-117.24808, 33.78924], [-117.25025, 33.78924], [-117.25029, 33.79101], [-117.25252, 33.79101], [-117.25253, 33.79438], [-117.26128, 33.79438], [-117.26134, 33.80817], [-117.26358, 33.80819], [-117.2636, 33.81004], [-117.26579, 33.81005], [-117.2658, 33.81188], [-117.26689, 33.81188], [-117.26694, 33.81554], [-117.26801, 33.81554], [-117.26806, 33.81916]], [[-117.25355, 33.79496], [-117.25355, 33.79482], [-117.25339, 33.79482], [-117.25339, 33.79496], [-117.25355, 33.79496]]]]} | Restricted Access 2 | 5523 | Motte Rimrock Reserve | 22519 | 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 | https://ucnrs.org/reserves/motte-rimrock-reserve/ | Riverside 10 | 639.088 | Motte Rimrock Reserve | 0 | State Conservation Area 8 | 2 |
7602 | 7602 | 7601 | {"type": "Polygon", "coordinates": [[[-117.09082, 32.89483], [-117.08881, 32.89783], [-117.0865, 32.89848], [-117.08509, 32.89881], [-117.08278, 32.89949], [-117.08164, 32.89815], [-117.07952, 32.89829], [-117.07915, 32.89934], [-117.08029, 32.90022], [-117.07721, 32.90112], [-117.07883, 32.90284], [-117.07721, 32.90339], [-117.07527, 32.90178], [-117.07426, 32.90045], [-117.07239, 32.89842], [-117.07523, 32.89837], [-117.07522, 32.89663], [-117.08409, 32.89651], [-117.08416, 32.89467], [-117.08629, 32.8947], [-117.08637, 32.89287], [-117.08828, 32.89286], [-117.0883, 32.89111], [-117.09079, 32.89112], [-117.09082, 32.89483]]]} | Restricted Access 2 | 48471 | Elliott Chaparral Reserve | 33182 | 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 | https://ucnrs.org/reserves/elliott-chaparral-reserve/ | San Diego 4 | 183.016 | Elliott Chaparral Reserve | 0 | State Conservation Area 8 | 2 |
7672 | 7672 | 7671 | {"type": "Polygon", "coordinates": [[[-119.88447, 34.41537], [-119.88109, 34.41543], [-119.8811, 34.41769], [-119.87698, 34.41751], [-119.87697, 34.41748], [-119.87253, 34.41749], [-119.87264, 34.41654], [-119.87287, 34.41634], [-119.87326, 34.41582], [-119.87337, 34.41572], [-119.87354, 34.41562], [-119.87402, 34.41543], [-119.87405, 34.41541], [-119.87415, 34.41528], [-119.87415, 34.4152], [-119.87413, 34.41511], [-119.87398, 34.41487], [-119.8737, 34.41453], [-119.8736, 34.41438], [-119.87358, 34.41429], [-119.87366, 34.41409], [-119.87406, 34.41367], [-119.87424, 34.41353], [-119.87484, 34.41345], [-119.87492, 34.41343], [-119.87511, 34.4133], [-119.87521, 34.41316], [-119.87535, 34.41284], [-119.87544, 34.41272], [-119.87573, 34.41241], [-119.87588, 34.41226], [-119.87597, 34.4122], [-119.8761, 34.41214], [-119.87647, 34.41204], [-119.87677, 34.41186], [-119.87692, 34.41168], [-119.87702, 34.41149], [-119.87731, 34.41112], [-119.87748, 34.41083], [-119.87809, 34.41023], [-119.87832, 34.40993], [-119.87843, 34.40976], [-119.8785, 34.40956], [-119.87848, 34.4095], [-119.87828, 34.40933], [-119.87753, 34.40893], [-119.87745, 34.40884], [-119.87746, 34.40873], [-119.87745, 34.40867], [-119.87755, 34.40847], [-119.8776, 34.40821], [-119.87773, 34.40793], [-119.87778, 34.40784], [-119.87783, 34.4078], [-119.87802, 34.40771], [-119.87823, 34.40767], [-119.87837, 34.40768], [-119.87892, 34.40783], [-119.87898, 34.40775], [-119.87895, 34.40755], [-119.87836, 34.40717], [-119.87818, 34.4072], [-119.87779, 34.40751], [-119.87745, 34.40752], [-119.87739, 34.40733], [-119.87753, 34.40714], [-119.87764, 34.40705], [-119.8778, 34.40697], [-119.87796, 34.40689], [-119.87807, 34.40685], [-119.87821, 34.40684], [-119.87839, 34.40687], [-119.87864, 34.40696], [-119.87905, 34.40717], [-119.88006, 34.40796], [-119.88044, 34.40829], [-119.88136, 34.40918], [-119.88176, 34.40962], [-119.88228, 34.41026], [-119.88332, 34.41179], [-119.88351, 34.41198], [-119.8837, 34.41226], [-119.88443, 34.41319], [-119.88447, 34.41537]]]} | Restricted Access 2 | 7582 | Coal Oil Point Natural Reserve | 33181 | 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://coaloilpoint.ucnrs.org/ | Santa Barbara 7 | 174.185 | Coal Oil Point Natural Reserve | 0 | State Conservation Area 8 | 2 |
7756 | 7756 | 7755 | {"type": "Polygon", "coordinates": [[[-117.04819, 33.46996], [-117.04601, 33.46999], [-117.04383, 33.47], [-117.04258, 33.47004], [-117.03519, 33.47001], [-117.03512, 33.46655], [-117.03512, 33.46296], [-117.04814, 33.46288], [-117.04819, 33.46996]], [[-117.04266, 33.46696], [-117.04265, 33.46697], [-117.04274, 33.46733], [-117.04314, 33.46728], [-117.04307, 33.46691], [-117.04266, 33.46696]]]} | Restricted Access 2 | 48472 | Emerson Oaks Reserve | 33183 | 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 | https://ucnrs.org/reserves/emerson-oaks-reserve/ | Riverside 10 | 234.781 | Emerson Oaks Reserve | 0 | State Conservation Area 8 | 2 |
7999 | 7999 | 7998 | {"type": "Polygon", "coordinates": [[[-117.85797, 33.6566], [-117.85687, 33.66016], [-117.85439, 33.66093], [-117.85304, 33.66254], [-117.85132, 33.66388], [-117.85077, 33.6635], [-117.85031, 33.66313], [-117.85005, 33.66289], [-117.84982, 33.66264], [-117.84939, 33.6621], [-117.84905, 33.66153], [-117.84883, 33.66102], [-117.84833, 33.65945], [-117.85104, 33.6568], [-117.84759, 33.65285], [-117.8483, 33.65243], [-117.84904, 33.65207], [-117.8495, 33.65186], [-117.85028, 33.65158], [-117.85094, 33.65138], [-117.85193, 33.65114], [-117.85261, 33.65103], [-117.85295, 33.65099], [-117.85572, 33.65361], [-117.85656, 33.65519], [-117.85797, 33.6566]]]} | Restricted Access 2 | 11237 | San Joaquin Marsh Reserve | 33193 | 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 | https://ucnrs.org/reserves/san-joaquin-marsh-reserve/ | Orange 3 | 198.279 | San Joaquin Marsh Reserve | 0 | State Conservation Area 8 | 2 |
8345 | 8345 | 8344 | {"type": "Polygon", "coordinates": [[[-123.76615, 39.28535], [-123.76613, 39.28619], [-123.76623, 39.28837], [-123.76622, 39.29088], [-123.76353, 39.28996], [-123.76354, 39.28536], [-123.76125, 39.28534], [-123.76132, 39.28339], [-123.76129, 39.28146], [-123.7637, 39.2815], [-123.76605, 39.28153], [-123.76615, 39.28535]]]} | Restricted Access 2 | 48474 | Hans Jenny Pygmy Forest Reserve | 33185 | 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 | https://ucnrs.org/reserves/hans-jenny-pygmy-forest-reserve/ | Mendocino 24 | 75.697 | Hans Jenny Pygmy Forest Reserve | 0 | State Conservation Area 8 | 2 |
8346 | 8346 | 8345 | {"type": "Polygon", "coordinates": [[[-117.23111, 32.79319], [-117.23107, 32.79326], [-117.23079, 32.7932], [-117.23029, 32.79353], [-117.2303, 32.79356], [-117.23015, 32.79366], [-117.23009, 32.79379], [-117.23005, 32.79383], [-117.23004, 32.79417], [-117.23009, 32.79439], [-117.2301, 32.79484], [-117.23047, 32.79495], [-117.23076, 32.79592], [-117.23007, 32.79609], [-117.2299, 32.79556], [-117.22808, 32.79595], [-117.22756, 32.79426], [-117.22918, 32.79378], [-117.2293, 32.79327], [-117.23017, 32.79269], [-117.23073, 32.79196], [-117.23111, 32.79319]]]} | Restricted Access 2 | 48475 | Kendall Frost Mission Bay Marsh Reserve | 33187 | 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 | https://ucnrs.org/reserves/kendall-frost-mission-bay-marsh-reserve/ | San Diego 4 | 16.556 | Kendall Frost Mission Bay Marsh Reserve | 0 | State Conservation Area 8 | 2 |
8348 | 8348 | 8347 | {"type": "MultiPolygon", "coordinates": [[[[-122.41094, 38.85388], [-122.4109, 38.86064], [-122.41064, 38.86043], [-122.41045, 38.86031], [-122.40971, 38.85998], [-122.40952, 38.85988], [-122.40712, 38.85804], [-122.40687, 38.85789], [-122.40358, 38.85648], [-122.40329, 38.85638], [-122.40383, 38.85581], [-122.40383, 38.8558], [-122.40339, 38.85564], [-122.40303, 38.85564], [-122.40277, 38.85567], [-122.40247, 38.85568], [-122.402, 38.85586], [-122.40174, 38.85591], [-122.4014, 38.85577], [-122.40121, 38.85547], [-122.40099, 38.85506], [-122.40086, 38.85472], [-122.40053, 38.85448], [-122.40009, 38.85431], [-122.39986, 38.85425], [-122.39967, 38.85404], [-122.39955, 38.85379], [-122.41094, 38.85388]]], [[[-122.41361, 38.86493], [-122.4059, 38.8649], [-122.40599, 38.86091], [-122.40127, 38.86083], [-122.40125, 38.86271], [-122.39731, 38.86263], [-122.4032, 38.85648], [-122.40351, 38.85657], [-122.40679, 38.85797], [-122.40702, 38.85812], [-122.40943, 38.85996], [-122.40964, 38.86008], [-122.41038, 38.86041], [-122.41067, 38.8606], [-122.4109, 38.86083], [-122.4109, 38.86098], [-122.411, 38.86098], [-122.41104, 38.86105], [-122.41215, 38.86347], [-122.41234, 38.86382], [-122.4126, 38.86414], [-122.4128, 38.86433], [-122.41303, 38.86451], [-122.41361, 38.86493]]], [[[-122.42422, 38.87573], [-122.42408, 38.87585], [-122.41522, 38.87548], [-122.41522, 38.87045], [-122.4174, 38.87051], [-122.41776, 38.87075], [-122.41802, 38.87089], [-122.42, 38.87169], [-122.42023, 38.87181], [-122.42044, 38.87195], [-122.42062, 38.87211], [-122.42078, 38.87229], [-122.42091, 38.87248], [-122.421, 38.87268], [-122.4216, 38.87421], [-122.42178, 38.87453], [-122.42203, 38.87482], [-122.42235, 38.87507], [-122.42259, 38.87521], [-122.42284, 38.87532], [-122.42311, 38.87541], [-122.42422, 38.87573]]], [[[-122.44673, 38.8798], [-122.44346, 38.87981], [-122.44345, 38.87995], [-122.44277, 38.87981], [-122.43966, 38.8804], [-122.43894, 38.88033], [-122.43696, 38.87922], [-122.43486, 38.87902], [-122.43409, 38.87868], [-122.43283, 38.8773], [-122.43267, 38.87716], [-122.43248, 38.87704], [-122.43216, 38.8769], [-122.43193, 38.87684], [-122.4317, 38.8768], [-122.43146, 38.87678], [-122.43125, 38.87679], [-122.43105, 38.87682], [-122.42927, 38.87726], [-122.42901, 38.87732], [-122.4288, 38.87734], [-122.42857, 38.87735], [-122.42823, 38.87731], [-122.42801, 38.87725], [-122.42771, 38.87711], [-122.4265, 38.87633], [-122.42616, 38.87617], [-122.42316, 38.87531], [-122.42289, 38.87522], [-122.42264, 38.8751], [-122.42241, 38.87497], [-122.42222, 38.87482], [-122.42204, 38.87465], [-122.42183, 38.87437], [-122.42173, 38.87417], [-122.42109, 38.87254], [-122.42092, 38.87226], [-122.42069, 38.872], [-122.4204, 38.87177], [-122.42007, 38.87159], [-122.41823, 38.87085], [-122.41796, 38.87073], [-122.41771, 38.87058], [-122.41748, 38.87042], [-122.41727, 38.87024], [-122.4171, 38.87004], [-122.41688, 38.86972], [-122.41623, 38.86846], [-122.41606, 38.86816], [-122.41431, 38.86544], [-122.4141, 38.86519], [-122.41381, 38.86493], [-122.41291, 38.86426], [-122.41262, 38.86397], [-122.41247, 38.86376], [-122.41228, 38.86343], [-122.41116, 38.86099], [-122.41549, 38.86112], [-122.41551, 38.85757], [-122.42008, 38.85771], [-122.42945, 38.85792], [-122.42944, 38.87069], [-122.43174, 38.87069], [-122.4321, 38.87105], [-122.43243, 38.87134], [-122.43274, 38.87195], [-122.43308, 38.87236], [-122.4334, 38.87257], [-122.43375, 38.87276], [-122.43413, 38.87264], [-122.43498, 38.87277], [-122.4339, 38.87337], [-122.4331, 38.87389], [-122.4331, 38.87391], [-122.43337, 38.87416], [-122.43348, 38.87422], [-122.4335, 38.8744], [-122.43748, 38.87427], [-122.43935, 38.87519], [-122.44673, 38.8798]]]]} | Restricted Access 2 | 48476 | McLaughlin Natural Reserve | 33195 | 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 | https://ucnrs.org/reserves/mclaughlin-natural-reserve/ | Lake 40 | 1035.449 | McLaughlin Natural Reserve | 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]);