units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
139 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 10 sorted by AGNCY_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, YR_EST
MNG_AGENCY >30
- Sempervirens Fund 16
- The Nature Conservancy 14
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- Sonoma Land Trust 9
- Center for Natural Lands Management 5
- Solano Land Trust 5
- Truckee Donner Land Trust 5
- Rivers and Lands Conservancy 5
- Sequoia Riverlands Trust 4
- Land Trust of Santa Cruz County 4
- Save Mount Diablo 4
- The Wildlands Conservancy 3
- Peninsula Open Space Trust 3
- The Conservation Fund - California 3
- Save the Redwoods League 2
- Santa Lucia Conservancy 2
- Bear Yuba Land Trust 2
- LandPaths 2
- Land Trust for Santa Barbara County 2
- Fallbrook Land Conservancy 2
- Santa Catalina Island Conservancy 2
- Los Angeles Neighborhood Land Trust 2
- Lake County Land Trust 2
- American River Conservancy 2
- John Muir Land Trust 1
- Friends of the Desert Mountains 1
- Arroyos and Foothills Conservancy 1
- Mendocino Land Trust 1
- Tuleyome 1
- …
DES_TP 6
MNG_AG_TYP 1
- Non Profit - Land Trust · 139 ✖
ACCESS_TYP 1
- Restricted Access · 139 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14864 | 14864 | 14863 | {"type": "Polygon", "coordinates": [[[-122.72506, 37.93451], [-122.72495, 37.93459], [-122.72482, 37.93444], [-122.72471, 37.93435], [-122.72459, 37.93428], [-122.72437, 37.93421], [-122.72394, 37.93413], [-122.72367, 37.93403], [-122.72274, 37.93348], [-122.72259, 37.93342], [-122.72243, 37.93337], [-122.72226, 37.93335], [-122.722, 37.93337], [-122.72175, 37.93343], [-122.72113, 37.93357], [-122.7207, 37.93362], [-122.72048, 37.93363], [-122.72005, 37.93359], [-122.71984, 37.93355], [-122.7189, 37.9333], [-122.71849, 37.93332], [-122.71808, 37.93337], [-122.71655, 37.93368], [-122.71574, 37.93392], [-122.71545, 37.93405], [-122.71489, 37.93435], [-122.71462, 37.93448], [-122.71454, 37.93443], [-122.71441, 37.93442], [-122.71438, 37.93436], [-122.71419, 37.93432], [-122.71413, 37.93419], [-122.71388, 37.93409], [-122.71379, 37.93395], [-122.71372, 37.9339], [-122.7134, 37.93381], [-122.71333, 37.93377], [-122.71332, 37.93375], [-122.71316, 37.9337], [-122.71304, 37.93357], [-122.71295, 37.93353], [-122.71282, 37.9335], [-122.71269, 37.93343], [-122.71253, 37.9334], [-122.71245, 37.93334], [-122.70667, 37.9369], [-122.70634, 37.93609], [-122.70687, 37.93533], [-122.70592, 37.93456], [-122.70629, 37.93386], [-122.7066, 37.93362], [-122.70653, 37.93304], [-122.70541, 37.93222], [-122.70429, 37.92993], [-122.7045, 37.92982], [-122.70408, 37.92889], [-122.70385, 37.92868], [-122.70364, 37.92803], [-122.70491, 37.92746], [-122.70585, 37.92711], [-122.70672, 37.9272], [-122.70693, 37.92728], [-122.70749, 37.92808], [-122.70927, 37.9283], [-122.71002, 37.92806], [-122.71104, 37.9276], [-122.71153, 37.92745], [-122.71325, 37.92755], [-122.71344, 37.92751], [-122.71432, 37.92926], [-122.71654, 37.92939], [-122.71933, 37.92944], [-122.7195, 37.92962], [-122.72148, 37.9304], [-122.72088, 37.93096], [-122.72506, 37.93451]]]} | Restricted Access 2 | 45377 | Paradise Valley Ranch | 27899 | 3038 | Marin Agricultural Land Trust 1125 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.malt.org/ | Non Governmental Organization 10 | 3038 | Marin Agricultural Land Trust 1079 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.malt.org/protected-lands/slideshow-paradise-valley-ranch | Marin 23 | 235.112 | Paradise Valley Ranch | 0 | Private Conservation 16 | 2 |
11275 | 11275 | 11274 | {"type": "Polygon", "coordinates": [[[-121.46596, 38.66791], [-121.46595, 38.66872], [-121.46583, 38.66866], [-121.46595, 38.66841], [-121.46579, 38.66833], [-121.46512, 38.6682], [-121.46418, 38.66813], [-121.46331, 38.66809], [-121.463, 38.66824], [-121.46235, 38.66836], [-121.46193, 38.66838], [-121.46111, 38.66833], [-121.46048, 38.66832], [-121.45968, 38.66858], [-121.45913, 38.66879], [-121.45875, 38.66888], [-121.45845, 38.66893], [-121.45814, 38.66895], [-121.4572, 38.66894], [-121.45713, 38.66904], [-121.45712, 38.66929], [-121.4569, 38.66927], [-121.4569, 38.66844], [-121.45715, 38.66844], [-121.4573, 38.66859], [-121.45804, 38.6686], [-121.45838, 38.66858], [-121.45884, 38.66849], [-121.45949, 38.66826], [-121.46, 38.66809], [-121.4603, 38.66801], [-121.46073, 38.66797], [-121.46113, 38.66797], [-121.46194, 38.66802], [-121.46228, 38.66801], [-121.46282, 38.6679], [-121.46319, 38.66773], [-121.46422, 38.66777], [-121.46423, 38.6678], [-121.46516, 38.66788], [-121.46575, 38.66796], [-121.46584, 38.6679], [-121.46596, 38.66791]]]} | Restricted Access 2 | 21781 | Dry Creek Watershed | 18286 | 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 | 8.226 | Dry Creek Watershed | 0 | Private Conservation 16 | 2 | |
15529 | 15529 | 15528 | {"type": "MultiPolygon", "coordinates": [[[[-116.37339, 33.20669], [-116.37126, 33.20669], [-116.3712, 33.20314], [-116.369, 33.20315], [-116.36895, 33.19964], [-116.37329, 33.19965], [-116.37339, 33.20669]]], [[[-116.36684, 33.20585], [-116.36473, 33.20589], [-116.36486, 33.21146], [-116.36444, 33.2114], [-116.364, 33.21137], [-116.36273, 33.21136], [-116.36269, 33.21043], [-116.36051, 33.21041], [-116.36039, 33.20494], [-116.3647, 33.20498], [-116.36682, 33.20495], [-116.36684, 33.20585]]]]} | Restricted Access 2 | 49075 | Unnamed site - Anza-Borrego Foundation | 33775 | 3004 | Anza-Borrego Foundation 836 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 3004 | Anza-Borrego Foundation 822 | Non Profit 6 | Non Profit - Land Trust 10 | https://theabf.org/ | San Diego 4 | 128.692 | 2019 | Private Other or Unknown 399 | 4 | |
4565 | 4565 | 4564 | {"type": "Polygon", "coordinates": [[[-115.25908, 33.44142], [-115.25691, 33.44141], [-115.25692, 33.44321], [-115.24776, 33.44322], [-115.24775, 33.43597], [-115.2538, 33.43597], [-115.25908, 33.44142]]]} | Restricted Access 2 | 35204 | Unnamed site - Riverside Land Conservancy | 28657 | 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 | 162.476 | 0 | Private Other or Unknown 399 | 4 | ||
4591 | 4591 | 4590 | {"type": "Polygon", "coordinates": [[[-115.2538, 33.43596], [-115.24775, 33.43597], [-115.24775, 33.43111], [-115.25054, 33.43293], [-115.25106, 33.4333], [-115.25155, 33.43373], [-115.2538, 33.43596]]]} | Restricted Access 2 | 35485 | Unnamed site - Riverside Land Conservancy | 28657 | 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 | 41.317 | 0 | Private Other or Unknown 399 | 4 | ||
4594 | 4594 | 4593 | {"type": "Polygon", "coordinates": [[[-117.34544, 33.91468], [-117.34509, 33.91482], [-117.34481, 33.91495], [-117.34443, 33.91447], [-117.3444, 33.91406], [-117.34438, 33.91401], [-117.34438, 33.91173], [-117.34444, 33.9118], [-117.34479, 33.91339], [-117.34492, 33.91372], [-117.34544, 33.91468]]]} | Restricted Access 2 | 35501 | Unnamed site - Riverside Land Conservancy | 28657 | 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 | 3.461 | 0 | Private Other or Unknown 399 | 4 | ||
4595 | 4595 | 4594 | {"type": "Polygon", "coordinates": [[[-117.34438, 33.91173], [-117.34438, 33.91401], [-117.3442, 33.91372], [-117.34412, 33.91332], [-117.34414, 33.91296], [-117.34378, 33.91232], [-117.3426, 33.91104], [-117.34229, 33.91079], [-117.34089, 33.91024], [-117.34062, 33.9102], [-117.34003, 33.91028], [-117.34003, 33.9097], [-117.3405, 33.90992], [-117.34147, 33.90992], [-117.34322, 33.91072], [-117.34323, 33.91092], [-117.34382, 33.91091], [-117.34438, 33.91173]]]} | Restricted Access 2 | 35502 | Unnamed site - Riverside Land Conservancy | 28657 | 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 | 8.55 | 0 | Private Other or Unknown 399 | 4 | ||
8005 | 8005 | 8004 | {"type": "MultiPolygon", "coordinates": [[[[-117.04813, 33.96332], [-117.04799, 33.96459], [-117.04296, 33.96421], [-117.04294, 33.96247], [-117.04813, 33.96332]]], [[[-117.11098, 33.97499], [-117.11056, 33.97488], [-117.11047, 33.97503], [-117.11042, 33.97501], [-117.1103, 33.97501], [-117.11025, 33.9748], [-117.10985, 33.97492], [-117.10991, 33.97466], [-117.10994, 33.97464], [-117.11008, 33.97458], [-117.11021, 33.97454], [-117.11027, 33.97454], [-117.11033, 33.97456], [-117.11041, 33.97462], [-117.11054, 33.97465], [-117.1108, 33.9747], [-117.11095, 33.9747], [-117.11098, 33.97499]]], [[[-117.10899, 33.97446], [-117.10892, 33.97454], [-117.10885, 33.9747], [-117.10883, 33.97481], [-117.10884, 33.975], [-117.1086, 33.97495], [-117.10849, 33.97519], [-117.10833, 33.97514], [-117.10821, 33.97513], [-117.10823, 33.97493], [-117.10842, 33.97491], [-117.10856, 33.97458], [-117.10879, 33.97435], [-117.10899, 33.97446]]], [[[-117.11021, 33.97445], [-117.11017, 33.9745], [-117.10992, 33.97458], [-117.10988, 33.97461], [-117.10985, 33.97465], [-117.10978, 33.9749], [-117.10976, 33.97492], [-117.10968, 33.97494], [-117.10963, 33.97499], [-117.10962, 33.97504], [-117.10964, 33.97507], [-117.1097, 33.9751], [-117.10977, 33.9751], [-117.10986, 33.97521], [-117.10958, 33.97522], [-117.10958, 33.97544], [-117.10936, 33.97544], [-117.10921, 33.97541], [-117.10921, 33.97518], [-117.10936, 33.97516], [-117.10936, 33.97506], [-117.10899, 33.97509], [-117.10897, 33.97492], [-117.10935, 33.97489], [-117.10935, 33.97473], [-117.10946, 33.9746], [-117.10956, 33.97455], [-117.10949, 33.97432], [-117.10977, 33.97426], [-117.11003, 33.97422], [-117.1102, 33.97441], [-117.11021, 33.97445]]]]} | Restricted Access 2 | 11290 | River Lands Conservancy | 24411 | 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 | 22.618 | River Lands Conservancy | 0 | Private Conservation 16 | 2 | |
4149 | 4149 | 4148 | {"type": "MultiPolygon", "coordinates": [[[[-122.32741, 37.14284], [-122.32714, 37.14347], [-122.32654, 37.14419], [-122.32659, 37.14425], [-122.32635, 37.14448], [-122.32503, 37.14518], [-122.3204, 37.14206], [-122.32012, 37.14206], [-122.31984, 37.14197], [-122.31969, 37.14186], [-122.31953, 37.1417], [-122.31951, 37.14157], [-122.3194, 37.14146], [-122.31921, 37.14132], [-122.31909, 37.14122], [-122.31847, 37.14093], [-122.31833, 37.14084], [-122.31822, 37.14074], [-122.31806, 37.14068], [-122.31789, 37.14063], [-122.31761, 37.14047], [-122.31728, 37.14035], [-122.31671, 37.14023], [-122.31598, 37.14017], [-122.31506, 37.14021], [-122.31469, 37.14019], [-122.31474, 37.13998], [-122.31591, 37.13998], [-122.31621, 37.14008], [-122.31682, 37.13974], [-122.31636, 37.13934], [-122.31598, 37.13892], [-122.31583, 37.13895], [-122.31581, 37.13892], [-122.31557, 37.139], [-122.31498, 37.13835], [-122.31505, 37.13831], [-122.31505, 37.13829], [-122.31314, 37.13613], [-122.31577, 37.13477], [-122.32065, 37.13982], [-122.32108, 37.14022], [-122.32156, 37.14058], [-122.32192, 37.14082], [-122.32236, 37.14106], [-122.32309, 37.1414], [-122.32348, 37.14156], [-122.32514, 37.1421], [-122.32517, 37.14208], [-122.32741, 37.14284]]], [[[-122.33433, 37.13521], [-122.33247, 37.13613], [-122.33252, 37.13834], [-122.33203, 37.13838], [-122.33175, 37.13834], [-122.33151, 37.13861], [-122.33151, 37.13868], [-122.33135, 37.13904], [-122.33118, 37.13917], [-122.33089, 37.13931], [-122.33051, 37.13942], [-122.33031, 37.13963], [-122.3302, 37.13989], [-122.33012, 37.14016], [-122.3299, 37.14031], [-122.32948, 37.14052], [-122.32877, 37.14075], [-122.32857, 37.14103], [-122.32809, 37.14106], [-122.32753, 37.1412], [-122.32688, 37.14128], [-122.32644, 37.14131], [-122.326, 37.14148], [-122.32563, 37.14174], [-122.32349, 37.14099], [-122.323, 37.1408], [-122.32236, 37.14048], [-122.32194, 37.14021], [-122.3217, 37.14004], [-122.32132, 37.13973], [-122.32111, 37.13953], [-122.31997, 37.13828], [-122.31976, 37.1381], [-122.31617, 37.13441], [-122.3303, 37.12878], [-122.33433, 37.13521]]]]} | Restricted Access 2 | 47513 | Cascade Ranch | 31226 | 3377 | Cascade Ranch Historic Farm 724 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3377 | Cascade Ranch Historic Farm 709 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 420.574 | Cascade Ranch | 2003 | Private Conservation 16 | 2 | ||
14457 | 14457 | 14456 | {"type": "Polygon", "coordinates": [[[-120.93673, 39.94566], [-120.93198, 39.94783], [-120.93058, 39.94473], [-120.9314, 39.9438], [-120.93159, 39.9436], [-120.93187, 39.94338], [-120.93217, 39.9432], [-120.93236, 39.94312], [-120.93268, 39.94302], [-120.93526, 39.94251], [-120.93609, 39.94426], [-120.93673, 39.94566]]]} | Restricted Access 2 | 47077 | Leonhardt Ranch Learning Landscape | 30731 | 3123 | Feather River Land Trust 720 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.frlt.org/ | Non Governmental Organization 10 | 3123 | Feather River Land Trust 703 | Non Profit 6 | Non Profit - Land Trust 10 | Plumas 57 | 46.846 | Leonhardt Ranch Learning Landscape | 0 | Private Conservation 16 | 2 | |
6251 | 6251 | 6250 | {"type": "MultiPolygon", "coordinates": [[[[-116.68093, 32.60085], [-116.68055, 32.60089], [-116.68054, 32.60089], [-116.68054, 32.60089], [-116.68093, 32.60085]]], [[[-116.68153, 32.60102], [-116.68153, 32.60106], [-116.68151, 32.60109], [-116.68151, 32.60109], [-116.68151, 32.6011], [-116.6815, 32.60111], [-116.68153, 32.60102], [-116.68152, 32.60097], [-116.68149, 32.60092], [-116.68139, 32.60088], [-116.68144, 32.60089], [-116.68147, 32.6009], [-116.68149, 32.60092], [-116.68152, 32.60097], [-116.68153, 32.60102]]], [[[-116.68378, 32.60165], [-116.68372, 32.60158], [-116.68369, 32.60157], [-116.68364, 32.60157], [-116.68358, 32.60161], [-116.68362, 32.60158], [-116.68364, 32.60157], [-116.68366, 32.60157], [-116.68369, 32.60157], [-116.68372, 32.60158], [-116.68375, 32.60159], [-116.68378, 32.60165]]], [[[-116.68386, 32.60207], [-116.68385, 32.60192], [-116.68383, 32.60185], [-116.68384, 32.60189], [-116.68386, 32.60194], [-116.68386, 32.60207]]], [[[-116.68386, 32.60209], [-116.68386, 32.60209], [-116.68386, 32.60211], [-116.68386, 32.60209]]], [[[-116.68202, 32.6024], [-116.68181, 32.60235], [-116.68154, 32.60236], [-116.68179, 32.60235], [-116.68182, 32.60236], [-116.68187, 32.60236], [-116.68202, 32.6024]]], [[[-116.68384, 32.60247], [-116.68384, 32.60249], [-116.68383, 32.60251], [-116.68383, 32.60251], [-116.68384, 32.60247]]], [[[-116.68435, 32.60337], [-116.68425, 32.60331], [-116.68408, 32.60322], [-116.68422, 32.60329], [-116.68432, 32.60334], [-116.68435, 32.60337]]], [[[-116.68439, 32.6034], [-116.68438, 32.60339], [-116.68438, 32.60339], [-116.68439, 32.6034]]], [[[-116.68669, 32.60192], [-116.68659, 32.60417], [-116.68563, 32.60407], [-116.68538, 32.604], [-116.68518, 32.60389], [-116.68441, 32.60326], [-116.68397, 32.60303], [-116.68394, 32.60299], [-116.68386, 32.60281], [-116.68385, 32.60276], [-116.68397, 32.60248], [-116.68399, 32.60197], [-116.6839, 32.6016], [-116.68386, 32.60154], [-116.68378, 32.60148], [-116.68364, 32.60146], [-116.68352, 32.6015], [-116.68325, 32.60182], [-116.68272, 32.60218], [-116.68265, 32.6022], [-116.6821, 32.6023], [-116.6818, 32.60224], [-116.68147, 32.60225], [-116.6814, 32.60224], [-116.68107, 32.60191], [-116.68104, 32.60186], [-116.68103, 32.60179], [-116.68104, 32.60174], [-116.68116, 32.60151], [-116.6816, 32.60118], [-116.68166, 32.60108], [-116.68166, 32.60098], [-116.68249, 32.60098], [-116.6825, 32.60053], [-116.68293, 32.60077], [-116.68338, 32.60096], [-116.68669, 32.60192]]]]} | Restricted Access 2 | 1326 | Conservation Fund | 17596 | 3087 | The Conservation Fund - California 675 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.conservationfund.org/ | Non Governmental Organization 10 | 3087 | The Conservation Fund - California 665 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 23.197 | Conservation Fund | 0 | Private Conservation 16 | 2 | |
14576 | 14576 | 14575 | {"type": "MultiPolygon", "coordinates": [[[[-123.41901, 38.84956], [-123.41868, 38.85299], [-123.4139, 38.85284], [-123.4142, 38.84946], [-123.41901, 38.84956]]], [[[-123.44031, 38.79111], [-123.44054, 38.79177], [-123.44067, 38.79262], [-123.44073, 38.79425], [-123.44072, 38.79498], [-123.44064, 38.79566], [-123.44047, 38.79626], [-123.44004, 38.79701], [-123.4395, 38.79761], [-123.43877, 38.79822], [-123.43799, 38.79872], [-123.43707, 38.7992], [-123.43616, 38.79966], [-123.43523, 38.80001], [-123.43309, 38.80089], [-123.43229, 38.80124], [-123.43157, 38.80164], [-123.431, 38.80211], [-123.43057, 38.80266], [-123.43025, 38.80323], [-123.43009, 38.80366], [-123.42973, 38.80497], [-123.42785, 38.80493], [-123.42934, 38.80727], [-123.42936, 38.80841], [-123.42954, 38.80893], [-123.43016, 38.80978], [-123.43081, 38.81047], [-123.43171, 38.81113], [-123.43269, 38.81172], [-123.43523, 38.81309], [-123.43579, 38.81351], [-123.43619, 38.81393], [-123.43622, 38.81425], [-123.43619, 38.82007], [-123.43644, 38.82562], [-123.43708, 38.82597], [-123.43778, 38.82649], [-123.43869, 38.82727], [-123.43929, 38.82807], [-123.44081, 38.82956], [-123.44157, 38.83022], [-123.44234, 38.8308], [-123.44371, 38.83153], [-123.4448, 38.83193], [-123.44733, 38.83233], [-123.45983, 38.82934], [-123.46213, 38.82948], [-123.46273, 38.83652], [-123.46524, 38.83658], [-123.46512, 38.83994], [-123.46504, 38.84698], [-123.47892, 38.84758], [-123.47896, 38.8502], [-123.47894, 38.85134], [-123.47898, 38.86227], [-123.47422, 38.86203], [-123.46488, 38.86134], [-123.4645, 38.86486], [-123.45962, 38.86448], [-123.4598, 38.86111], [-123.45496, 38.86076], [-123.4553, 38.85725], [-123.45073, 38.85695], [-123.45041, 38.86039], [-123.44566, 38.85999], [-123.44064, 38.85967], [-123.44109, 38.85667], [-123.43671, 38.85652], [-123.43604, 38.86108], [-123.43573, 38.86094], [-123.43546, 38.86079], [-123.43517, 38.86035], [-123.43513, 38.85992], [-123.43516, 38.85936], [-123.43379, 38.85935], [-123.43374, 38.85992], [-123.43178, 38.85993], [-123.4313, 38.86324], [-123.43121, 38.86454], [-123.43106, 38.86455], [-123.43086, 38.86463], [-123.43078, 38.86483], [-123.43078, 38.86493], [-123.43087, 38.86513], [-123.43092, 38.86534], [-123.43091, 38.86542], [-123.43077, 38.8657], [-123.43072, 38.86586], [-123.43072, 38.86609], [-123.4307, 38.86626], [-123.43063, 38.86644], [-123.43055, 38.86651], [-123.42996, 38.86678], [-123.42972, 38.86706], [-123.42932, 38.86726], [-123.42911, 38.86739], [-123.42891, 38.86765], [-123.42884, 38.86789], [-123.42885, 38.86798], [-123.42887, 38.86804], [-123.42891, 38.86807], [-123.42911, 38.86805], [-123.42938, 38.86807], [-123.42942, 38.86809], [-123.42954, 38.86823], [-123.42977, 38.86837], [-123.42992, 38.86853], [-123.43048, 38.86896], [-123.43108, 38.86926], [-123.43109, 38.87019], [-123.42668, 38.87024], [-123.42701, 38.86342], [-123.42729, 38.85984], [-123.42794, 38.85297], [-123.4283, 38.84974], [-123.424, 38.84965], [-123.42373, 38.84631], [-123.41399, 38.84598], [-123.41383, 38.84248], [-123.40891, 38.84235], [-123.4093, 38.84938], [-123.4091, 38.85263], [-123.40829, 38.85225], [-123.40716, 38.8518], [-123.40658, 38.85194], [-123.40562, 38.85212], [-123.40437, 38.852], [-123.40434, 38.85468], [-123.4041, 38.85443], [-123.40384, 38.85423], [-123.40372, 38.854], [-123.40358, 38.85378], [-123.40349, 38.85366], [-123.40341, 38.8536], [-123.4033, 38.85354], [-123.40239, 38.85337], [-123.40222, 38.85336], [-123.40198, 38.85337], [-123.40158, 38.85344], [-123.40144, 38.85344], [-123.40115, 38.8534], [-123.40099, 38.8534], [-123.4009, 38.85336], [-123.40088, 38.85328], [-123.40091, 38.85321], [-123.40101, 38.85317], [-123.4013, 38.85313], [-123.40145, 38.85303], [-123.40148, 38.85292], [-123.40147, 38.8528], [-123.4015, 38.8524], [-123.40158, 38.85206], [-123.40169, 38.85186], [-123.40183, 38.85172], [-123.40209, 38.85161], [-123.40232, 38.85157], [-123.40249, 38.85152], [-123.40273, 38.85141], [-123.40326, 38.85138], [-123.40338, 38.85136], [-123.40349, 38.85125], [-123.40349, 38.85119], [-123.4034, 38.85103], [-123.40338, 38.85093], [-123.40338, 38.85082], [-123.40346, 38.85057], [-123.40346, 38.85035], [-123.40343, 38.85022], [-123.40336, 38.85014], [-123.40314, 38.85001], [-123.40289, 38.84992], [-123.40237, 38.84981], [-123.40219, 38.84975], [-123.40152, 38.84925], [-123.40102, 38.84851], [-123.40081, 38.84841], [-123.4004, 38.84833], [-123.40023, 38.84832], [-123.40013, 38.84834], [-123.39998, 38.84842], [-123.39973, 38.84862], [-123.39963, 38.84868], [-123.39944, 38.84871], [-123.39881, 38.84873], [-123.39862, 38.84875], [-123.39847, 38.84879], [-123.39826, 38.84882], [-123.39798, 38.84882], [-123.39764, 38.84868], [-123.39744, 38.84862], [-123.39729, 38.84861], [-123.39706, 38.84869], [-123.397, 38.84869], [-123.39682, 38.84868], [-123.39667, 38.84865], [-123.39638, 38.8485], [-123.39617, 38.84835], [-123.39552, 38.84808], [-123.39495, 38.84799], [-123.39448, 38.8478], [-123.39404, 38.84753], [-123.39377, 38.84723], [-123.3931, 38.84658], [-123.39294, 38.84636], [-123.39284, 38.84627], [-123.3927, 38.84622], [-123.39246, 38.84619], [-123.39232, 38.84618], [-123.39215, 38.84613], [-123.39193, 38.84598], [-123.39165, 38.8459], [-123.39107, 38.84564], [-123.38933, 38.84435], [-123.38897, 38.84439], [-123.38879, 38.84444], [-123.38854, 38.84448], [-123.38812, 38.84446], [-123.38799, 38.84439], [-123.3877, 38.84414], [-123.38745, 38.84388], [-123.3873, 38.8438], [-123.38681, 38.84359], [-123.3866, 38.84352], [-123.38652, 38.84345], [-123.38587, 38.84326], [-123.38575, 38.84327], [-123.38558, 38.84332], [-123.3854, 38.8434], [-123.38516, 38.84345], [-123.38498, 38.84343], [-123.38462, 38.84329], [-123.38432, 38.84313], [-123.38411, 38.84305], [-123.38392, 38.843], [-123.38383, 38.84295], [-123.38376, 38.84288], [-123.38366, 38.84278], [-123.38349, 38.84256], [-123.38314, 38.84232], [-123.38298, 38.84213], [-123.38281, 38.84176], [-123.38258, 38.84102], [-123.38248, 38.84084], [-123.38161, 38.84038], [-123.38101, 38.83968], [-123.3804, 38.83912], [-123.37977, 38.83867], [-123.37887, 38.83824], [-123.37842, 38.83776], [-123.37789, 38.83713], [-123.37745, 38.83655], [-123.37703, 38.83602], [-123.37607, 38.83502], [-123.37545, 38.83514], [-123.37513, 38.83536], [-123.37425, 38.8358], [-123.3738, 38.83625], [-123.37287, 38.83695], [-123.37251, 38.83706], [-123.37213, 38.83704], [-123.37152, 38.83669], [-123.37122, 38.83638], [-123.3709, 38.836], [-123.37074, 38.83569], [-123.37038, 38.8353], [-123.37, 38.835], [-123.36957, 38.83458], [-123.36875, 38.83228], [-123.36893, 38.83088], [-123.3733, 38.83085], [-123.37331, 38.83084], [-123.37308, 38.8238], [-123.36887, 38.82379], [-123.36838, 38.82008], [-123.36839, 38.80966], [-123.36841, 38.80646], [-123.36841, 38.79905], [-123.3685, 38.79187], [-123.36832, 38.77718], [-123.37611, 38.77709], [-123.38225, 38.77708], [-123.38691, 38.77703], [-123.40395, 38.77682], [-123.41798, 38.77657], [-123.41895, 38.77657], [-123.41923, 38.77702], [-123.41982, 38.77731], [-123.4218, 38.77883], [-123.42286, 38.77936], [-123.4241, 38.78034], [-123.42588, 38.78038], [-123.42663, 38.78037], [-123.42812, 38.78025], [-123.42917, 38.78025], [-123.43052, 38.78027], [-123.43195, 38.78037], [-123.43314, 38.78041], [-123.43452, 38.7809], [-123.43557, 38.78148], [-123.43641, 38.78208], [-123.43702, 38.78278], [-123.4373, 38.78349], [-123.43774, 38.7847], [-123.43818, 38.78557], [-123.43873, 38.78656], [-123.43927, 38.78738], [-123.43961, 38.7881], [-123.43977, 38.78874], [-123.43988, 38.79005], [-123.44031, 38.79111]], [[-123.44438, 38.85014], [-123.44439, 38.85013], [-123.44431, 38.84658], [-123.442, 38.84651], [-123.44045, 38.84657], [-123.44029, 38.8464], [-123.44028, 38.84595], [-123.44007, 38.84575], [-123.43967, 38.84561], [-123.43922, 38.84583], [-123.43894, 38.84602], [-123.43877, 38.84633], [-123.43873, 38.84655], [-123.43924, 38.84696], [-123.43915, 38.84726], [-123.4375, 38.84728], [-123.43754, 38.84998], [-123.44206, 38.85011], [-123.44438, 38.85014]]]]} | Restricted Access 2 | 44702 | Gualala River Forest | 19561 | 3087 | The Conservation Fund - California 675 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.conservationfund.org/ | Non Governmental Organization 10 | 3087 | The Conservation Fund - California 665 | Non Profit 6 | Non Profit - Land Trust 10 | Mendocino 24 | 13558.087 | Gualala River Forest | 0 | Private Conservation 16 | 2 | |
14651 | 14651 | 14650 | {"type": "MultiPolygon", "coordinates": [[[[-123.75672, 39.54169], [-123.75661, 39.5417], [-123.75661, 39.54179], [-123.75658, 39.54188], [-123.75649, 39.54196], [-123.75635, 39.542], [-123.75619, 39.54198], [-123.75592, 39.54186], [-123.75556, 39.54176], [-123.75456, 39.54131], [-123.75265, 39.53993], [-123.75164, 39.53936], [-123.75094, 39.53903], [-123.74967, 39.53835], [-123.74937, 39.53821], [-123.74889, 39.53801], [-123.74859, 39.53784], [-123.74806, 39.53759], [-123.74792, 39.53747], [-123.74779, 39.53733], [-123.74772, 39.53713], [-123.74759, 39.5364], [-123.74759, 39.53625], [-123.74762, 39.5361], [-123.7477, 39.53596], [-123.74779, 39.53585], [-123.74821, 39.53551], [-123.74833, 39.53537], [-123.74844, 39.53521], [-123.74868, 39.53478], [-123.74875, 39.53458], [-123.74879, 39.5343], [-123.74879, 39.53412], [-123.74872, 39.53387], [-123.74841, 39.53339], [-123.7481, 39.53299], [-123.74776, 39.53264], [-123.74732, 39.53209], [-123.74604, 39.53053], [-123.74582, 39.53024], [-123.74523, 39.52958], [-123.74437, 39.52852], [-123.744, 39.5282], [-123.74378, 39.52805], [-123.74352, 39.52796], [-123.74258, 39.52775], [-123.74191, 39.52757], [-123.74093, 39.52745], [-123.7409, 39.52761], [-123.7414, 39.52767], [-123.74218, 39.52781], [-123.7432, 39.52803], [-123.7436, 39.52817], [-123.74389, 39.52833], [-123.74423, 39.52866], [-123.74499, 39.52958], [-123.74589, 39.5307], [-123.74636, 39.53121], [-123.74719, 39.53222], [-123.74759, 39.53276], [-123.74807, 39.53324], [-123.74846, 39.53375], [-123.74857, 39.53403], [-123.7486, 39.53421], [-123.74859, 39.53445], [-123.74855, 39.53462], [-123.7484, 39.5349], [-123.74826, 39.53517], [-123.74811, 39.53537], [-123.74798, 39.5355], [-123.74766, 39.53572], [-123.74756, 39.53584], [-123.74747, 39.53596], [-123.74741, 39.5361], [-123.74741, 39.5363], [-123.74753, 39.53708], [-123.74758, 39.53727], [-123.74766, 39.53741], [-123.74782, 39.53758], [-123.74802, 39.53773], [-123.74858, 39.53801], [-123.74815, 39.53805], [-123.74781, 39.53813], [-123.74758, 39.53821], [-123.74679, 39.53855], [-123.74498, 39.53837], [-123.74511, 39.53123], [-123.74058, 39.53121], [-123.74072, 39.52779], [-123.74071, 39.52759], [-123.74068, 39.52752], [-123.73798, 39.52756], [-123.73741, 39.52742], [-123.73702, 39.52727], [-123.73662, 39.52705], [-123.73613, 39.52673], [-123.73545, 39.52642], [-123.73509, 39.52694], [-123.73448, 39.52668], [-123.73451, 39.52661], [-123.73473, 39.52628], [-123.73447, 39.52619], [-123.73424, 39.52619], [-123.73395, 39.52622], [-123.73381, 39.52626], [-123.73393, 39.52693], [-123.73309, 39.52705], [-123.73286, 39.52512], [-123.73192, 39.52523], [-123.73197, 39.52387], [-123.7409, 39.52395], [-123.74516, 39.52394], [-123.74505, 39.52766], [-123.74954, 39.52769], [-123.74939, 39.53006], [-123.7496, 39.53027], [-123.74987, 39.53029], [-123.75022, 39.53041], [-123.75044, 39.53057], [-123.75061, 39.53079], [-123.75082, 39.53097], [-123.75148, 39.53132], [-123.75149, 39.53331], [-123.75154, 39.53459], [-123.75429, 39.5346], [-123.75607, 39.53459], [-123.75571, 39.53707], [-123.75565, 39.53771], [-123.75566, 39.53839], [-123.75577, 39.53915], [-123.75596, 39.53997], [-123.75625, 39.54082], [-123.75672, 39.54169]], [[-123.73605, 39.52571], [-123.73614, 39.52557], [-123.73548, 39.52528], [-123.73515, 39.52572], [-123.73516, 39.52573], [-123.73605, 39.52571]]], [[[-123.74648, 39.54562], [-123.74527, 39.54564], [-123.74505, 39.54313], [-123.74594, 39.54407], [-123.74613, 39.54436], [-123.74626, 39.54471], [-123.74648, 39.54562]]], [[[-123.75423, 39.54137], [-123.75357, 39.54166], [-123.75343, 39.54142], [-123.753, 39.54103], [-123.75263, 39.54058], [-123.7523, 39.54038], [-123.75157, 39.54], [-123.75065, 39.53965], [-123.74995, 39.53946], [-123.74889, 39.53933], [-123.74809, 39.53939], [-123.74698, 39.53964], [-123.74621, 39.5399], [-123.74597, 39.54009], [-123.74589, 39.54023], [-123.74589, 39.54034], [-123.74597, 39.54049], [-123.74619, 39.5407], [-123.74664, 39.54101], [-123.74686, 39.54138], [-123.74696, 39.54169], [-123.74708, 39.54196], [-123.74723, 39.54217], [-123.74737, 39.5423], [-123.74772, 39.54245], [-123.74792, 39.54257], [-123.7481, 39.54276], [-123.74817, 39.54293], [-123.74817, 39.54319], [-123.74791, 39.54404], [-123.7479, 39.54422], [-123.74796, 39.54444], [-123.74813, 39.54467], [-123.74882, 39.54535], [-123.74919, 39.54562], [-123.74666, 39.54563], [-123.7464, 39.54451], [-123.7463, 39.54427], [-123.74619, 39.54407], [-123.74593, 39.54376], [-123.74568, 39.54355], [-123.74495, 39.54275], [-123.74482, 39.54249], [-123.74478, 39.54225], [-123.74482, 39.54197], [-123.74492, 39.54153], [-123.7453, 39.54012], [-123.74544, 39.53984], [-123.74563, 39.53958], [-123.74586, 39.53931], [-123.74608, 39.53914], [-123.74699, 39.53869], [-123.74702, 39.53873], [-123.74794, 39.53834], [-123.7485, 39.53826], [-123.74881, 39.5383], [-123.74912, 39.53841], [-123.7497, 39.53871], [-123.75035, 39.53896], [-123.7512, 39.53934], [-123.75209, 39.53983], [-123.75268, 39.54022], [-123.75324, 39.54062], [-123.75423, 39.54137]]]]} | Restricted Access 2 | 44911 | Ten Mile | 26239 | 3087 | The Conservation Fund - California 675 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.conservationfund.org/ | Non Governmental Organization 10 | 3087 | The Conservation Fund - California 665 | Non Profit 6 | Non Profit - Land Trust 10 | Mendocino 24 | 388.428 | Ten Mile | 0 | Private Conservation 16 | 2 | |
4904 | 4904 | 4903 | {"type": "Polygon", "coordinates": [[[-120.29165, 39.28907], [-120.28251, 39.28896], [-120.28251, 39.28535], [-120.29164, 39.28546], [-120.29165, 39.28907]]]} | Restricted Access 2 | 48986 | Hooper LaPlante | 33681 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.truckeedonnerlandtrust.org/ | Placer 35 | 78.05 | Hooper LaPlante | 0 | Private Conservation 16 | 2 |
14008 | 14008 | 14007 | {"type": "Polygon", "coordinates": [[[-120.45497, 39.44576], [-120.43752, 39.44578], [-120.43748, 39.43272], [-120.44146, 39.43275], [-120.44212, 39.43272], [-120.44281, 39.43275], [-120.45473, 39.43272], [-120.45489, 39.44426], [-120.45497, 39.44576]]]} | Restricted Access 2 | 37009 | Webber Lake and Lacey Meadows | 27324 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 533.587 | Webber Lake and Lacey Meadows | 0 | Private Conservation 16 | 2 | |
14184 | 14184 | 14183 | {"type": "Polygon", "coordinates": [[[-120.45515, 39.44723], [-120.43753, 39.44713], [-120.43757, 39.46105], [-120.42258, 39.46109], [-120.42275, 39.46508], [-120.42725, 39.46533], [-120.432, 39.46551], [-120.43191, 39.46904], [-120.43759, 39.46942], [-120.43761, 39.47565], [-120.42672, 39.47564], [-120.42801, 39.49003], [-120.41908, 39.4899], [-120.41914, 39.49739], [-120.41186, 39.497], [-120.41144, 39.49703], [-120.40982, 39.49723], [-120.40157, 39.49648], [-120.40111, 39.48301], [-120.40548, 39.48306], [-120.40505, 39.47561], [-120.40979, 39.47561], [-120.40836, 39.46112], [-120.41859, 39.46109], [-120.41827, 39.44701], [-120.43752, 39.44713], [-120.43752, 39.44609], [-120.4412, 39.446], [-120.44744, 39.44625], [-120.45063, 39.44611], [-120.45498, 39.44611], [-120.455, 39.44702], [-120.45515, 39.44723]]]} | Restricted Access 2 | 43108 | Webber Lake and Lacey Meadows | 27324 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Sierra 58 | 2562.263 | Webber Lake and Lacey Meadows | 0 | Private Conservation 16 | 2 | |
15724 | 15724 | 15723 | {"type": "Polygon", "coordinates": [[[-120.15979, 39.35605], [-120.15917, 39.35687], [-120.15867, 39.35761], [-120.15837, 39.35812], [-120.15809, 39.35864], [-120.15766, 39.35956], [-120.15084, 39.35953], [-120.14169, 39.35945], [-120.1417, 39.35904], [-120.14249, 39.35866], [-120.1432, 39.35835], [-120.14388, 39.35799], [-120.14467, 39.3575], [-120.14541, 39.35696], [-120.14578, 39.35665], [-120.1489, 39.35367], [-120.15846, 39.34589], [-120.15693, 39.3498], [-120.15755, 39.3498], [-120.15794, 39.34996], [-120.15825, 39.35026], [-120.15839, 39.35056], [-120.15794, 39.3547], [-120.15803, 39.35493], [-120.15833, 39.3553], [-120.15979, 39.35605]]]} | Restricted Access 2 | 44736 | Old Greenwood Golf Course | 33108 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 258.402 | Old Greenwood GC | 0 | Private Recreation or Education 65 | 4 | |
15725 | 15725 | 15724 | {"type": "MultiPolygon", "coordinates": [[[[-120.16777, 39.32371], [-120.16732, 39.32424], [-120.16563, 39.32376], [-120.16561, 39.32386], [-120.16581, 39.3241], [-120.16572, 39.32418], [-120.1656, 39.32411], [-120.16508, 39.32443], [-120.16493, 39.32458], [-120.16286, 39.32477], [-120.16153, 39.32476], [-120.16136, 39.32504], [-120.16135, 39.32548], [-120.16125, 39.32555], [-120.16113, 39.32561], [-120.161, 39.32564], [-120.16081, 39.32566], [-120.16081, 39.32247], [-120.16499, 39.32236], [-120.16777, 39.32371]]], [[[-120.17072, 39.32608], [-120.17051, 39.32637], [-120.17011, 39.32617], [-120.1701, 39.32604], [-120.16081, 39.32611], [-120.16081, 39.32583], [-120.1611, 39.3258], [-120.16131, 39.32572], [-120.16138, 39.32581], [-120.16245, 39.32571], [-120.16317, 39.32559], [-120.1645, 39.32524], [-120.16475, 39.32561], [-120.16713, 39.325], [-120.16742, 39.32482], [-120.16718, 39.32458], [-120.16732, 39.32449], [-120.16745, 39.32437], [-120.16794, 39.32379], [-120.17013, 39.32486], [-120.17072, 39.32608]]]]} | Restricted Access 2 | 44739 | Ponderosa Golf Course | 33109 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | Nevada 30 | 52.893 | Ponderosa GC | 0 | Private Recreation or Education 65 | 4 | |
3725 | 3725 | 3724 | {"type": "Polygon", "coordinates": [[[-121.79546, 37.80038], [-121.78656, 37.80059], [-121.78629, 37.79553], [-121.79272, 37.79569], [-121.79534, 37.79581], [-121.79536, 37.79761], [-121.79527, 37.79956], [-121.79546, 37.80038]]]} | Restricted Access 2 | 44708 | Highland Springs | 19939 | 3073 | Save Mount Diablo 633 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 104.068 | Highland Springs | 0 | Private Conservation 16 | 2 | |
5502 | 5502 | 5501 | {"type": "Polygon", "coordinates": [[[-121.86775, 37.88967], [-121.86773, 37.89262], [-121.86305, 37.89266], [-121.86296, 37.8891], [-121.85868, 37.8891], [-121.85869, 37.88548], [-121.86322, 37.88545], [-121.86466, 37.88548], [-121.8647, 37.88562], [-121.86472, 37.88588], [-121.86455, 37.88655], [-121.86486, 37.88681], [-121.86542, 37.8876], [-121.86593, 37.88815], [-121.866, 37.88863], [-121.86574, 37.88912], [-121.86545, 37.88935], [-121.86551, 37.88951], [-121.86626, 37.88943], [-121.86694, 37.88947], [-121.86775, 37.88967]]]} | Restricted Access 2 | 47797 | Anderson Ranch | 31682 | 3073 | Save Mount Diablo 633 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | Contra Costa 12 | 95.912 | Anderson Ranch | 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]);