units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
36 rows where ACCESS_TYP = 4, AGNCY_LEV = 6 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, 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 4
- 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 2
MNG_AG_TYP 1
- Non Profit - Land Trust · 36 ✖
ACCESS_TYP 1
- Unknown Access · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
120 | 120 | 119 | {"type": "Polygon", "coordinates": [[[-123.78052, 39.29709], [-123.78043, 39.29964], [-123.77587, 39.29973], [-123.77122, 39.29977], [-123.77099, 39.29555], [-123.77061, 39.29557], [-123.77054, 39.29471], [-123.7708, 39.29489], [-123.77101, 39.29492], [-123.77111, 39.29503], [-123.77132, 39.29511], [-123.77154, 39.29529], [-123.77225, 39.29551], [-123.77299, 39.29488], [-123.77329, 39.29439], [-123.77335, 39.29402], [-123.77311, 39.29345], [-123.77325, 39.29328], [-123.77364, 39.29341], [-123.77396, 39.29356], [-123.77417, 39.29367], [-123.77432, 39.2938], [-123.77443, 39.29393], [-123.7745, 39.29409], [-123.77451, 39.29457], [-123.7746, 39.29494], [-123.77467, 39.29504], [-123.775, 39.29528], [-123.77583, 39.29574], [-123.77585, 39.29616], [-123.7769, 39.29616], [-123.77711, 39.2962], [-123.77803, 39.29633], [-123.77875, 39.29629], [-123.77892, 39.29631], [-123.77935, 39.29648], [-123.78002, 39.29686], [-123.7802, 39.297], [-123.78052, 39.29709]]]} | Unknown Access 4 | 46785 | Big River-Mendocino Old-Growth Redwoods | 30239 | 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 | Mendocino 24 | 92.451 | Big River-Mendocino Old-Growth Redwoods | 0 | Private Conservation 16 | 2 | |
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 | |
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 | |
3494 | 3494 | 3493 | {"type": "Polygon", "coordinates": [[[-119.92013, 36.84814], [-119.9201, 36.84889], [-119.91933, 36.84892], [-119.91621, 36.84954], [-119.91557, 36.84957], [-119.91467, 36.84879], [-119.91115, 36.8488], [-119.91115, 36.85122], [-119.91068, 36.85129], [-119.91054, 36.85133], [-119.90847, 36.8513], [-119.90649, 36.85002], [-119.90733, 36.84921], [-119.90775, 36.84888], [-119.90795, 36.84855], [-119.90816, 36.84837], [-119.90879, 36.848], [-119.90911, 36.84784], [-119.90954, 36.8475], [-119.90997, 36.84724], [-119.91042, 36.84702], [-119.91072, 36.84679], [-119.91172, 36.8464], [-119.91209, 36.84619], [-119.91244, 36.84606], [-119.91285, 36.84585], [-119.91314, 36.84576], [-119.91372, 36.84572], [-119.91435, 36.84574], [-119.91473, 36.84573], [-119.91559, 36.84561], [-119.91563, 36.84814], [-119.92013, 36.84814]]]} | Unknown Access 4 | 25925 | Schneider Property | 25187 | 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 | 77.528 | Schneider Property | 0 | Private Conservation 16 | 2 | |
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 | |
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 | |
4150 | 4150 | 4149 | {"type": "Polygon", "coordinates": [[[-119.95114, 37.60758], [-119.95049, 37.61465], [-119.94827, 37.61467], [-119.94891, 37.60766], [-119.95114, 37.60758]]]} | Unknown Access 4 | 44690 | Feliciana Mountain Preserve | 18865 | 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 | Mariposa 31 | 37.919 | Feliciana Mtn. Preserve | 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 | |
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 | |||
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 | ||
4562 | 4562 | 4561 | {"type": "Polygon", "coordinates": [[[-121.79416, 36.26266], [-121.79365, 36.26267], [-121.79215, 36.26261], [-121.79215, 36.2623], [-121.79397, 36.26233], [-121.79416, 36.26266]]]} | Unknown Access 4 | 35188 | 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/ | Monterey 14 | 1.537 | 0 | Private Other or Unknown 399 | 4 | |
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 | |
4810 | 4810 | 4809 | {"type": "Polygon", "coordinates": [[[-120.26268, 38.26203], [-120.26258, 38.26565], [-120.24415, 38.26629], [-120.2352, 38.26616], [-120.23518, 38.25849], [-120.23727, 38.25839], [-120.24324, 38.25829], [-120.2438, 38.2583], [-120.24408, 38.26232], [-120.26268, 38.26203]]]} | Unknown Access 4 | 48626 | 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/ | Tuolumne 21 | 335.393 | 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 | |
5691 | 5691 | 5690 | {"type": "Polygon", "coordinates": [[[-122.21155, 37.27037], [-122.21143, 37.27072], [-122.21079, 37.27112], [-122.21082, 37.27244], [-122.20618, 37.27239], [-122.20221, 37.27237], [-122.20204, 37.27208], [-122.20204, 37.27183], [-122.19978, 37.27115], [-122.19977, 37.27116], [-122.19974, 37.27236], [-122.19714, 37.27235], [-122.19736, 37.2656], [-122.19736, 37.26339], [-122.19843, 37.26406], [-122.1996, 37.26318], [-122.19988, 37.26323], [-122.20027, 37.2634], [-122.20036, 37.26404], [-122.20052, 37.26424], [-122.20052, 37.26558], [-122.20336, 37.26556], [-122.20337, 37.26593], [-122.20335, 37.266], [-122.20293, 37.26597], [-122.20265, 37.26609], [-122.20254, 37.26627], [-122.20254, 37.26674], [-122.20277, 37.26701], [-122.20283, 37.26721], [-122.20311, 37.26748], [-122.20353, 37.26795], [-122.20362, 37.26846], [-122.20321, 37.26895], [-122.20312, 37.26973], [-122.20306, 37.26996], [-122.20294, 37.27009], [-122.20269, 37.27021], [-122.20268, 37.27039], [-122.20314, 37.27053], [-122.20359, 37.27038], [-122.20381, 37.27013], [-122.20373, 37.26987], [-122.20385, 37.26986], [-122.20406, 37.26993], [-122.20409, 37.27008], [-122.20398, 37.27025], [-122.20399, 37.27045], [-122.20403, 37.27046], [-122.20435, 37.26999], [-122.20439, 37.26963], [-122.20453, 37.26933], [-122.20493, 37.26902], [-122.20462, 37.26868], [-122.20503, 37.26852], [-122.20551, 37.26869], [-122.20565, 37.26819], [-122.20618, 37.26795], [-122.20641, 37.26766], [-122.20651, 37.2675], [-122.20681, 37.26714], [-122.20745, 37.26724], [-122.20766, 37.267], [-122.20743, 37.2665], [-122.20741, 37.26624], [-122.20755, 37.26597], [-122.20754, 37.26592], [-122.20771, 37.26591], [-122.20771, 37.2658], [-122.20781, 37.2658], [-122.20799, 37.26599], [-122.2082, 37.26605], [-122.2084, 37.26603], [-122.20896, 37.26581], [-122.20925, 37.26555], [-122.2093, 37.26559], [-122.209, 37.26586], [-122.20842, 37.26609], [-122.20852, 37.26662], [-122.20882, 37.26768], [-122.20894, 37.26769], [-122.2089, 37.26823], [-122.20972, 37.26827], [-122.2097, 37.26883], [-122.21007, 37.26885], [-122.21001, 37.26984], [-122.20988, 37.26996], [-122.20941, 37.27007], [-122.20888, 37.27049], [-122.20885, 37.27054], [-122.20886, 37.2706], [-122.20891, 37.27065], [-122.20965, 37.27097], [-122.20986, 37.27105], [-122.21022, 37.2711], [-122.211, 37.27058], [-122.21115, 37.27058], [-122.21131, 37.27025], [-122.21155, 37.27037]]]} | Unknown Access 4 | 48625 | 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/ | San Mateo 15 | 179.263 | 0 | Private Other or Unknown 399 | 4 | |
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 | |
5893 | 5893 | 5892 | {"type": "Polygon", "coordinates": [[[-124.0476, 41.30161], [-124.04702, 41.30206], [-124.04612, 41.30252], [-124.04528, 41.30274], [-124.04622, 41.30429], [-124.04651, 41.30425], [-124.04688, 41.30455], [-124.04662, 41.30539], [-124.04623, 41.30514], [-124.04619, 41.30507], [-124.0461, 41.30505], [-124.04612, 41.30606], [-124.04595, 41.30602], [-124.04503, 41.30596], [-124.04517, 41.30612], [-124.04525, 41.31016], [-124.04507, 41.3112], [-124.04396, 41.3131], [-124.04226, 41.31424], [-124.0411, 41.31599], [-124.04101, 41.31625], [-124.04008, 41.31624], [-124.03943, 41.31654], [-124.03957, 41.31625], [-124.03992, 41.3159], [-124.04058, 41.31577], [-124.04093, 41.31553], [-124.0415, 41.31441], [-124.0425, 41.31351], [-124.04384, 41.31249], [-124.04423, 41.31194], [-124.0446, 41.31063], [-124.04452, 41.3099], [-124.04374, 41.30915], [-124.04234, 41.30856], [-124.04208, 41.30829], [-124.04181, 41.30791], [-124.04152, 41.30769], [-124.03988, 41.30602], [-124.03979, 41.30554], [-124.03971, 41.30484], [-124.03954, 41.30281], [-124.03953, 41.30198], [-124.03979, 41.30125], [-124.04042, 41.30076], [-124.04103, 41.30043], [-124.04173, 41.30022], [-124.04304, 41.30023], [-124.04305, 41.30015], [-124.044, 41.30014], [-124.04458, 41.30009], [-124.04586, 41.3005], [-124.0476, 41.30161]]]} | Unknown Access 4 | 46786 | Orick Mill Site | 30240 | 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 | Humboldt 45 | 125.427 | Orick Mill Site | 0 | Private Conservation 16 | 2 | |
5894 | 5894 | 5893 | {"type": "Polygon", "coordinates": [[[-124.04065, 41.3174], [-124.03951, 41.32033], [-124.03923, 41.32036], [-124.03889, 41.32062], [-124.03874, 41.32109], [-124.03872, 41.32125], [-124.03832, 41.32127], [-124.03852, 41.32073], [-124.03931, 41.31984], [-124.03934, 41.31945], [-124.03918, 41.31876], [-124.03895, 41.31814], [-124.03895, 41.31789], [-124.03916, 41.31755], [-124.04065, 41.3174]]]} | Unknown Access 4 | 46787 | Berry Glen Trail Connection | 30241 | 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 | Humboldt 45 | 6.789 | Berry Glen Trail Connection | 0 | Private Conservation 16 | 2 | |
5895 | 5895 | 5894 | {"type": "Polygon", "coordinates": [[[-124.0807, 41.29969], [-124.07697, 41.29966], [-124.07626, 41.29945], [-124.07585, 41.29923], [-124.07587, 41.29684], [-124.07565, 41.29683], [-124.07566, 41.29585], [-124.07231, 41.29587], [-124.07002, 41.29466], [-124.06981, 41.29466], [-124.06958, 41.29464], [-124.06937, 41.29458], [-124.06913, 41.29447], [-124.06864, 41.29419], [-124.0685, 41.29408], [-124.06839, 41.29394], [-124.06832, 41.29379], [-124.06804, 41.29293], [-124.06774, 41.29221], [-124.07421, 41.29216], [-124.07424, 41.29259], [-124.07436, 41.29303], [-124.0745, 41.29335], [-124.07449, 41.29337], [-124.07457, 41.29353], [-124.07475, 41.2938], [-124.07488, 41.29396], [-124.07469, 41.29407], [-124.07423, 41.29424], [-124.07423, 41.29425], [-124.07428, 41.29436], [-124.0745, 41.29432], [-124.0747, 41.29432], [-124.07489, 41.29434], [-124.07508, 41.2944], [-124.07532, 41.29453], [-124.07578, 41.29489], [-124.07577, 41.29675], [-124.08069, 41.29671], [-124.0807, 41.29969]]]} | Unknown Access 4 | 46788 | McNamara Dairy | 30242 | 3294 | Northcoast Regional Land Trust 819 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ncrlt.org/ | Non Governmental Organization 10 | 3294 | Northcoast Regional Land Trust 797 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 80.699 | McNamara Dairy | 0 | Private Conservation 16 | 2 | |
5898 | 5898 | 5897 | {"type": "Polygon", "coordinates": [[[-124.18306, 40.75177], [-124.18271, 40.75197], [-124.18253, 40.75214], [-124.18242, 40.75249], [-124.18125, 40.75249], [-124.18016, 40.75287], [-124.17956, 40.75286], [-124.17939, 40.75284], [-124.17933, 40.75296], [-124.17898, 40.75279], [-124.17838, 40.7527], [-124.17813, 40.7527], [-124.1781, 40.7529], [-124.17788, 40.75289], [-124.17787, 40.75291], [-124.17827, 40.75381], [-124.1766, 40.7538], [-124.17659, 40.75401], [-124.17628, 40.75401], [-124.17628, 40.7538], [-124.17427, 40.75379], [-124.17328, 40.75483], [-124.17331, 40.75172], [-124.17589, 40.75172], [-124.17592, 40.75152], [-124.17591, 40.75105], [-124.17625, 40.75064], [-124.1765, 40.75041], [-124.17694, 40.75024], [-124.17736, 40.75018], [-124.17754, 40.7502], [-124.17786, 40.75028], [-124.17804, 40.75038], [-124.1782, 40.75052], [-124.17821, 40.75174], [-124.18306, 40.75177]]]} | Unknown Access 4 | 46791 | Martin Slough | 30246 | 3294 | Northcoast Regional Land Trust 819 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ncrlt.org/ | Non Governmental Organization 10 | 3294 | Northcoast Regional Land Trust 797 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 41.186 | Martin Slough | 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]);