units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,162 rows where MNG_AG_TYP = 4 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, GAP_STS
MNG_AGENCY >30
- East Bay Regional Park District 167
- Hayward Area Recreation and Park District 84
- Valley-Wide Recreation and Park District 67
- Rancho Simi Recreation and Park District 54
- Midpeninsula Regional Open Space District 51
- Conejo Recreation and Park District 50
- Marin County Open Space District 41
- Southgate Recreation and Park District 41
- Sunrise Recreation and Park District 39
- Cordova Recreation and Park District 38
- Greater Vallejo Recreation and Park District 33
- Pleasant Valley Recreation and Park District 31
- North of the River Recreation and Park District 27
- Monterey Peninsula Regional Park District 25
- Santa Clara Valley Open Space Authority 25
- Sonoma County Agricultural Preservation and Open Space District 21
- Isla Vista Recreation and Park District 18
- Jurupa Area Recreation and Park District 18
- Desert Recreation District 15
- Mission Oaks Recreation and Park District 14
- Apple Valley Recreation and Park District 13
- Livermore Area Recreation and Park District 13
- 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
- Napa County Regional Park and Open Space District 10
- Miraleste Recreation and Park District 10
- Rio Linda Elverta Recreation and Park District 9
- …
DES_TP >30
- Local Park 704
- Local Conservation Area 172
- Local Recreation Area 164
- Local Other or Unknown 28
- Local Historic or Cultural Area 3
- 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
- …
LAYER 8 ✖
ACCESS_TYP 4
- Open Access 991
- No Public Access 106
- Restricted Access 64
- Unknown Access 1
MNG_AG_TYP 1
- Recreation/Parks District · 1,162 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4485 | 4485 | 4484 | {"type": "Polygon", "coordinates": [[[-116.23302, 33.58134], [-116.23293, 33.58128], [-116.23136, 33.57741], [-116.23092, 33.57648], [-116.22951, 33.57441], [-116.22812, 33.57509], [-116.22717, 33.57368], [-116.22436, 33.5737], [-116.22436, 33.57461], [-116.22274, 33.57463], [-116.22139, 33.57376], [-116.22098, 33.57302], [-116.22093, 33.57256], [-116.22053, 33.57243], [-116.22029, 33.57202], [-116.21854, 33.57148], [-116.21604, 33.57082], [-116.21605, 33.56939], [-116.22448, 33.56938], [-116.22417, 33.57223], [-116.22418, 33.57224], [-116.22904, 33.56937], [-116.233, 33.56936], [-116.23299, 33.57257], [-116.23302, 33.58134]]]} | Open Access 1 | 4461 | Unnamed site - Riverside County Regional Park and Open Space District | 28656 | 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 | 187.128 | 0 | Local Other or Unknown 14 | 4 | ||
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 0 | Local Other or Unknown 14 | 4 | |||
4493 | 4493 | 4492 | {"type": "Polygon", "coordinates": [[[-118.36086, 33.76832], [-118.3608, 33.76862], [-118.36056, 33.76861], [-118.36041, 33.76865], [-118.36031, 33.76842], [-118.36043, 33.76817], [-118.36086, 33.76832]]]} | Open Access 1 | 5915 | Unknown park - Westfield Recreation and Park District | 28677 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.462 | 0 | Local Other or Unknown 14 | 4 | |||
4520 | 4520 | 4519 | {"type": "Polygon", "coordinates": [[[-119.13455, 35.37983], [-119.13454, 35.38338], [-119.13233, 35.38337], [-119.13234, 35.37982], [-119.13455, 35.37983]]]} | Open Access 1 | 13519 | Unnamed site - North of the River Recreation and Park District | 32826 | 2096 | North of the River Recreation and Park District 386 | Special District 4 | Recreation/Parks District 4 | http://norfun.org/ | Special District 4 | 2096 | North of the River Recreation and Park District 382 | Special District 4 | Recreation/Parks District 4 | Kern 36 | 19.594 | 0 | Local Other or Unknown 14 | 4 | ||
4559 | 4559 | 4558 | {"type": "Polygon", "coordinates": [[[-121.86369, 36.93775], [-121.86367, 36.9378], [-121.86349, 36.938], [-121.86335, 36.93821], [-121.86263, 36.93764], [-121.86282, 36.9375], [-121.86287, 36.9375], [-121.86293, 36.93754], [-121.86296, 36.93752], [-121.86302, 36.93756], [-121.86312, 36.93749], [-121.86321, 36.93756], [-121.86335, 36.93746], [-121.86366, 36.93771], [-121.86369, 36.93775]]]} | Open Access 1 | 35179 | Unknown park - La Selva Beach Parks and Recreation District | 28690 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 1.005 | 0 | Local Other or Unknown 14 | 4 | ||
4611 | 4611 | 4610 | {"type": "Polygon", "coordinates": [[[-116.61537, 33.98365], [-116.61085, 33.98366], [-116.61082, 33.98821], [-116.60649, 33.98822], [-116.60648, 33.98541], [-116.60215, 33.98543], [-116.60214, 33.98822], [-116.60433, 33.98822], [-116.60433, 33.99003], [-116.59774, 33.99004], [-116.59775, 33.98278], [-116.61537, 33.98276], [-116.61537, 33.98365]], [[-116.59886, 33.98636], [-116.59885, 33.98823], [-116.59995, 33.98822], [-116.59995, 33.98637], [-116.59886, 33.98636]]]} | Open Access 1 | 35753 | Unnamed site - Riverside County Regional Park and Open Space District | 28656 | 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 | 185.049 | 0 | Local Other or Unknown 14 | 4 | ||
4618 | 4618 | 4617 | {"type": "Polygon", "coordinates": [[[-121.86433, 36.93568], [-121.86428, 36.93572], [-121.8632, 36.9346], [-121.86325, 36.93456], [-121.86433, 36.93568]]]} | Open Access 1 | 36130 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.256 | 0 | Local Other or Unknown 14 | 4 | ||
4619 | 4619 | 4618 | {"type": "Polygon", "coordinates": [[[-121.86, 36.94078], [-121.85982, 36.94067], [-121.85962, 36.94058], [-121.85956, 36.94051], [-121.8596, 36.94044], [-121.85969, 36.9404], [-121.86, 36.94039], [-121.86, 36.94078]]]} | Open Access 1 | 36131 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.265 | 0 | Local Other or Unknown 14 | 4 | ||
4628 | 4628 | 4627 | {"type": "MultiPolygon", "coordinates": [[[[-121.86066, 36.93962], [-121.86062, 36.93973], [-121.86059, 36.94006], [-121.86048, 36.94029], [-121.86042, 36.94033], [-121.86035, 36.94032], [-121.86032, 36.94029], [-121.86032, 36.94025], [-121.86066, 36.93962]]], [[[-121.8624, 36.9389], [-121.86234, 36.93895], [-121.86222, 36.93911], [-121.86212, 36.9392], [-121.86196, 36.93931], [-121.86184, 36.93937], [-121.8617, 36.93936], [-121.86144, 36.93927], [-121.86121, 36.93924], [-121.86099, 36.9393], [-121.86083, 36.9394], [-121.86071, 36.93953], [-121.86082, 36.93939], [-121.86095, 36.93926], [-121.86106, 36.93919], [-121.86116, 36.93917], [-121.86153, 36.93924], [-121.86176, 36.93924], [-121.86197, 36.93918], [-121.8624, 36.9389]]], [[[-121.86359, 36.93809], [-121.86355, 36.9382], [-121.86353, 36.93834], [-121.86347, 36.93848], [-121.86323, 36.93869], [-121.86305, 36.9388], [-121.86297, 36.93883], [-121.86269, 36.93881], [-121.86256, 36.93883], [-121.86292, 36.93873], [-121.86307, 36.93867], [-121.86324, 36.93857], [-121.86336, 36.93843], [-121.86356, 36.93807], [-121.86359, 36.93809]]]]} | Open Access 1 | 36258 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.768 | 0 | Local Other or Unknown 14 | 4 | ||
4673 | 4673 | 4672 | {"type": "Polygon", "coordinates": [[[-121.86411, 36.93794], [-121.86404, 36.93797], [-121.86384, 36.93798], [-121.86379, 36.93797], [-121.86377, 36.93793], [-121.86383, 36.93779], [-121.86393, 36.93787], [-121.86398, 36.93783], [-121.86411, 36.93794]]]} | Open Access 1 | 36646 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.092 | 0 | Local Other or Unknown 14 | 4 | ||
4683 | 4683 | 4682 | {"type": "Polygon", "coordinates": [[[-121.8613, 36.93786], [-121.86128, 36.9379], [-121.86099, 36.93813], [-121.86095, 36.93813], [-121.86093, 36.9381], [-121.86095, 36.93798], [-121.86093, 36.93765], [-121.86096, 36.93761], [-121.86102, 36.93762], [-121.86128, 36.93782], [-121.8613, 36.93786]]]} | Open Access 1 | 43074 | Unknown park - La Selva Beach Recreation District | 28639 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.278 | 0 | Local Other or Unknown 14 | 4 | ||
4687 | 4687 | 4686 | {"type": "Polygon", "coordinates": [[[-121.32025, 36.42989], [-121.32025, 36.43031], [-121.31912, 36.4303], [-121.31914, 36.42962], [-121.31995, 36.42962], [-121.31996, 36.42988], [-121.32025, 36.42989]]]} | Open Access 1 | 43092 | Unknown park - Soledad-Mission Recreation District | 28668 | 2154 | Soledad-Mission Recreation District 775 | Special District 4 | Recreation/Parks District 4 | http://www.soledad-mission-recreation-district.org/ | Special District 4 | 2154 | Soledad-Mission Recreation District 756 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1.687 | 0 | Local Other or Unknown 14 | 4 | ||
4800 | 4800 | 4799 | {"type": "Polygon", "coordinates": [[[-120.91362, 38.89783], [-120.91305, 38.89803], [-120.91312, 38.89817], [-120.91226, 38.89828], [-120.91215, 38.89848], [-120.91174, 38.89845], [-120.91132, 38.89844], [-120.91116, 38.89838], [-120.91124, 38.89813], [-120.91198, 38.89771], [-120.91213, 38.89791], [-120.91217, 38.89791], [-120.91219, 38.89797], [-120.91239, 38.89791], [-120.91242, 38.89803], [-120.91284, 38.89788], [-120.91293, 38.898], [-120.91358, 38.89777], [-120.91362, 38.89783]]]} | Open Access 1 | 48517 | Unnamed site - Georgetown Divide Recreation District | 33230 | 2223 | Georgetown Divide Recreation District 784 | Special District 4 | Recreation/Parks District 4 | http://www.gdrd.org/ | Special District 4 | 2223 | Georgetown Divide Recreation District 764 | Special District 4 | Recreation/Parks District 4 | El Dorado 34 | 1.949 | 0 | Local Other or Unknown 14 | 4 | ||
15479 | 15479 | 15478 | {"type": "Polygon", "coordinates": [[[-121.72963, 36.78547], [-121.72962, 36.78553], [-121.72872, 36.78627], [-121.72865, 36.78628], [-121.72807, 36.78601], [-121.72823, 36.78577], [-121.72779, 36.78557], [-121.728, 36.78528], [-121.72812, 36.78532], [-121.72824, 36.78532], [-121.72835, 36.78529], [-121.72844, 36.78523], [-121.7285, 36.78514], [-121.72863, 36.7848], [-121.72871, 36.78483], [-121.72869, 36.78491], [-121.72871, 36.78496], [-121.72875, 36.785], [-121.72886, 36.78503], [-121.72899, 36.78498], [-121.72903, 36.78499], [-121.72935, 36.78519], [-121.72948, 36.7853], [-121.72963, 36.78547]]]} | Open Access 1 | 43075 | Unknown park - North County Recreation and Park District | 28650 | 2094 | North County Recreation and Park District 733 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.408 | 0 | Local Other or Unknown 14 | 4 | ||
15482 | 15482 | 15481 | {"type": "Polygon", "coordinates": [[[-121.85976, 36.9403], [-121.85956, 36.94034], [-121.85939, 36.94045], [-121.85932, 36.94046], [-121.85927, 36.94041], [-121.85927, 36.94028], [-121.85951, 36.94009], [-121.85976, 36.9403]]]} | Open Access 1 | 43081 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.222 | 0 | Local Other or Unknown 14 | 4 | ||
15483 | 15483 | 15482 | {"type": "Polygon", "coordinates": [[[-121.7569, 36.77289], [-121.75622, 36.77347], [-121.75458, 36.77228], [-121.75464, 36.77222], [-121.75547, 36.77222], [-121.75581, 36.77227], [-121.75598, 36.77233], [-121.75612, 36.77239], [-121.7569, 36.77289]]]} | Open Access 1 | 43083 | Unnamed site - North County Recreation and Park District | 28720 | 2094 | North County Recreation and Park District 733 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.303 | 0 | Local Other or Unknown 14 | 4 | ||
15485 | 15485 | 15484 | {"type": "Polygon", "coordinates": [[[-121.8621, 36.93337], [-121.86183, 36.93378], [-121.86183, 36.93423], [-121.86175, 36.93427], [-121.86176, 36.93376], [-121.86206, 36.93332], [-121.8621, 36.93337]]]} | Open Access 1 | 43087 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.166 | 0 | Local Other or Unknown 14 | 4 | ||
14550 | 14550 | 14549 | {"type": "Polygon", "coordinates": [[[-117.10104, 33.61814], [-117.10099, 33.61814], [-117.09946, 33.61994], [-117.09898, 33.61995], [-117.09889, 33.61989], [-117.09899, 33.61985], [-117.09924, 33.6196], [-117.09936, 33.61964], [-117.0994, 33.6196], [-117.09934, 33.61951], [-117.09946, 33.61938], [-117.09904, 33.61905], [-117.09888, 33.61919], [-117.09878, 33.61912], [-117.09873, 33.61915], [-117.09878, 33.61926], [-117.09857, 33.6194], [-117.0983, 33.6194], [-117.09822, 33.61937], [-117.09817, 33.61938], [-117.09814, 33.61941], [-117.09791, 33.61928], [-117.09793, 33.61925], [-117.09829, 33.61916], [-117.09853, 33.61889], [-117.09858, 33.61865], [-117.09868, 33.61843], [-117.09879, 33.61824], [-117.09903, 33.61795], [-117.09915, 33.61771], [-117.0992, 33.61745], [-117.09919, 33.61714], [-117.09914, 33.61694], [-117.09893, 33.61631], [-117.10101, 33.6163], [-117.10104, 33.61814]]]} | Open Access 1 | 48276 | Abelia Sports Park | 32831 | 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 | Riverside 10 | 15.608 | Abelia Sports Park | 0 | Local Recreation Area 3 | 4 | |
11859 | 11859 | 11858 | {"type": "Polygon", "coordinates": [[[-117.02375, 33.23685], [-117.02356, 33.2408], [-117.0235, 33.24085], [-117.01947, 33.24142], [-117.01954, 33.24036], [-117.01953, 33.24028], [-117.0196, 33.23816], [-117.01959, 33.23767], [-117.02055, 33.23769], [-117.02067, 33.23715], [-117.02219, 33.23726], [-117.02227, 33.23694], [-117.02375, 33.23685]]]} | Open Access 1 | 24307 | Adams Community Park | 15259 | 2267 | Valley Center Parks and Recreation 994 | Special District 4 | Recreation/Parks District 4 | http://www.valleycenterparks.com/ | Special District 4 | 2267 | Valley Center Parks and Recreation 957 | Special District 4 | Recreation/Parks District 4 | http://valleycenterparks.com/adams-park.html | San Diego 4 | 40.858 | Adams Community Park | 0 | Local Park 2 | 4 |
14443 | 14443 | 14442 | {"type": "Polygon", "coordinates": [[[-117.09722, 33.59201], [-117.09678, 33.59201], [-117.09676, 33.59226], [-117.09668, 33.59227], [-117.09652, 33.59204], [-117.09625, 33.59204], [-117.09621, 33.59183], [-117.09621, 33.59161], [-117.09646, 33.59165], [-117.09678, 33.59166], [-117.09722, 33.59161], [-117.09722, 33.59201]]]} | Open Access 1 | 48261 | Adeline's Farm Park | 32815 | 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/adeline-s-farm | Riverside 10 | 1.08 | Adeline's Farm 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]);