units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
629 rows where DES_TP = 16 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, MNG_AG_LEV
MNG_AGENCY >30
- The Nature Conservancy 48
- National Audubon Society 27
- Sonoma Land Trust 24
- Center for Natural Lands Management 23
- The Wildlands Conservancy 23
- Peninsula Open Space Trust 23
- Truckee Donner Land Trust 22
- Big Sur Land Trust 21
- The Environmental Trust 21
- Land Trust of Napa County 18
- Sempervirens Fund 18
- American River Conservancy 18
- Save Mount Diablo 17
- Endangered Habitats Conservancy 14
- Land Trust of Santa Cruz County 14
- Fallbrook Land Conservancy 14
- Wilderness Land Trust 13
- Save the Redwoods League 10
- Bear Yuba Land Trust 10
- Marin Audubon Society 9
- Elkhorn Slough Foundation 9
- The Conservation Fund - California 9
- Mojave Desert Land Trust 8
- Coastside Land Trust 8
- Ojai Valley Land Conservancy 8
- Friends of the Desert Mountains 7
- Sierra Foothill Conservancy 7
- Solano Land Trust 7
- San Diego River Park Foundation 7
- John Muir Land Trust 6
- …
MNG_AG_TYP 7
ACCESS_TYP 4
- Open Access 212
- No Public Access 211
- Restricted Access 154
- Unknown Access 52
AGNCY_LEV 2 ✖
- Non Profit 613
- Private 16
DES_TP 1
- Private Conservation · 629 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17036 | 17036 | 17035 | {"type": "MultiPolygon", "coordinates": [[[[-121.86855, 36.95368], [-121.86785, 36.9536], [-121.86778, 36.95397], [-121.86827, 36.95404], [-121.8681, 36.95412], [-121.86798, 36.95419], [-121.86788, 36.95429], [-121.86781, 36.9544], [-121.86779, 36.95418], [-121.86747, 36.95345], [-121.86637, 36.95283], [-121.86511, 36.95253], [-121.86503, 36.95132], [-121.86479, 36.95133], [-121.86423, 36.95139], [-121.86423, 36.95134], [-121.86425, 36.95128], [-121.86429, 36.95123], [-121.86436, 36.9512], [-121.8647, 36.95108], [-121.86509, 36.95088], [-121.86524, 36.95084], [-121.8657, 36.95078], [-121.86564, 36.95101], [-121.86605, 36.9511], [-121.86605, 36.95118], [-121.8657, 36.95128], [-121.86586, 36.95146], [-121.86623, 36.95156], [-121.86649, 36.9518], [-121.86681, 36.95186], [-121.86727, 36.95224], [-121.86812, 36.95309], [-121.86841, 36.95299], [-121.86849, 36.95322], [-121.86855, 36.95356], [-121.86855, 36.95368]]], [[[-121.87549, 36.96011], [-121.87303, 36.96118], [-121.87263, 36.96085], [-121.87208, 36.96106], [-121.8715, 36.96037], [-121.87129, 36.96025], [-121.87108, 36.96047], [-121.87106, 36.96044], [-121.87104, 36.96033], [-121.871, 36.96027], [-121.87089, 36.96023], [-121.87076, 36.96024], [-121.87069, 36.96029], [-121.87066, 36.96034], [-121.87065, 36.96041], [-121.87068, 36.96047], [-121.87072, 36.96051], [-121.87079, 36.96055], [-121.87098, 36.96054], [-121.87108, 36.9606], [-121.87119, 36.96069], [-121.87125, 36.96077], [-121.87135, 36.96098], [-121.87154, 36.96118], [-121.87158, 36.96134], [-121.87152, 36.96137], [-121.87159, 36.9615], [-121.87162, 36.96154], [-121.87168, 36.96152], [-121.87188, 36.96173], [-121.8719, 36.96183], [-121.87187, 36.96192], [-121.8718, 36.962], [-121.87175, 36.962], [-121.87174, 36.96207], [-121.87167, 36.96219], [-121.8711, 36.962], [-121.87087, 36.96207], [-121.87033, 36.96217], [-121.87019, 36.96225], [-121.87022, 36.96236], [-121.87014, 36.96246], [-121.87019, 36.96255], [-121.87075, 36.96276], [-121.87084, 36.96298], [-121.87079, 36.96353], [-121.87048, 36.96362], [-121.87038, 36.96339], [-121.87039, 36.9631], [-121.87008, 36.96249], [-121.86907, 36.96281], [-121.86843, 36.96158], [-121.86812, 36.96111], [-121.86787, 36.96082], [-121.86533, 36.95799], [-121.86511, 36.95772], [-121.86486, 36.95753], [-121.86466, 36.95712], [-121.86454, 36.9568], [-121.86445, 36.95647], [-121.86445, 36.95601], [-121.86453, 36.95553], [-121.86448, 36.95517], [-121.86439, 36.9549], [-121.8649, 36.95488], [-121.86486, 36.95408], [-121.86519, 36.95406], [-121.8652, 36.95327], [-121.86524, 36.95323], [-121.86562, 36.9534], [-121.86678, 36.95378], [-121.86691, 36.95385], [-121.86707, 36.95399], [-121.86716, 36.95411], [-121.86721, 36.95423], [-121.86679, 36.95432], [-121.86649, 36.95426], [-121.86637, 36.95445], [-121.86628, 36.95446], [-121.8662, 36.95451], [-121.86588, 36.95436], [-121.8658, 36.95458], [-121.86587, 36.95474], [-121.8657, 36.9548], [-121.86591, 36.95527], [-121.86639, 36.95509], [-121.8665, 36.95521], [-121.86651, 36.95524], [-121.86642, 36.95549], [-121.86614, 36.95593], [-121.86573, 36.95582], [-121.86567, 36.95607], [-121.86568, 36.95616], [-121.8657, 36.95632], [-121.86581, 36.95656], [-121.8661, 36.95689], [-121.86641, 36.95667], [-121.86673, 36.95691], [-121.86689, 36.957], [-121.86703, 36.9571], [-121.86713, 36.95723], [-121.86715, 36.95732], [-121.86715, 36.95746], [-121.86716, 36.95754], [-121.86722, 36.95764], [-121.86728, 36.95772], [-121.86741, 36.95781], [-121.86797, 36.95802], [-121.8682, 36.95822], [-121.86845, 36.95832], [-121.86852, 36.95836], [-121.86857, 36.95843], [-121.86876, 36.95879], [-121.8689, 36.95897], [-121.86886, 36.95901], [-121.86902, 36.95914], [-121.86907, 36.9591], [-121.86919, 36.95917], [-121.86927, 36.95926], [-121.8694, 36.9593], [-121.86953, 36.95926], [-121.86959, 36.9592], [-121.86961, 36.95914], [-121.86958, 36.95906], [-121.86953, 36.95901], [-121.86948, 36.95898], [-121.86937, 36.95897], [-121.86926, 36.95901], [-121.86958, 36.95877], [-121.86924, 36.95836], [-121.86877, 36.95851], [-121.86873, 36.95845], [-121.86914, 36.95826], [-121.869, 36.95808], [-121.86835, 36.95758], [-121.86804, 36.95742], [-121.86779, 36.95782], [-121.86745, 36.95768], [-121.86737, 36.95762], [-121.8673, 36.95753], [-121.86728, 36.95745], [-121.86728, 36.95727], [-121.86722, 36.95713], [-121.86716, 36.95704], [-121.86697, 36.9569], [-121.86696, 36.95687], [-121.86697, 36.95684], [-121.86708, 36.95675], [-121.86717, 36.95672], [-121.86726, 36.95672], [-121.86753, 36.95684], [-121.86771, 36.95685], [-121.86778, 36.95712], [-121.86841, 36.95715], [-121.86852, 36.95685], [-121.86841, 36.95668], [-121.86849, 36.95661], [-121.86897, 36.95652], [-121.86865, 36.95606], [-121.86805, 36.95608], [-121.86741, 36.95624], [-121.86731, 36.95657], [-121.8672, 36.95657], [-121.86709, 36.95658], [-121.86695, 36.95664], [-121.86684, 36.95672], [-121.86679, 36.95673], [-121.86661, 36.9566], [-121.8669, 36.95637], [-121.8667, 36.95616], [-121.86681, 36.95585], [-121.86645, 36.95576], [-121.86658, 36.95556], [-121.86694, 36.95563], [-121.86707, 36.95545], [-121.86758, 36.9553], [-121.86744, 36.95498], [-121.86761, 36.95489], [-121.86776, 36.95478], [-121.86819, 36.95508], [-121.86839, 36.9549], [-121.86845, 36.95461], [-121.86807, 36.95434], [-121.86814, 36.95429], [-121.86838, 36.95417], [-121.86854, 36.95405], [-121.86864, 36.95393], [-121.86871, 36.95381], [-121.86874, 36.95372], [-121.86875, 36.9536], [-121.86872, 36.95343], [-121.8695, 36.95337], [-121.8697, 36.95315], [-121.87043, 36.95349], [-121.86981, 36.95388], [-121.86967, 36.95405], [-121.8729, 36.95732], [-121.87454, 36.95909], [-121.8745, 36.95921], [-121.87477, 36.95933], [-121.87549, 36.96011]]]]} | Open Access 1 | 28279 | Center For Natural Lands Management | 17036 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 134.75 | Ctr. For Natural Lands Management | 0 | Private Conservation 16 | 2 | |
17006 | 17006 | 17005 | {"type": "Polygon", "coordinates": [[[-118.19254, 35.71776], [-118.1836, 35.71794], [-118.1836, 35.71704], [-118.18467, 35.71701], [-118.18468, 35.71528], [-118.18695, 35.71525], [-118.18695, 35.71442], [-118.18805, 35.71441], [-118.18805, 35.71353], [-118.19024, 35.71353], [-118.19022, 35.71063], [-118.19243, 35.71062], [-118.19254, 35.71776]]]} | Unknown Access 4 | 36107 | National Audubon Society 22 | 22651 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 89.965 | Nat. Audubon Society 22 | 0 | Private Conservation 16 | 2 | |
17005 | 17005 | 17004 | {"type": "MultiPolygon", "coordinates": [[[[-118.27949, 35.6743], [-118.27766, 35.67533], [-118.27639, 35.67657], [-118.27567, 35.67719], [-118.27431, 35.67791], [-118.27241, 35.67875], [-118.2724, 35.67795], [-118.27014, 35.67796], [-118.27242, 35.67433], [-118.27949, 35.6743]]], [[[-118.29007, 35.67426], [-118.29004, 35.67601], [-118.28531, 35.67602], [-118.28534, 35.67702], [-118.28094, 35.67704], [-118.281, 35.67803], [-118.27658, 35.67804], [-118.27673, 35.68152], [-118.27241, 35.68149], [-118.27241, 35.67948], [-118.27406, 35.67834], [-118.27537, 35.67772], [-118.2763, 35.67737], [-118.27703, 35.67702], [-118.27775, 35.67646], [-118.27821, 35.67605], [-118.27892, 35.67557], [-118.27928, 35.67501], [-118.28015, 35.6743], [-118.29007, 35.67426]]], [[[-118.30793, 35.67964], [-118.30557, 35.67965], [-118.30549, 35.67607], [-118.2989, 35.67609], [-118.29896, 35.67796], [-118.2921, 35.67798], [-118.29219, 35.67908], [-118.29025, 35.6794], [-118.29025, 35.67746], [-118.29028, 35.67426], [-118.29434, 35.67423], [-118.2958, 35.6747], [-118.29683, 35.675], [-118.29777, 35.67524], [-118.29874, 35.67537], [-118.30001, 35.67532], [-118.301, 35.67521], [-118.30188, 35.67485], [-118.30372, 35.6742], [-118.3079, 35.67418], [-118.30793, 35.67964]]], [[[-118.30196, 35.67421], [-118.30081, 35.67458], [-118.29936, 35.67488], [-118.29809, 35.67483], [-118.29611, 35.67423], [-118.30196, 35.67421]]]]} | Unknown Access 4 | 36106 | National Audubon Society 12 | 22641 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 302.293 | Nat. Audubon Society 12 | 0 | Private Conservation 16 | 2 | |
17004 | 17004 | 17003 | {"type": "MultiPolygon", "coordinates": [[[[-118.29467, 35.67377], [-118.29419, 35.67362], [-118.29189, 35.67317], [-118.29062, 35.67315], [-118.29037, 35.67301], [-118.29034, 35.67178], [-118.2902, 35.67177], [-118.29016, 35.66927], [-118.29248, 35.66885], [-118.29249, 35.67009], [-118.29464, 35.6701], [-118.29467, 35.67377]]], [[[-118.29434, 35.67423], [-118.29226, 35.67424], [-118.29226, 35.67408], [-118.29168, 35.67375], [-118.29272, 35.67385], [-118.29434, 35.67423]]]]} | Unknown Access 4 | 36101 | National Audubon Society 3 | 22653 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 42.725 | Nat. Audubon Society 3 | 0 | Private Conservation 16 | 2 | |
17001 | 17001 | 17000 | {"type": "MultiPolygon", "coordinates": [[[[-118.25928, 35.67024], [-118.25921, 35.67026], [-118.25904, 35.67033], [-118.25865, 35.67053], [-118.25835, 35.67072], [-118.258, 35.67097], [-118.25768, 35.67124], [-118.25744, 35.67148], [-118.25696, 35.67205], [-118.25584, 35.67205], [-118.25583, 35.67252], [-118.25465, 35.67252], [-118.25467, 35.67066], [-118.25461, 35.66342], [-118.2582, 35.66342], [-118.25822, 35.66403], [-118.25906, 35.66405], [-118.25928, 35.67024]]], [[[-118.26209, 35.67064], [-118.25938, 35.67289], [-118.25934, 35.67204], [-118.25722, 35.67205], [-118.25745, 35.67176], [-118.25766, 35.67153], [-118.25789, 35.6713], [-118.25814, 35.67109], [-118.25841, 35.6709], [-118.25869, 35.67072], [-118.25899, 35.67056], [-118.25929, 35.67042], [-118.25931, 35.67065], [-118.26209, 35.67064]]], [[[-118.264, 35.67436], [-118.25943, 35.67436], [-118.25939, 35.67328], [-118.26257, 35.67064], [-118.26379, 35.67063], [-118.264, 35.67436]]]]} | Unknown Access 4 | 36112 | National Audubon Society 16 | 22645 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 135.112 | Nat. Audubon Society 16 | 0 | Private Conservation 16 | 2 | |
16998 | 16998 | 16997 | {"type": "Polygon", "coordinates": [[[-118.31679, 35.67415], [-118.31247, 35.67416], [-118.31243, 35.67061], [-118.30792, 35.67063], [-118.30795, 35.66668], [-118.31204, 35.66666], [-118.31679, 35.66529], [-118.31679, 35.67415]]]} | Unknown Access 4 | 43026 | National Audubon Society 14 | 22643 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 133.04 | Nat. Audubon Society 14 | 0 | Private Conservation 16 | 2 | |
16997 | 16997 | 16996 | {"type": "MultiPolygon", "coordinates": [[[[-118.30795, 35.66696], [-118.3079, 35.6734], [-118.30686, 35.67324], [-118.30399, 35.67358], [-118.30196, 35.67421], [-118.29905, 35.67422], [-118.2991, 35.66701], [-118.2991, 35.66489], [-118.30103, 35.66465], [-118.30104, 35.66566], [-118.30398, 35.66567], [-118.30399, 35.66695], [-118.30795, 35.66696]]], [[[-118.3079, 35.67385], [-118.3079, 35.67418], [-118.30372, 35.6742], [-118.30562, 35.67372], [-118.30749, 35.67378], [-118.3079, 35.67385]]]]} | Unknown Access 4 | 43025 | National Audubon Society 15 | 22644 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 173.319 | Nat. Audubon Society 15 | 0 | Private Conservation 16 | 2 | |
16996 | 16996 | 16995 | {"type": "MultiPolygon", "coordinates": [[[[-118.18308, 35.74613], [-118.18307, 35.74668], [-118.17417, 35.7468], [-118.16604, 35.74711], [-118.16564, 35.74343], [-118.17202, 35.74325], [-118.17204, 35.74501], [-118.17417, 35.74496], [-118.1801, 35.74487], [-118.1815, 35.74541], [-118.18202, 35.74564], [-118.18308, 35.74613]]], [[[-118.18308, 35.74581], [-118.18218, 35.74539], [-118.18088, 35.74486], [-118.18091, 35.74485], [-118.18087, 35.74309], [-118.18304, 35.74308], [-118.18308, 35.74581]]]]} | Unknown Access 4 | 43024 | National Audubon Society 11 | 22640 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 114.543 | Nat. Audubon Society 11 | 0 | Private Conservation 16 | 2 | |
16995 | 16995 | 16994 | {"type": "MultiPolygon", "coordinates": [[[[-118.32729, 35.67268], [-118.32554, 35.67299], [-118.32559, 35.67163], [-118.32667, 35.6723], [-118.32694, 35.67249], [-118.32729, 35.67268]]], [[[-118.33913, 35.6662], [-118.33753, 35.66683], [-118.33575, 35.66799], [-118.33412, 35.66986], [-118.33236, 35.67133], [-118.32783, 35.67255], [-118.32755, 35.67242], [-118.32729, 35.67228], [-118.32693, 35.67204], [-118.3256, 35.67122], [-118.32571, 35.66683], [-118.32574, 35.66363], [-118.32902, 35.66361], [-118.33069, 35.66324], [-118.33669, 35.66321], [-118.33666, 35.66368], [-118.33695, 35.66497], [-118.3391, 35.66591], [-118.33913, 35.6662]]], [[[-118.33451, 35.67194], [-118.33451, 35.67409], [-118.3266, 35.6742], [-118.32676, 35.67347], [-118.32829, 35.67307], [-118.32861, 35.67315], [-118.32902, 35.67322], [-118.32936, 35.67331], [-118.32971, 35.67337], [-118.33, 35.6734], [-118.33029, 35.6734], [-118.33058, 35.67339], [-118.33087, 35.67335], [-118.33148, 35.67318], [-118.33287, 35.67269], [-118.33292, 35.67279], [-118.3335, 35.67261], [-118.33375, 35.6725], [-118.33406, 35.67232], [-118.33431, 35.67214], [-118.33451, 35.67194]]], [[[-118.33452, 35.67084], [-118.33452, 35.67101], [-118.33429, 35.67122], [-118.33405, 35.67153], [-118.33385, 35.67174], [-118.33364, 35.6719], [-118.33337, 35.67205], [-118.33315, 35.67214], [-118.33271, 35.67227], [-118.33274, 35.67238], [-118.33134, 35.67287], [-118.33073, 35.67304], [-118.33067, 35.67305], [-118.33058, 35.67289], [-118.3302, 35.67291], [-118.32986, 35.67289], [-118.32976, 35.67304], [-118.32946, 35.67299], [-118.32904, 35.67289], [-118.33057, 35.67251], [-118.33314, 35.67175], [-118.33432, 35.67112], [-118.33452, 35.67084]]], [[[-118.33903, 35.667], [-118.33898, 35.67037], [-118.33489, 35.67031], [-118.33543, 35.66955], [-118.33642, 35.66855], [-118.33784, 35.66754], [-118.33903, 35.667]]]]} | Unknown Access 4 | 36166 | National Audubon Society 9 | 22659 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 264.275 | Nat. Audubon Society 9 | 0 | Private Conservation 16 | 2 | |
16986 | 16986 | 16985 | {"type": "Polygon", "coordinates": [[[-122.33796, 37.45405], [-122.33784, 37.45482], [-122.3369, 37.45579], [-122.33616, 37.45669], [-122.33589, 37.45776], [-122.33615, 37.45885], [-122.33668, 37.45965], [-122.31809, 37.47368], [-122.31807, 37.47367], [-122.3133, 37.47728], [-122.30701, 37.47208], [-122.30873, 37.47076], [-122.30803, 37.46999], [-122.30845, 37.46868], [-122.30961, 37.46678], [-122.31148, 37.46868], [-122.31435, 37.46651], [-122.3146, 37.46658], [-122.31482, 37.46659], [-122.31543, 37.46654], [-122.3156, 37.46558], [-122.33576, 37.45033], [-122.33575, 37.45149], [-122.33668, 37.45179], [-122.33796, 37.45405]]]} | Restricted Access 2 | 16413 | Filoli Center | 18900 | 3047 | National Trust for Historic Preservation 1184 | Non Profit 6 | Non Profit - Other 22 | http://www.preservationnation.org/ | Non Governmental Organization 10 | 3047 | National Trust for Historic Preservation 1122 | Non Profit 6 | Non Profit - Other 20 | San Mateo 15 | 657.331 | Filoli Ctr. | 1975 | Private Conservation 16 | 2 | |
16918 | 16918 | 16917 | {"type": "MultiPolygon", "coordinates": [[[[-117.00734, 32.82839], [-117.00392, 32.82838], [-117.0039, 32.82652], [-117.00386, 32.82602], [-117.0038, 32.82557], [-117.00368, 32.82495], [-117.00357, 32.82448], [-117.00326, 32.82344], [-117.00307, 32.82251], [-117.00276, 32.8221], [-117.00268, 32.82025], [-117.00321, 32.82077], [-117.00576, 32.82077], [-117.00573, 32.82409], [-117.00731, 32.82409], [-117.00734, 32.82839]]], [[[-116.95669, 32.82962], [-116.95654, 32.83497], [-116.95635, 32.83495], [-116.95638, 32.83471], [-116.95628, 32.83455], [-116.95619, 32.83452], [-116.9561, 32.83434], [-116.95588, 32.83427], [-116.9558, 32.83427], [-116.95567, 32.83419], [-116.95552, 32.83414], [-116.95532, 32.83416], [-116.95531, 32.83414], [-116.95521, 32.83415], [-116.95506, 32.834], [-116.95488, 32.83367], [-116.95483, 32.83348], [-116.95482, 32.83335], [-116.95466, 32.83319], [-116.95474, 32.83289], [-116.95481, 32.83275], [-116.95485, 32.83257], [-116.95491, 32.83249], [-116.95499, 32.83243], [-116.95509, 32.83233], [-116.95517, 32.83224], [-116.95527, 32.83218], [-116.9553, 32.83219], [-116.95532, 32.83217], [-116.95532, 32.83212], [-116.95541, 32.83201], [-116.95548, 32.83199], [-116.95558, 32.83188], [-116.95562, 32.83175], [-116.95561, 32.83161], [-116.95555, 32.83146], [-116.95535, 32.83134], [-116.955, 32.83137], [-116.95486, 32.83146], [-116.95482, 32.83152], [-116.9548, 32.83153], [-116.9546, 32.83141], [-116.9544, 32.83131], [-116.95436, 32.83119], [-116.95433, 32.83116], [-116.95433, 32.8311], [-116.95428, 32.83098], [-116.95418, 32.83088], [-116.95405, 32.83081], [-116.9539, 32.83078], [-116.95377, 32.83079], [-116.95348, 32.83086], [-116.95322, 32.83097], [-116.95299, 32.83113], [-116.95286, 32.83129], [-116.95282, 32.83142], [-116.95268, 32.83165], [-116.95265, 32.83179], [-116.95256, 32.83194], [-116.95252, 32.83207], [-116.95241, 32.83209], [-116.95223, 32.83206], [-116.95219, 32.83203], [-116.95217, 32.83197], [-116.95212, 32.83195], [-116.95207, 32.83182], [-116.95202, 32.83174], [-116.95199, 32.83163], [-116.95184, 32.83144], [-116.95172, 32.83137], [-116.95157, 32.83134], [-116.9515, 32.83116], [-116.95147, 32.83115], [-116.95132, 32.83126], [-116.95125, 32.83126], [-116.95124, 32.83118], [-116.95112, 32.83102], [-116.95112, 32.83092], [-116.95141, 32.83042], [-116.95153, 32.83037], [-116.95186, 32.83031], [-116.95204, 32.83022], [-116.95224, 32.83004], [-116.95232, 32.82994], [-116.95238, 32.82984], [-116.95242, 32.82963], [-116.95669, 32.82962]]], [[[-116.95131, 32.82963], [-116.95131, 32.83021], [-116.95122, 32.83027], [-116.95114, 32.83034], [-116.9508, 32.83075], [-116.95075, 32.83091], [-116.95075, 32.83101], [-116.95077, 32.83111], [-116.95047, 32.83118], [-116.95015, 32.83128], [-116.94998, 32.83117], [-116.95013, 32.83091], [-116.95013, 32.8308], [-116.95008, 32.83067], [-116.94998, 32.83058], [-116.94958, 32.83037], [-116.94911, 32.83033], [-116.94862, 32.83057], [-116.94837, 32.83096], [-116.94836, 32.83124], [-116.94827, 32.83151], [-116.9481, 32.83187], [-116.94808, 32.83205], [-116.94813, 32.83206], [-116.94814, 32.83214], [-116.94818, 32.83221], [-116.94828, 32.8323], [-116.94837, 32.83233], [-116.94857, 32.83236], [-116.94871, 32.83283], [-116.94883, 32.83308], [-116.94895, 32.83323], [-116.94908, 32.83337], [-116.94922, 32.83348], [-116.94941, 32.8336], [-116.9494, 32.83373], [-116.94933, 32.83388], [-116.94937, 32.83402], [-116.94929, 32.83426], [-116.94925, 32.83428], [-116.94916, 32.83441], [-116.94916, 32.83458], [-116.94927, 32.83474], [-116.94935, 32.83481], [-116.94904, 32.83507], [-116.94889, 32.83516], [-116.94877, 32.83519], [-116.94865, 32.83519], [-116.94847, 32.83514], [-116.94833, 32.83504], [-116.94802, 32.83464], [-116.94782, 32.83444], [-116.94775, 32.83427], [-116.94741, 32.83415], [-116.94744, 32.83397], [-116.94744, 32.83386], [-116.94738, 32.83376], [-116.94719, 32.83358], [-116.94684, 32.83345], [-116.94671, 32.83333], [-116.94656, 32.83289], [-116.94632, 32.83245], [-116.94585, 32.83196], [-116.94545, 32.83191], [-116.94523, 32.83219], [-116.94506, 32.83233], [-116.94483, 32.83222], [-116.94437, 32.83145], [-116.94414, 32.83127], [-116.94397, 32.831], [-116.94378, 32.83089], [-116.94367, 32.8309], [-116.94335, 32.83102], [-116.94301, 32.83041], [-116.94316, 32.83037], [-116.94328, 32.83025], [-116.94331, 32.82988], [-116.94227, 32.82818], [-116.94213, 32.8282], [-116.94168, 32.82763], [-116.94133, 32.82731], [-116.94086, 32.82743], [-116.94112, 32.82837], [-116.9421, 32.83001], [-116.94262, 32.8298], [-116.94287, 32.83056], [-116.94318, 32.83109], [-116.94315, 32.8311], [-116.94297, 32.83097], [-116.94291, 32.83096], [-116.94281, 32.83096], [-116.94277, 32.83093], [-116.94254, 32.83101], [-116.94259, 32.83114], [-116.94266, 32.83123], [-116.94267, 32.83128], [-116.94263, 32.83149], [-116.94257, 32.83151], [-116.94251, 32.83141], [-116.94238, 32.83131], [-116.94194, 32.83113], [-116.94183, 32.83111], [-116.94152, 32.83112], [-116.9415, 32.83121], [-116.94097, 32.83047], [-116.94132, 32.83014], [-116.94004, 32.82856], [-116.93998, 32.82777], [-116.93891, 32.82645], [-116.93871, 32.82573], [-116.93798, 32.82498], [-116.93798, 32.82414], [-116.9438, 32.82422], [-116.9434, 32.82478], [-116.94597, 32.82657], [-116.94531, 32.82749], [-116.94581, 32.82963], [-116.95131, 32.82963]]], [[[-116.95321, 32.83622], [-116.95321, 32.83622], [-116.95179, 32.83622], [-116.95199, 32.83605], [-116.95199, 32.83583], [-116.95203, 32.83582], [-116.95203, 32.83578], [-116.9521, 32.83584], [-116.95218, 32.83588], [-116.95233, 32.83589], [-116.95239, 32.83598], [-116.95246, 32.83603], [-116.95283, 32.8361], [-116.95312, 32.83607], [-116.95314, 32.83611], [-116.95321, 32.83611], [-116.95321, 32.83622]]], [[[-116.95858, 32.83819], [-116.95645, 32.83814], [-116.95649, 32.83674], [-116.95652, 32.83678], [-116.95669, 32.83684], [-116.95683, 32.83684], [-116.95693, 32.83682], [-116.95696, 32.83687], [-116.95704, 32.83685], [-116.95729, 32.83718], [-116.95733, 32.83734], [-116.95738, 32.83739], [-116.95745, 32.83744], [-116.9576, 32.8375], [-116.95769, 32.83751], [-116.9578, 32.8375], [-116.9581, 32.83787], [-116.95824, 32.83794], [-116.95838, 32.83797], [-116.9585, 32.83812], [-116.95858, 32.83819]]], [[[-116.95265, 32.84001], [-116.95263, 32.84088], [-116.95214, 32.84086], [-116.95181, 32.84042], [-116.95154, 32.8401], [-116.95121, 32.83982], [-116.95087, 32.83959], [-116.95007, 32.83933], [-116.94968, 32.83922], [-116.94891, 32.83909], [-116.94852, 32.83906], [-116.94812, 32.83904], [-116.9472, 32.83907], [-116.94662, 32.83921], [-116.94627, 32.83963], [-116.94597, 32.84032], [-116.94593, 32.8407], [-116.94594, 32.84114], [-116.94614, 32.84158], [-116.94644, 32.8419], [-116.9467, 32.84202], [-116.94509, 32.84199], [-116.94511, 32.83552], [-116.94473, 32.83538], [-116.94445, 32.83451], [-116.94396, 32.83412], [-116.94368, 32.83361], [-116.94319, 32.83321], [-116.94306, 32.83331], [-116.94248, 32.8328], [-116.94175, 32.83178], [-116.94187, 32.83172], [-116.9419, 32.83174], [-116.94194, 32.83169], [-116.94197, 32.83162], [-116.94198, 32.83155], [-116.94196, 32.83149], [-116.94184, 32.83135], [-116.94225, 32.83152], [-116.94231, 32.83161], [-116.94234, 32.83176], [-116.9424, 32.83188], [-116.94248, 32.83193], [-116.94258, 32.83195], [-116.9427, 32.83193], [-116.94286, 32.83169], [-116.94289, 32.83161], [-116.94295, 32.83129], [-116.9431, 32.83146], [-116.9431, 32.83153], [-116.94313, 32.83157], [-116.9432, 32.8316], [-116.94317, 32.8318], [-116.9432, 32.83199], [-116.94342, 32.83234], [-116.94347, 32.83255], [-116.94356, 32.83267], [-116.94366, 32.83273], [-116.94379, 32.83301], [-116.94399, 32.83327], [-116.94447, 32.83355], [-116.94464, 32.83373], [-116.94479, 32.83397], [-116.94517, 32.83442], [-116.94533, 32.83466], [-116.94544, 32.8348], [-116.94544, 32.83493], [-116.9456, 32.83516], [-116.94577, 32.83527], [-116.94598, 32.83524], [-116.94629, 32.83513], [-116.94656, 32.83499], [-116.94678, 32.83481], [-116.94705, 32.83491], [-116.94732, 32.83489], [-116.94759, 32.83468], [-116.94771, 32.8348], [-116.94788, 32.83503], [-116.9479, 32.83516], [-116.94804, 32.83531], [-116.94817, 32.83534], [-116.9483, 32.83541], [-116.94845, 32.83547], [-116.94869, 32.8355], [-116.9487, 32.83556], [-116.95115, 32.83556], [-116.95109, 32.83771], [-116.95174, 32.83773], [-116.95169, 32.83944], [-116.95202, 32.83945], [-116.952, 32.84], [-116.95265, 32.84001]], [[-116.94884, 32.83757], [-116.94908, 32.83757], [-116.94938, 32.8373], [-116.94947, 32.83675], [-116.94879, 32.83666], [-116.94884, 32.83757]]], [[[-116.96895, 32.87857], [-116.96687, 32.87858], [-116.96687, 32.87678], [-116.96894, 32.87677], [-116.96895, 32.87857]]]]} | No Public Access 3 | 45248 | Rattlesnake Mountain | 24195 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 324.276 | Rattlesnake Mtn. | 0 | Private Conservation 16 | 2 | |
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 |
16908 | 16908 | 16907 | {"type": "Polygon", "coordinates": [[[-117.24764, 33.43349], [-117.24755, 33.43356], [-117.24749, 33.43379], [-117.24725, 33.43425], [-117.24708, 33.43464], [-117.24704, 33.4348], [-117.24703, 33.43509], [-117.24706, 33.43524], [-117.24711, 33.43543], [-117.24713, 33.43582], [-117.24704, 33.43686], [-117.24703, 33.43761], [-117.24701, 33.43771], [-117.24694, 33.43784], [-117.24682, 33.43797], [-117.24664, 33.43805], [-117.24658, 33.43806], [-117.24611, 33.43833], [-117.246, 33.43843], [-117.24594, 33.43853], [-117.24241, 33.43684], [-117.24264, 33.43527], [-117.2425, 33.43413], [-117.2422, 33.43397], [-117.24202, 33.43414], [-117.24151, 33.43426], [-117.24138, 33.43426], [-117.24136, 33.43193], [-117.2441, 33.43197], [-117.24701, 33.43192], [-117.24726, 33.43248], [-117.24764, 33.43349]]]} | Open Access 1 | 12581 | Rock Mountain Preserve | 24510 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/rock-mountain.html | San Diego 4 | 76.127 | Rock Mtn. Preserve | 0 | Private Conservation 16 | 2 |
16903 | 16903 | 16902 | {"type": "Polygon", "coordinates": [[[-119.4705, 37.00923], [-119.48101, 37.00954], [-119.47739, 37.01125], [-119.47204, 37.01411], [-119.47068, 37.01486], [-119.4707, 37.01538], [-119.47069, 37.01639], [-119.47003, 37.01635], [-119.46892, 37.01634], [-119.46835, 37.0174], [-119.46819, 37.01854], [-119.4683, 37.01929], [-119.46862, 37.02004], [-119.4699, 37.02217], [-119.47038, 37.02338], [-119.47044, 37.02372], [-119.46563, 37.0237], [-119.46181, 37.02347], [-119.46199, 37.02735], [-119.46646, 37.02738], [-119.46647, 37.02727], [-119.46727, 37.02728], [-119.46728, 37.02724], [-119.46817, 37.02723], [-119.46838, 37.02694], [-119.46854, 37.02693], [-119.46852, 37.02545], [-119.46871, 37.02564], [-119.46871, 37.02728], [-119.46864, 37.02729], [-119.46876, 37.03083], [-119.47022, 37.03086], [-119.47022, 37.03104], [-119.46884, 37.03101], [-119.46206, 37.03098], [-119.46199, 37.02735], [-119.45751, 37.02724], [-119.45743, 37.02365], [-119.453, 37.02364], [-119.45298, 37.01999], [-119.45282, 37.0164], [-119.44827, 37.01635], [-119.44815, 37.01283], [-119.44373, 37.0128], [-119.43919, 37.01275], [-119.43493, 37.0126], [-119.435, 37.00904], [-119.42135, 37.00884], [-119.42131, 36.99474], [-119.43021, 36.99511], [-119.43034, 37.00213], [-119.43485, 37.00214], [-119.43493, 37.00554], [-119.43947, 37.00563], [-119.45272, 37.00573], [-119.45268, 37.00919], [-119.45269, 37.0092], [-119.46145, 37.00922], [-119.46598, 37.00928], [-119.4705, 37.00923]], [[-119.43034, 37.00215], [-119.42581, 37.00206], [-119.42587, 37.00554], [-119.43037, 37.00554], [-119.43034, 37.00215]]]} | Open Access 1 | 7684 | Mary Elizabeth Miller Preserve at Black Mountain | 29280 | 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 | http://awww.sierrafoothill.org/index.php/land/preserves/mary-elizabeth-miller-preserve/ | Fresno 9 | 1460.655 | Mary Elizabeth Miller Preserve at Black Mtn. | 0 | Private Conservation 16 | 2 |
16810 | 16810 | 16809 | {"type": "Polygon", "coordinates": [[[-123.53176, 38.79603], [-123.52979, 38.79762], [-123.52905, 38.79637], [-123.52785, 38.79494], [-123.52811, 38.79484], [-123.52838, 38.79482], [-123.5285, 38.79482], [-123.52897, 38.79489], [-123.52942, 38.79536], [-123.53153, 38.79567], [-123.53176, 38.79603]]]} | Open Access 1 | 48503 | Redwood Coast Recreation Center | 33212 | 3389 | Redwood Coast Recreation Center 1176 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/#about | Non Governmental Organization 10 | 3389 | Redwood Coast Recreation Center 1116 | Non Profit 6 | Non Profit - Conservation 12 | http://rcrcpool.org/ | Mendocino 24 | 11.148 | Redwood Coast Rec. Ctr. | 1999 | Private Conservation 16 | 2 |
16654 | 16654 | 16653 | {"type": "MultiPolygon", "coordinates": [[[[-115.66924, 33.61112], [-115.66923, 33.61294], [-115.66696, 33.61293], [-115.66697, 33.61112], [-115.66924, 33.61112]]], [[[-115.67834, 33.60387], [-115.67834, 33.60569], [-115.67607, 33.60569], [-115.67608, 33.60387], [-115.67834, 33.60387]]], [[[-115.76491, 33.5382], [-115.76059, 33.53822], [-115.76058, 33.53641], [-115.76489, 33.53639], [-115.76491, 33.5382]]], [[[-115.78358, 33.58041], [-115.779, 33.58027], [-115.77894, 33.57662], [-115.78351, 33.57676], [-115.78358, 33.58041]]]]} | Restricted Access 2 | 48548 | Orocopia Mountains Wilderness Area | 33267 | 3025 | Friends of the Desert Mountains 281 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.desertmountains.org/ | Non Governmental Organization 10 | 3025 | Friends of the Desert Mountains 277 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.blm.gov/visit/orocopia-mountains-wilderness | Riverside 10 | 83.319 | Orocopia Mtns. Wilderness Area | 1994 | Private Conservation 16 | 2 |
16616 | 16616 | 16615 | {"type": "MultiPolygon", "coordinates": [[[[-118.29226, 35.67424], [-118.29028, 35.67426], [-118.29026, 35.67365], [-118.29076, 35.67366], [-118.29168, 35.67375], [-118.29226, 35.67408], [-118.29226, 35.67424]]], [[[-118.29062, 35.67315], [-118.29038, 35.67314], [-118.29037, 35.67301], [-118.29037, 35.67301], [-118.29062, 35.67315]]]]} | Unknown Access 4 | 43064 | National Audubon Society 20 | 22650 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 2.496 | Nat. Audubon Society 20 | 0 | Private Conservation 16 | 2 | |
16516 | 16516 | 16515 | {"type": "Polygon", "coordinates": [[[-118.29012, 35.69205], [-118.28803, 35.69205], [-118.28803, 35.69251], [-118.2814, 35.6925], [-118.28132, 35.69068], [-118.2747, 35.69061], [-118.27464, 35.68696], [-118.27242, 35.68693], [-118.27242, 35.68512], [-118.2769, 35.68515], [-118.27693, 35.68874], [-118.29007, 35.68874], [-118.29008, 35.69014], [-118.29012, 35.69205]]]} | Unknown Access 4 | 36142 | National Audubon Society 18 | 22647 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 141.001 | Nat. Audubon Society 18 | 0 | Private Conservation 16 | 2 | |
16411 | 16411 | 16410 | {"type": "Polygon", "coordinates": [[[-119.75792, 36.91239], [-119.75661, 36.91246], [-119.75643, 36.91024], [-119.75775, 36.91023], [-119.75792, 36.91239]]]} | Open Access 1 | 25932 | River Center | 24407 | 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 | 7.035 | River Ctr. | 0 | Private Conservation 16 | 2 | |
16380 | 16380 | 16379 | {"type": "Polygon", "coordinates": [[[-118.2968, 35.69602], [-118.29474, 35.69602], [-118.29474, 35.69437], [-118.29674, 35.69595], [-118.2968, 35.69602]]]} | Unknown Access 4 | 43028 | National Audubon Society 17 | 22646 | 3046 | National Audubon Society 651 | Non Profit 6 | Non Profit - Conservation 12 | http://ca.audubon.org/ | Non Governmental Organization 10 | 3046 | National Audubon Society 640 | Non Profit 6 | Non Profit - Conservation 12 | Kern 36 | 4.294 | Nat. Audubon Society 17 | 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]);