units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
802 rows where MNG_AG_LEV = 6 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, LAYER, GAP_STS
MNG_AGENCY >30
- The Nature Conservancy 51
- National Audubon Society 32
- Mountains Restoration Trust 30
- Rivers and Lands Conservancy 28
- Peninsula Open Space Trust 27
- Center for Natural Lands Management 25
- Sonoma Land Trust 25
- The Wildlands Conservancy 24
- Truckee Donner Land Trust 24
- Big Sur Land Trust 21
- The Environmental Trust 21
- American River Conservancy 20
- Save the Redwoods League 18
- Land Trust of Napa County 18
- Sempervirens Fund 18
- Save Mount Diablo 17
- Land Trust of Santa Cruz County 16
- Fallbrook Land Conservancy 15
- Endangered Habitats Conservancy 14
- Wilderness Land Trust 14
- San Joaquin River Parkway and Conservation Trust 12
- Bear Yuba Land Trust 10
- Friends of the Desert Mountains 10
- Del Monte Forest Foundation 10
- Mojave Desert Land Trust 10
- Marin Audubon Society 9
- Elkhorn Slough Foundation 9
- The Conservation Fund - California 9
- John Muir Land Trust 8
- Solano Land Trust 8
- …
DES_TP >30
- Private Conservation 613
- Private Recreation or Education 76
- Private Other or Unknown 51
- Private Agricultural 12
- National Monument or Landmark 4
- Private Historic or Cultural 4
- State Conservation Area 1
- State Park 1
- State Recreation Area 1
- State Other or Unknown 1
- National Wildlife Refuge 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
MNG_AG_TYP 5
ACCESS_TYP 4
- Open Access 302
- No Public Access 268
- Restricted Access 168
- Unknown Access 64
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 | |
16972 | 16972 | 16971 | {"type": "MultiPolygon", "coordinates": [[[[-118.67434, 34.03964], [-118.67429, 34.03977], [-118.67426, 34.03994], [-118.67425, 34.04043], [-118.67418, 34.04053], [-118.67404, 34.04067], [-118.67399, 34.04073], [-118.67394, 34.04093], [-118.67391, 34.04099], [-118.67372, 34.04118], [-118.67363, 34.04133], [-118.67354, 34.0416], [-118.67352, 34.04184], [-118.67346, 34.04201], [-118.6734, 34.04213], [-118.67323, 34.04235], [-118.6733, 34.04205], [-118.6733, 34.04199], [-118.67328, 34.04194], [-118.67375, 34.04068], [-118.67374, 34.04061], [-118.67368, 34.04054], [-118.67358, 34.0405], [-118.67252, 34.04064], [-118.67253, 34.04059], [-118.6735, 34.04045], [-118.67361, 34.04045], [-118.67371, 34.04048], [-118.67376, 34.04053], [-118.6738, 34.0406], [-118.67381, 34.04064], [-118.67382, 34.04065], [-118.67387, 34.04052], [-118.67402, 34.03978], [-118.67399, 34.03952], [-118.67425, 34.03936], [-118.67428, 34.03938], [-118.67432, 34.03946], [-118.67434, 34.03964]]], [[[-118.67508, 34.03923], [-118.6749, 34.04047], [-118.67444, 34.0432], [-118.67375, 34.04319], [-118.67367, 34.04274], [-118.67333, 34.04244], [-118.67355, 34.04212], [-118.67363, 34.04194], [-118.6742, 34.04205], [-118.67421, 34.04204], [-118.67431, 34.04138], [-118.67404, 34.04102], [-118.67408, 34.04094], [-118.67409, 34.04083], [-118.67413, 34.04074], [-118.67432, 34.04056], [-118.67438, 34.04045], [-118.67439, 34.03997], [-118.67448, 34.03958], [-118.67447, 34.03948], [-118.67442, 34.03937], [-118.67421, 34.03914], [-118.67418, 34.03908], [-118.67417, 34.03901], [-118.67421, 34.03884], [-118.6742, 34.03876], [-118.67416, 34.03867], [-118.67442, 34.03858], [-118.67464, 34.039], [-118.67508, 34.03923]]]]} | No Public Access 3 | 12520 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 9.545 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16970 | 16970 | 16969 | {"type": "Polygon", "coordinates": [[[-118.62222, 34.10346], [-118.62187, 34.10346], [-118.62175, 34.10335], [-118.62193, 34.10321], [-118.62222, 34.10346]]]} | No Public Access 3 | 12502 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.156 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16969 | 16969 | 16968 | {"type": "Polygon", "coordinates": [[[-118.6238, 34.10536], [-118.62339, 34.10535], [-118.62338, 34.10426], [-118.62367, 34.10438], [-118.6238, 34.10442], [-118.6238, 34.10536]]]} | Restricted Access 2 | 12501 | Mountains Restoration Trust Parkland | 29662 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 1.053 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16965 | 16965 | 16964 | {"type": "Polygon", "coordinates": [[[-118.60409, 34.06453], [-118.60408, 34.06544], [-118.60193, 34.06544], [-118.60193, 34.06453], [-118.60409, 34.06453]]]} | No Public Access 3 | 12509 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 4.966 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16958 | 16958 | 16957 | {"type": "Polygon", "coordinates": [[[-118.62162, 34.10069], [-118.62138, 34.1008], [-118.62131, 34.10072], [-118.62156, 34.10061], [-118.62162, 34.10069]]]} | No Public Access 3 | 12507 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.069 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16957 | 16957 | 16956 | {"type": "Polygon", "coordinates": [[[-118.77416, 34.04757], [-118.77403, 34.04762], [-118.77363, 34.04741], [-118.7737, 34.04729], [-118.77414, 34.04746], [-118.77416, 34.04757]]]} | No Public Access 3 | 12504 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.213 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
16954 | 16954 | 16953 | {"type": "Polygon", "coordinates": [[[-118.77802, 34.04594], [-118.77704, 34.04594], [-118.77695, 34.0458], [-118.77801, 34.0458], [-118.77802, 34.04594]]]} | No Public Access 3 | 12522 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.35 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
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 |
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]);