units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
704 rows where DES_TP = 2 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY 67
- East Bay Regional Park District 76
- Hayward Area Recreation and Park District 74
- Valley-Wide Recreation and Park District 57
- Rancho Simi Recreation and Park District 41
- Cordova Recreation and Park District 37
- Southgate Recreation and Park District 34
- Greater Vallejo Recreation and Park District 29
- Sunrise Recreation and Park District 25
- North of the River Recreation and Park District 24
- Pleasant Valley Recreation and Park District 21
- Conejo Recreation and Park District 20
- Jurupa Area Recreation and Park District 16
- Mission Oaks Recreation and Park District 14
- Isla Vista Recreation and Park District 10
- Apple Valley Recreation and Park District 10
- Carmichael Recreation and Park District 10
- North Highland Recreation and Park District 10
- Auburn Area Recreation and Park District 9
- Pleasant Hill Recreation and Park District 9
- Hesperia Recreation and Park District 9
- Desert Recreation District 8
- Fair Oaks Recreation and Park District 8
- Monterey Peninsula Regional Park District 7
- Livermore Area Recreation and Park District 7
- Rio Linda Elverta Recreation and Park District 7
- Big Bear Valley Recreation and Park District 7
- Feather River Recreation and Park District 6
- Boulder Creek Recreation and Park District 5
- Miraleste Recreation and Park District 5
- Orangevale Recreation and Park District 5
- Coalinga-Huron Recreation and Park District 4
- Paradise Recreation and Park District 4
- Tehachapi Valley Recreation and Parks District 4
- Tuolumne Park and Recreation District 4
- Arbuckle Parks and Recreation District 4
- Arden Manor Recreation and Park District 4
- Napa County Regional Park and Open Space District 3
- Ambrose Recreation and Park District 3
- Riverside County Regional Park and Open Space District 3
- Shafter Recreation and Park District 3
- Wasco Recreation and Park District 3
- West Side Recreation and Park District 3
- McFarland Recreation and Park District 3
- Truckee-Donner Recreation and Park District 3
- Strawberry Recreation District 3
- North County Recreation and Park District 3
- Arcade Creek Recreation and Park District 3
- Georgetown Divide Recreation District 3
- Valley Center Parks and Recreation 3
- Russian River Recreation and Park District 3
- Marin County Open Space District 2
- Twentynine Palms Park and Recreation District 2
- Monte Rio Recreation and Park District 2
- Joshua Tree Park and Recreation District 2
- Beaumont-Cherry Valley Recreation and Park District 2
- Arden Park Recreation and Park District 2
- Weaverville - Douglas City Recreation District 2
- Bear Mountain Recreation and Park District 2
- Rim of the World Recreation and Park District 1
- Greenfield Public Recreation District 1
- Mt. Shasta Recreation and Park District 1
- Jenny Lind Veterans Memorial District 1
- Dunsmuir Recreation and Park District 1
- Central Plumas Recreation and Parks District 1
- San Andreas Recreation and Park District 1
- Carmel Valley Recreation Park District 1
- Western Gateway Recreation and Park District 1
ACCESS_TYP 3
- Open Access 646
- No Public Access 27
- Restricted Access 18
MNG_AG_TYP 1
- Recreation/Parks District · 691 ✖
DES_TP 1
- Local Park · 691 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
515 | 515 | 514 | {"type": "Polygon", "coordinates": [[[-118.67368, 34.2754], [-118.67345, 34.2754], [-118.67293, 34.27548], [-118.67292, 34.27601], [-118.67213, 34.2753], [-118.67207, 34.27515], [-118.67207, 34.27372], [-118.67302, 34.27372], [-118.67356, 34.27375], [-118.67356, 34.27402], [-118.67368, 34.27412], [-118.67368, 34.2754]]]} | Open Access 1 | 1716 | Verde Park | 26986 | 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 | 7.268 | Verde Park | 0 | Local Park 2 | 4 | |
540 | 540 | 539 | {"type": "Polygon", "coordinates": [[[-118.8993, 34.1842], [-118.89897, 34.18424], [-118.89814, 34.18437], [-118.89767, 34.18434], [-118.89715, 34.18448], [-118.89638, 34.18443], [-118.89611, 34.18408], [-118.89593, 34.18404], [-118.89683, 34.18341], [-118.8969, 34.18346], [-118.89768, 34.18368], [-118.89819, 34.18346], [-118.89872, 34.18292], [-118.89889, 34.18303], [-118.89887, 34.18356], [-118.8993, 34.1842]]]} | Open Access 1 | 1801 | Walnut Grove Park | 27233 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.623 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
544 | 544 | 543 | {"type": "Polygon", "coordinates": [[[-119.01467, 34.22283], [-119.01414, 34.22287], [-119.01409, 34.22258], [-119.01399, 34.22232], [-119.0138, 34.22197], [-119.0135, 34.22159], [-119.01349, 34.22154], [-119.01351, 34.2215], [-119.01392, 34.22133], [-119.01404, 34.2213], [-119.01415, 34.22121], [-119.01463, 34.22119], [-119.01467, 34.22283]]]} | Open Access 1 | 1813 | Calleguas Creek Park | 16738 | 2113 | Pleasant Valley Recreation and Park District 149 | Special District 4 | Recreation/Parks District 4 | http://www.pvrpd.org/ | Special District 4 | 2113 | Pleasant Valley Recreation and Park District 145 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 3.236 | Calleguas Creek Park | 0 | Local Park 2 | 4 | |
547 | 547 | 546 | {"type": "Polygon", "coordinates": [[[-118.85957, 34.20397], [-118.85928, 34.20419], [-118.85956, 34.20468], [-118.85943, 34.20577], [-118.85902, 34.20577], [-118.85882, 34.2057], [-118.85753, 34.20575], [-118.85776, 34.20423], [-118.85881, 34.20412], [-118.85882, 34.20405], [-118.85957, 34.20397]]]} | Open Access 1 | 1822 | Waverly Park | 27320 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 7.419 | Waverly Park | 0 | Local Park 2 | 4 | |
558 | 558 | 557 | {"type": "Polygon", "coordinates": [[[-117.10871, 33.60376], [-117.10807, 33.60376], [-117.10803, 33.6038], [-117.10795, 33.60373], [-117.108, 33.60362], [-117.10791, 33.60312], [-117.10865, 33.60308], [-117.10871, 33.60312], [-117.10871, 33.60376]]]} | Open Access 1 | 48385 | Primrose Park | 32949 | 2171 | Valley-Wide Recreation and Park District 160 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/ | Special District 4 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/primrose-park | Riverside 10 | 1.259 | Primrose Park | 0 | Local Park 2 | 4 |
592 | 592 | 591 | {"type": "Polygon", "coordinates": [[[-121.94024, 38.01658], [-121.93978, 38.01658], [-121.93977, 38.01672], [-121.93947, 38.01673], [-121.9395, 38.01832], [-121.93948, 38.01832], [-121.93914, 38.01842], [-121.93876, 38.01847], [-121.93842, 38.01836], [-121.93821, 38.01832], [-121.93821, 38.01825], [-121.93793, 38.01815], [-121.9373, 38.01768], [-121.93773, 38.01605], [-121.94023, 38.01603], [-121.94024, 38.01658]]]} | Open Access 1 | 2015 | Ambrose Park | 15445 | 2001 | Ambrose Recreation and Park District 217 | Special District 4 | Recreation/Parks District 4 | http://www.ambroserec.org/ | Special District 4 | 2001 | Ambrose Recreation and Park District 213 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 11.746 | Ambrose Park | 0 | Local Park 2 | 4 | |
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 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 | 14.46 | Southgate Park | 1965 | Local Park 2 | 4 | |
800 | 800 | 799 | {"type": "Polygon", "coordinates": [[[-116.73692, 33.70731], [-116.73692, 33.70798], [-116.73675, 33.71539], [-116.73248, 33.71537], [-116.73258, 33.70742], [-116.73272, 33.70733], [-116.73692, 33.70731]]]} | Open Access 1 | 5190 | McCall Memorial Park | 21990 | 2123 | Riverside County Regional Park and Open Space District 262 | Special District 4 | Recreation/Parks District 4 | http://www.riversidecountyparks.org/ | Special District 4 | 2123 | Riverside County Regional Park and Open Space District 258 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 88.363 | McCall 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 | ||
872 | 872 | 871 | {"type": "Polygon", "coordinates": [[[-120.34928, 36.13978], [-120.34751, 36.13979], [-120.34749, 36.13797], [-120.34786, 36.13796], [-120.34785, 36.13675], [-120.34924, 36.13666], [-120.34928, 36.13978]]]} | Open Access 1 | 5613 | Olsen Park | 23139 | 2021 | Coalinga-Huron Recreation and Park District 275 | Special District 4 | Recreation/Parks District 4 | http://www.chrpd.org/ | Special District 4 | 2021 | Coalinga-Huron Recreation and Park District 270 | Special District 4 | Recreation/Parks District 4 | Fresno 9 | 12.316 | Olsen 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 | ||
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 | |
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 |
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]);