units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where ACCESS_TYP = 4, AGNCY_TYP = 10 and DES_TP = 16
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
MNG_AGENCY 12
- Save the Redwoods League 4
- 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
- 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
MNG_AG_TYP 1
DES_TP 1
- Private Conservation · 26 ✖
ACCESS_TYP 1
- Unknown Access · 26 ✖
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 | |
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 | |
5900 | 5900 | 5899 | {"type": "Polygon", "coordinates": [[[-124.10154, 40.78543], [-124.09837, 40.78644], [-124.09699, 40.78702], [-124.09651, 40.78736], [-124.09547, 40.78733], [-124.09421, 40.78637], [-124.09389, 40.78634], [-124.0936, 40.78639], [-124.09263, 40.78672], [-124.09247, 40.78675], [-124.09223, 40.78675], [-124.09194, 40.78672], [-124.09156, 40.78664], [-124.09121, 40.78653], [-124.09109, 40.78639], [-124.09099, 40.78622], [-124.0909, 40.78602], [-124.09073, 40.7858], [-124.09059, 40.78568], [-124.09047, 40.78561], [-124.08992, 40.78549], [-124.0895, 40.78533], [-124.08937, 40.78525], [-124.08908, 40.78492], [-124.08893, 40.78461], [-124.08855, 40.784], [-124.08832, 40.78382], [-124.08816, 40.78381], [-124.0881, 40.78368], [-124.09263, 40.78369], [-124.09692, 40.78363], [-124.09748, 40.78367], [-124.09845, 40.78402], [-124.09916, 40.78435], [-124.10076, 40.78497], [-124.10114, 40.78505], [-124.10152, 40.78511], [-124.10154, 40.78543]]]} | Unknown Access 4 | 46792 | Freshwater Farms Reserve | 30247 | 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 | 71.838 | Freshwater Farms Reserve | 0 | Private Conservation 16 | 2 | |
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 | |
10600 | 10600 | 10599 | {"type": "Polygon", "coordinates": [[[-123.31159, 38.63197], [-123.31112, 38.63968], [-123.2963, 38.63978], [-123.29666, 38.63575], [-123.28701, 38.6359], [-123.28723, 38.63198], [-123.28725, 38.62452], [-123.30782, 38.62432], [-123.30767, 38.63183], [-123.31159, 38.63197]]]} | Unknown Access 4 | 48628 | Harold Richardson Redwood Reserve | 33334 | 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/ | Sonoma 16 | 732.202 | Harold Richardson Redwood Reserve | 2018 | Private Conservation 16 | 2 |
11268 | 11268 | 11267 | {"type": "Polygon", "coordinates": [[[-121.10403, 38.53104], [-121.09492, 38.53108], [-121.0766, 38.53089], [-121.07662, 38.53269], [-121.0812, 38.53276], [-121.0813, 38.53997], [-121.07672, 38.53991], [-121.07682, 38.54717], [-121.07751, 38.54719], [-121.07756, 38.55519], [-121.05018, 38.55534], [-121.04994, 38.53981], [-121.04431, 38.53982], [-121.04427, 38.52682], [-121.04435, 38.51911], [-121.04438, 38.51881], [-121.04445, 38.51855], [-121.0446, 38.51822], [-121.05431, 38.51822], [-121.05426, 38.51236], [-121.05499, 38.51254], [-121.05576, 38.51289], [-121.05645, 38.51315], [-121.05733, 38.51316], [-121.05853, 38.51297], [-121.05916, 38.51294], [-121.06187, 38.51222], [-121.06235, 38.51218], [-121.06237, 38.51098], [-121.06789, 38.51094], [-121.06796, 38.51453], [-121.07734, 38.51455], [-121.0774, 38.52537], [-121.08654, 38.52535], [-121.08652, 38.52171], [-121.09468, 38.5217], [-121.09471, 38.52541], [-121.09918, 38.5254], [-121.09922, 38.52901], [-121.10385, 38.52898], [-121.10384, 38.53069], [-121.10403, 38.53104]]]} | Unknown Access 4 | 21722 | Blue Oak Hills | 16179 | 3061 | Sacramento Valley Conservancy 972 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sacramentovalleyconservancy.org/ | Non Governmental Organization 10 | 3061 | Sacramento Valley Conservancy 937 | Non Profit 6 | Non Profit - Land Trust 10 | Sacramento 41 | 3447.408 | Blue Oak Hills | 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 | |
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 | |
12276 | 12276 | 12275 | {"type": "Polygon", "coordinates": [[[-119.90876, 36.84585], [-119.90533, 36.84896], [-119.90287, 36.84725], [-119.9036, 36.84715], [-119.90433, 36.84704], [-119.90505, 36.8469], [-119.90576, 36.84675], [-119.90647, 36.84658], [-119.90717, 36.84638], [-119.90786, 36.84617], [-119.90876, 36.84585]]]} | Unknown Access 4 | 25926 | Riverside Restoration Area | 24459 | 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 | Fresno 9 | 14.792 | Riverside Restoration Area | 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]);