units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
92 rows where DES_TP = 16 and MNG_AG_TYP = 12 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, COUNTY, YR_EST
MNG_AGENCY 27
- National Audubon Society 27
- Endangered Habitats Conservancy 14
- Marin Audubon Society 9
- San Diego River Park Foundation 7
- Del Monte Forest Foundation 5
- Audubon Canyon Ranch 5
- Mountains Restoration Trust 3
- Morro Coast Audubon Society 2
- Friends of the Enchanted Meadow 2
- California Biological Field Studies Association 1
- Community Environmental Council 1
- California Academy of Sciences 1
- North Star Historic Conservancy 1
- San Diego Audubon Society 1
- Sequoia Audubon Society 1
- North Fork Association 1
- Elings Park Foundation 1
- Redwood Coast Land Conservancy 1
- Trust for Hidden Villa 1
- Friends of the Tuolumne 1
- Placer Legacy 1
- Watsonville Wetlands Watch 1
- Marin Conservation League 1
- Living Landscape Initiative Partners 1
- River Partners 1
- Batiquitos Lagoon Foundation 1
- Redwood Coast Recreation Center 1
ACCESS_TYP 4
- No Public Access 28
- Open Access 27
- Unknown Access 23
- Restricted Access 14
MNG_AG_TYP 1
- Non Profit - Conservation · 92 ✖
LAYER 1 ✖
DES_TP 1
- Private Conservation · 92 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 | 2004 | 2003 | {"type": "Polygon", "coordinates": [[[-120.83864, 35.3316], [-120.83864, 35.33176], [-120.83843, 35.33176], [-120.83823, 35.33167], [-120.83823, 35.33139], [-120.83864, 35.3316]]]} | Open Access 1 | 16907 | Audubon Overlook | 15703 | 3043 | Morro Coast Audubon Society 468 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | San Luis Obispo 1 | 0.256 | Audubon Overlook | 0 | Private Conservation 16 | 2 | |
11226 | 11226 | 11225 | {"type": "Polygon", "coordinates": [[[-121.20019, 38.71522], [-121.20005, 38.71565], [-121.19981, 38.71561], [-121.19954, 38.7156], [-121.19959, 38.71518], [-121.20019, 38.71522]]]} | Open Access 1 | 21564 | Elsami | 18603 | 3056 | Placer Legacy 969 | Non Profit 6 | Non Profit - Conservation 12 | http://www.placer.ca.gov/departments/communitydevelopment/planning/placerlegacy | Non Governmental Organization 10 | 3056 | Placer Legacy 935 | Non Profit 6 | Non Profit - Conservation 12 | Placer 35 | 0.573 | Elsami | 0 | Private Conservation 16 | 2 | |
3739 | 3739 | 3738 | {"type": "Polygon", "coordinates": [[[-122.53527, 38.06893], [-122.5352, 38.06916], [-122.53501, 38.06911], [-122.53442, 38.06923], [-122.53406, 38.06927], [-122.53308, 38.06944], [-122.53252, 38.06952], [-122.53229, 38.06957], [-122.53239, 38.06949], [-122.53251, 38.06943], [-122.5325, 38.06937], [-122.53297, 38.06927], [-122.53439, 38.06908], [-122.53527, 38.06893]]]} | No Public Access 3 | 31028 | Marin Audubon Society | 21815 | 3039 | Marin Audubon Society 261 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinaudubon.org | Non Governmental Organization 10 | 3039 | Marin Audubon Society 257 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 1.098 | Marin Audubon Society | 0 | Private Conservation 16 | 2 | |
13192 | 13192 | 13191 | {"type": "Polygon", "coordinates": [[[-121.97264, 36.58026], [-121.97194, 36.58041], [-121.97168, 36.58018], [-121.97156, 36.57995], [-121.97243, 36.57965], [-121.97257, 36.57999], [-121.97264, 36.58026]]]} | Open Access 1 | 35189 | S.F.B. Morse Memorial Lot | 28537 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.252 | S.F.B. Morse Memorial Lot | 0 | Private Conservation 16 | 2 | |
13186 | 13186 | 13185 | {"type": "Polygon", "coordinates": [[[-121.95578, 36.56241], [-121.95541, 36.5627], [-121.95521, 36.56252], [-121.9544, 36.56194], [-121.95423, 36.56185], [-121.95402, 36.56181], [-121.95408, 36.56142], [-121.95494, 36.56186], [-121.95578, 36.56241]]]} | Open Access 1 | 35176 | Pescadero Point and Hill Preserve | 28527 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.664 | Pescadero Point and Hill Preserve | 0 | Private Conservation 16 | 2 | |
12992 | 12992 | 12991 | {"type": "Polygon", "coordinates": [[[-122.52978, 37.8954], [-122.52954, 37.89543], [-122.52847, 37.89519], [-122.52798, 37.89489], [-122.5279, 37.89438], [-122.52814, 37.89335], [-122.52828, 37.89337], [-122.52811, 37.89431], [-122.52822, 37.89474], [-122.52855, 37.89493], [-122.52945, 37.89515], [-122.52977, 37.89515], [-122.52978, 37.8954]]]} | No Public Access 3 | 31029 | Marin Audubon Society | 21815 | 3039 | Marin Audubon Society 261 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinaudubon.org | Non Governmental Organization 10 | 3039 | Marin Audubon Society 257 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 1.819 | Marin Audubon Society | 0 | Private Conservation 16 | 2 | |
11546 | 11546 | 11545 | {"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]} | No Public Access 3 | 46824 | Guyot/La Cresta Property | 30292 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 1.954 | Guyot/La Cresta Property | 0 | 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 | |
196 | 196 | 195 | {"type": "Polygon", "coordinates": [[[-116.80824, 32.84466], [-116.80813, 32.84546], [-116.80736, 32.84567], [-116.80702, 32.84516], [-116.80704, 32.84466], [-116.80824, 32.84466]]]} | No Public Access 3 | 46830 | Palmer Property | 30298 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 2.548 | Palmer Property | 0 | Private Conservation 16 | 2 | |
11540 | 11540 | 11539 | {"type": "Polygon", "coordinates": [[[-116.88944, 32.80854], [-116.88892, 32.80921], [-116.88842, 32.809], [-116.8881, 32.80881], [-116.88819, 32.80758], [-116.88937, 32.8079], [-116.88944, 32.80854]]]} | No Public Access 3 | 46832 | Saxena/La Cresta Property | 30300 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 4.044 | Saxena/La Cresta Property | 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 | |
13187 | 13187 | 13186 | {"type": "Polygon", "coordinates": [[[-121.95407, 36.56142], [-121.95402, 36.56181], [-121.95362, 36.56184], [-121.9532, 36.56194], [-121.9528, 36.56209], [-121.95254, 36.56226], [-121.95162, 36.56178], [-121.95157, 36.56134], [-121.95185, 36.56108], [-121.95365, 36.5612], [-121.95407, 36.56142]]]} | Open Access 1 | 35177 | Pescadero Point and Hill Preserve | 28527 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 4.86 | Pescadero Point and Hill Preserve | 0 | Private Conservation 16 | 2 | |
2300 | 2300 | 2299 | {"type": "Polygon", "coordinates": [[[-119.71423, 34.41147], [-119.71286, 34.41261], [-119.71211, 34.41205], [-119.71252, 34.41167], [-119.71232, 34.41149], [-119.71267, 34.41116], [-119.7132, 34.41071], [-119.71401, 34.41104], [-119.71423, 34.41147]]]} | Open Access 1 | 16932 | Honda Valley Park - Community Environmental Council | 20066 | 3015 | Community Environmental Council 508 | Non Profit 6 | Non Profit - Conservation 12 | http://www.communityenvironmentalcouncil.org/ | Non Governmental Organization 10 | 3015 | Community Environmental Council 500 | Non Profit 6 | Non Profit - Conservation 12 | Santa Barbara 7 | 5.43 | Honda Valley Park - Community Environmental Council | 0 | Private Conservation 16 | 2 | |
12493 | 12493 | 12492 | {"type": "Polygon", "coordinates": [[[-121.77745, 36.91053], [-121.77722, 36.91156], [-121.77673, 36.91208], [-121.77635, 36.91196], [-121.77603, 36.91181], [-121.77584, 36.91168], [-121.7757, 36.91157], [-121.77547, 36.91132], [-121.77591, 36.91037], [-121.77745, 36.91053]]]} | Open Access 1 | 28302 | Tarplant Hill | 26191 | 3118 | Watsonville Wetlands Watch 1028 | Non Profit 6 | Non Profit - Conservation 12 | http://www.watsonvillewetlandswatch.org/ | Non Governmental Organization 10 | 3118 | Watsonville Wetlands Watch 989 | Non Profit 6 | Non Profit - Conservation 12 | Santa Cruz 5 | 5.694 | Tarplant Hill | 0 | Private Conservation 16 | 2 | |
9139 | 9139 | 9138 | {"type": "Polygon", "coordinates": [[[-123.64935, 38.84992], [-123.64931, 38.84997], [-123.64904, 38.85012], [-123.6491, 38.8502], [-123.64922, 38.8503], [-123.64935, 38.85043], [-123.64926, 38.85052], [-123.64925, 38.85081], [-123.64913, 38.85087], [-123.64879, 38.8509], [-123.6488, 38.85097], [-123.64889, 38.851], [-123.64926, 38.851], [-123.64932, 38.85103], [-123.64924, 38.85123], [-123.64905, 38.85129], [-123.64886, 38.85128], [-123.64865, 38.85135], [-123.64865, 38.8514], [-123.64859, 38.85151], [-123.64858, 38.8516], [-123.64874, 38.85164], [-123.64862, 38.8517], [-123.64861, 38.85178], [-123.6485, 38.85183], [-123.64834, 38.85186], [-123.64822, 38.85194], [-123.64778, 38.85177], [-123.6477, 38.85162], [-123.64757, 38.85111], [-123.64735, 38.85059], [-123.64703, 38.8501], [-123.64817, 38.84956], [-123.6482, 38.84968], [-123.64816, 38.84975], [-123.64816, 38.84981], [-123.64797, 38.84979], [-123.64779, 38.84979], [-123.64762, 38.85], [-123.64765, 38.85012], [-123.64778, 38.85034], [-123.64793, 38.85047], [-123.64806, 38.85051], [-123.64829, 38.85043], [-123.64844, 38.85027], [-123.64843, 38.85018], [-123.64865, 38.85004], [-123.64885, 38.84997], [-123.64907, 38.84994], [-123.64935, 38.84992]]]} | Open Access 1 | 48998 | Hearn Gulch | 33693 | 3303 | Redwood Coast Land Conservancy 904 | Non Profit 6 | Non Profit - Conservation 12 | http://www.rc-lc.org/ | Non Governmental Organization 10 | 3303 | Redwood Coast Land Conservancy 879 | Non Profit 6 | Non Profit - Conservation 12 | https://www.rclc.org/hearn-gulch/ | Mendocino 24 | 6.409 | Hearn Gulch | 2008 | Private Conservation 16 | 2 |
15947 | 15947 | 15946 | {"type": "Polygon", "coordinates": [[[-122.49954, 37.89424], [-122.49884, 37.89498], [-122.49752, 37.89514], [-122.49729, 37.89525], [-122.49639, 37.89483], [-122.49647, 37.89479], [-122.49673, 37.89397], [-122.49747, 37.89359], [-122.49821, 37.89349], [-122.49911, 37.89369], [-122.49954, 37.89424]]]} | No Public Access 3 | 5202 | Audubon Society Lyford House Open Space Area | 15705 | 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 | Marin 23 | 9.091 | Audubon Society Lyford House OS Area | 0 | Private Conservation 16 | 2 | |
4322 | 4322 | 4321 | {"type": "Polygon", "coordinates": [[[-123.7274, 39.24845], [-123.72682, 39.2487], [-123.72662, 39.2486], [-123.72645, 39.24844], [-123.72609, 39.24815], [-123.72594, 39.24806], [-123.72562, 39.24794], [-123.72529, 39.24766], [-123.72488, 39.24741], [-123.72471, 39.24728], [-123.72437, 39.24658], [-123.72419, 39.2464], [-123.72412, 39.2462], [-123.72418, 39.24532], [-123.72483, 39.24527], [-123.72523, 39.24513], [-123.7251, 39.24577], [-123.72525, 39.24628], [-123.72568, 39.24692], [-123.72603, 39.24724], [-123.72638, 39.24732], [-123.72713, 39.24796], [-123.72724, 39.24812], [-123.72735, 39.24824], [-123.7274, 39.24845]]]} | Open Access 1 | 45424 | Albert Cattalini Conservancy | 28204 | 3353 | Friends of the Enchanted Meadow 744 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/ | Non Governmental Organization 10 | 3353 | Friends of the Enchanted Meadow 730 | Non Profit 6 | Non Profit - Conservation 12 | http://www.friendsofenchantedmeadow.org/acc.html | Mendocino 24 | 9.326 | Albert Cattalini Conservancy | 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 |
13193 | 13193 | 13192 | {"type": "Polygon", "coordinates": [[[-121.97332, 36.57802], [-121.97338, 36.57809], [-121.97338, 36.57814], [-121.97336, 36.57819], [-121.97331, 36.57824], [-121.97312, 36.57833], [-121.97302, 36.57843], [-121.97297, 36.57853], [-121.97293, 36.57871], [-121.97263, 36.57919], [-121.97258, 36.57922], [-121.97253, 36.57924], [-121.97246, 36.57923], [-121.97242, 36.57921], [-121.9721, 36.57881], [-121.97039, 36.57694], [-121.97018, 36.57673], [-121.97014, 36.57667], [-121.97012, 36.57657], [-121.97014, 36.57584], [-121.97018, 36.57573], [-121.97027, 36.57565], [-121.97038, 36.5756], [-121.97052, 36.57559], [-121.97066, 36.57564], [-121.97074, 36.57569], [-121.97096, 36.57594], [-121.97118, 36.57611], [-121.97227, 36.57678], [-121.97236, 36.57686], [-121.97251, 36.57711], [-121.97271, 36.57731], [-121.97281, 36.57755], [-121.97292, 36.57771], [-121.97307, 36.57787], [-121.97332, 36.57802]]]} | Open Access 1 | 35190 | Crocker Grove | 28538 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 12.522 | Crocker Grove | 0 | Private Conservation 16 | 2 | |
3308 | 3308 | 3307 | {"type": "Polygon", "coordinates": [[[-116.87605, 32.81198], [-116.87602, 32.81296], [-116.87303, 32.81508], [-116.87286, 32.81473], [-116.87304, 32.8145], [-116.87303, 32.81413], [-116.87289, 32.81331], [-116.87318, 32.8132], [-116.87335, 32.81308], [-116.87345, 32.81299], [-116.87353, 32.81288], [-116.87364, 32.81257], [-116.87401, 32.81237], [-116.87427, 32.81228], [-116.87453, 32.81222], [-116.87555, 32.8121], [-116.8758, 32.81205], [-116.87605, 32.81198]]]} | No Public Access 3 | 46828 | La Cresta Hills Property | 30296 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 12.874 | La Cresta Hills Property | 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]);