units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,139 rows where AGNCY_LEV = 4 and DES_TP = 2 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP
MNG_AGENCY >30
- Consumnes Community Services District 90
- Hayward Area Recreation and Park District 74
- East Bay Regional Park District 56
- Valley-Wide Recreation and Park District 49
- Mountains Recreation and Conservation Authority 43
- Rancho Simi Recreation and Park District 42
- Cordova Recreation and Park District 37
- Southgate Recreation and Park District 34
- Greater Vallejo Recreation and Park District 29
- Conejo Recreation and Park District 25
- Sunrise Recreation and Park District 25
- Pleasant Valley Recreation and Park District 24
- North of the River Recreation and Park District 24
- El Dorado Hills Community Service District 20
- Whittier, City of 18
- Jurupa Area Recreation and Park District 16
- San Diego Unified Port District 15
- Olivehurst Public Utility District 15
- Los Angeles Unified School District 15
- Mission Oaks Recreation and Park District 14
- San Ramon, City of 13
- Fresno Metropolitan Flood Control District 13
- Isla Vista Recreation and Park District 12
- Apple Valley Recreation and Park District 10
- Carmichael Recreation and Park District 10
- Jurupa Community Services District 10
- North Highland Recreation and Park District 10
- Pleasant Hill Recreation and Park District 9
- Hesperia Recreation and Park District 9
- Monterey Peninsula Regional Park District 8
- …
MNG_AG_TYP 14
- Recreation/Parks District 669
- Community Services District 171
- City Agency 116
- Open Space District 51
- Water District 35
- School District 32
- Port/Harbor District 22
- Flood District 17
- Special District - Other 9
- County Agency - Parks 7
- County Agency 5
- Cemetery District 3
- Irrigation District 1
- Sanitation District 1
ACCESS_TYP 4
- Open Access 968
- Restricted Access 143
- No Public Access 25
- Unknown Access 3
DES_TP 1
- Local Park · 1,139 ✖
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB ▼ | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
189 | 189 | 188 | {"type": "Polygon", "coordinates": [[[-121.69813, 38.13724], [-121.69797, 38.13757], [-121.69794, 38.13778], [-121.698, 38.138], [-121.698, 38.13839], [-121.69766, 38.13941], [-121.69748, 38.13979], [-121.69707, 38.14119], [-121.69655, 38.14207], [-121.69614, 38.14262], [-121.69612, 38.14317], [-121.69601, 38.14374], [-121.69455, 38.14262], [-121.69398, 38.1421], [-121.69404, 38.14198], [-121.69415, 38.14179], [-121.69439, 38.14132], [-121.69453, 38.14097], [-121.69475, 38.14037], [-121.69492, 38.14001], [-121.6952, 38.13921], [-121.6953, 38.13884], [-121.69555, 38.13824], [-121.69594, 38.13708], [-121.6961, 38.13642], [-121.69719, 38.1368], [-121.69813, 38.13724]]]} | Open Access 1 | 520 | Sandy Beach Park | 25025 | 2187 | Solano Tri-City and County Cooperative Planning Group 74 | Special District 4 | Open Space District 6 | Special District 4 | 2187 | Solano Tri-City and County Cooperative Planning Group 72 | Special District 4 | Open Space District 6 | Solano 26 | 36.239 | Sandy Beach Park | 0 | Local Park 2 | 4 | ||
351 | 351 | 350 | {"type": "Polygon", "coordinates": [[[-119.32193, 36.20761], [-119.32189, 36.20923], [-119.32081, 36.20925], [-119.32078, 36.20934], [-119.31981, 36.20934], [-119.31987, 36.20762], [-119.32193, 36.20761]]]} | Open Access 1 | 969 | Tulare Veterans Memorial Park | 26570 | 2168 | Tulare Veterans Memorial District 144 | Special District 4 | Cemetery District 11 | Special District 4 | 2168 | Tulare Veterans Memorial District 140 | Special District 4 | Cemetery District 11 | Tulare 29 | 8.555 | Tulare Veterans Memorial Park | 0 | Local Park 2 | 4 | ||
818 | 818 | 817 | {"type": "Polygon", "coordinates": [[[-117.1878, 34.44347], [-117.18605, 34.44348], [-117.18605, 34.44269], [-117.18779, 34.44268], [-117.1878, 34.44347]]]} | Open Access 1 | 5287 | Mendel Park | 22148 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.478 | Mendel Park | 0 | Local Park 2 | 4 | ||
910 | 910 | 909 | {"type": "Polygon", "coordinates": [[[-117.21458, 34.53082], [-117.21419, 34.53082], [-117.21418, 34.53128], [-117.21261, 34.53128], [-117.2126, 34.53013], [-117.21265, 34.53009], [-117.21457, 34.53009], [-117.21458, 34.53082]]]} | Open Access 1 | 5810 | Thunderbird Park | 26338 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 5.461 | Thunderbird Park | 0 | Local Park 2 | 4 | ||
1307 | 1307 | 1306 | {"type": "MultiPolygon", "coordinates": [[[[-118.63657, 34.26504], [-118.63633, 34.26516], [-118.63617, 34.26526], [-118.63601, 34.2654], [-118.63587, 34.26558], [-118.6358, 34.26572], [-118.63574, 34.26588], [-118.63571, 34.26605], [-118.63569, 34.26628], [-118.63564, 34.26647], [-118.63554, 34.26667], [-118.63539, 34.26684], [-118.63447, 34.26759], [-118.63418, 34.26779], [-118.63386, 34.26798], [-118.63327, 34.26823], [-118.63273, 34.2646], [-118.63657, 34.26504]]], [[[-118.63485, 34.26765], [-118.63449, 34.26821], [-118.63372, 34.26845], [-118.63334, 34.26871], [-118.63329, 34.2684], [-118.6338, 34.26819], [-118.63416, 34.26801], [-118.63449, 34.2678], [-118.63477, 34.26758], [-118.63485, 34.26765]]], [[[-118.65762, 34.27232], [-118.65772, 34.2726], [-118.65771, 34.27281], [-118.65769, 34.27297], [-118.65755, 34.27344], [-118.65753, 34.27346], [-118.65749, 34.27338], [-118.65642, 34.27257], [-118.65573, 34.27221], [-118.6555, 34.27195], [-118.65574, 34.27169], [-118.65574, 34.27168], [-118.65499, 34.27151], [-118.65408, 34.27081], [-118.65349, 34.27065], [-118.65242, 34.27019], [-118.65185, 34.27015], [-118.65094, 34.26998], [-118.65002, 34.26966], [-118.65006, 34.26918], [-118.64922, 34.26888], [-118.64886, 34.26879], [-118.64705, 34.26807], [-118.64679, 34.26814], [-118.64604, 34.26809], [-118.6458, 34.26796], [-118.64547, 34.26785], [-118.64495, 34.26758], [-118.64462, 34.26755], [-118.64414, 34.26724], [-118.64391, 34.26694], [-118.64358, 34.26675], [-118.64244, 34.26649], [-118.64221, 34.26578], [-118.64205, 34.2657], [-118.64022, 34.26616], [-118.63857, 34.266], [-118.63825, 34.26619], [-118.63802, 34.26604], [-118.63773, 34.26595], [-118.63661, 34.26612], [-118.63614, 34.26631], [-118.6356, 34.26704], [-118.6354, 34.2672], [-118.63532, 34.26713], [-118.6356, 34.26688], [-118.6357, 34.26676], [-118.63579, 34.26662], [-118.63588, 34.26636], [-118.63591, 34.26604], [-118.63594, 34.26588], [-118.636, 34.26574], [-118.63609, 34.2656], [-118.63624, 34.26544], [-118.63642, 34.2653], [-118.63663, 34.2652], [-118.63687, 34.26513], [-118.63725, 34.26529], [-118.63763, 34.2653], [-118.63817, 34.26541], [-118.6387, 34.26529], [-118.64734, 34.26629], [-118.64784, 34.26632], [-118.6482, 34.2663], [-118.64863, 34.26625], [-118.64905, 34.26617], [-118.64946, 34.26604], [-118.64985, 34.26589], [-118.65022, 34.26569], [-118.65061, 34.26543], [-118.65172, 34.26447], [-118.65208, 34.26407], [-118.65307, 34.2632], [-118.65352, 34.26283], [-118.65404, 34.26249], [-118.65458, 34.26292], [-118.65468, 34.26296], [-118.65481, 34.26299], [-118.65467, 34.26301], [-118.65448, 34.26298], [-118.6544, 34.26301], [-118.65435, 34.26305], [-118.65433, 34.2631], [-118.65433, 34.26316], [-118.65435, 34.2632], [-118.65288, 34.26389], [-118.65201, 34.26446], [-118.65231, 34.26447], [-118.65299, 34.26403], [-118.65496, 34.2631], [-118.65568, 34.26311], [-118.6557, 34.26352], [-118.65602, 34.26352], [-118.65602, 34.26311], [-118.65619, 34.26311], [-118.65614, 34.26652], [-118.6561, 34.2667], [-118.65643, 34.26684], [-118.65636, 34.26695], [-118.65626, 34.2677], [-118.65595, 34.26773], [-118.65595, 34.26945], [-118.6562, 34.26962], [-118.65629, 34.26981], [-118.65688, 34.27019], [-118.65701, 34.27046], [-118.65718, 34.27077], [-118.65734, 34.27095], [-118.6567, 34.2711], [-118.65679, 34.2714], [-118.65666, 34.27168], [-118.65762, 34.27232]]]]} | Open Access 1 | 10485 | Corriganville Park | 8979 | 2117 | Rancho Simi Open Space Conservation Agency 345 | Special District 4 | Open Space District 6 | Special District 4 | 2117 | Rancho Simi Open Space Conservation Agency 342 | Special District 4 | Open Space District 6 | http://www.rsrpd.org/park/corrignavilleparkandtrail/corrignavilleparkandtrail.html | Ventura 8 | 178.572 | Corriganville Park | 0 | Local Park 2 | 4 | |
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.3015, 33.61798], [-117.3012, 33.61831], [-117.29877, 33.61679], [-117.29902, 33.61646], [-117.3015, 33.61798]]]} | Open Access 1 | 48910 | Regency-Heritage Park | 33631 | 2437 | Ortega Trail Recreation and Park District 529 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 1706 | Wildomar, City of 522 | City 2 | City Agency 2 | http://www.cityofwildomar.org/community/parks_trails/parks/regency-heritage_park | Riverside 10 | 3.114 | Regency-Heritage Park | 0 | Local Park 2 | 4 | |
2660 | 2660 | 2659 | {"type": "Polygon", "coordinates": [[[-117.25827, 34.54145], [-117.25718, 34.54179], [-117.25716, 34.54027], [-117.25826, 34.54028], [-117.25827, 34.54145]]]} | Open Access 1 | 18164 | Corwin Park | 17669 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 3.691 | Corwin Park | 0 | Local Park 2 | 4 | ||
2666 | 2666 | 2665 | {"type": "Polygon", "coordinates": [[[-121.21401, 36.33581], [-121.21125, 36.33739], [-121.2107, 36.33678], [-121.2099, 36.33723], [-121.2097, 36.3372], [-121.20858, 36.33591], [-121.21228, 36.33384], [-121.21401, 36.33581]]]} | Open Access 1 | 18207 | Oak Park | 30778 | 2042 | Greenfield Public Recreation District 542 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2042 | Greenfield Public Recreation District 535 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 24.875 | Oak Park | 0 | Local Park 2 | 4 | ||
3014 | 3014 | 3013 | {"type": "Polygon", "coordinates": [[[-116.03991, 34.14688], [-116.03988, 34.15024], [-116.03658, 34.15029], [-116.03661, 34.14692], [-116.03991, 34.14688]]]} | Open Access 1 | 24302 | Luckie Park | 21581 | 2265 | Twentynine Palms Park and Recreation District 571 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 28.066 | Luckie Park | 0 | Local Park 2 | 4 | ||
3362 | 3362 | 3361 | {"type": "Polygon", "coordinates": [[[-116.30843, 34.14128], [-116.30425, 34.14132], [-116.30424, 34.13951], [-116.30642, 34.1395], [-116.30643, 34.13956], [-116.30842, 34.13955], [-116.30843, 34.14128]]]} | Open Access 1 | 24295 | Sunburst Park | 25986 | 2230 | Joshua Tree Park and Recreation District 627 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2230 | Joshua Tree Park and Recreation District 616 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 18.753 | Sunburst Park | 0 | Local Park 2 | 4 | ||
5404 | 5404 | 5403 | {"type": "Polygon", "coordinates": [[[-117.22181, 34.53488], [-117.22174, 34.535], [-117.2217, 34.53513], [-117.22168, 34.53527], [-117.22168, 34.53555], [-117.22166, 34.53558], [-117.22162, 34.5356], [-117.22091, 34.53561], [-117.2209, 34.53514], [-117.22017, 34.53515], [-117.22017, 34.53467], [-117.22045, 34.5346], [-117.22059, 34.53454], [-117.22074, 34.53444], [-117.22112, 34.53478], [-117.22124, 34.53468], [-117.22181, 34.53488]]]} | Open Access 1 | 12495 | Cramer Family Park | 17754 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 2.825 | Cramer Family Park | 0 | Local Park 2 | 4 | ||
5438 | 5438 | 5437 | {"type": "Polygon", "coordinates": [[[-116.49934, 33.94046], [-116.49924, 33.94316], [-116.49819, 33.94316], [-116.49818, 33.94225], [-116.4971, 33.94225], [-116.49718, 33.94045], [-116.49934, 33.94046]]]} | Open Access 1 | 47920 | Mission Springs Park | 32032 | 2330 | Mission Springs Water District 806 | Special District 4 | Water District 13 | Special District 4 | 1670 | Desert Hot Springs, City of 630 | City 2 | City Agency 2 | Riverside 10 | 12.328 | Mission Springs Park | 0 | Local Park 2 | 4 | ||
6011 | 6011 | 6010 | {"type": "Polygon", "coordinates": [[[-118.99501, 36.06561], [-118.99069, 36.06572], [-118.99063, 36.06396], [-118.99499, 36.06385], [-118.99501, 36.06561]]]} | Open Access 1 | 812 | Hillcrest Memorial Park | 19967 | 2115 | Porterville Public Cemetery District 823 | Special District 4 | Cemetery District 11 | Special District 4 | 2115 | Porterville Public Cemetery District 801 | Special District 4 | Cemetery District 11 | Tulare 29 | 18.954 | Hillcrest Memorial Park | 0 | Local Park 2 | 4 | ||
6438 | 6438 | 6437 | {"type": "Polygon", "coordinates": [[[-117.1555, 34.55318], [-117.15316, 34.55317], [-117.15316, 34.55251], [-117.15326, 34.55248], [-117.1533, 34.55243], [-117.15331, 34.55239], [-117.1533, 34.55235], [-117.15324, 34.55222], [-117.15324, 34.55175], [-117.15329, 34.55171], [-117.15334, 34.55169], [-117.15537, 34.55167], [-117.15544, 34.55169], [-117.15548, 34.55175], [-117.1555, 34.55318]]]} | Open Access 1 | 1964 | Sycamore Rocks Park | 26142 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 8.579 | Sycamore Rocks Park | 0 | Local Park 2 | 4 | ||
6533 | 6533 | 6532 | {"type": "Polygon", "coordinates": [[[-116.08355, 34.12978], [-116.08208, 34.12979], [-116.08206, 34.12438], [-116.08353, 34.12437], [-116.08355, 34.12978]]]} | Open Access 1 | 2940 | Knott Sky Park | 20705 | 2265 | Twentynine Palms Park and Recreation District 571 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2265 | Twentynine Palms Park and Recreation District 563 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 20.118 | Knott Sky Park | 0 | Local Park 2 | 4 | ||
6619 | 6619 | 6618 | {"type": "Polygon", "coordinates": [[[-117.21166, 34.51739], [-117.21088, 34.51795], [-117.2105, 34.51759], [-117.21131, 34.51706], [-117.21142, 34.51709], [-117.2115, 34.51715], [-117.21159, 34.51725], [-117.21166, 34.51739]]]} | Open Access 1 | 4236 | Lion's Park | 21311 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 1.245 | Lion's Park | 0 | Local Park 2 | 4 | ||
6914 | 6914 | 6913 | {"type": "Polygon", "coordinates": [[[-117.21794, 34.50725], [-117.21794, 34.50766], [-117.2166, 34.50766], [-117.21659, 34.50655], [-117.21716, 34.50654], [-117.21716, 34.50697], [-117.21713, 34.5071], [-117.21716, 34.50719], [-117.21723, 34.50724], [-117.21735, 34.50728], [-117.2175, 34.50725], [-117.21794, 34.50725]]]} | Open Access 1 | 5805 | Norm Schmidt Park | 22794 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 2.378 | Norm Schmidt Park | 0 | Local Park 2 | 4 | ||
7492 | 7492 | 7491 | {"type": "Polygon", "coordinates": [[[-120.94993, 40.13923], [-120.94987, 40.13929], [-120.94983, 40.13929], [-120.94982, 40.13916], [-120.94993, 40.13923]]]} | Open Access 1 | 48943 | Triangle Park | 33659 | 2229 | Indian Valley Community Services District 869 | Special District 4 | Community Services District 19 | Special District 4 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | Plumas 57 | 0.02 | Triangle Park | 0 | Local Park 2 | 4 | |
7518 | 7518 | 7517 | {"type": "Polygon", "coordinates": [[[-120.83763, 40.07496], [-120.83763, 40.07516], [-120.837, 40.07515], [-120.837, 40.07495], [-120.83763, 40.07496]]]} | Open Access 1 | 48944 | Chuck Clay Memorial Park | 33660 | 2229 | Indian Valley Community Services District 869 | Special District 4 | Community Services District 19 | Special District 4 | 2229 | Indian Valley Community Services District 848 | Special District 4 | Community Services District 17 | http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf | Plumas 57 | 0.296 | Chuck Clay Memorial Park | 0 | Local Park 2 | 4 | |
9111 | 9111 | 9110 | {"type": "Polygon", "coordinates": [[[-117.17372, 34.56238], [-117.17371, 34.5633], [-117.17151, 34.5633], [-117.17152, 34.56283], [-117.17239, 34.56283], [-117.1724, 34.56238], [-117.17372, 34.56238]]]} | Open Access 1 | 15101 | Virginia Park | 27158 | 2200 | Apple Valley Recreation and Park District 267 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2200 | Apple Valley Recreation and Park District 262 | Special District 4 | Recreation/Parks District 4 | San Bernardino 22 | 4.099 | Virginia Park | 0 | Local Park 2 | 4 |
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]);