units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where ACCESS_TYP = 4 and MNG_AG_TYP = 10 sorted by map
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, LABEL_NAME, YR_EST, GAP_STS
MNG_AGENCY 16
- Save the Redwoods League 10
- San Joaquin River Parkway and Conservation Trust 8
- Wilderness Land Trust 4
- Sierra Foothill Conservancy 3
- Northcoast Regional Land Trust 3
- Back Country Land Trust 2
- Center for Natural Lands Management 1
- The Wildlands Conservancy 1
- The Habitat Trust 1
- Mendocino Land Trust 1
- American River Conservancy 1
- Mojave Desert Land Trust 1
- Native American Land Conservancy 1
- Rivers and Lands Conservancy 1
- Sacramento Valley Conservancy 1
- Jacoby Creek Land Trust 1
DES_TP 6
- Private Conservation 26
- Private Other or Unknown 10
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- Non Profit - Land Trust · 40 ✖
ACCESS_TYP 1
- Unknown Access · 40 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3735 | 3735 | 3734 | {"type": "MultiPolygon", "coordinates": [[[[-115.10406, 34.54508], [-115.08803, 34.54518], [-115.08805, 34.53083], [-115.08787, 34.53082], [-115.08786, 34.53069], [-115.08667, 34.53068], [-115.08667, 34.53042], [-115.10406, 34.53045], [-115.10406, 34.54508]]], [[[-115.12163, 34.51577], [-115.12163, 34.52303], [-115.12161, 34.53026], [-115.11284, 34.5303], [-115.10424, 34.53032], [-115.10424, 34.51581], [-115.12163, 34.51577]]], [[[-115.12164, 34.48689], [-115.12161, 34.50126], [-115.10425, 34.5013], [-115.10427, 34.48694], [-115.12164, 34.48689]]], [[[-115.12292, 34.54519], [-115.12277, 34.55666], [-115.10969, 34.55712], [-115.10968, 34.55726], [-115.10553, 34.55726], [-115.10557, 34.5452], [-115.12292, 34.54519]]]]} | Unknown Access 4 | 31017 | Native American Land Conservancy | 22662 | 3125 | Native American Land Conservancy 674 | Non Profit 6 | Non Profit - Land Trust 10 | http://nalc4all.org/ | Non Governmental Organization 10 | 3125 | Native American Land Conservancy 664 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 2369.21 | Native American Land Conservancy | 0 | Private Conservation 16 | 2 | |
14641 | 14641 | 14640 | {"type": "MultiPolygon", "coordinates": [[[[-116.56634, 32.63655], [-116.56633, 32.63969], [-116.56352, 32.63968], [-116.56358, 32.64082], [-116.56185, 32.64104], [-116.56185, 32.64021], [-116.55769, 32.64018], [-116.55772, 32.63652], [-116.56634, 32.63655]]], [[[-116.6012, 32.62905], [-116.59837, 32.62903], [-116.59317, 32.62899], [-116.59319, 32.62897], [-116.59318, 32.62895], [-116.59344, 32.62873], [-116.59351, 32.62863], [-116.59356, 32.62851], [-116.59366, 32.628], [-116.59372, 32.62789], [-116.59379, 32.6278], [-116.59502, 32.62687], [-116.59524, 32.62673], [-116.59556, 32.62659], [-116.59593, 32.62649], [-116.59665, 32.62643], [-116.59792, 32.62625], [-116.59822, 32.62623], [-116.60025, 32.62627], [-116.60052, 32.6263], [-116.60079, 32.62638], [-116.60093, 32.62639], [-116.6012, 32.62905]]]]} | Unknown Access 4 | 44886 | Long Potrero | 21450 | 3007 | Back Country Land Trust 152 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bclt.org/ | Non Governmental Organization 10 | 3007 | Back Country Land Trust 148 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 128.12 | Long Potrero | 0 | Private Conservation 16 | 2 | |
4278 | 4278 | 4277 | {"type": "MultiPolygon", "coordinates": [[[[-116.584, 32.62899], [-116.58381, 32.62893], [-116.58043, 32.62894], [-116.58043, 32.62888], [-116.58398, 32.62886], [-116.584, 32.62899]]], [[[-116.60233, 32.63994], [-116.59384, 32.63985], [-116.59345, 32.63629], [-116.58904, 32.6363], [-116.58933, 32.63975], [-116.585, 32.63974], [-116.58464, 32.63618], [-116.58059, 32.63617], [-116.58043, 32.6291], [-116.58377, 32.62909], [-116.58401, 32.62918], [-116.58433, 32.63245], [-116.58868, 32.6325], [-116.58869, 32.63248], [-116.58834, 32.62897], [-116.59286, 32.62901], [-116.59317, 32.62899], [-116.60121, 32.62905], [-116.6016, 32.63273], [-116.60233, 32.63994]]]]} | Unknown Access 4 | 45247 | San Diego Mountain Ranch | 24856 | 3007 | Back Country Land Trust 152 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bclt.org/ | Non Governmental Organization 10 | 3007 | Back Country Land Trust 148 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 471.918 | San Diego Mtn. Ranch | 0 | Private Conservation 16 | 2 | |
5692 | 5692 | 5691 | {"type": "MultiPolygon", "coordinates": [[[[-122.5494, 38.53711], [-122.54933, 38.53827], [-122.54861, 38.53827], [-122.54859, 38.53851], [-122.54148, 38.53854], [-122.54152, 38.53795], [-122.5415, 38.53598], [-122.54414, 38.53611], [-122.54439, 38.53632], [-122.5455, 38.53638], [-122.54663, 38.53714], [-122.5494, 38.53711]]], [[[-122.5552, 38.53847], [-122.55433, 38.53848], [-122.55446, 38.53722], [-122.55391, 38.5372], [-122.55388, 38.53772], [-122.5521, 38.5377], [-122.55166, 38.53732], [-122.55183, 38.53662], [-122.55238, 38.53655], [-122.55327, 38.5359], [-122.5533, 38.53502], [-122.55517, 38.53502], [-122.5552, 38.53847]]]]} | Unknown Access 4 | 48630 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Napa 11 | 54.128 | 0 | Private Other or Unknown 399 | 4 | |
3997 | 3997 | 3996 | {"type": "MultiPolygon", "coordinates": [[[[-123.41974, 39.40958], [-123.41971, 39.41004], [-123.41961, 39.41068], [-123.41961, 39.41086], [-123.42009, 39.41226], [-123.42016, 39.41249], [-123.42017, 39.41254], [-123.42014, 39.4126], [-123.41996, 39.41277], [-123.4196, 39.41306], [-123.41918, 39.41332], [-123.41917, 39.41315], [-123.41925, 39.4096], [-123.41974, 39.40958]]], [[[-123.42502, 39.41343], [-123.42496, 39.41356], [-123.42481, 39.41372], [-123.42462, 39.41382], [-123.42433, 39.41389], [-123.42395, 39.41386], [-123.42383, 39.41386], [-123.42403, 39.4137], [-123.42421, 39.41349], [-123.42432, 39.41333], [-123.42439, 39.41302], [-123.42436, 39.41285], [-123.42428, 39.41259], [-123.42419, 39.41243], [-123.42394, 39.41213], [-123.42333, 39.41113], [-123.42309, 39.41079], [-123.42302, 39.41058], [-123.42303, 39.41046], [-123.42441, 39.41035], [-123.42458, 39.41098], [-123.42457, 39.41109], [-123.42437, 39.41154], [-123.42416, 39.4119], [-123.42414, 39.41215], [-123.42424, 39.41241], [-123.42491, 39.41307], [-123.42498, 39.4132], [-123.42502, 39.41343]]], [[[-123.43275, 39.41761], [-123.43185, 39.41718], [-123.4317, 39.41708], [-123.43161, 39.417], [-123.43156, 39.41691], [-123.43152, 39.41669], [-123.43156, 39.4165], [-123.43166, 39.41629], [-123.43185, 39.41572], [-123.43275, 39.41761]]], [[[-123.43767, 39.41665], [-123.4376, 39.41888], [-123.43737, 39.4187], [-123.43708, 39.41859], [-123.43676, 39.41855], [-123.43611, 39.41858], [-123.43713, 39.41725], [-123.43569, 39.41667], [-123.43767, 39.41665]]], [[[-123.4374, 39.41943], [-123.43731, 39.41961], [-123.43722, 39.41967], [-123.43713, 39.41971], [-123.43699, 39.41973], [-123.43681, 39.41974], [-123.43662, 39.41973], [-123.43644, 39.41968], [-123.43561, 39.4194], [-123.43621, 39.41889], [-123.43625, 39.41882], [-123.43675, 39.4188], [-123.43699, 39.41883], [-123.43719, 39.4189], [-123.43735, 39.41903], [-123.43741, 39.41916], [-123.43742, 39.41931], [-123.4374, 39.41943]]], [[[-123.42407, 39.41301], [-123.42402, 39.41324], [-123.42394, 39.41335], [-123.42377, 39.41355], [-123.42346, 39.4138], [-123.42334, 39.41383], [-123.42313, 39.41383], [-123.4221, 39.41366], [-123.42194, 39.41366], [-123.4217, 39.41371], [-123.42151, 39.41377], [-123.42093, 39.41413], [-123.42061, 39.41437], [-123.42029, 39.41464], [-123.41998, 39.41497], [-123.4199, 39.4151], [-123.41982, 39.41528], [-123.4198, 39.41543], [-123.41979, 39.41567], [-123.41985, 39.4159], [-123.41999, 39.41623], [-123.42027, 39.41661], [-123.42042, 39.41675], [-123.42067, 39.41691], [-123.42136, 39.41727], [-123.42171, 39.4176], [-123.42197, 39.41791], [-123.42202, 39.41799], [-123.42208, 39.41817], [-123.42216, 39.41854], [-123.42218, 39.41881], [-123.42217, 39.41906], [-123.4221, 39.41962], [-123.42211, 39.41974], [-123.42222, 39.41992], [-123.42236, 39.42006], [-123.42257, 39.42017], [-123.42284, 39.42029], [-123.42292, 39.42033], [-123.42316, 39.4206], [-123.42325, 39.42073], [-123.4233, 39.42085], [-123.4233, 39.42097], [-123.42325, 39.4211], [-123.42318, 39.42122], [-123.42307, 39.4213], [-123.4228, 39.4214], [-123.42232, 39.42147], [-123.42213, 39.42144], [-123.42196, 39.42137], [-123.42179, 39.42127], [-123.42165, 39.42117], [-123.42144, 39.42094], [-123.42121, 39.42063], [-123.42112, 39.42036], [-123.42112, 39.42029], [-123.42115, 39.42021], [-123.42139, 39.41992], [-123.42156, 39.41961], [-123.42165, 39.41939], [-123.42175, 39.41902], [-123.42176, 39.41873], [-123.42171, 39.41857], [-123.42165, 39.41847], [-123.42151, 39.4183], [-123.42127, 39.41808], [-123.421, 39.41793], [-123.42066, 39.41779], [-123.42046, 39.41777], [-123.4203, 39.41772], [-123.42004, 39.41755], [-123.41983, 39.41747], [-123.41937, 39.41735], [-123.41922, 39.41727], [-123.41916, 39.41366], [-123.41981, 39.41325], [-123.4202, 39.41294], [-123.42042, 39.41272], [-123.42048, 39.41257], [-123.42048, 39.41246], [-123.4204, 39.41219], [-123.41992, 39.41083], [-123.41992, 39.4107], [-123.42003, 39.41006], [-123.42006, 39.40957], [-123.42352, 39.40953], [-123.42334, 39.40956], [-123.42315, 39.40963], [-123.42309, 39.40967], [-123.42299, 39.40979], [-123.42284, 39.41001], [-123.42272, 39.41025], [-123.4227, 39.41061], [-123.42276, 39.41082], [-123.4228, 39.4109], [-123.42304, 39.41124], [-123.42366, 39.41224], [-123.4239, 39.41254], [-123.42398, 39.41268], [-123.42405, 39.4129], [-123.42407, 39.41301]]], [[[-123.43757, 39.41975], [-123.43757, 39.42032], [-123.43489, 39.42036], [-123.43503, 39.42411], [-123.43485, 39.42411], [-123.43471, 39.42373], [-123.43442, 39.42344], [-123.43367, 39.42296], [-123.43348, 39.42286], [-123.43334, 39.42273], [-123.43326, 39.42255], [-123.43332, 39.42222], [-123.43352, 39.42143], [-123.43361, 39.42092], [-123.43336, 39.42048], [-123.43275, 39.42019], [-123.43127, 39.41938], [-123.43106, 39.41917], [-123.431, 39.41904], [-123.43101, 39.41891], [-123.43103, 39.41878], [-123.43111, 39.41861], [-123.43119, 39.41853], [-123.43135, 39.41848], [-123.43163, 39.41847], [-123.43188, 39.41849], [-123.43213, 39.41853], [-123.43241, 39.41861], [-123.43331, 39.41891], [-123.43372, 39.41985], [-123.43534, 39.41981], [-123.43546, 39.41962], [-123.43632, 39.41991], [-123.43655, 39.41997], [-123.43681, 39.41999], [-123.43703, 39.41998], [-123.43724, 39.41994], [-123.43741, 39.41987], [-123.43757, 39.41975]]], [[[-123.43436, 39.42412], [-123.4328, 39.42416], [-123.4329, 39.42602], [-123.4261, 39.42607], [-123.426, 39.42423], [-123.42371, 39.42426], [-123.42362, 39.42242], [-123.4192, 39.42247], [-123.41909, 39.42059], [-123.41925, 39.42057], [-123.41921, 39.41757], [-123.41972, 39.4177], [-123.41989, 39.41777], [-123.42015, 39.41794], [-123.42037, 39.418], [-123.42056, 39.41803], [-123.42084, 39.41814], [-123.42104, 39.41825], [-123.42125, 39.41845], [-123.42137, 39.41859], [-123.42144, 39.41874], [-123.42143, 39.41899], [-123.42134, 39.41934], [-123.42127, 39.41951], [-123.4211, 39.4198], [-123.42085, 39.42012], [-123.4208, 39.42028], [-123.42081, 39.4204], [-123.42091, 39.42073], [-123.42117, 39.42108], [-123.42142, 39.42134], [-123.42178, 39.42157], [-123.42203, 39.42168], [-123.42232, 39.42171], [-123.42287, 39.42164], [-123.42307, 39.42158], [-123.42325, 39.42151], [-123.42342, 39.42137], [-123.42354, 39.4212], [-123.42362, 39.421], [-123.42361, 39.4208], [-123.42355, 39.42065], [-123.42343, 39.42047], [-123.42326, 39.42027], [-123.42315, 39.42016], [-123.42303, 39.42008], [-123.42274, 39.41997], [-123.42258, 39.41988], [-123.42249, 39.41979], [-123.42242, 39.41967], [-123.42249, 39.41907], [-123.4225, 39.4188], [-123.42247, 39.41852], [-123.42239, 39.41812], [-123.42232, 39.41791], [-123.42226, 39.41779], [-123.42197, 39.41745], [-123.42158, 39.41709], [-123.42085, 39.4167], [-123.42063, 39.41657], [-123.42054, 39.41648], [-123.42028, 39.41613], [-123.42016, 39.41584], [-123.42011, 39.41565], [-123.42011, 39.41545], [-123.42014, 39.41533], [-123.42019, 39.4152], [-123.42026, 39.4151], [-123.42054, 39.41478], [-123.42084, 39.41454], [-123.42119, 39.41429], [-123.42168, 39.41398], [-123.422, 39.41391], [-123.42208, 39.41391], [-123.42304, 39.41407], [-123.42266, 39.41423], [-123.42198, 39.4144], [-123.4218, 39.41449], [-123.42155, 39.41489], [-123.42151, 39.41504], [-123.4215, 39.41522], [-123.42154, 39.41535], [-123.42163, 39.41548], [-123.42169, 39.41551], [-123.422, 39.41562], [-123.42237, 39.41573], [-123.42269, 39.41576], [-123.42279, 39.41579], [-123.42316, 39.41601], [-123.42374, 39.41653], [-123.42381, 39.41687], [-123.42399, 39.41722], [-123.42426, 39.41756], [-123.42479, 39.41816], [-123.42492, 39.41827], [-123.42506, 39.41836], [-123.42576, 39.41864], [-123.42595, 39.41876], [-123.42609, 39.41892], [-123.42624, 39.41916], [-123.42636, 39.41947], [-123.42646, 39.4196], [-123.42672, 39.41973], [-123.42717, 39.41987], [-123.42731, 39.41994], [-123.42742, 39.42], [-123.42762, 39.42017], [-123.42765, 39.42023], [-123.42767, 39.4203], [-123.42766, 39.42047], [-123.42757, 39.42077], [-123.42746, 39.42091], [-123.42734, 39.421], [-123.427, 39.4212], [-123.42684, 39.42131], [-123.4267, 39.42147], [-123.4266, 39.42169], [-123.42661, 39.42188], [-123.42672, 39.42211], [-123.42674, 39.42222], [-123.42674, 39.4225], [-123.42677, 39.42271], [-123.42686, 39.4229], [-123.42776, 39.42376], [-123.42852, 39.42437], [-123.42877, 39.42449], [-123.42909, 39.42454], [-123.42944, 39.42454], [-123.42971, 39.42447], [-123.42992, 39.42435], [-123.42997, 39.42431], [-123.43008, 39.42416], [-123.43015, 39.42384], [-123.43013, 39.42366], [-123.43007, 39.4235], [-123.42995, 39.42332], [-123.42973, 39.42318], [-123.42952, 39.42309], [-123.42933, 39.42307], [-123.42869, 39.42305], [-123.42844, 39.423], [-123.42823, 39.42289], [-123.42787, 39.42253], [-123.4278, 39.42242], [-123.42776, 39.42232], [-123.42768, 39.42188], [-123.42771, 39.42179], [-123.42794, 39.42155], [-123.42872, 39.42107], [-123.42871, 39.42078], [-123.42854, 39.42087], [-123.42796, 39.42121], [-123.42771, 39.42137], [-123.42757, 39.42151], [-123.42743, 39.42167], [-123.42738, 39.42178], [-123.42736, 39.42188], [-123.4274, 39.42211], [-123.42745, 39.42236], [-123.42751, 39.42252], [-123.42761, 39.42267], [-123.42802, 39.42308], [-123.42831, 39.42322], [-123.42864, 39.4233], [-123.42942, 39.42333], [-123.42955, 39.42338], [-123.4297, 39.42349], [-123.42978, 39.42359], [-123.42981, 39.4237], [-123.42983, 39.42383], [-123.42977, 39.42409], [-123.42971, 39.42416], [-123.42956, 39.42425], [-123.42936, 39.4243], [-123.42912, 39.4243], [-123.42891, 39.42426], [-123.42872, 39.42418], [-123.428, 39.4236], [-123.42714, 39.42277], [-123.42708, 39.42266], [-123.42705, 39.42249], [-123.42706, 39.4222], [-123.42703, 39.42205], [-123.42693, 39.42183], [-123.42692, 39.42173], [-123.42699, 39.42158], [-123.42708, 39.42147], [-123.42755, 39.42119], [-123.4277, 39.42108], [-123.42787, 39.42086], [-123.42796, 39.42056], [-123.42799, 39.42026], [-123.42796, 39.42015], [-123.42789, 39.42004], [-123.42765, 39.41983], [-123.42749, 39.41973], [-123.42731, 39.41965], [-123.42686, 39.41951], [-123.4267, 39.41943], [-123.42665, 39.41937], [-123.42653, 39.41905], [-123.42636, 39.4188], [-123.42619, 39.4186], [-123.42593, 39.41843], [-123.42523, 39.41815], [-123.42514, 39.41809], [-123.42504, 39.41801], [-123.42453, 39.41743], [-123.42428, 39.41711], [-123.42412, 39.4168], [-123.42406, 39.41651], [-123.42401, 39.41639], [-123.42384, 39.41623], [-123.42337, 39.41583], [-123.42293, 39.41557], [-123.42277, 39.41552], [-123.42246, 39.41549], [-123.42213, 39.4154], [-123.42187, 39.4153], [-123.42184, 39.41526], [-123.42182, 39.41518], [-123.42185, 39.41498], [-123.42206, 39.41465], [-123.42211, 39.41462], [-123.42279, 39.41445], [-123.42325, 39.41426], [-123.42361, 39.41414], [-123.42384, 39.41411], [-123.42398, 39.41411], [-123.42437, 39.41414], [-123.42476, 39.41405], [-123.42505, 39.41388], [-123.42523, 39.41369], [-123.42534, 39.41348], [-123.42534, 39.41342], [-123.42529, 39.41315], [-123.4252, 39.41295], [-123.42452, 39.41229], [-123.42446, 39.41211], [-123.42447, 39.41197], [-123.42466, 39.41163], [-123.42489, 39.41112], [-123.42489, 39.41094], [-123.42466, 39.41009], [-123.42456, 39.40988], [-123.42444, 39.40972], [-123.42422, 39.4096], [-123.42402, 39.40953], [-123.42849, 39.40945], [-123.42849, 39.41175], [-123.42832, 39.41185], [-123.42811, 39.41201], [-123.42793, 39.41231], [-123.42782, 39.41259], [-123.4276, 39.41354], [-123.42751, 39.4141], [-123.42746, 39.41427], [-123.42739, 39.41443], [-123.42725, 39.41467], [-123.42703, 39.41495], [-123.42685, 39.41512], [-123.42667, 39.41535], [-123.4266, 39.41557], [-123.42658, 39.41577], [-123.4266, 39.416], [-123.42665, 39.41621], [-123.42698, 39.41738], [-123.42754, 39.41919], [-123.42765, 39.41933], [-123.42786, 39.4195], [-123.4281, 39.41965], [-123.42872, 39.41993], [-123.42883, 39.42002], [-123.42893, 39.42019], [-123.42897, 39.42046], [-123.42929, 39.42045], [-123.42929, 39.42038], [-123.42924, 39.42012], [-123.42916, 39.41997], [-123.42908, 39.41987], [-123.42891, 39.41973], [-123.42829, 39.41945], [-123.42808, 39.41931], [-123.42789, 39.41917], [-123.42784, 39.41911], [-123.42729, 39.41732], [-123.42696, 39.41617], [-123.4269, 39.41578], [-123.42692, 39.41561], [-123.42696, 39.41545], [-123.42711, 39.41526], [-123.42729, 39.41509], [-123.42753, 39.41479], [-123.42768, 39.41453], [-123.42777, 39.41434], [-123.42782, 39.41414], [-123.42791, 39.41358], [-123.42813, 39.41264], [-123.42823, 39.4124], [-123.42837, 39.41216], [-123.42853, 39.41203], [-123.42873, 39.41192], [-123.42896, 39.41183], [-123.42917, 39.4118], [-123.42942, 39.41179], [-123.42959, 39.41182], [-123.43038, 39.41234], [-123.43081, 39.41328], [-123.43085, 39.41367], [-123.4309, 39.41381], [-123.43112, 39.4141], [-123.4317, 39.41518], [-123.43135, 39.41623], [-123.43125, 39.41645], [-123.4312, 39.41668], [-123.43122, 39.41684], [-123.43126, 39.417], [-123.43135, 39.41714], [-123.43148, 39.41726], [-123.43166, 39.41738], [-123.43291, 39.41798], [-123.43317, 39.41859], [-123.43253, 39.41838], [-123.43221, 39.41829], [-123.43193, 39.41824], [-123.43165, 39.41822], [-123.43127, 39.41824], [-123.43101, 39.41833], [-123.43082, 39.4185], [-123.43072, 39.41874], [-123.43069, 39.4189], [-123.43069, 39.41909], [-123.43078, 39.4193], [-123.43105, 39.41956], [-123.43277, 39.4205], [-123.43316, 39.42107], [-123.43289, 39.42177], [-123.43277, 39.42231], [-123.4327, 39.42272], [-123.4328, 39.42299], [-123.43303, 39.42316], [-123.43397, 39.42365], [-123.4343, 39.42394], [-123.43436, 39.42412]]]]} | Unknown Access 4 | 46795 | Noyo River Redwoods Property | 30250 | 3128 | Mendocino Land Trust 500 | Non Profit 6 | Non Profit - Land Trust 10 | http://mendocinolandtrust.org/ | Non Governmental Organization 10 | 3128 | Mendocino Land Trust 492 | Non Profit 6 | Non Profit - Land Trust 10 | Mendocino 24 | 416.183 | Noyo River Redwoods Property | 0 | Private Conservation 16 | 2 | |
4809 | 4809 | 4808 | {"type": "MultiPolygon", "coordinates": [[[[-123.77085, 40.18643], [-123.77076, 40.18671], [-123.76986, 40.18652], [-123.77005, 40.18631], [-123.77085, 40.18643]]], [[[-123.99131, 40.44672], [-123.99065, 40.44671], [-123.99064, 40.44675], [-123.9901, 40.44673], [-123.9901, 40.44654], [-123.99131, 40.44654], [-123.99131, 40.44672]]], [[[-124.08532, 41.27009], [-124.08526, 41.27384], [-124.08271, 41.27382], [-124.08208, 41.27252], [-124.0817, 41.27221], [-124.08163, 41.27204], [-124.08201, 41.27202], [-124.08195, 41.27003], [-124.08318, 41.27001], [-124.08532, 41.27009]]], [[[-124.15032, 40.69913], [-124.14997, 40.69952], [-124.14997, 40.70003], [-124.14924, 40.69999], [-124.14952, 40.69933], [-124.14954, 40.69895], [-124.14945, 40.6986], [-124.14928, 40.69831], [-124.14911, 40.69816], [-124.14881, 40.69805], [-124.14854, 40.69803], [-124.14835, 40.69813], [-124.14831, 40.69825], [-124.14838, 40.69837], [-124.14872, 40.69865], [-124.14878, 40.6988], [-124.14872, 40.69891], [-124.14794, 40.6995], [-124.14724, 40.6999], [-124.14689, 40.69987], [-124.14654, 40.69979], [-124.14621, 40.69967], [-124.14599, 40.69956], [-124.14546, 40.69987], [-124.14507, 40.6996], [-124.14487, 40.69937], [-124.14463, 40.69916], [-124.14441, 40.69888], [-124.144, 40.69806], [-124.14386, 40.69787], [-124.14326, 40.69743], [-124.14259, 40.69713], [-124.14213, 40.69682], [-124.14194, 40.69666], [-124.14184, 40.69655], [-124.14164, 40.69593], [-124.14149, 40.69555], [-124.14148, 40.69537], [-124.14151, 40.69528], [-124.14171, 40.69508], [-124.14203, 40.69494], [-124.14223, 40.69481], [-124.14229, 40.6947], [-124.14225, 40.69455], [-124.14214, 40.69442], [-124.14207, 40.69439], [-124.14264, 40.69415], [-124.14295, 40.69454], [-124.14296, 40.69454], [-124.14329, 40.69379], [-124.14376, 40.6938], [-124.14398, 40.6937], [-124.14425, 40.69348], [-124.14427, 40.69345], [-124.14588, 40.69346], [-124.14592, 40.69353], [-124.14604, 40.69421], [-124.14639, 40.69519], [-124.14669, 40.69543], [-124.14707, 40.69543], [-124.14771, 40.69497], [-124.14832, 40.69488], [-124.14849, 40.69515], [-124.14897, 40.69675], [-124.14938, 40.69708], [-124.14997, 40.69735], [-124.14997, 40.69815], [-124.15032, 40.69913]]]]} | Unknown Access 4 | 48621 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Humboldt 45 | 106.296 | 0 | Private Other or Unknown 399 | 4 | |
14118 | 14118 | 14117 | {"type": "MultiPolygon", "coordinates": [[[[-124.03502, 40.80993], [-124.03498, 40.81172], [-124.03246, 40.81177], [-124.03248, 40.81705], [-124.02927, 40.8171], [-124.02926, 40.81711], [-124.02992, 40.8179], [-124.03317, 40.82081], [-124.03489, 40.822], [-124.03491, 40.82314], [-124.0345, 40.82247], [-124.03312, 40.82178], [-124.03296, 40.82168], [-124.02823, 40.82176], [-124.02824, 40.82087], [-124.02836, 40.81711], [-124.02895, 40.8171], [-124.02881, 40.81654], [-124.02839, 40.81594], [-124.02798, 40.81568], [-124.02707, 40.8152], [-124.02645, 40.81468], [-124.02631, 40.81455], [-124.0261, 40.8141], [-124.0262, 40.81377], [-124.02613, 40.81335], [-124.02589, 40.81297], [-124.02556, 40.81266], [-124.02527, 40.81232], [-124.02447, 40.81117], [-124.02409, 40.81086], [-124.02396, 40.81062], [-124.0239, 40.81002], [-124.02352, 40.80855], [-124.02346, 40.80814], [-124.02564, 40.80819], [-124.02561, 40.81005], [-124.03502, 40.80993]]], [[[-124.04434, 40.82678], [-124.04426, 40.82918], [-124.04221, 40.82917], [-124.04219, 40.82908], [-124.04223, 40.82879], [-124.04169, 40.82846], [-124.04067, 40.82843], [-124.0405, 40.82846], [-124.04036, 40.82856], [-124.03973, 40.82756], [-124.03983, 40.82704], [-124.03977, 40.8268], [-124.04013, 40.82673], [-124.04434, 40.82678]]], [[[-124.05768, 40.8335], [-124.05768, 40.83357], [-124.05758, 40.83375], [-124.05737, 40.83393], [-124.05725, 40.8342], [-124.05728, 40.83437], [-124.05736, 40.83451], [-124.0574, 40.83454], [-124.05702, 40.83465], [-124.05688, 40.83687], [-124.05618, 40.83864], [-124.05609, 40.83871], [-124.05475, 40.83809], [-124.05509, 40.83359], [-124.05526, 40.83358], [-124.05592, 40.83345], [-124.05625, 40.83344], [-124.05636, 40.8335], [-124.0566, 40.83349], [-124.05699, 40.83336], [-124.05719, 40.83333], [-124.0574, 40.83333], [-124.05753, 40.83335], [-124.05766, 40.83344], [-124.05768, 40.8335]]], [[[-124.07009, 40.83765], [-124.0679, 40.83919], [-124.06747, 40.83885], [-124.06692, 40.83922], [-124.06663, 40.83902], [-124.06593, 40.83952], [-124.06344, 40.83745], [-124.06343, 40.83657], [-124.05867, 40.83659], [-124.05867, 40.8347], [-124.06281, 40.83472], [-124.06288, 40.83478], [-124.06298, 40.83472], [-124.06301, 40.83472], [-124.06303, 40.83523], [-124.06343, 40.83522], [-124.06343, 40.83497], [-124.06488, 40.83499], [-124.06557, 40.83532], [-124.06597, 40.83578], [-124.06597, 40.83587], [-124.06601, 40.83598], [-124.06608, 40.83605], [-124.06619, 40.83612], [-124.06629, 40.83616], [-124.0664, 40.83618], [-124.06718, 40.83656], [-124.06763, 40.83681], [-124.06893, 40.83725], [-124.06923, 40.83733], [-124.06978, 40.83708], [-124.07009, 40.83765]]]]} | Unknown Access 4 | 46794 | Unnamed site - Jacoby Creek Land Trust | 30249 | 6085 | Jacoby Creek Land Trust 1072 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jclandtrust.org/ | Non Governmental Organization 10 | 6085 | Jacoby Creek Land Trust 1028 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 262.805 | 0 | Private Other or Unknown 399 | 4 | ||
5687 | 5687 | 5686 | {"type": "MultiPolygon", "coordinates": [[[[-124.06439, 41.78643], [-124.0617, 41.78643], [-124.06168, 41.78487], [-124.06429, 41.78484], [-124.06439, 41.78643]]], [[[-124.13806, 41.79306], [-124.13754, 41.79306], [-124.13754, 41.79243], [-124.13784, 41.79246], [-124.13791, 41.79248], [-124.13798, 41.79253], [-124.13801, 41.79259], [-124.13801, 41.79266], [-124.13793, 41.79282], [-124.13793, 41.7929], [-124.13796, 41.79298], [-124.13806, 41.79306]]]]} | Unknown Access 4 | 48623 | Unnamed site - Save the Redwoods League | 28667 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.savetheredwoods.org/ | Del Norte 50 | 10.154 | 0 | Private Other or Unknown 399 | 4 | |
12612 | 12612 | 12611 | {"type": "Polygon", "coordinates": [[[-114.71493, 34.89453], [-114.71491, 34.90936], [-114.71073, 34.90934], [-114.71076, 34.90206], [-114.70637, 34.90206], [-114.70643, 34.89457], [-114.71493, 34.89453]]]} | Unknown Access 4 | 29372 | Mojave Desert Land Trust Properties | 22350 | 3124 | Mojave Desert Land Trust 669 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.mojavedesertlandtrust.org/ | Non Governmental Organization 10 | 3124 | Mojave Desert Land Trust 657 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 236.65 | Mojave Desert Land Trust Properties | 0 | Private Conservation 16 | 2 | |
12260 | 12260 | 12259 | {"type": "Polygon", "coordinates": [[[-115.41747, 34.16754], [-115.41528, 34.16754], [-115.41526, 34.16572], [-115.41745, 34.16572], [-115.41747, 34.16754]]]} | Unknown Access 4 | 25832 | Wilderness Land Trust | 27510 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 10.084 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
4484 | 4484 | 4483 | {"type": "Polygon", "coordinates": [[[-116.0659, 33.7911], [-116.05721, 33.7911], [-116.05721, 33.78748], [-116.0659, 33.78747], [-116.0659, 33.7911]]]} | Unknown Access 4 | 4435 | Unnamed site - The Wildlands Conservancy | 28672 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 79.972 | 0 | Private Other or Unknown 399 | 4 | ||
3478 | 3478 | 3477 | {"type": "Polygon", "coordinates": [[[-116.10126, 34.74073], [-116.10125, 34.74791], [-116.09285, 34.74777], [-116.09283, 34.74063], [-116.10126, 34.74073]]]} | Unknown Access 4 | 25830 | Wilderness Land Trust | 27510 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 151.196 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
15454 | 15454 | 15453 | {"type": "Polygon", "coordinates": [[[-116.36903, 33.83109], [-116.36896, 33.83837], [-116.36677, 33.83836], [-116.36686, 33.83109], [-116.36903, 33.83109]]]} | Unknown Access 4 | 3769 | Unnamed site - Center for Natural Lands Management | 28629 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 40.197 | 0 | Private Other or Unknown 399 | 4 | ||
7084 | 7084 | 7083 | {"type": "Polygon", "coordinates": [[[-117.0755, 33.96786], [-117.07505, 33.96822], [-117.07457, 33.96855], [-117.07407, 33.96885], [-117.0736, 33.9691], [-117.07372, 33.96933], [-117.07377, 33.96948], [-117.07215, 33.96914], [-117.07101, 33.96947], [-117.07067, 33.96961], [-117.07035, 33.96978], [-117.06978, 33.97015], [-117.06923, 33.97046], [-117.06889, 33.97062], [-117.06841, 33.97082], [-117.06793, 33.97099], [-117.06743, 33.97113], [-117.06654, 33.97132], [-117.06623, 33.97139], [-117.06594, 33.97149], [-117.06566, 33.97161], [-117.06518, 33.97187], [-117.06317, 33.97326], [-117.06274, 33.9735], [-117.06229, 33.97371], [-117.06172, 33.97392], [-117.06123, 33.97405], [-117.0586, 33.97456], [-117.05856, 33.97219], [-117.05761, 33.97215], [-117.05467, 33.97047], [-117.05245, 33.96774], [-117.0517, 33.96634], [-117.05121, 33.96614], [-117.05118, 33.96562], [-117.05079, 33.96501], [-117.05106, 33.96393], [-117.05499, 33.96461], [-117.0585, 33.96508], [-117.06453, 33.96538], [-117.07137, 33.96431], [-117.07301, 33.96574], [-117.07301, 33.96587], [-117.07175, 33.9669], [-117.07175, 33.96691], [-117.07206, 33.96707], [-117.07326, 33.96609], [-117.0734, 33.96609], [-117.07502, 33.96749], [-117.0755, 33.96786]]]} | Unknown Access 4 | 6123 | Oak Valley | 23013 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 363.201 | Oak Valley | 0 | Private Conservation 16 | 2 | |
4475 | 4475 | 4474 | {"type": "Polygon", "coordinates": [[[-117.51483, 34.17196], [-117.51477, 34.17839], [-117.51026, 34.17888], [-117.51022, 34.17196], [-117.51483, 34.17196]]]} | Unknown Access 4 | 3291 | Unnamed site - The Habitat Trust | 28671 | 3089 | The Habitat Trust 340 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3089 | The Habitat Trust 337 | Non Profit 6 | Non Profit - Land Trust 10 | San Bernardino 22 | 76.971 | 0 | Private Other or Unknown 399 | 4 | |||
12262 | 12262 | 12261 | {"type": "Polygon", "coordinates": [[[-117.90111, 35.49943], [-117.89655, 35.49938], [-117.89647, 35.49577], [-117.90107, 35.49582], [-117.90111, 35.49943]]]} | Unknown Access 4 | 25836 | Wilderness Land Trust | 27510 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | Kern 36 | 41.08 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
3480 | 3480 | 3479 | {"type": "Polygon", "coordinates": [[[-118.84904, 38.00675], [-118.84899, 38.01037], [-118.8444, 38.01038], [-118.84445, 38.00676], [-118.84904, 38.00675]]]} | Unknown Access 4 | 25838 | Wilderness Land Trust | 27510 | 3097 | Wilderness Land Trust 603 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildernesslandtrust.org/ | Non Governmental Organization 10 | 3097 | Wilderness Land Trust 592 | Non Profit 6 | Non Profit - Land Trust 10 | Mono 32 | 40.043 | Wilderness Land Trust | 0 | Private Conservation 16 | 2 | |
14533 | 14533 | 14532 | {"type": "Polygon", "coordinates": [[[-119.2126, 36.96446], [-119.21258, 36.9658], [-119.21037, 36.96576], [-119.21039, 36.97035], [-119.20819, 36.97041], [-119.20817, 36.97301], [-119.20782, 36.97306], [-119.2055, 36.96985], [-119.20388, 36.96986], [-119.20388, 36.96959], [-119.20593, 36.9695], [-119.20621, 36.9678], [-119.20389, 36.96782], [-119.20381, 36.96503], [-119.20598, 36.96497], [-119.20594, 36.96231], [-119.21142, 36.96221], [-119.21149, 36.96441], [-119.2126, 36.96446]]]} | Unknown Access 4 | 44691 | The Haslett Basin Wildlife Preserve | 26284 | 3077 | Sierra Foothill Conservancy 323 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sierrafoothill.org/ | Non Governmental Organization 10 | 3077 | Sierra Foothill Conservancy 320 | Non Profit 6 | Non Profit - Land Trust 10 | Fresno 9 | 125.188 | The Haslett Basin Wildlife Preserve | 0 | Private Conservation 16 | 2 | |
12430 | 12430 | 12429 | {"type": "Polygon", "coordinates": [[[-119.71821, 36.9953], [-119.71722, 36.99589], [-119.71659, 36.99671], [-119.71588, 36.99675], [-119.7158, 36.99679], [-119.71468, 36.99589], [-119.71464, 36.99589], [-119.71464, 36.99591], [-119.71575, 36.9968], [-119.71547, 36.9969], [-119.71513, 36.99758], [-119.71582, 36.99857], [-119.71483, 36.99866], [-119.71447, 36.99918], [-119.71168, 37.00082], [-119.71099, 37.00163], [-119.70974, 37.00139], [-119.70892, 37.00087], [-119.70902, 36.99762], [-119.71017, 36.99591], [-119.71021, 36.9959], [-119.71069, 36.99548], [-119.71091, 36.99527], [-119.71103, 36.99513], [-119.7143, 36.99202], [-119.71821, 36.9953]]]} | Unknown Access 4 | 27038 | Wagner | 27208 | 3069 | San Joaquin River Parkway and Conservation Trust 649 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 110.701 | Wagner | 0 | Private Conservation 16 | 2 | |
12283 | 12283 | 12282 | {"type": "Polygon", "coordinates": [[[-119.73125, 36.98478], [-119.73073, 36.98528], [-119.72986, 36.98556], [-119.72892, 36.9862], [-119.72812, 36.98615], [-119.72732, 36.98671], [-119.72713, 36.98843], [-119.72603, 36.98868], [-119.72487, 36.99101], [-119.72383, 36.99097], [-119.72294, 36.99154], [-119.72257, 36.99189], [-119.72123, 36.99292], [-119.72037, 36.99324], [-119.71923, 36.99432], [-119.71902, 36.99486], [-119.71869, 36.99531], [-119.71453, 36.9918], [-119.71485, 36.99148], [-119.71495, 36.99127], [-119.71539, 36.99089], [-119.71615, 36.99035], [-119.71649, 36.99027], [-119.71675, 36.99029], [-119.71709, 36.99018], [-119.71734, 36.99008], [-119.71707, 36.99034], [-119.71691, 36.99053], [-119.71644, 36.99085], [-119.71607, 36.99103], [-119.716, 36.9911], [-119.71601, 36.99112], [-119.7161, 36.99111], [-119.71634, 36.99099], [-119.71667, 36.99078], [-119.71696, 36.99057], [-119.71716, 36.9904], [-119.71734, 36.99018], [-119.71756, 36.99005], [-119.71786, 36.98983], [-119.71812, 36.98976], [-119.71841, 36.98965], [-119.71879, 36.98943], [-119.71938, 36.98901], [-119.72004, 36.9887], [-119.72093, 36.98816], [-119.72121, 36.98794], [-119.72144, 36.98772], [-119.72232, 36.98703], [-119.72335, 36.98634], [-119.72393, 36.98604], [-119.72431, 36.98577], [-119.7243, 36.98575], [-119.72418, 36.98575], [-119.72431, 36.98567], [-119.72443, 36.98546], [-119.72464, 36.98524], [-119.72514, 36.98512], [-119.7254, 36.98495], [-119.72531, 36.98452], [-119.72543, 36.98436], [-119.72601, 36.98431], [-119.72649, 36.98424], [-119.7268, 36.98407], [-119.72708, 36.98388], [-119.72723, 36.98375], [-119.7277, 36.98344], [-119.72824, 36.98301], [-119.72864, 36.98276], [-119.72918, 36.98246], [-119.73125, 36.98478]], [[-119.72523, 36.9884], [-119.72525, 36.98842], [-119.72562, 36.98816], [-119.72578, 36.98798], [-119.72553, 36.98814], [-119.72523, 36.9884]]]} | Unknown Access 4 | 25931 | River Vista | 24429 | 3069 | San Joaquin River Parkway and Conservation Trust 649 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.riverparkway.org | Non Governmental Organization 10 | 3069 | San Joaquin River Parkway and Conservation Trust 491 | Non Profit 6 | Non Profit - Land Trust 10 | Madera 48 | 160.718 | River Vista | 0 | Private Conservation 16 | 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]);