units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
122 rows where AGNCY_LEV = 2 and MNG_AGENCY = 56 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 83
- Local Recreation Area 13
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 102
MNG_AGENCY 1
- Oakland, City of · 102 ✖
ACCESS_TYP 1
- Open Access 102
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9313 | 9313 | 9312 | {"type": "Polygon", "coordinates": [[[-122.24204, 37.85062], [-122.23984, 37.85093], [-122.23982, 37.85109], [-122.2391, 37.85125], [-122.23883, 37.8512], [-122.23693, 37.85067], [-122.23681, 37.85044], [-122.23681, 37.85023], [-122.23658, 37.84995], [-122.23623, 37.84978], [-122.23624, 37.84932], [-122.23667, 37.84953], [-122.23731, 37.84991], [-122.23785, 37.85015], [-122.23846, 37.85028], [-122.23905, 37.85035], [-122.24001, 37.85032], [-122.2408, 37.85019], [-122.24128, 37.85007], [-122.24168, 37.84993], [-122.24196, 37.84972], [-122.24204, 37.85062]]]} | Open Access 1 | 15527 | Chabot Park | 17109 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 10.307 | Chabot Park | 1961 | Local Park 2 | 4 | |
8494 | 8494 | 8493 | {"type": "Polygon", "coordinates": [[[-122.26277, 37.79503], [-122.26265, 37.79521], [-122.26225, 37.79504], [-122.26118, 37.79682], [-122.25982, 37.79631], [-122.25937, 37.79601], [-122.25689, 37.79375], [-122.25807, 37.79295], [-122.25956, 37.79323], [-122.26015, 37.79275], [-122.26028, 37.79248], [-122.26063, 37.79208], [-122.2611, 37.792], [-122.26168, 37.79229], [-122.26185, 37.79209], [-122.26272, 37.79287], [-122.26204, 37.79397], [-122.26183, 37.79427], [-122.26277, 37.79503]]]} | Open Access 1 | 13280 | Channel Park | 17121 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 37.379 | Channel Park | 0 | Local Park 2 | 4 | |
8493 | 8493 | 8492 | {"type": "Polygon", "coordinates": [[[-122.27085, 37.79746], [-122.27066, 37.79776], [-122.27058, 37.79782], [-122.27046, 37.79786], [-122.27036, 37.79786], [-122.2702, 37.79782], [-122.26962, 37.79759], [-122.26993, 37.79709], [-122.27085, 37.79746]]]} | Open Access 1 | 13277 | Chinese Garden Park | 32515 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.324 | Chinese Garden Park | 0 | Local Park 2 | 4 | |
1779 | 1779 | 1778 | {"type": "Polygon", "coordinates": [[[-122.27241, 37.80487], [-122.27205, 37.80548], [-122.27156, 37.80529], [-122.27141, 37.80474], [-122.27152, 37.80454], [-122.27241, 37.80487]]]} | Open Access 1 | 13266 | City Hall Plaza | 17298 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.331 | City Hall Plaza | 0 | Local Park 2 | 4 | |
8498 | 8498 | 8497 | {"type": "Polygon", "coordinates": [[[-122.25379, 37.79435], [-122.25304, 37.79487], [-122.25235, 37.79427], [-122.2531, 37.79373], [-122.25379, 37.79435]]]} | Open Access 1 | 13293 | Clinton Park | 32504 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.998 | Clinton Park | 0 | Local Park 2 | 4 | |
8522 | 8522 | 8521 | {"type": "Polygon", "coordinates": [[[-122.25792, 37.84756], [-122.2579, 37.8476], [-122.25786, 37.84762], [-122.25741, 37.84767], [-122.25737, 37.84765], [-122.25735, 37.84762], [-122.25734, 37.84745], [-122.25736, 37.84742], [-122.2574, 37.8474], [-122.25781, 37.84735], [-122.25789, 37.84739], [-122.25792, 37.84756]]]} | Open Access 1 | 13441 | Colby Park | 17479 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.357 | Colby Park | 0 | Local Park 2 | 4 | |
8517 | 8517 | 8516 | {"type": "Polygon", "coordinates": [[[-122.19938, 37.75713], [-122.19924, 37.75722], [-122.19918, 37.75734], [-122.19815, 37.75822], [-122.19753, 37.7576], [-122.19759, 37.75714], [-122.19761, 37.75712], [-122.1977, 37.75643], [-122.19856, 37.7565], [-122.19859, 37.75649], [-122.19874, 37.7565], [-122.19938, 37.75713]]]} | Open Access 1 | 13377 | Coliseum Gardens Park | 17499 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 4.999 | Coliseum Gardens Park | 0 | Local Park 2 | 4 | |
9315 | 9315 | 9314 | {"type": "MultiPolygon", "coordinates": [[[[-122.18916, 37.72907], [-122.18879, 37.72898], [-122.18871, 37.72856], [-122.18907, 37.72866], [-122.18916, 37.72907]]], [[[-122.19138, 37.73026], [-122.1904, 37.73064], [-122.18972, 37.73088], [-122.18947, 37.73095], [-122.18934, 37.73095], [-122.1893, 37.73091], [-122.1888, 37.7291], [-122.1892, 37.7292], [-122.18966, 37.73082], [-122.18972, 37.73083], [-122.19011, 37.73067], [-122.19012, 37.73037], [-122.19019, 37.73034], [-122.1909, 37.73032], [-122.19107, 37.73029], [-122.19126, 37.73022], [-122.19134, 37.73022], [-122.19138, 37.73026]]]]} | Open Access 1 | 15530 | Columbian Gardens Park | 17550 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 2.649 | Columbian Gardens Park | 0 | Local Park 2 | 4 | |
8516 | 8516 | 8515 | {"type": "Polygon", "coordinates": [[[-122.18437, 37.77273], [-122.18343, 37.77353], [-122.18268, 37.77286], [-122.18334, 37.77241], [-122.18287, 37.77195], [-122.18325, 37.77171], [-122.18437, 37.77273]]]} | Open Access 1 | 13374 | Concordia Park | 17577 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 3.494 | Concordia Park | 0 | Local Park 2 | 4 | |
4211 | 4211 | 4210 | {"type": "Polygon", "coordinates": [[[-122.20516, 37.78073], [-122.20486, 37.78088], [-122.20461, 37.78104], [-122.2045, 37.78112], [-122.20436, 37.781], [-122.20469, 37.78076], [-122.20493, 37.78052], [-122.20516, 37.78073]]]} | Open Access 1 | 44961 | Courtland Creek Park | 17721 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.386 | Courtland Creek Park | 0 | Local Park 2 | 4 | |
9374 | 9374 | 9373 | {"type": "Polygon", "coordinates": [[[-122.29722, 37.80377], [-122.29719, 37.80383], [-122.29678, 37.80373], [-122.2968, 37.80366], [-122.29722, 37.80377]]]} | Open Access 1 | 15671 | Cresent Park | 17799 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.075 | Cresent Park | 0 | Local Park 2 | 4 | |
3074 | 3074 | 3073 | {"type": "Polygon", "coordinates": [[[-122.21426, 37.79561], [-122.21378, 37.79679], [-122.21206, 37.79603], [-122.21209, 37.79595], [-122.21209, 37.79585], [-122.21199, 37.79538], [-122.21201, 37.79535], [-122.21252, 37.79484], [-122.21426, 37.79561]]]} | Open Access 1 | 24940 | Curt Flood Field | 17862 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 6.219 | Curt Flood Field | 0 | Local Recreation Area 3 | 4 | |
3585 | 3585 | 3584 | {"type": "Polygon", "coordinates": [[[-122.29309, 37.81022], [-122.29302, 37.81041], [-122.29246, 37.81028], [-122.29225, 37.81086], [-122.29188, 37.81077], [-122.29186, 37.81081], [-122.29176, 37.81079], [-122.29189, 37.81038], [-122.29198, 37.80998], [-122.29309, 37.81022]]]} | Open Access 1 | 29165 | Cypress Freeway Memorial Park | 17873 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 1.278 | Cypress Freeway Memorial Park | 0 | Local Park 2 | 4 | |
2039 | 2039 | 2038 | {"type": "Polygon", "coordinates": [[[-122.28859, 37.81185], [-122.28813, 37.81311], [-122.28611, 37.81266], [-122.28528, 37.8123], [-122.28569, 37.81119], [-122.28859, 37.81185]]]} | Open Access 1 | 15570 | DeFremery Park | 18017 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 9.428 | DeFremery Park | 1910 | Local Park 2 | 4 | |
9394 | 9394 | 9393 | {"type": "MultiPolygon", "coordinates": [[[[-122.21418, 37.81309], [-122.21399, 37.81324], [-122.21383, 37.81341], [-122.21296, 37.81468], [-122.21287, 37.81488], [-122.21282, 37.81505], [-122.21279, 37.81524], [-122.21276, 37.81568], [-122.21271, 37.81589], [-122.21264, 37.81615], [-122.21255, 37.81635], [-122.21242, 37.8166], [-122.21216, 37.81697], [-122.21188, 37.81727], [-122.21156, 37.81754], [-122.21134, 37.81732], [-122.21021, 37.8181], [-122.21042, 37.81832], [-122.20899, 37.81931], [-122.20864, 37.8196], [-122.20844, 37.8198], [-122.20824, 37.82005], [-122.20783, 37.82076], [-122.20752, 37.82065], [-122.20748, 37.82071], [-122.20708, 37.82061], [-122.20721, 37.82062], [-122.20724, 37.82059], [-122.2066, 37.81988], [-122.20655, 37.81977], [-122.20656, 37.81968], [-122.20664, 37.81949], [-122.20665, 37.81934], [-122.2074, 37.81931], [-122.20747, 37.81913], [-122.20759, 37.81904], [-122.20763, 37.81894], [-122.2074, 37.81888], [-122.20735, 37.81874], [-122.20698, 37.81872], [-122.20695, 37.81862], [-122.20657, 37.81849], [-122.20619, 37.81822], [-122.20582, 37.81817], [-122.20518, 37.81767], [-122.20512, 37.81752], [-122.20472, 37.81736], [-122.20425, 37.81689], [-122.20411, 37.81684], [-122.20401, 37.81675], [-122.20367, 37.8167], [-122.2035, 37.81649], [-122.2037, 37.81627], [-122.20461, 37.81657], [-122.20479, 37.81665], [-122.20494, 37.81677], [-122.20511, 37.81692], [-122.20541, 37.81728], [-122.20586, 37.81761], [-122.20601, 37.81766], [-122.20628, 37.81764], [-122.20626, 37.81779], [-122.20644, 37.8179], [-122.20652, 37.81792], [-122.2067, 37.8179], [-122.20684, 37.81792], [-122.20729, 37.81814], [-122.21117, 37.8155], [-122.21113, 37.8148], [-122.2109, 37.81458], [-122.2105, 37.81486], [-122.21011, 37.81458], [-122.20948, 37.81371], [-122.20937, 37.8135], [-122.20949, 37.81337], [-122.20984, 37.81349], [-122.20991, 37.81338], [-122.21032, 37.81354], [-122.21028, 37.81361], [-122.21029, 37.81362], [-122.21061, 37.81374], [-122.21072, 37.81377], [-122.21091, 37.81377], [-122.21113, 37.81371], [-122.2114, 37.8137], [-122.21165, 37.81365], [-122.21181, 37.81358], [-122.21196, 37.81346], [-122.21202, 37.81339], [-122.21205, 37.81331], [-122.21206, 37.81323], [-122.21203, 37.81315], [-122.2119, 37.81299], [-122.21187, 37.81289], [-122.21226, 37.81285], [-122.21266, 37.8127], [-122.21266, 37.81226], [-122.21289, 37.81238], [-122.2131, 37.81212], [-122.21365, 37.81239], [-122.21398, 37.81251], [-122.21379, 37.81288], [-122.21397, 37.81301], [-122.21403, 37.81298], [-122.21418, 37.81309]]], [[[-122.21615, 37.8102], [-122.21597, 37.81029], [-122.21571, 37.81014], [-122.21562, 37.81013], [-122.21555, 37.81019], [-122.21534, 37.81058], [-122.21499, 37.81103], [-122.21478, 37.81126], [-122.21455, 37.81134], [-122.21436, 37.81156], [-122.21424, 37.81174], [-122.2144, 37.81205], [-122.2142, 37.81215], [-122.21411, 37.81217], [-122.21403, 37.81225], [-122.21399, 37.81236], [-122.21374, 37.81227], [-122.21319, 37.812], [-122.21359, 37.81151], [-122.21352, 37.8107], [-122.21438, 37.81005], [-122.21447, 37.81011], [-122.21466, 37.80997], [-122.21458, 37.80989], [-122.21471, 37.8098], [-122.21499, 37.80946], [-122.21512, 37.8092], [-122.21515, 37.80906], [-122.21527, 37.80907], [-122.21528, 37.80895], [-122.21517, 37.80894], [-122.2152, 37.80871], [-122.21533, 37.80871], [-122.21534, 37.80861], [-122.21522, 37.8086], [-122.21532, 37.80794], [-122.21544, 37.80794], [-122.21549, 37.80762], [-122.21546, 37.80761], [-122.21574, 37.80753], [-122.21592, 37.80763], [-122.21611, 37.80767], [-122.21615, 37.80805], [-122.21614, 37.80818], [-122.21605, 37.80838], [-122.21605, 37.80855], [-122.21595, 37.80889], [-122.21601, 37.80917], [-122.216, 37.80924], [-122.2159, 37.80948], [-122.21589, 37.80955], [-122.21593, 37.80968], [-122.21603, 37.80983], [-122.21615, 37.8102]]], [[[-122.21679, 37.804], [-122.2167, 37.80414], [-122.21665, 37.80427], [-122.21669, 37.80442], [-122.21656, 37.80466], [-122.21669, 37.80483], [-122.21644, 37.80488], [-122.21632, 37.80495], [-122.21649, 37.80502], [-122.21633, 37.80543], [-122.21638, 37.80566], [-122.21638, 37.80575], [-122.21591, 37.80605], [-122.21592, 37.80644], [-122.21605, 37.80683], [-122.2162, 37.80705], [-122.21621, 37.8072], [-122.21619, 37.80727], [-122.21605, 37.80744], [-122.21606, 37.80752], [-122.21596, 37.80749], [-122.21584, 37.80742], [-122.21578, 37.80736], [-122.21537, 37.80669], [-122.21432, 37.80652], [-122.21493, 37.80498], [-122.21446, 37.80489], [-122.2151, 37.80326], [-122.21637, 37.80358], [-122.21649, 37.80358], [-122.21672, 37.80373], [-122.2167, 37.80387], [-122.21679, 37.804]]]]} | Open Access 1 | 15702 | Dimond Canyon Park | 18154 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 78.65 | Dimond Canyon Park | 0 | Local Park 2 | 4 | |
11166 | 11166 | 11165 | {"type": "Polygon", "coordinates": [[[-122.2686, 37.84295], [-122.26834, 37.843], [-122.26827, 37.84298], [-122.26793, 37.84302], [-122.26779, 37.84237], [-122.26814, 37.84232], [-122.2682, 37.84224], [-122.26821, 37.84226], [-122.26845, 37.84222], [-122.2686, 37.84295]]]} | Open Access 1 | 47995 | Dover Street Park | 32417 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | https://www.oaklandca.gov/services/find-a-parks-and-recreation-location | Alameda 17 | 1.139 | Dover Street Park | 0 | Local Park 2 | 4 |
8532 | 8532 | 8531 | {"type": "Polygon", "coordinates": [[[-122.14501, 37.74224], [-122.14462, 37.74247], [-122.14315, 37.74306], [-122.14154, 37.74234], [-122.14023, 37.74083], [-122.14108, 37.73916], [-122.14144, 37.73896], [-122.14157, 37.73902], [-122.14195, 37.7395], [-122.14307, 37.73996], [-122.1434, 37.74026], [-122.1437, 37.74072], [-122.14413, 37.74111], [-122.14501, 37.74224]]]} | Open Access 1 | 13404 | Dunsmuir Estate Park | 18309 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 25.146 | Dunsmuir Estate Park | 0 | Local Park 2 | 4 | |
7449 | 7449 | 7448 | {"type": "Polygon", "coordinates": [[[-122.27229, 37.81853], [-122.27223, 37.81886], [-122.27181, 37.81879], [-122.2719, 37.81848], [-122.27229, 37.81853]]]} | Open Access 1 | 13447 | Durant Mini Park | 18311 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.32 | Durant MP | 0 | Local Park 2 | 4 | |
8526 | 8526 | 8525 | {"type": "Polygon", "coordinates": [[[-122.17538, 37.74328], [-122.17464, 37.74363], [-122.17402, 37.74281], [-122.17476, 37.74246], [-122.17538, 37.74328]]]} | Open Access 1 | 13385 | Elmhurst Plaza | 18598 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 2.01 | Elmhurst Plaza | 0 | Local Park 2 | 4 | |
12240 | 12240 | 12239 | {"type": "Polygon", "coordinates": [[[-122.2692, 37.78832], [-122.26784, 37.7905], [-122.26673, 37.79006], [-122.26651, 37.79041], [-122.26597, 37.79022], [-122.26578, 37.79011], [-122.26541, 37.79026], [-122.26406, 37.79116], [-122.26366, 37.7911], [-122.26364, 37.79113], [-122.2627, 37.79097], [-122.26272, 37.79082], [-122.26329, 37.79083], [-122.26769, 37.78754], [-122.26822, 37.78774], [-122.2692, 37.78832]]]} | Open Access 1 | 25444 | Estuary Park | 18732 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 20.666 | Estuary 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]);