units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
198 rows where MNG_AG_TYP = 17 sorted by AGNCY_WEB
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, COUNTY, ACRES, LABEL_NAME, YR_EST, GAP_STS
MNG_AGENCY 38
- Consumnes Community Services District 94
- El Dorado Hills Community Service District 25
- Jurupa Community Services District 10
- Cameron Park Community Services District 8
- Mountain House Community Services District 7
- McKinleyville Community Services District 4
- Tamalpais Community Services District 4
- Brooktrails Community Services District 3
- Marinwood Community Service District 3
- Rossmore Community Services District 2
- Twain Harte Community Services District 2
- Groveland Community Services District 2
- Manila Community Services District 2
- Truckee Tahoe Airport District 2
- Indian Valley Community Services District 2
- Aromona Community Services District 2
- Helendale Community Services District 2
- Pajaro Community Services District 2
- Salton Community Services District 2
- Templeton Community Services District 2
- Discovery Bay Community Service District 1
- Scotia Community Services District 1
- Bear Valley Springs Community Services District 1
- Morongo Valley Community Services District 1
- Cambria Community Services District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Golden Hills Community Service District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Lake Shastina Community Services District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Tomales Village Community Services District 1
- Bolinas Community Public Utility District 1
- Bel Marin Keys Community Services District 1
- Mountain Gate Community Special District 1
- Willow Creek Community Services District 1
- Home Garden Community Services District 1
PARK_URL 26 ✖
- https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities 3
- http://cloud2.snappages.com/14694d9d5e0e722731c9a38ca07276495d3755a5/IVCSD%20Properties.pdf 2
- http://www.eldoradohillscsd.org/images/park_detail_popups/new-york-creek/index.html 2
- http://ffrpcambria.org/ranch.html 1
- http://mckinleyvillecsd.com/pierson-park 1
- http://scotiacsd.com/parks-recreation/ 1
- http://www.eldoradohillscsd.org/images/park_detail_popups/allan-lindsey/ 1
- http://www.eldoradohillscsd.org/images/park_detail_popups/governors/index.html 1
- http://www.friendsofthedunes.org/resources/ 1
- http://www.yourcsd.com/566/Buscher-Park 1
- http://www.yourcsd.com/569/Camden-Park 1
- http://www.yourcsd.com/584/Bartholomew-Sports-Park 1
- http://www.yourcsd.com/586/Constellation-Park 1
- http://www.yourcsd.com/590/Derr-Okamoto-Park 1
- http://www.yourcsd.com/595/Bridgeview-Park 1
- http://www.yourcsd.com/604/Jordan-Family-Park 1
- http://www.yourcsd.com/621/Promenade-Park 1
- http://www.yourcsd.com/624/Rose-Garden-Park 1
- http://www.yourcsd.com/631/Island-Park 1
- http://www.yourcsd.com/639/Storybook-Woods-Park 1
- http://www.yourcsd.com/646/Underwood-Park 1
- https://ghcsd.com/wp-content/uploads/eastside-kiosk-map.pdf 1
- https://helendalecsd.recdesk.com/Community/Page?pageId=18185 1
- https://www.btcsd.org/brooktrails-redwood-park 1
- https://www.helendalecsd.org/parks_facilities.html 1
- https://www.jcsd.us/Home/Components/FacilityDirectory/FacilityDirectory/2/82 1
DES_TP 12
- Local Park 173
- Local Recreation Area 14
- Local Other or Unknown 2
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 194
- Restricted Access 4
MNG_AG_TYP 1
- Community Services District · 198 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
7820 | 7820 | 7819 | {"type": "Polygon", "coordinates": [[[-119.70761, 36.31119], [-119.70698, 36.31119], [-119.70698, 36.31202], [-119.70615, 36.31201], [-119.70613, 36.3117], [-119.70512, 36.31171], [-119.70511, 36.31068], [-119.70548, 36.31064], [-119.70565, 36.31049], [-119.70587, 36.31042], [-119.7061, 36.31041], [-119.70699, 36.31031], [-119.7076, 36.31031], [-119.70761, 36.31119]]]} | Open Access 1 | 9049 | Armona Recreation Park | 15593 | 2279 | Aromona Community Services District 880 | Special District 4 | Community Services District 19 | Special District 4 | 2279 | Aromona Community Services District 856 | Special District 4 | Community Services District 17 | Kings 44 | 7.734 | Armona Rec. Park | 0 | Local Recreation Area 3 | 4 | ||
7828 | 7828 | 7827 | {"type": "Polygon", "coordinates": [[[-119.71474, 36.32481], [-119.71447, 36.32482], [-119.71291, 36.32308], [-119.7091, 36.3231], [-119.70911, 36.3207], [-119.71061, 36.3207], [-119.71062, 36.32069], [-119.70911, 36.31921], [-119.70919, 36.31883], [-119.7097, 36.31935], [-119.71109, 36.31934], [-119.7111, 36.31884], [-119.71159, 36.31884], [-119.71156, 36.32113], [-119.71151, 36.32118], [-119.71408, 36.32382], [-119.7146, 36.32439], [-119.71435, 36.3244], [-119.71474, 36.32481]]]} | Open Access 1 | 9397 | Armona Recreation Park | 15593 | 2279 | Aromona Community Services District 880 | Special District 4 | Community Services District 19 | Special District 4 | 2279 | Aromona Community Services District 856 | Special District 4 | Community Services District 17 | Kings 44 | 26.885 | Armona Rec. Park | 0 | Local Recreation Area 3 | 4 | ||
11866 | 11866 | 11865 | {"type": "Polygon", "coordinates": [[[-123.37488, 41.79526], [-123.37479, 41.79527], [-123.37464, 41.79551], [-123.37252, 41.79546], [-123.37205, 41.79325], [-123.3725, 41.79301], [-123.37448, 41.79406], [-123.37488, 41.79526]]]} | Open Access 1 | 24311 | Gale Zinc Memorial Park | 19173 | 2226 | Happy Camp Community Services District 995 | Special District 4 | Community Services District 19 | Special District 4 | 2226 | Happy Camp Community Services District 958 | Special District 4 | Community Services District 17 | Siskiyou 28 | 10.657 | Gale Zinc Memorial Park | 0 | Local Park 2 | 4 | ||
3018 | 3018 | 3017 | {"type": "Polygon", "coordinates": [[[-120.22896, 37.8407], [-120.22786, 37.84097], [-120.22634, 37.84146], [-120.22619, 37.84109], [-120.22604, 37.84066], [-120.22665, 37.8405], [-120.22662, 37.83992], [-120.22722, 37.83984], [-120.22824, 37.83973], [-120.22836, 37.84012], [-120.22861, 37.84009], [-120.22869, 37.84028], [-120.22896, 37.8407]]]} | Open Access 1 | 24323 | Mary Laveroni Community Park | 21935 | 2225 | Groveland Community Services District 575 | Special District 4 | Community Services District 19 | http://gcsd.org/ | Special District 4 | 2225 | Groveland Community Services District 567 | Special District 4 | Community Services District 17 | Tuolumne 21 | 6.919 | Mary Laveroni Community Park | 0 | Local Park 2 | 4 | |
3368 | 3368 | 3367 | {"type": "Polygon", "coordinates": [[[-120.22752, 37.84921], [-120.22678, 37.84949], [-120.22674, 37.84968], [-120.22664, 37.85002], [-120.22645, 37.85003], [-120.22647, 37.84962], [-120.22639, 37.84956], [-120.22598, 37.84877], [-120.22683, 37.84863], [-120.22716, 37.84872], [-120.22752, 37.84921]]]} | Open Access 1 | 24325 | Leon Rose Ball Park | 21170 | 2225 | Groveland Community Services District 575 | Special District 4 | Community Services District 19 | http://gcsd.org/ | Special District 4 | 2225 | Groveland Community Services District 567 | Special District 4 | Community Services District 17 | Tuolumne 21 | 2.504 | Leon Rose Ball Park | 0 | Local Recreation Area 3 | 4 | |
3352 | 3352 | 3351 | {"type": "Polygon", "coordinates": [[[-124.10338, 40.95518], [-124.10286, 40.95518], [-124.10286, 40.95491], [-124.10338, 40.95491], [-124.10338, 40.95518]]]} | Open Access 1 | 24241 | Larissa Park | 21027 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | Humboldt 45 | 0.324 | Larissa Park | 0 | Local Park 2 | 4 | |
7381 | 7381 | 7380 | {"type": "Polygon", "coordinates": [[[-124.07921, 40.91543], [-124.07916, 40.91219], [-124.08423, 40.91223], [-124.08337, 40.91339], [-124.08297, 40.91427], [-124.08271, 40.9151], [-124.08267, 40.91537], [-124.08199, 40.91665], [-124.07922, 40.91579], [-124.07921, 40.91543]]]} | Restricted Access 2 | 47595 | Riverfront Park | 31322 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | Humboldt 45 | 36.389 | Riverfront Park | 0 | Local Park 2 | 4 | |
11843 | 11843 | 11842 | {"type": "MultiPolygon", "coordinates": [[[[-124.12092, 40.949], [-124.11648, 40.94898], [-124.11663, 40.9423], [-124.12009, 40.94232], [-124.12005, 40.94415], [-124.12013, 40.94702], [-124.12017, 40.94729], [-124.12021, 40.94747], [-124.12035, 40.94787], [-124.12092, 40.949]]], [[[-124.12553, 40.94239], [-124.1243, 40.94901], [-124.12126, 40.949], [-124.12063, 40.94769], [-124.12055, 40.9475], [-124.12043, 40.9471], [-124.12037, 40.94679], [-124.1203, 40.9442], [-124.12032, 40.94239], [-124.12553, 40.94239]]]]} | Open Access 1 | 24242 | Hiller Park Playground and Picnic Area | 19973 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | Humboldt 45 | 124.095 | Hiller Park Playground and Picnic Area | 0 | Local Recreation Area 3 | 4 | |
11844 | 11844 | 11843 | {"type": "Polygon", "coordinates": [[[-124.09944, 40.94435], [-124.09763, 40.94435], [-124.09762, 40.94319], [-124.09864, 40.94317], [-124.09865, 40.94306], [-124.09944, 40.94308], [-124.09944, 40.94435]]]} | Open Access 1 | 24243 | Pierson Park | 23666 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | http://mckinleyvillecsd.com/pierson-park | Humboldt 45 | 5.118 | Pierson Park | 0 | Local Park 2 | 4 |
14168 | 14168 | 14167 | {"type": "Polygon", "coordinates": [[[-122.33651, 40.70968], [-122.33649, 40.71002], [-122.33604, 40.7099], [-122.33608, 40.70968], [-122.33651, 40.70968]]]} | Open Access 1 | 43063 | Mountain Gate Community Special District 1 | 22539 | 2292 | Mountain Gate Community Special District 1093 | Special District 4 | Community Services District 19 | http://mountaingatecsd.com/ | Special District 4 | 2292 | Mountain Gate Community Special District 1048 | Special District 4 | Community Services District 17 | Shasta 27 | 0.286 | Mtn. Gate Community Spec. Dist. 1 | None 1205 | |||
11839 | 11839 | 11838 | {"type": "Polygon", "coordinates": [[[-121.75839, 36.87566], [-121.75803, 36.87597], [-121.75767, 36.87552], [-121.7581, 36.87529], [-121.75839, 36.87566]]]} | Open Access 1 | 24251 | Caytano Park | 16984 | 2249 | Pajaro Community Services District 992 | Special District 4 | Community Services District 19 | http://pajarosunnymesa.com/ | Special District 4 | 2249 | Pajaro Community Services District 956 | Special District 4 | Community Services District 17 | Monterey 14 | 0.618 | Caytano Park | 0 | Local Park 2 | 4 | |
11840 | 11840 | 11839 | {"type": "Polygon", "coordinates": [[[-121.74682, 36.88845], [-121.74016, 36.88843], [-121.73988, 36.88451], [-121.74432, 36.88292], [-121.74492, 36.88208], [-121.74483, 36.88119], [-121.74643, 36.88131], [-121.74635, 36.88214], [-121.74634, 36.88253], [-121.74634, 36.88304], [-121.74682, 36.88845]]]} | Open Access 1 | 24252 | Memorial Park | 22142 | 2249 | Pajaro Community Services District 992 | Special District 4 | Community Services District 19 | http://pajarosunnymesa.com/ | Special District 4 | 2249 | Pajaro Community Services District 956 | Special District 4 | Community Services District 17 | Monterey 14 | 87.007 | Memorial Park | 0 | Local Park 2 | 4 | |
3746 | 3746 | 3745 | {"type": "Polygon", "coordinates": [[[-117.57139, 33.96796], [-117.57095, 33.96793], [-117.57034, 33.96782], [-117.56983, 33.96767], [-117.56909, 33.96739], [-117.56852, 33.96724], [-117.56786, 33.96714], [-117.56726, 33.96712], [-117.56721, 33.96707], [-117.5672, 33.9647], [-117.57139, 33.9647], [-117.57139, 33.96796]]]} | Open Access 1 | 44902 | Harada Heritage Park | 19658 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | Riverside 10 | 29.71 | Harada Heritage Park | 0 | Local Park 2 | 4 | |
5310 | 5310 | 5309 | {"type": "Polygon", "coordinates": [[[-117.60325, 33.93325], [-117.60036, 33.93326], [-117.60037, 33.93321], [-117.60032, 33.933], [-117.60022, 33.93275], [-117.60012, 33.93259], [-117.59983, 33.93223], [-117.59978, 33.93214], [-117.59975, 33.93201], [-117.59976, 33.93153], [-117.5999, 33.93138], [-117.60052, 33.93174], [-117.60097, 33.93195], [-117.60157, 33.93215], [-117.60186, 33.93223], [-117.60232, 33.93232], [-117.60276, 33.93237], [-117.60324, 33.93239], [-117.60332, 33.93241], [-117.60335, 33.93244], [-117.60337, 33.93248], [-117.60337, 33.93316], [-117.60334, 33.93323], [-117.6033, 33.93325], [-117.60325, 33.93325]]]} | Open Access 1 | 48902 | Dairyland Park | 33619 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities | Riverside 10 | 9.932 | Dairyland Park | 0 | Local Park 2 | 4 |
6455 | 6455 | 6454 | {"type": "Polygon", "coordinates": [[[-117.61081, 33.96804], [-117.60946, 33.96804], [-117.60945, 33.96786], [-117.60921, 33.96786], [-117.60921, 33.96804], [-117.60387, 33.96805], [-117.6108, 33.96589], [-117.61081, 33.96804]]]} | Open Access 1 | 48900 | American Heroes Park | 33617 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | https://www.jcsd.us/Home/Components/FacilityDirectory/FacilityDirectory/2/82 | Riverside 10 | 18.815 | American Heroes Park | 0 | Local Park 2 | 4 |
6605 | 6605 | 6604 | {"type": "Polygon", "coordinates": [[[-117.6, 33.94975], [-117.59999, 33.95205], [-117.59995, 33.95209], [-117.59977, 33.9521], [-117.59968, 33.95208], [-117.59949, 33.95201], [-117.5994, 33.95201], [-117.59932, 33.95205], [-117.59929, 33.95212], [-117.5993, 33.9522], [-117.59937, 33.95225], [-117.59901, 33.95226], [-117.59896, 33.9523], [-117.59891, 33.95224], [-117.59882, 33.95221], [-117.59874, 33.95223], [-117.59867, 33.95228], [-117.59864, 33.95225], [-117.5981, 33.95225], [-117.59829, 33.95213], [-117.59844, 33.95198], [-117.59855, 33.95182], [-117.59862, 33.95163], [-117.59864, 33.95146], [-117.59862, 33.94997], [-117.59867, 33.94993], [-117.59917, 33.94992], [-117.59943, 33.94994], [-117.5995, 33.94992], [-117.59957, 33.94988], [-117.59961, 33.94982], [-117.59963, 33.94976], [-117.6, 33.94975]]]} | Open Access 1 | 48901 | Mountainview Park | 33618 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities | Riverside 10 | 8.186 | Mountainview Park | 0 | Local Park 2 | 4 |
6770 | 6770 | 6769 | {"type": "Polygon", "coordinates": [[[-117.56267, 33.9516], [-117.55847, 33.9516], [-117.55845, 33.94993], [-117.55859, 33.94992], [-117.55858, 33.94739], [-117.56038, 33.94687], [-117.56071, 33.94684], [-117.56211, 33.94742], [-117.56267, 33.94752], [-117.56267, 33.9516]]]} | Open Access 1 | 48903 | Eastvale Community Park | 33620 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | https://www.jcsd.us/services/parks-and-recreation/parks-and-recreation-facilities | Riverside 10 | 46.601 | Eastvale Community Park | 0 | Local Park 2 | 4 |
13019 | 13019 | 13018 | {"type": "Polygon", "coordinates": [[[-117.59289, 33.97159], [-117.59218, 33.97181], [-117.58877, 33.97278], [-117.58866, 33.97294], [-117.58864, 33.97293], [-117.58875, 33.97278], [-117.58875, 33.97258], [-117.58833, 33.97238], [-117.58852, 33.97211], [-117.58873, 33.9719], [-117.58897, 33.97171], [-117.58923, 33.97155], [-117.5896, 33.97137], [-117.59057, 33.97103], [-117.59166, 33.97069], [-117.59189, 33.97065], [-117.59195, 33.97061], [-117.592, 33.97055], [-117.59201, 33.97048], [-117.59199, 33.9704], [-117.59287, 33.97039], [-117.59289, 33.97159]]]} | Open Access 1 | 44903 | James C. Huber Park | 20343 | 2331 | Jurupa Community Services District 677 | Special District 4 | Community Services District 19 | http://parks.jcsd.us/ | Special District 4 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | Riverside 10 | 13.184 | James C. Huber 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]);