units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,162 rows where MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- East Bay Regional Park District 165
- Hayward Area Recreation and Park District 83
- Valley-Wide Recreation and Park District 64
- Rancho Simi Recreation and Park District 51
- Midpeninsula Regional Open Space District 51
- Conejo Recreation and Park District 42
- Southgate Recreation and Park District 41
- Marin County Open Space District 39
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- North of the River Recreation and Park District 27
- Pleasant Valley Recreation and Park District 25
- Santa Clara Valley Open Space Authority 25
- Monterey Peninsula Regional Park District 24
- Sonoma County Agricultural Preservation and Open Space District 21
- Jurupa Area Recreation and Park District 18
- Isla Vista Recreation and Park District 16
- Desert Recreation District 15
- Mission Oaks Recreation and Park District 14
- Livermore Area Recreation and Park District 13
- Apple Valley Recreation and Park District 12
- Pleasant Hill Recreation and Park District 12
- Carmichael Recreation and Park District 12
- Auburn Area Recreation and Park District 11
- Hesperia Recreation and Park District 11
- North Highland Recreation and Park District 11
- Miraleste Recreation and Park District 10
- Napa County Regional Park and Open Space District 9
- Rio Linda Elverta Recreation and Park District 9
- …
DES_TP >30
- Local Park 681
- Local Conservation Area 169
- Local Recreation Area 158
- Local Other or Unknown 28
- Local Historic or Cultural Area 2
- Local Resource Management Area 2
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- …
ACCESS_TYP 4
- Open Access 956
- No Public Access 106
- Restricted Access 64
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,127 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
914 | 914 | 913 | {"type": "Polygon", "coordinates": [[[-116.21951, 33.73621], [-116.21842, 33.7359], [-116.21755, 33.73558], [-116.21752, 33.73455], [-116.21811, 33.73476], [-116.21947, 33.73475], [-116.21951, 33.73621]]]} | Open Access 1 | 5922 | North Jackson Park | 22825 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 5.877 | North Jackson Park | 0 | Local Park 2 | 4 | |
957 | 957 | 956 | {"type": "Polygon", "coordinates": [[[-119.86245, 34.41488], [-119.86245, 34.41514], [-119.86157, 34.41513], [-119.86153, 34.41509], [-119.86147, 34.41507], [-119.86127, 34.41513], [-119.86127, 34.41487], [-119.86245, 34.41488]]]} | Open Access 1 | 6027 | Childrens Park | 17198 | 2049 | Isla Vista Recreation and Park District 174 | Special District 4 | Recreation/Parks District 4 | http://www.ivparks.org/ | Special District 4 | 2049 | Isla Vista Recreation and Park District 170 | Special District 4 | Recreation/Parks District 4 | Santa Barbara 7 | 0.744 | Childrens Park | 0 | Local Park 2 | 4 | |
1044 | 1044 | 1043 | {"type": "Polygon", "coordinates": [[[-121.23855, 38.54734], [-121.23856, 38.54816], [-121.23852, 38.54822], [-121.23846, 38.54824], [-121.23795, 38.54825], [-121.23749, 38.54829], [-121.23743, 38.54783], [-121.23743, 38.54772], [-121.23747, 38.54761], [-121.23758, 38.54748], [-121.23769, 38.54741], [-121.23786, 38.54735], [-121.23855, 38.54734]]]} | Open Access 1 | 47582 | Eagle's Nest Park | 31309 | 2193 | Cordova Recreation and Park District 307 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.com/ | Special District 4 | 2193 | Cordova Recreation and Park District 304 | Special District 4 | Recreation/Parks District 4 | http://crpd.com/parks/eagles-nest-park/ | Sacramento 41 | 2.302 | Eagle's Nest Park | 0 | Local Park 2 | 4 |
1045 | 1045 | 1044 | {"type": "Polygon", "coordinates": [[[-121.54516, 39.43302], [-121.54378, 39.43304], [-121.54377, 39.43221], [-121.54515, 39.4322], [-121.54516, 39.43302]]]} | Open Access 1 | 47583 | Palermo Park | 31310 | 2222 | Feather River Recreation and Park District 308 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | Butte 42 | 2.687 | Palermo Park | 0 | Local Park 2 | 4 | |
1100 | 1100 | 1099 | {"type": "Polygon", "coordinates": [[[-116.06596, 33.57378], [-116.06557, 33.57379], [-116.06548, 33.57372], [-116.06537, 33.57369], [-116.06485, 33.57371], [-116.06478, 33.57369], [-116.06475, 33.57365], [-116.06473, 33.57358], [-116.06477, 33.57339], [-116.06475, 33.5733], [-116.06469, 33.57322], [-116.06463, 33.5732], [-116.06455, 33.57319], [-116.06455, 33.57293], [-116.06596, 33.57293], [-116.06596, 33.57378]]]} | Open Access 1 | 48933 | Huerta De Mecca Park | 33653 | 2216 | Desert Recreation District 286 | Special District 4 | Recreation/Parks District 4 | http://www.myrecreationdistrict.com | Special District 4 | 2216 | Desert Recreation District 282 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 2.605 | Huerta De Mecca Park | 0 | Local Park 2 | 4 | |
1101 | 1101 | 1100 | {"type": "Polygon", "coordinates": [[[-122.06832, 37.64878], [-122.0678, 37.64887], [-122.06776, 37.64853], [-122.06779, 37.64844], [-122.06798, 37.64835], [-122.06832, 37.64878]]]} | Open Access 1 | 15630 | Haymont Mini Park | 19758 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 0.431 | Haymont MP | 0 | Local Park 2 | 4 | |
1185 | 1185 | 1184 | {"type": "MultiPolygon", "coordinates": [[[[-118.76357, 34.27256], [-118.7633, 34.2725], [-118.76322, 34.27252], [-118.76314, 34.27256], [-118.76308, 34.27262], [-118.76305, 34.27269], [-118.76307, 34.27293], [-118.762, 34.27293], [-118.76199, 34.27321], [-118.76194, 34.27319], [-118.76188, 34.2731], [-118.76182, 34.27308], [-118.76172, 34.27309], [-118.76166, 34.27313], [-118.76164, 34.27319], [-118.76165, 34.27325], [-118.7616, 34.27328], [-118.76161, 34.27387], [-118.76165, 34.27389], [-118.76164, 34.27393], [-118.76166, 34.27398], [-118.76161, 34.27401], [-118.76161, 34.27454], [-118.76165, 34.27457], [-118.76164, 34.27461], [-118.76165, 34.27467], [-118.7616, 34.27469], [-118.7616, 34.27527], [-118.76153, 34.27526], [-118.7615, 34.27521], [-118.76151, 34.27282], [-118.76152, 34.27281], [-118.76154, 34.2726], [-118.76154, 34.27208], [-118.76253, 34.27209], [-118.76304, 34.27213], [-118.76357, 34.2722], [-118.76357, 34.27256]]], [[[-118.76165, 34.27606], [-118.76164, 34.27611], [-118.76165, 34.27617], [-118.7616, 34.27619], [-118.7616, 34.27678], [-118.76165, 34.2768], [-118.76164, 34.27685], [-118.76165, 34.2769], [-118.7616, 34.27692], [-118.7616, 34.27746], [-118.76165, 34.27748], [-118.76164, 34.27752], [-118.76165, 34.27758], [-118.7616, 34.2776], [-118.7616, 34.27787], [-118.76151, 34.27787], [-118.7615, 34.2755], [-118.76153, 34.27546], [-118.76158, 34.27544], [-118.7616, 34.27544], [-118.7616, 34.27605], [-118.76165, 34.27606]]]]} | Open Access 1 | 6872 | Citrus Grove Park | 17281 | 2118 | Rancho Simi Recreation and Park District 80 | Special District 4 | Recreation/Parks District 4 | http://www.rsrpd.org/ | Special District 4 | 2118 | Rancho Simi Recreation and Park District 78 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.144 | Citrus Grove Park | 0 | Local Park 2 | 4 | |
1192 | 1192 | 1191 | {"type": "MultiPolygon", "coordinates": [[[[-122.48372, 37.92711], [-122.47966, 37.92717], [-122.4794, 37.92537], [-122.48367, 37.9253], [-122.48372, 37.92711]]], [[[-122.49518, 37.92873], [-122.48832, 37.92884], [-122.48822, 37.92522], [-122.49509, 37.9251], [-122.49518, 37.92873]]], [[[-122.49976, 37.92865], [-122.49747, 37.92869], [-122.49739, 37.92507], [-122.49764, 37.92506], [-122.49818, 37.92572], [-122.49942, 37.92654], [-122.49972, 37.92677], [-122.49976, 37.92865]]]]} | Open Access 1 | 6910 | Water Lots | 27294 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | Marin 23 | 93.387 | Water Lots | 0 | Local Other or Unknown 14 | 4 | |
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
1285 | 1285 | 1284 | {"type": "Polygon", "coordinates": [[[-122.16939, 38.13727], [-122.1693, 38.1373], [-122.16926, 38.13734], [-122.16922, 38.13742], [-122.16905, 38.13739], [-122.16875, 38.1372], [-122.16875, 38.13718], [-122.16851, 38.137], [-122.16847, 38.13692], [-122.16846, 38.13684], [-122.16849, 38.13674], [-122.16854, 38.13669], [-122.16871, 38.13664], [-122.16872, 38.13655], [-122.16896, 38.1365], [-122.16909, 38.13685], [-122.16917, 38.13685], [-122.16919, 38.13698], [-122.16929, 38.13704], [-122.16937, 38.13716], [-122.16939, 38.13727]]]} | Open Access 1 | 47641 | Hiddenbrooke Park | 31383 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Hiddenbrooke | Solano 26 | 1.124 | Hiddenbrooke Park | 0 | Local Park 2 | 4 |
1321 | 1321 | 1320 | {"type": "Polygon", "coordinates": [[[-122.19217, 38.12822], [-122.192, 38.12829], [-122.19189, 38.12829], [-122.19143, 38.12808], [-122.19086, 38.12773], [-122.19079, 38.12766], [-122.19072, 38.12752], [-122.18982, 38.12792], [-122.18795, 38.12517], [-122.18822, 38.125], [-122.18931, 38.12463], [-122.1904, 38.12448], [-122.19158, 38.12409], [-122.19132, 38.12454], [-122.19125, 38.12472], [-122.19119, 38.12493], [-122.19117, 38.12529], [-122.1912, 38.12567], [-122.19158, 38.127], [-122.19196, 38.12787], [-122.19217, 38.12822]]]} | Open Access 1 | 47620 | Blue Rock Springs Park | 31355 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Blue_Rock_Springs_Park | Solano 26 | 21.53 | Blue Rock Springs Park | 0 | Local Park 2 | 4 |
1322 | 1322 | 1321 | {"type": "Polygon", "coordinates": [[[-122.24455, 38.102], [-122.24448, 38.10265], [-122.24424, 38.10265], [-122.24424, 38.102], [-122.24455, 38.102]]]} | Open Access 1 | 47622 | Amador Bocce Ball Court | 31357 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Amador_Bocce_Ball | Solano 26 | 0.431 | Amador Bocce Ball Court | 0 | Local Park 2 | 4 |
1409 | 1409 | 1408 | {"type": "Polygon", "coordinates": [[[-122.22844, 38.49945], [-122.2279, 38.50313], [-122.22773, 38.50628], [-122.22303, 38.50615], [-122.22259, 38.50313], [-122.21653, 38.50301], [-122.21525, 38.49979], [-122.21427, 38.50009], [-122.21463, 38.49794], [-122.21505, 38.49581], [-122.2195, 38.49582], [-122.22405, 38.49579], [-122.22333, 38.49946], [-122.22844, 38.49945]]]} | Open Access 1 | 47680 | Berryessa Vista Wilderness Park | 31419 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 223.82 | Berryessa Vista Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
1421 | 1421 | 1420 | {"type": "Polygon", "coordinates": [[[-117.47044, 34.01823], [-117.46999, 34.0192], [-117.46848, 34.01888], [-117.46878, 34.0179], [-117.47044, 34.01823]]]} | Open Access 1 | 9051 | Boulder Hill Park | 16296 | 2051 | Jurupa Area Recreation and Park District 364 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 4.195 | Boulder Hill Park | 0 | Local Park 2 | 4 | |
1434 | 1434 | 1433 | {"type": "Polygon", "coordinates": [[[-122.0272, 37.65621], [-122.02609, 37.65763], [-122.02388, 37.65638], [-122.02421, 37.65615], [-122.02448, 37.65581], [-122.02462, 37.65538], [-122.02478, 37.655], [-122.02503, 37.65468], [-122.02527, 37.65453], [-122.0272, 37.65621]]]} | Open Access 1 | 47699 | J.A. Lewis Park | 31435 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 12.57 | J.A. Lewis Park | 0 | Local Park 2 | 4 | |
1435 | 1435 | 1434 | {"type": "Polygon", "coordinates": [[[-122.13981, 37.67822], [-122.13977, 37.67831], [-122.13782, 37.6791], [-122.13753, 37.67864], [-122.13699, 37.67886], [-122.13613, 37.67751], [-122.13869, 37.67647], [-122.13981, 37.67822]]]} | Open Access 1 | 47700 | Mervin Morris Park | 31436 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 13.34 | Mervin Morris Park | 0 | Local Park 2 | 4 | |
1451 | 1451 | 1450 | {"type": "Polygon", "coordinates": [[[-122.09749, 37.66354], [-122.09714, 37.66357], [-122.09618, 37.66266], [-122.09563, 37.66224], [-122.09518, 37.66185], [-122.0948, 37.66148], [-122.0965, 37.6607], [-122.09689, 37.66105], [-122.0972, 37.66164], [-122.09739, 37.66218], [-122.09747, 37.66261], [-122.09753, 37.66314], [-122.09749, 37.66354]]]} | Open Access 1 | 9747 | Centennial Park | 17031 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.492 | Centennial Park | 0 | Local Park 2 | 4 | |
1518 | 1518 | 1517 | {"type": "Polygon", "coordinates": [[[-122.08221, 37.69769], [-122.08102, 37.69769], [-122.08099, 37.69634], [-122.08217, 37.69632], [-122.08221, 37.69769]]]} | Open Access 1 | 47719 | Adobe Park | 31505 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/facilities/facility/details/Adobe-Park-116 | Alameda 17 | 3.894 | Adobe Park | 0 | Local Park 2 | 4 |
1528 | 1528 | 1527 | {"type": "Polygon", "coordinates": [[[-122.22958, 38.1515], [-122.22956, 38.15146], [-122.22963, 38.15108], [-122.22967, 38.15093], [-122.22976, 38.15069], [-122.22982, 38.15065], [-122.2301, 38.15071], [-122.23062, 38.15087], [-122.23115, 38.15107], [-122.23154, 38.15124], [-122.23158, 38.15129], [-122.23134, 38.15166], [-122.2313, 38.1517], [-122.23122, 38.15172], [-122.23115, 38.15172], [-122.22964, 38.15153], [-122.22958, 38.1515]]]} | Open Access 1 | 11032 | Borges Ranch Park | 16284 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Borges_Ranch_Park | Solano 26 | 3.378 | Borges Ranch 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]);