units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
205 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 10 sorted by MNG_AGENCY descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- The Wildlands Conservancy 20
- Truckee Donner Land Trust 19
- Center for Natural Lands Management 11
- Fallbrook Land Conservancy 10
- Friends of the Desert Mountains 8
- Coastside Land Trust 8
- Land Trust of Santa Cruz County 7
- Mojave Desert Land Trust 7
- Los Angeles Neighborhood Land Trust 6
- Ojai Valley Land Conservancy 6
- The Nature Conservancy 5
- Bear Yuba Land Trust 5
- Sonoma Land Trust 5
- Tuleyome 5
- Trinidad Coastal Land Trust 5
- Save the Redwoods League 4
- John Muir Land Trust 4
- Sierra Foothill Conservancy 4
- Arroyos and Foothills Conservancy 4
- Mendocino Land Trust 4
- Wilderness Land Trust 4
- American River Conservancy 4
- Feather River Land Trust 4
- Big Sur Land Trust 3
- Land Trust for Santa Barbara County 3
- San Dieguito River Valley Land Conservancy 3
- San Joaquin River Parkway and Conservation Trust 3
- Eastern Sierra Land Trust 3
- Land Trust of Napa County 2
- Back Country Land Trust 2
- …
DES_TP 9
MNG_AG_TYP 1
- Non Profit - Land Trust · 205 ✖
ACCESS_TYP 1
- Open Access · 205 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16917 | 16917 | 16916 | {"type": "MultiPolygon", "coordinates": [[[[-116.59408, 33.15137], [-116.5897, 33.15166], [-116.58967, 33.1474], [-116.5906, 33.14589], [-116.59217, 33.14588], [-116.59219, 33.14793], [-116.59401, 33.14784], [-116.59407, 33.15133], [-116.59408, 33.15137]]], [[[-116.60729, 33.13867], [-116.60595, 33.14048], [-116.60542, 33.14383], [-116.60515, 33.14379], [-116.60489, 33.14372], [-116.60467, 33.14363], [-116.60434, 33.14346], [-116.60408, 33.14337], [-116.60384, 33.14332], [-116.60345, 33.14327], [-116.60035, 33.14481], [-116.59837, 33.14496], [-116.59831, 33.14088], [-116.59792, 33.14069], [-116.59776, 33.14065], [-116.59759, 33.14064], [-116.59734, 33.14068], [-116.59708, 33.14078], [-116.59669, 33.1409], [-116.59628, 33.14097], [-116.59573, 33.14101], [-116.59525, 33.14098], [-116.59498, 33.14091], [-116.59491, 33.1408], [-116.5949, 33.14068], [-116.59486, 33.14058], [-116.59479, 33.1405], [-116.59469, 33.14043], [-116.59454, 33.14037], [-116.59404, 33.14029], [-116.59385, 33.1403], [-116.59366, 33.14037], [-116.59355, 33.14044], [-116.59325, 33.1407], [-116.59334, 33.14043], [-116.59342, 33.14027], [-116.59353, 33.14013], [-116.59361, 33.14016], [-116.59395, 33.13963], [-116.59383, 33.13914], [-116.59385, 33.1356], [-116.59825, 33.13536], [-116.59829, 33.13385], [-116.59827, 33.12787], [-116.6003, 33.12794], [-116.60103, 33.12798], [-116.60142, 33.12798], [-116.60155, 33.13262], [-116.60124, 33.1326], [-116.60134, 33.13326], [-116.60152, 33.13326], [-116.60171, 33.13324], [-116.60217, 33.13306], [-116.60256, 33.13297], [-116.6029, 33.13297], [-116.60297, 33.13299], [-116.60304, 33.13305], [-116.60311, 33.1332], [-116.60309, 33.13325], [-116.60306, 33.1333], [-116.60296, 33.13335], [-116.60279, 33.13339], [-116.60263, 33.13346], [-116.60252, 33.13353], [-116.60246, 33.13361], [-116.60244, 33.13368], [-116.60245, 33.13418], [-116.60241, 33.1344], [-116.60344, 33.13434], [-116.60353, 33.1343], [-116.60358, 33.13427], [-116.60367, 33.13401], [-116.60423, 33.13395], [-116.60462, 33.13382], [-116.60492, 33.13354], [-116.60483, 33.13294], [-116.60704, 33.13315], [-116.60729, 33.13867]]]]} | Open Access 1 | 46819 | Volcan Mountain Wilderness Preserve | 30284 | 3333 | Volcan Mountain Preserve Foundation 1182 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.volcanmt.org/acquisition-projects-accomplishments | Non Governmental Organization 10 | 3333 | Volcan Mountain Preserve Foundation 1120 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.volcanmt.org | San Diego 4 | 381.895 | Volcan Mtn. Wilderness Preserve | 0 | Private Conservation 16 | 2 |
14668 | 14668 | 14667 | {"type": "Polygon", "coordinates": [[[-122.31117, 41.31557], [-122.31075, 41.3159], [-122.31093, 41.31615], [-122.31111, 41.31631], [-122.31112, 41.31722], [-122.30817, 41.31723], [-122.31116, 41.31505], [-122.31117, 41.31557]]]} | Open Access 1 | 48307 | Sisson Meadow | 32876 | 3101 | Shasta Land Trust 1118 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.shastalandtrust.org/ | Non Governmental Organization 10 | 3101 | Shasta Land Trust 1072 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.siskiyoulandtrust.org/projects-2/sisson-meadow/ | Siskiyou 28 | 6.987 | Sisson Meadow | 2003 | Private Conservation 16 | 2 |
14429 | 14429 | 14428 | {"type": "Polygon", "coordinates": [[[-119.27805, 34.44329], [-119.27769, 34.44431], [-119.27478, 34.4436], [-119.27445, 34.44452], [-119.27212, 34.44395], [-119.27099, 34.44709], [-119.2703, 34.44551], [-119.27013, 34.44518], [-119.26995, 34.44489], [-119.26995, 34.44484], [-119.26999, 34.4448], [-119.26984, 34.44459], [-119.26978, 34.4446], [-119.26972, 34.44458], [-119.26946, 34.44428], [-119.26922, 34.44404], [-119.27049, 34.44044], [-119.27296, 34.44104], [-119.273, 34.44096], [-119.27484, 34.44141], [-119.27476, 34.44163], [-119.27388, 34.44142], [-119.27372, 34.44185], [-119.27447, 34.44204], [-119.27435, 34.44241], [-119.27621, 34.44287], [-119.27648, 34.44181], [-119.27664, 34.44185], [-119.27638, 34.4429], [-119.27639, 34.44296], [-119.27642, 34.44302], [-119.27651, 34.44306], [-119.278, 34.44331], [-119.27805, 34.44329]]]} | Open Access 1 | 48256 | Ojai Meadows Preserve | 32807 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/ojai-meadows-preserve/ | Ventura 8 | 57.567 | Ojai Meadows Preserve | 0 | Private Conservation 16 | 2 |
14431 | 14431 | 14430 | {"type": "Polygon", "coordinates": [[[-119.32074, 34.44659], [-119.31997, 34.44697], [-119.31959, 34.44753], [-119.31966, 34.44777], [-119.31991, 34.44793], [-119.31988, 34.44867], [-119.32047, 34.44898], [-119.32056, 34.44894], [-119.32043, 34.45608], [-119.31154, 34.45623], [-119.31159, 34.45399], [-119.31158, 34.45398], [-119.30262, 34.45901], [-119.30243, 34.46356], [-119.2962, 34.46364], [-119.29568, 34.46299], [-119.29521, 34.46301], [-119.29487, 34.4626], [-119.29444, 34.46201], [-119.29443, 34.46153], [-119.29411, 34.46052], [-119.29309, 34.46035], [-119.2929, 34.46038], [-119.29287, 34.46026], [-119.29287, 34.4602], [-119.29292, 34.46008], [-119.29345, 34.45923], [-119.2935, 34.45916], [-119.29358, 34.4591], [-119.29402, 34.45888], [-119.29434, 34.4588], [-119.29436, 34.45885], [-119.29448, 34.45884], [-119.29459, 34.45886], [-119.29488, 34.45902], [-119.29512, 34.45909], [-119.29538, 34.4591], [-119.29561, 34.45907], [-119.29584, 34.45898], [-119.29602, 34.45885], [-119.29616, 34.4587], [-119.29632, 34.45841], [-119.29623, 34.45837], [-119.29628, 34.45825], [-119.2963, 34.45813], [-119.29627, 34.45796], [-119.29621, 34.45785], [-119.29612, 34.45775], [-119.29573, 34.45742], [-119.29588, 34.45694], [-119.2967, 34.45519], [-119.29685, 34.45439], [-119.29691, 34.45439], [-119.29692, 34.45433], [-119.29692, 34.4542], [-119.29682, 34.45361], [-119.29683, 34.45353], [-119.29686, 34.45345], [-119.29713, 34.45302], [-119.29718, 34.45288], [-119.2972, 34.45269], [-119.29701, 34.45268], [-119.29697, 34.45123], [-119.29694, 34.45122], [-119.29692, 34.45106], [-119.29689, 34.45095], [-119.29678, 34.45076], [-119.29603, 34.44982], [-119.29595, 34.4497], [-119.2959, 34.44958], [-119.29585, 34.44942], [-119.29584, 34.44928], [-119.29586, 34.44912], [-119.29592, 34.44892], [-119.29885, 34.44294], [-119.29913, 34.4427], [-119.30065, 34.44314], [-119.30071, 34.44315], [-119.30079, 34.44313], [-119.30086, 34.44306], [-119.30087, 34.44299], [-119.30085, 34.44295], [-119.3007, 34.44281], [-119.30065, 34.44272], [-119.30064, 34.44265], [-119.30064, 34.44241], [-119.30045, 34.44236], [-119.30042, 34.44276], [-119.30035, 34.44283], [-119.30024, 34.44284], [-119.29936, 34.44259], [-119.29978, 34.44241], [-119.2992, 34.44227], [-119.29882, 34.44254], [-119.29575, 34.44884], [-119.29566, 34.44909], [-119.29564, 34.44927], [-119.29566, 34.44945], [-119.2957, 34.44962], [-119.29578, 34.44978], [-119.29588, 34.44993], [-119.29591, 34.44992], [-119.29662, 34.45081], [-119.29673, 34.45101], [-119.29677, 34.45119], [-119.29679, 34.45211], [-119.29673, 34.45212], [-119.29662, 34.4528], [-119.29633, 34.45327], [-119.29627, 34.45346], [-119.29626, 34.45366], [-119.2963, 34.45367], [-119.29639, 34.45428], [-119.29625, 34.45509], [-119.29545, 34.4568], [-119.2952, 34.45722], [-119.29515, 34.45736], [-119.29515, 34.45745], [-119.29517, 34.45755], [-119.29521, 34.45764], [-119.29528, 34.45773], [-119.29542, 34.45783], [-119.29574, 34.45796], [-119.29583, 34.45805], [-119.29585, 34.45811], [-119.29584, 34.45818], [-119.2957, 34.45844], [-119.29574, 34.45847], [-119.29567, 34.45856], [-119.29556, 34.45863], [-119.29545, 34.45868], [-119.29531, 34.45869], [-119.29514, 34.45866], [-119.29485, 34.45851], [-119.2947, 34.45846], [-119.29451, 34.45843], [-119.29431, 34.45844], [-119.29384, 34.45856], [-119.29334, 34.45881], [-119.2932, 34.45891], [-119.29309, 34.45902], [-119.29252, 34.45993], [-119.29248, 34.46004], [-119.29245, 34.46014], [-119.29244, 34.46026], [-119.29246, 34.46038], [-119.28926, 34.46041], [-119.2913, 34.44458], [-119.29138, 34.44449], [-119.2914, 34.44452], [-119.29158, 34.44437], [-119.29207, 34.44413], [-119.29226, 34.44399], [-119.29291, 34.44359], [-119.29312, 34.44329], [-119.29327, 34.44319], [-119.29367, 34.443], [-119.29419, 34.44282], [-119.29456, 34.44275], [-119.2951, 34.44284], [-119.29539, 34.44292], [-119.29558, 34.443], [-119.29585, 34.44291], [-119.29602, 34.44277], [-119.29607, 34.44257], [-119.29618, 34.44231], [-119.29629, 34.44215], [-119.29636, 34.44158], [-119.29651, 34.44135], [-119.29658, 34.44113], [-119.29673, 34.44088], [-119.29689, 34.44076], [-119.29698, 34.44065], [-119.29706, 34.4403], [-119.29735, 34.43997], [-119.29743, 34.43979], [-119.29733, 34.43978], [-119.2975, 34.43943], [-119.2974, 34.439], [-119.29747, 34.43839], [-119.29746, 34.43812], [-119.29747, 34.43786], [-119.29735, 34.43763], [-119.2973, 34.4373], [-119.29706, 34.43698], [-119.29685, 34.43658], [-119.29671, 34.4362], [-119.29664, 34.43578], [-119.29636, 34.43493], [-119.29638, 34.43472], [-119.29648, 34.43472], [-119.29653, 34.4343], [-119.29657, 34.43358], [-119.29663, 34.43326], [-119.29646, 34.43272], [-119.29639, 34.43245], [-119.29826, 34.42815], [-119.3032, 34.4259], [-119.30349, 34.4258], [-119.3043, 34.42658], [-119.30437, 34.4271], [-119.30557, 34.42893], [-119.30553, 34.42947], [-119.30496, 34.43061], [-119.30508, 34.43159], [-119.30487, 34.43196], [-119.30387, 34.43264], [-119.30329, 34.43336], [-119.30327, 34.43462], [-119.3034, 34.43527], [-119.30305, 34.43595], [-119.30157, 34.43754], [-119.30164, 34.4383], [-119.30136, 34.43923], [-119.30089, 34.43994], [-119.30054, 34.44083], [-119.30003, 34.44117], [-119.30059, 34.44156], [-119.30019, 34.44178], [-119.30011, 34.44225], [-119.30066, 34.44194], [-119.30067, 34.44214], [-119.3012, 34.44185], [-119.30231, 34.44151], [-119.3023, 34.44146], [-119.30238, 34.44145], [-119.30252, 34.44145], [-119.30264, 34.44148], [-119.30312, 34.44178], [-119.30329, 34.44186], [-119.30349, 34.4419], [-119.30369, 34.44191], [-119.30393, 34.44188], [-119.30658, 34.44112], [-119.30679, 34.44108], [-119.30705, 34.44108], [-119.30706, 34.44112], [-119.30735, 34.44119], [-119.30782, 34.44141], [-119.30802, 34.44146], [-119.30822, 34.44147], [-119.30846, 34.44144], [-119.30869, 34.44136], [-119.30887, 34.44124], [-119.30883, 34.4412], [-119.30901, 34.44105], [-119.30911, 34.44099], [-119.30923, 34.44096], [-119.31227, 34.44099], [-119.31244, 34.44098], [-119.31259, 34.44094], [-119.31515, 34.44417], [-119.32074, 34.44659]]]} | Open Access 1 | 48253 | Ventura River Preserve | 32805 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/ventura-river-rancho-el-nido/ | Ventura 8 | 1434.839 | Ventura River Preserve | 0 | Private Conservation 16 | 2 |
14433 | 14433 | 14432 | {"type": "MultiPolygon", "coordinates": [[[[-119.25067, 34.46479], [-119.25063, 34.46704], [-119.2506, 34.47067], [-119.23676, 34.47049], [-119.23685, 34.46486], [-119.23694, 34.46472], [-119.23738, 34.4646], [-119.23742, 34.46464], [-119.23746, 34.46475], [-119.23747, 34.46484], [-119.23746, 34.46504], [-119.23738, 34.46541], [-119.23738, 34.46552], [-119.23742, 34.46565], [-119.23753, 34.46591], [-119.23761, 34.46603], [-119.2378, 34.46614], [-119.23788, 34.46617], [-119.238, 34.46618], [-119.2381, 34.46616], [-119.23821, 34.46612], [-119.23878, 34.46578], [-119.23916, 34.46561], [-119.23926, 34.46559], [-119.23964, 34.46563], [-119.23975, 34.46561], [-119.23986, 34.46556], [-119.23996, 34.46547], [-119.24002, 34.46535], [-119.24003, 34.46527], [-119.24002, 34.46497], [-119.24005, 34.46489], [-119.24011, 34.46482], [-119.2402, 34.46475], [-119.24045, 34.46465], [-119.24055, 34.46466], [-119.24074, 34.46472], [-119.2408, 34.46476], [-119.2409, 34.46487], [-119.24094, 34.46496], [-119.24092, 34.46523], [-119.24094, 34.46535], [-119.24105, 34.46548], [-119.24121, 34.46556], [-119.24132, 34.46557], [-119.24144, 34.46554], [-119.24178, 34.46526], [-119.24187, 34.46523], [-119.24193, 34.46524], [-119.24198, 34.46527], [-119.24207, 34.46542], [-119.24218, 34.46551], [-119.24232, 34.46555], [-119.24247, 34.46553], [-119.2426, 34.46547], [-119.24307, 34.46505], [-119.24314, 34.46502], [-119.24321, 34.465], [-119.24334, 34.46502], [-119.24343, 34.46508], [-119.24348, 34.46513], [-119.24355, 34.46532], [-119.24364, 34.46541], [-119.24371, 34.46545], [-119.24379, 34.46549], [-119.24392, 34.46551], [-119.24411, 34.46547], [-119.24425, 34.46539], [-119.24436, 34.46527], [-119.24442, 34.46518], [-119.24446, 34.46506], [-119.24458, 34.46455], [-119.24467, 34.46437], [-119.24536, 34.46346], [-119.24544, 34.46341], [-119.24551, 34.46339], [-119.24561, 34.4634], [-119.24571, 34.46344], [-119.24594, 34.46372], [-119.24602, 34.46378], [-119.24616, 34.46385], [-119.24629, 34.46386], [-119.24641, 34.46385], [-119.24651, 34.46381], [-119.24659, 34.46376], [-119.24666, 34.46369], [-119.2467, 34.46359], [-119.24672, 34.4635], [-119.2467, 34.46342], [-119.24667, 34.46333], [-119.2483, 34.46335], [-119.24844, 34.46381], [-119.24848, 34.4639], [-119.24856, 34.464], [-119.24867, 34.46409], [-119.24881, 34.46417], [-119.24894, 34.46422], [-119.24917, 34.46426], [-119.24928, 34.46432], [-119.24938, 34.46442], [-119.24947, 34.46463], [-119.24958, 34.46473], [-119.24969, 34.46478], [-119.24981, 34.4648], [-119.25031, 34.46474], [-119.25045, 34.46475], [-119.25067, 34.46479]]], [[[-119.24645, 34.46333], [-119.24651, 34.46346], [-119.2465, 34.46358], [-119.24646, 34.46363], [-119.24641, 34.46367], [-119.24629, 34.4637], [-119.2462, 34.46368], [-119.24612, 34.46364], [-119.24584, 34.46332], [-119.24645, 34.46333]]], [[[-119.2507, 34.46338], [-119.25067, 34.46462], [-119.25049, 34.46459], [-119.2503, 34.46458], [-119.24985, 34.46464], [-119.24976, 34.46462], [-119.24966, 34.46457], [-119.24963, 34.46452], [-119.24954, 34.46432], [-119.24945, 34.46423], [-119.24937, 34.46417], [-119.24921, 34.4641], [-119.24891, 34.46403], [-119.24874, 34.46392], [-119.24869, 34.46386], [-119.24863, 34.46376], [-119.24851, 34.46339], [-119.24857, 34.46335], [-119.2507, 34.46338]]]]} | Open Access 1 | 48254 | Valley View Preserve | 32806 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/valley-view-preserve/ | Ventura 8 | 208.805 | Valley View Preserve | 0 | Private Conservation 16 | 2 |
14700 | 14700 | 14699 | {"type": "Polygon", "coordinates": [[[-119.17097, 34.46273], [-119.16225, 34.46274], [-119.16227, 34.45928], [-119.17096, 34.45919], [-119.17097, 34.46273]]]} | Open Access 1 | 48311 | Ilvento Preserve | 32879 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/ilvento/ | Ventura 8 | 76.715 | Ilvento Preserve | 1997 | Private Conservation 16 | 2 |
14701 | 14701 | 14700 | {"type": "Polygon", "coordinates": [[[-119.31061, 34.3893], [-119.30984, 34.39525], [-119.3074, 34.39503], [-119.30777, 34.39226], [-119.30787, 34.39109], [-119.30782, 34.39089], [-119.30758, 34.39039], [-119.30751, 34.39018], [-119.30745, 34.38994], [-119.30742, 34.38972], [-119.30743, 34.38939], [-119.30748, 34.38909], [-119.30759, 34.38877], [-119.30815, 34.38775], [-119.30831, 34.38732], [-119.3084, 34.38688], [-119.30843, 34.3865], [-119.31055, 34.3867], [-119.30993, 34.38752], [-119.31, 34.38844], [-119.31061, 34.3893]]]} | Open Access 1 | 48312 | Rio Vista Preserve | 32880 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/rio-vista-preserve/ | Ventura 8 | 53.272 | Rio Vista Preserve | 2009 | Private Conservation 16 | 2 |
14775 | 14775 | 14774 | {"type": "MultiPolygon", "coordinates": [[[[-119.30699, 34.38027], [-119.30462, 34.38044], [-119.30512, 34.37949], [-119.30634, 34.37676], [-119.30649, 34.37654], [-119.30663, 34.37735], [-119.30655, 34.37739], [-119.30656, 34.37746], [-119.30665, 34.37743], [-119.30658, 34.37809], [-119.3066, 34.37844], [-119.30664, 34.37866], [-119.30674, 34.37905], [-119.30691, 34.37902], [-119.30699, 34.38027]]], [[[-119.30728, 34.37477], [-119.30685, 34.37623], [-119.30682, 34.37632], [-119.30652, 34.37483], [-119.30728, 34.37477]]]]} | Open Access 1 | 48318 | Ventura River Confluence Preserve | 32882 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/ventura-river-confluence/ | Ventura 8 | 12.458 | Ventura River Confluence Preserve | 2004 | Private Conservation 16 | 2 |
11227 | 11227 | 11226 | {"type": "Polygon", "coordinates": [[[-121.87811, 38.68543], [-121.878, 38.6898], [-121.87761, 38.69013], [-121.87679, 38.69016], [-121.87668, 38.69018], [-121.87616, 38.69219], [-121.87565, 38.69185], [-121.87286, 38.69091], [-121.87253, 38.69108], [-121.87209, 38.6912], [-121.87148, 38.69125], [-121.87098, 38.69118], [-121.87039, 38.69107], [-121.87026, 38.69108], [-121.86517, 38.69271], [-121.86633, 38.68796], [-121.86685, 38.68787], [-121.86744, 38.68781], [-121.87071, 38.68756], [-121.87166, 38.6877], [-121.87424, 38.68732], [-121.87682, 38.68599], [-121.87811, 38.68543]]]} | Open Access 1 | 21567 | Cache Creek Nature Preserve | 16648 | 3009 | Cache Creek Conservancy 970 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.cachecreekconservancy.org/ | Non Governmental Organization 10 | 3009 | Cache Creek Conservancy 936 | Non Profit 6 | Non Profit - Land Trust 10 | Yolo 33 | 120.255 | Cache Creek Nature Preserve | 0 | Private Conservation 16 | 2 | |
11135 | 11135 | 11134 | {"type": "Polygon", "coordinates": [[[-118.91455, 34.04435], [-118.91454, 34.04441], [-118.91405, 34.04578], [-118.91346, 34.04887], [-118.91316, 34.05135], [-118.9094, 34.04933], [-118.90939, 34.04934], [-118.9094, 34.05179], [-118.90586, 34.05052], [-118.90586, 34.04863], [-118.9089, 34.04905], [-118.90886, 34.04357], [-118.91455, 34.04435]]]} | Open Access 1 | 21512 | Nature Trust of the Santa Monica Mountains | 22674 | 3204 | Nature Trust of the Santa Monica Mountains 965 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.naturetrust.net/ | Non Governmental Organization 10 | 3204 | Nature Trust of the Santa Monica Mountains 933 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 98.902 | Nature Trust of the Santa Monica Mtns. | 0 | Private Conservation 16 | 2 | |
10607 | 10607 | 10606 | {"type": "MultiPolygon", "coordinates": [[[[-121.57774, 40.1605], [-121.57681, 40.16049], [-121.57679, 40.15889], [-121.57686, 40.15911], [-121.57695, 40.15954], [-121.57774, 40.1605]]], [[[-121.59589, 40.15883], [-121.59555, 40.17348], [-121.57692, 40.17344], [-121.57684, 40.16423], [-121.5815, 40.16418], [-121.58155, 40.16053], [-121.58154, 40.16052], [-121.57797, 40.1605], [-121.57715, 40.15947], [-121.57694, 40.15857], [-121.59589, 40.15883]]]]} | Open Access 1 | 48634 | Lower Deer Creek Falls | 33337 | 3107 | Northern California Regional Land Trust 952 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landconservation.org/ | Non Governmental Organization 10 | 3107 | Northern California Regional Land Trust 924 | Non Profit 6 | Non Profit - Land Trust 10 | http://landconservation.org/acres-conserved/lower-deer-creek-falls/ | Tehama 18 | 609.407 | Lower Deer Creek Falls | 2012 | Private Conservation 16 | 2 |
7399 | 7399 | 7398 | {"type": "MultiPolygon", "coordinates": [[[[-118.32813, 34.25287], [-118.32799, 34.2536], [-118.32811, 34.254], [-118.32728, 34.25449], [-118.32715, 34.25435], [-118.32611, 34.25459], [-118.32583, 34.25429], [-118.32522, 34.25334], [-118.32538, 34.25159], [-118.32516, 34.25134], [-118.32518, 34.25131], [-118.32529, 34.25124], [-118.32592, 34.25118], [-118.32619, 34.25128], [-118.32645, 34.25156], [-118.32659, 34.25202], [-118.32678, 34.25225], [-118.32709, 34.25239], [-118.32776, 34.25256], [-118.32813, 34.25287]]], [[[-118.35035, 34.24485], [-118.34989, 34.24486], [-118.34989, 34.2463], [-118.34866, 34.2463], [-118.3484, 34.24562], [-118.34795, 34.24522], [-118.34716, 34.24544], [-118.346, 34.2464], [-118.34557, 34.24817], [-118.34407, 34.24477], [-118.34085, 34.24487], [-118.34106, 34.24552], [-118.33901, 34.24712], [-118.3387, 34.24719], [-118.33869, 34.25013], [-118.33898, 34.25021], [-118.33904, 34.25075], [-118.34034, 34.25092], [-118.34011, 34.25127], [-118.34019, 34.2513], [-118.34027, 34.2514], [-118.34073, 34.25205], [-118.34066, 34.25204], [-118.34065, 34.25205], [-118.34078, 34.2522], [-118.34112, 34.25233], [-118.34098, 34.25322], [-118.34001, 34.25301], [-118.33978, 34.25305], [-118.33979, 34.25311], [-118.33919, 34.25323], [-118.33871, 34.25314], [-118.3387, 34.25408], [-118.3348, 34.25297], [-118.32787, 34.25114], [-118.32532, 34.24575], [-118.32614, 34.24569], [-118.32564, 34.24438], [-118.32585, 34.24356], [-118.32829, 34.24373], [-118.32941, 34.24303], [-118.33558, 34.24282], [-118.33558, 34.24462], [-118.33559, 34.24463], [-118.33679, 34.24372], [-118.34114, 34.24136], [-118.34166, 34.24142], [-118.34431, 34.24006], [-118.34432, 34.24256], [-118.35034, 34.24236], [-118.35035, 34.24485]]], [[[-118.33422, 34.25811], [-118.33386, 34.25817], [-118.33304, 34.25842], [-118.33287, 34.25845], [-118.33269, 34.25847], [-118.33263, 34.2585], [-118.3325, 34.25862], [-118.33238, 34.25867], [-118.33187, 34.25871], [-118.33175, 34.25879], [-118.33179, 34.25942], [-118.33099, 34.2595], [-118.33094, 34.2595], [-118.33093, 34.25949], [-118.33073, 34.2595], [-118.32881, 34.25776], [-118.32752, 34.25663], [-118.32832, 34.25596], [-118.32851, 34.25262], [-118.32804, 34.25162], [-118.33174, 34.2526], [-118.33131, 34.25461], [-118.33187, 34.2553], [-118.33162, 34.25606], [-118.33175, 34.25642], [-118.33176, 34.25744], [-118.33282, 34.25776], [-118.33402, 34.25796], [-118.33422, 34.25811]]], [[[-118.35418, 34.24275], [-118.35397, 34.24291], [-118.35393, 34.24342], [-118.35417, 34.24362], [-118.35417, 34.24516], [-118.35385, 34.24535], [-118.35372, 34.24537], [-118.35366, 34.24534], [-118.35357, 34.24544], [-118.35354, 34.24541], [-118.35312, 34.24527], [-118.3527, 34.24541], [-118.35272, 34.24228], [-118.35417, 34.24223], [-118.35418, 34.24275]]]]} | Open Access 1 | 6826 | Fond Wilderness Preserve | 3733 | 3023 | Fond Land Preservation Foundation 862 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.flpf.org/ | Non Governmental Organization 10 | 3023 | Fond Land Preservation Foundation 840 | Non Profit 6 | Non Profit - Land Trust 10 | http://flpf.org/index.html | Los Angeles 6 | 498.668 | Fond Wilderness Preserve | 0 | Private Conservation 16 | 2 |
5823 | 5823 | 5822 | {"type": "Polygon", "coordinates": [[[-117.49312, 33.68441], [-117.49096, 33.68541], [-117.48724, 33.68546], [-117.48576, 33.68326], [-117.4842, 33.68401], [-117.47939, 33.67705], [-117.48271, 33.67554], [-117.48504, 33.67885], [-117.48843, 33.67738], [-117.49312, 33.68441]]]} | Open Access 1 | 17817 | Cleveland National Forest Wildlife Corridors | 17421 | 3063 | San Bernardino Mountains Land Trust 818 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sbmlt.net/ | Non Governmental Organization 10 | 3063 | San Bernardino Mountains Land Trust 796 | Non Profit 6 | Non Profit - Land Trust 10 | Orange 3 | 169.255 | Cleveland NF Wildlife Corridors | 0 | Private Conservation 16 | 2 | |
6988 | 6988 | 6987 | {"type": "Polygon", "coordinates": [[[-118.33644, 33.78052], [-118.33502, 33.78169], [-118.33424, 33.78103], [-118.33328, 33.78201], [-118.33297, 33.78166], [-118.33295, 33.7813], [-118.33297, 33.78118], [-118.33305, 33.78097], [-118.33316, 33.78082], [-118.3333, 33.7807], [-118.33338, 33.78064], [-118.3335, 33.78058], [-118.33367, 33.78051], [-118.33384, 33.78047], [-118.33477, 33.78038], [-118.3356, 33.7797], [-118.33565, 33.77963], [-118.33563, 33.77955], [-118.33559, 33.77951], [-118.33482, 33.77939], [-118.33338, 33.77961], [-118.33208, 33.77952], [-118.33208, 33.77874], [-118.33144, 33.77865], [-118.33113, 33.77864], [-118.33095, 33.77812], [-118.33221, 33.77812], [-118.33242, 33.77815], [-118.33247, 33.7784], [-118.33623, 33.77894], [-118.33571, 33.78009], [-118.33644, 33.78052]]]} | Open Access 1 | 5912 | Linden H. Chandler Preserve | 21289 | 3052 | Palos Verdes Peninsula Land Conservancy 846 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.pvplc.org/preserves.shtml | Non Governmental Organization 10 | 3052 | Palos Verdes Peninsula Land Conservancy 727 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 19.666 | Linden H. Chandler Preserve | 0 | Private Conservation 16 | 2 | |
14876 | 14876 | 14875 | {"type": "Polygon", "coordinates": [[[-118.38886, 33.7537], [-118.38884, 33.75428], [-118.38568, 33.75472], [-118.38468, 33.75461], [-118.38403, 33.75377], [-118.38081, 33.75391], [-118.38052, 33.75579], [-118.3799, 33.75633], [-118.37866, 33.75701], [-118.37781, 33.75817], [-118.3771, 33.75868], [-118.37707, 33.75825], [-118.37711, 33.7576], [-118.37672, 33.75717], [-118.37591, 33.75727], [-118.37537, 33.75747], [-118.37496, 33.75736], [-118.37444, 33.7576], [-118.37405, 33.7573], [-118.37305, 33.75748], [-118.37273, 33.75801], [-118.37208, 33.75856], [-118.37204, 33.75801], [-118.3719, 33.75777], [-118.37171, 33.75778], [-118.37132, 33.75803], [-118.36941, 33.75792], [-118.36906, 33.7576], [-118.36876, 33.75761], [-118.36893, 33.75736], [-118.36946, 33.75731], [-118.3696, 33.75725], [-118.36996, 33.75672], [-118.36943, 33.75647], [-118.36924, 33.75632], [-118.36863, 33.75616], [-118.36873, 33.7559], [-118.36863, 33.75581], [-118.36675, 33.75661], [-118.36646, 33.75686], [-118.36637, 33.75679], [-118.36647, 33.75669], [-118.36628, 33.75629], [-118.36646, 33.75528], [-118.368, 33.754], [-118.36936, 33.75121], [-118.371, 33.7519], [-118.37101, 33.75208], [-118.37207, 33.75267], [-118.37212, 33.75284], [-118.37233, 33.75281], [-118.37205, 33.75415], [-118.37348, 33.75414], [-118.37418, 33.75324], [-118.37402, 33.75299], [-118.37386, 33.75259], [-118.37375, 33.7522], [-118.37377, 33.75166], [-118.37358, 33.75128], [-118.37308, 33.7509], [-118.37297, 33.75099], [-118.37276, 33.75087], [-118.37279, 33.75062], [-118.37327, 33.75061], [-118.37421, 33.75153], [-118.37399, 33.75225], [-118.37442, 33.75285], [-118.37497, 33.75239], [-118.37553, 33.75118], [-118.37586, 33.75109], [-118.37637, 33.7511], [-118.37727, 33.75155], [-118.37867, 33.75187], [-118.38047, 33.751], [-118.38057, 33.75145], [-118.38325, 33.75147], [-118.38324, 33.75182], [-118.38564, 33.7539], [-118.38797, 33.75337], [-118.38886, 33.7537]]]} | Open Access 1 | 45418 | Upper Filiorum Reserve | 32428 | 1265 | Rancho Palos Verdes, City of 265 | City 2 | City Agency 2 | http://palosverdes.com/rpv/recreationparks/index.cfm | City 2 | 3052 | Palos Verdes Peninsula Land Conservancy 727 | Non Profit 6 | Non Profit - Land Trust 10 | http://pvplc.org/_lands/filiorum.asp | Los Angeles 6 | 207.362 | Upper Filiorum Reserve | 2009 | None 1282 | |
4064 | 4064 | 4063 | {"type": "Polygon", "coordinates": [[[-120.3848, 39.80942], [-120.38431, 39.80942], [-120.38434, 39.81012], [-120.37919, 39.81011], [-120.37917, 39.81285], [-120.36803, 39.81173], [-120.36148, 39.81104], [-120.36147, 39.81004], [-120.37073, 39.81007], [-120.37074, 39.80281], [-120.37087, 39.79921], [-120.37563, 39.79923], [-120.37805, 39.79919], [-120.37787, 39.80285], [-120.38036, 39.80287], [-120.38012, 39.80642], [-120.38429, 39.80655], [-120.38472, 39.80744], [-120.3848, 39.80942]]]} | Open Access 1 | 47066 | Feather River Ranch | 30718 | 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 | 338.36 | Feather River Ranch | 0 | Private Conservation 16 | 2 | |
14421 | 14421 | 14420 | {"type": "MultiPolygon", "coordinates": [[[[-120.3804, 39.79567], [-120.38036, 39.7964], [-120.38025, 39.79925], [-120.37805, 39.79919], [-120.37563, 39.79923], [-120.37087, 39.79921], [-120.37074, 39.80281], [-120.37073, 39.81007], [-120.35191, 39.81], [-120.35191, 39.81036], [-120.34327, 39.80946], [-120.34323, 39.79552], [-120.34339, 39.79198], [-120.34341, 39.78848], [-120.35202, 39.78821], [-120.36156, 39.78817], [-120.36172, 39.78096], [-120.36631, 39.78096], [-120.36637, 39.77731], [-120.37111, 39.77735], [-120.37998, 39.77723], [-120.37999, 39.77749], [-120.37999, 39.79566], [-120.3804, 39.79567]]], [[[-120.3567, 39.81713], [-120.35425, 39.81716], [-120.34768, 39.81717], [-120.34782, 39.81026], [-120.35191, 39.81069], [-120.3534, 39.81099], [-120.35669, 39.81355], [-120.3567, 39.81713]]]]} | Open Access 1 | 47034 | Sierra Valley Preserve | 30685 | 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 | 2200.819 | Sierra Valley Preserve | 0 | Private Conservation 16 | 2 | |
14456 | 14456 | 14455 | {"type": "Polygon", "coordinates": [[[-120.7219, 40.05271], [-120.72186, 40.05619], [-120.71244, 40.05613], [-120.71233, 40.05961], [-120.70762, 40.05953], [-120.70754, 40.0624], [-120.70371, 40.06239], [-120.70365, 40.06603], [-120.69406, 40.06603], [-120.69399, 40.06951], [-120.68457, 40.0695], [-120.68457, 40.06876], [-120.68539, 40.06875], [-120.68537, 40.06702], [-120.68457, 40.06706], [-120.68456, 40.06598], [-120.68954, 40.06601], [-120.68957, 40.06236], [-120.6933, 40.06236], [-120.69344, 40.05938], [-120.69364, 40.0526], [-120.6937, 40.04825], [-120.71704, 40.04853], [-120.71713, 40.05268], [-120.7219, 40.05271]]]} | Open Access 1 | 47076 | Heart K Ranch | 30730 | 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 | 904.84 | Heart K Ranch | 0 | Private Conservation 16 | 2 | |
14461 | 14461 | 14460 | {"type": "MultiPolygon", "coordinates": [[[[-121.22252, 40.31078], [-121.22234, 40.31082], [-121.22234, 40.31244], [-121.21829, 40.31287], [-121.21776, 40.31256], [-121.21823, 40.31224], [-121.21838, 40.31208], [-121.21838, 40.31207], [-121.21784, 40.31203], [-121.21747, 40.31174], [-121.21775, 40.31162], [-121.21816, 40.31165], [-121.21801, 40.3114], [-121.21819, 40.31108], [-121.21785, 40.31078], [-121.21836, 40.31078], [-121.21846, 40.31048], [-121.21802, 40.3103], [-121.21835, 40.30991], [-121.21831, 40.30977], [-121.21884, 40.3096], [-121.21883, 40.30958], [-121.2184, 40.3095], [-121.21846, 40.30891], [-121.21846, 40.30843], [-121.2186, 40.30816], [-121.21866, 40.30782], [-121.21894, 40.30745], [-121.21913, 40.30715], [-121.21911, 40.30694], [-121.21916, 40.30681], [-121.22156, 40.30685], [-121.2219, 40.30715], [-121.22246, 40.30748], [-121.22252, 40.30979], [-121.22252, 40.31078]]], [[[-121.22266, 40.32148], [-121.22212, 40.32148], [-121.22206, 40.32084], [-121.22192, 40.32077], [-121.22135, 40.32061], [-121.22117, 40.3204], [-121.22083, 40.32055], [-121.22063, 40.32057], [-121.22055, 40.32044], [-121.2208, 40.32025], [-121.22073, 40.32014], [-121.2205, 40.32006], [-121.22102, 40.31986], [-121.2211, 40.31976], [-121.22105, 40.3196], [-121.22087, 40.31955], [-121.2208, 40.31943], [-121.2213, 40.3193], [-121.22129, 40.31814], [-121.22128, 40.31813], [-121.22081, 40.31841], [-121.22059, 40.31849], [-121.22048, 40.31844], [-121.22051, 40.31839], [-121.22049, 40.31835], [-121.22041, 40.31833], [-121.22035, 40.31835], [-121.22027, 40.3183], [-121.22027, 40.31817], [-121.22033, 40.3181], [-121.22066, 40.31789], [-121.22076, 40.31785], [-121.22089, 40.31773], [-121.22107, 40.3175], [-121.22112, 40.31734], [-121.22078, 40.31758], [-121.22052, 40.3178], [-121.22035, 40.31792], [-121.21999, 40.31802], [-121.21983, 40.318], [-121.21957, 40.31786], [-121.21928, 40.31737], [-121.21899, 40.31698], [-121.21886, 40.31692], [-121.21872, 40.31693], [-121.21855, 40.3169], [-121.21863, 40.31678], [-121.21933, 40.31659], [-121.21938, 40.31659], [-121.21955, 40.31664], [-121.21967, 40.3167], [-121.21977, 40.31666], [-121.21961, 40.31653], [-121.21942, 40.31648], [-121.21925, 40.31648], [-121.21868, 40.31664], [-121.21853, 40.31643], [-121.21867, 40.31617], [-121.21878, 40.31605], [-121.21878, 40.31594], [-121.21868, 40.31584], [-121.21847, 40.31589], [-121.21837, 40.31581], [-121.21837, 40.3157], [-121.2185, 40.31551], [-121.21862, 40.31548], [-121.21882, 40.31556], [-121.21898, 40.31555], [-121.21962, 40.31534], [-121.21985, 40.31529], [-121.21985, 40.31527], [-121.21962, 40.31515], [-121.21969, 40.31503], [-121.21988, 40.31485], [-121.21973, 40.3148], [-121.21978, 40.31467], [-121.22005, 40.31459], [-121.21985, 40.31451], [-121.21985, 40.3144], [-121.22015, 40.31431], [-121.22053, 40.31428], [-121.22069, 40.31432], [-121.22092, 40.31433], [-121.22093, 40.31432], [-121.22073, 40.31416], [-121.22015, 40.31415], [-121.21981, 40.3142], [-121.21968, 40.31428], [-121.21957, 40.31447], [-121.21954, 40.3146], [-121.2195, 40.31468], [-121.21941, 40.31478], [-121.21926, 40.31487], [-121.2189, 40.3147], [-121.21921, 40.31447], [-121.2192, 40.31424], [-121.21942, 40.31415], [-121.21933, 40.31408], [-121.21955, 40.31405], [-121.21983, 40.31407], [-121.22027, 40.31387], [-121.22028, 40.31385], [-121.21964, 40.3139], [-121.21944, 40.31383], [-121.21925, 40.31367], [-121.21903, 40.31356], [-121.21864, 40.31343], [-121.21851, 40.31326], [-121.2212, 40.31293], [-121.22213, 40.31275], [-121.22218, 40.31323], [-121.22238, 40.31321], [-121.22238, 40.31391], [-121.22266, 40.32148]]]]} | Open Access 1 | 47078 | Olsen Barn | 30732 | 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 | 103.048 | Olsen Barn | 0 | Private Conservation 16 | 2 | |
3834 | 3834 | 3833 | {"type": "Polygon", "coordinates": [[[-124.12251, 41.04406], [-124.12176, 41.04463], [-124.12151, 41.04441], [-124.12099, 41.04406], [-124.12081, 41.04391], [-124.12065, 41.04375], [-124.12044, 41.04348], [-124.12027, 41.04316], [-124.1202, 41.04307], [-124.12117, 41.04308], [-124.12124, 41.04322], [-124.12149, 41.04344], [-124.1218, 41.0436], [-124.1221, 41.04381], [-124.12227, 41.04396], [-124.12251, 41.04406]]]} | Open Access 1 | 45380 | North Luffenholtz Beach | 27913 | 3203 | Trinidad Coastal Land Trust 690 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 3.699 | North Luffenholtz Beach | 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]);