units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where DES_TP = 2 and MNG_AGENCY = 15 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
MNG_AG_TYP 1
- City Agency 31
MNG_AGENCY 1
- Moreno Valley, City of · 31 ✖
DES_TP 1
- Local Park · 31 ✖
ACCESS_TYP 1
- Open Access 31
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14112 | 14112 | 14111 | {"type": "Polygon", "coordinates": [[[-117.22611, 33.89861], [-117.22604, 33.89868], [-117.22536, 33.89868], [-117.22533, 33.89865], [-117.22533, 33.8984], [-117.22611, 33.8984], [-117.22611, 33.89861]]]} | Open Access 1 | 39195 | Patriot Park | 23514 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 0.54 | Patriot Park | 0 | Local Park 2 | 4 | |
14111 | 14111 | 14110 | {"type": "Polygon", "coordinates": [[[-117.18933, 33.93181], [-117.18902, 33.93204], [-117.18795, 33.93145], [-117.18795, 33.93102], [-117.18841, 33.93099], [-117.18842, 33.93067], [-117.18859, 33.93067], [-117.1886, 33.9313], [-117.18912, 33.93158], [-117.18933, 33.93181]]]} | Open Access 1 | 39194 | Rock Ridge Park | 24512 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 1.93 | Rock Ridge Park | 0 | Local Park 2 | 4 | |
11991 | 11991 | 11990 | {"type": "Polygon", "coordinates": [[[-117.18266, 33.90361], [-117.1824, 33.90362], [-117.1824, 33.90407], [-117.1809, 33.90438], [-117.18064, 33.90402], [-117.1806, 33.9038], [-117.18052, 33.9038], [-117.18053, 33.90297], [-117.18062, 33.90291], [-117.18258, 33.90291], [-117.18266, 33.90297], [-117.18266, 33.90361]]]} | Open Access 1 | 24645 | Celebration Park | 17004 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 6.573 | Celebration Park | 0 | Local Park 2 | 4 | |
11344 | 11344 | 11343 | {"type": "Polygon", "coordinates": [[[-117.20012, 33.92813], [-117.19583, 33.92815], [-117.19583, 33.92645], [-117.20007, 33.92645], [-117.20008, 33.92693], [-117.20006, 33.92694], [-117.20006, 33.92702], [-117.20008, 33.92703], [-117.20008, 33.9274], [-117.20012, 33.92741], [-117.20012, 33.92813]]]} | Open Access 1 | 22124 | Morrison Park | 22499 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 18.257 | Morrison Park | 0 | Local Park 2 | 4 | |
10709 | 10709 | 10708 | {"type": "Polygon", "coordinates": [[[-117.27147, 33.98103], [-117.27074, 33.98105], [-117.27077, 33.98227], [-117.27102, 33.98307], [-117.26991, 33.98309], [-117.26957, 33.98198], [-117.26922, 33.98177], [-117.2686, 33.98153], [-117.26838, 33.98123], [-117.2681, 33.98108], [-117.26807, 33.98093], [-117.26797, 33.9808], [-117.26785, 33.98078], [-117.26794, 33.98044], [-117.26796, 33.98026], [-117.26797, 33.98009], [-117.26794, 33.97977], [-117.26792, 33.97965], [-117.26796, 33.9796], [-117.26815, 33.97959], [-117.26828, 33.9796], [-117.2685, 33.97966], [-117.26861, 33.97971], [-117.26894, 33.97996], [-117.26907, 33.98004], [-117.26923, 33.98011], [-117.26939, 33.98015], [-117.26956, 33.98017], [-117.26973, 33.98017], [-117.2699, 33.98015], [-117.27025, 33.98005], [-117.27046, 33.98003], [-117.27066, 33.98004], [-117.27084, 33.98009], [-117.27102, 33.98017], [-117.27117, 33.98028], [-117.2713, 33.98041], [-117.27139, 33.98058], [-117.27147, 33.98103]]]} | Open Access 1 | 19867 | Hidden Springs Community Park | 19912 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 16.933 | Hidden Springs Community Park | 0 | Local Park 2 | 4 | |
10120 | 10120 | 10119 | {"type": "Polygon", "coordinates": [[[-117.24196, 33.9082], [-117.24193, 33.90836], [-117.24184, 33.90826], [-117.24182, 33.90826], [-117.24187, 33.90844], [-117.24187, 33.90876], [-117.24154, 33.90837], [-117.24154, 33.90821], [-117.24138, 33.90821], [-117.23994, 33.90653], [-117.23999, 33.9065], [-117.24031, 33.9065], [-117.24179, 33.9082], [-117.24196, 33.9082]]]} | Open Access 1 | 17589 | CA Aqueduct Linear Park Site | 16631 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 2.084 | CA Aqueduct Linear Park Site | 0 | Local Park 2 | 4 | |
9291 | 9291 | 9290 | {"type": "Polygon", "coordinates": [[[-117.21472, 33.90996], [-117.21294, 33.90995], [-117.21286, 33.90989], [-117.21286, 33.90933], [-117.21282, 33.90908], [-117.21269, 33.9088], [-117.21259, 33.90866], [-117.21246, 33.90852], [-117.21246, 33.90847], [-117.21263, 33.90828], [-117.21277, 33.90806], [-117.21323, 33.90814], [-117.21324, 33.90816], [-117.21472, 33.90815], [-117.21472, 33.90996]]]} | Open Access 1 | 15477 | Woodland Park | 27723 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 9.086 | Woodland Park | 0 | Local Park 2 | 4 | |
9175 | 9175 | 9174 | {"type": "Polygon", "coordinates": [[[-117.26135, 33.96557], [-117.2581, 33.96558], [-117.2581, 33.96493], [-117.25814, 33.96497], [-117.26135, 33.96496], [-117.26135, 33.96557]]]} | Open Access 1 | 15233 | Westbluff Park | 28291 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/resident_services/park_rec/index_park-rec.shtml?tab=3#Tab-mv | Riverside 10 | 5.011 | Westbluff Park | 0 | Local Park 2 | 4 |
9118 | 9118 | 9117 | {"type": "Polygon", "coordinates": [[[-117.19889, 33.89558], [-117.19852, 33.89557], [-117.19849, 33.89555], [-117.19837, 33.89556], [-117.19832, 33.8956], [-117.19829, 33.89566], [-117.19832, 33.89575], [-117.19792, 33.89604], [-117.19709, 33.89601], [-117.19671, 33.89594], [-117.19595, 33.89591], [-117.19595, 33.89558], [-117.19655, 33.89555], [-117.19736, 33.89543], [-117.19793, 33.89529], [-117.19827, 33.89519], [-117.19884, 33.89498], [-117.19892, 33.8951], [-117.19894, 33.89523], [-117.19889, 33.89558]]]} | Open Access 1 | 15118 | Vista Lomas Park | 27177 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 3.935 | Vista Lomas Park | 0 | Local Park 2 | 4 | |
9084 | 9084 | 9083 | {"type": "Polygon", "coordinates": [[[-117.21378, 33.89051], [-117.21312, 33.89162], [-117.21163, 33.89101], [-117.21232, 33.88986], [-117.21261, 33.89002], [-117.21378, 33.89051]]]} | Open Access 1 | 15043 | Victoriano Park | 27086 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.25 | Victoriano Park | 0 | Local Park 2 | 4 | |
8911 | 8911 | 8910 | {"type": "MultiPolygon", "coordinates": [[[[-117.25065, 33.96318], [-117.25048, 33.96323], [-117.24879, 33.96134], [-117.24853, 33.96172], [-117.24839, 33.96167], [-117.24852, 33.9613], [-117.24634, 33.96131], [-117.24633, 33.96104], [-117.24874, 33.96103], [-117.25065, 33.96318]]], [[[-117.25129, 33.96387], [-117.25109, 33.96388], [-117.25065, 33.9634], [-117.25082, 33.96336], [-117.25129, 33.96387]]], [[[-117.25281, 33.9656], [-117.25279, 33.96569], [-117.25275, 33.96576], [-117.25123, 33.96404], [-117.25144, 33.96406], [-117.25281, 33.9656]]], [[[-117.25338, 33.96623], [-117.25333, 33.96631], [-117.25328, 33.96635], [-117.25288, 33.9659], [-117.25296, 33.96576], [-117.25338, 33.96623]]], [[[-117.25523, 33.96837], [-117.25508, 33.96843], [-117.25439, 33.96765], [-117.25341, 33.96652], [-117.25351, 33.96641], [-117.25523, 33.96837]]]]} | Open Access 1 | 14579 | Sunnymead Ranch Linear Park Site | 26008 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.344 | Sunnymead Ranch Linear Park Site | 0 | Local Park 2 | 4 | |
8438 | 8438 | 8437 | {"type": "MultiPolygon", "coordinates": [[[[-117.21676, 33.87927], [-117.21586, 33.87795], [-117.21494, 33.87663], [-117.21514, 33.87659], [-117.21528, 33.87655], [-117.2164, 33.87818], [-117.21673, 33.87813], [-117.21674, 33.87813], [-117.21676, 33.87826], [-117.21676, 33.87927]]], [[[-117.21737, 33.88013], [-117.21706, 33.8797], [-117.21698, 33.87969], [-117.217, 33.87965], [-117.217, 33.87958], [-117.21697, 33.87946], [-117.21696, 33.87901], [-117.21701, 33.87907], [-117.21737, 33.87907], [-117.21737, 33.88013]]], [[[-117.22183, 33.88557], [-117.22158, 33.88526], [-117.2185, 33.88162], [-117.2189, 33.88163], [-117.21965, 33.88249], [-117.22153, 33.88472], [-117.22183, 33.88474], [-117.22183, 33.88557]]], [[[-117.22605, 33.89039], [-117.22544, 33.88968], [-117.22443, 33.88853], [-117.22531, 33.88855], [-117.22531, 33.88869], [-117.22584, 33.88911], [-117.22605, 33.88911], [-117.22605, 33.89039]]], [[[-117.26297, 33.925], [-117.26293, 33.92504], [-117.26285, 33.92519], [-117.26276, 33.9252], [-117.26189, 33.92465], [-117.26244, 33.92465], [-117.26297, 33.925]]], [[[-117.2647, 33.92609], [-117.26457, 33.92628], [-117.26448, 33.92628], [-117.263, 33.92535], [-117.263, 33.92528], [-117.26311, 33.92516], [-117.2632, 33.92513], [-117.2647, 33.92609]]], [[[-117.26729, 33.92786], [-117.26683, 33.92784], [-117.26572, 33.9271], [-117.26572, 33.92708], [-117.26475, 33.92646], [-117.26476, 33.92638], [-117.26487, 33.92626], [-117.26489, 33.9262], [-117.26721, 33.92771], [-117.26729, 33.92786]]], [[[-117.26937, 33.92941], [-117.26755, 33.92824], [-117.26714, 33.92799], [-117.2677, 33.928], [-117.26936, 33.92906], [-117.26937, 33.92941]]], [[[-117.26993, 33.92942], [-117.26985, 33.9295], [-117.26962, 33.92949], [-117.26957, 33.92946], [-117.26957, 33.9292], [-117.26993, 33.92942]]]]} | Open Access 1 | 13105 | CA Aqueduct Linear Park Site | 16631 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 16.212 | CA Aqueduct Linear Park Site | 0 | Local Park 2 | 4 | |
8162 | 8162 | 8161 | {"type": "Polygon", "coordinates": [[[-117.25852, 33.97926], [-117.25646, 33.9793], [-117.25643, 33.97744], [-117.25746, 33.97774], [-117.2577, 33.9778], [-117.2581, 33.97782], [-117.25828, 33.97782], [-117.2585, 33.9778], [-117.25852, 33.97926]]]} | Open Access 1 | 12358 | Shadow Mountain Park | 25338 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 8.258 | Shadow Mtn. Park | 0 | Local Park 2 | 4 | |
7849 | 7849 | 7848 | {"type": "Polygon", "coordinates": [[[-117.16526, 33.9064], [-117.16413, 33.90667], [-117.16329, 33.90674], [-117.1629, 33.90592], [-117.16314, 33.90583], [-117.16455, 33.90547], [-117.16488, 33.90537], [-117.16526, 33.9064]]]} | Open Access 1 | 9934 | Ridge Crest Park | 24347 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 5.282 | Ridge Crest Park | 0 | Local Park 2 | 4 | |
7845 | 7845 | 7844 | {"type": "Polygon", "coordinates": [[[-117.36351, 34.00678], [-117.36336, 34.00838], [-117.362, 34.01018], [-117.35971, 34.01331], [-117.35887, 34.0143], [-117.35658, 34.01406], [-117.35175, 34.01332], [-117.35243, 34.01217], [-117.35253, 34.01193], [-117.35277, 34.01117], [-117.35321, 34.01016], [-117.35385, 34.00916], [-117.35449, 34.00853], [-117.35588, 34.0073], [-117.35792, 34.00425], [-117.35802, 34.00423], [-117.36351, 34.00678]]]} | Open Access 1 | 9734 | Reid Park | 24279 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 172.703 | Reid Park | 0 | Local Park 2 | 4 | |
6949 | 6949 | 6948 | {"type": "Polygon", "coordinates": [[[-117.27414, 33.9303], [-117.27373, 33.93047], [-117.27341, 33.93062], [-117.27307, 33.93022], [-117.27271, 33.9302], [-117.27232, 33.93041], [-117.27226, 33.93049], [-117.27225, 33.93059], [-117.27252, 33.93064], [-117.2726, 33.93064], [-117.27261, 33.93067], [-117.27257, 33.93068], [-117.27232, 33.93086], [-117.27232, 33.93088], [-117.2741, 33.93202], [-117.27379, 33.93222], [-117.27206, 33.93112], [-117.27105, 33.93222], [-117.27066, 33.93199], [-117.27036, 33.93185], [-117.27008, 33.93174], [-117.26982, 33.93166], [-117.26976, 33.93157], [-117.27001, 33.93095], [-117.2701, 33.93078], [-117.27017, 33.93054], [-117.2702, 33.93038], [-117.27022, 33.93016], [-117.27021, 33.92961], [-117.27035, 33.92969], [-117.27063, 33.92969], [-117.27071, 33.92965], [-117.27074, 33.92961], [-117.27379, 33.92959], [-117.27387, 33.92956], [-117.27394, 33.92955], [-117.27405, 33.92948], [-117.27406, 33.92991], [-117.27414, 33.9303]]]} | Open Access 1 | 5848 | Towngate Memorial Park | 26496 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 17.341 | Towngate Memorial Park | 0 | Local Park 2 | 4 | |
6932 | 6932 | 6931 | {"type": "Polygon", "coordinates": [[[-117.20878, 33.92995], [-117.20869, 33.93002], [-117.20851, 33.93004], [-117.20839, 33.93007], [-117.20832, 33.93003], [-117.20827, 33.92988], [-117.20813, 33.92963], [-117.20798, 33.92942], [-117.20768, 33.92911], [-117.2076, 33.92895], [-117.20755, 33.9288], [-117.20755, 33.92834], [-117.20759, 33.9283], [-117.20869, 33.92829], [-117.20877, 33.92837], [-117.20878, 33.92995]]]} | Open Access 1 | 5828 | Weston Park | 27415 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.152 | Weston Park | 0 | Local Park 2 | 4 | |
6888 | 6888 | 6887 | {"type": "Polygon", "coordinates": [[[-117.20187, 33.88492], [-117.2018, 33.88527], [-117.20042, 33.88512], [-117.19991, 33.88513], [-117.19955, 33.88521], [-117.19917, 33.88533], [-117.19887, 33.88551], [-117.19816, 33.88599], [-117.19788, 33.88627], [-117.19772, 33.88652], [-117.19751, 33.88627], [-117.19725, 33.8861], [-117.19692, 33.88591], [-117.19683, 33.88575], [-117.19714, 33.88561], [-117.19738, 33.88546], [-117.19799, 33.88517], [-117.19816, 33.88507], [-117.19837, 33.88486], [-117.19849, 33.88468], [-117.19859, 33.88457], [-117.19869, 33.8845], [-117.19878, 33.88446], [-117.19892, 33.88446], [-117.19919, 33.88452], [-117.1995, 33.88457], [-117.19982, 33.88459], [-117.2001, 33.88458], [-117.20077, 33.88457], [-117.20186, 33.88486], [-117.20187, 33.88492]]]} | Open Access 1 | 5626 | College Park | 17510 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 8.921 | College Park | 0 | Local Park 2 | 4 | |
6860 | 6860 | 6859 | {"type": "Polygon", "coordinates": [[[-117.2372, 33.92043], [-117.23719, 33.92081], [-117.23527, 33.92082], [-117.23514, 33.92072], [-117.23514, 33.92045], [-117.2372, 33.92043]]]} | Open Access 1 | 5494 | Bayside Park | 15896 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 1.935 | Bayside Park | 0 | Local Park 2 | 4 | |
6618 | 6618 | 6617 | {"type": "MultiPolygon", "coordinates": [[[[-117.25331, 33.91882], [-117.25309, 33.91903], [-117.25258, 33.9187], [-117.25256, 33.91835], [-117.25331, 33.91882]]], [[[-117.25764, 33.92158], [-117.25733, 33.92173], [-117.25325, 33.91913], [-117.25334, 33.91902], [-117.25347, 33.91893], [-117.25764, 33.92158]]], [[[-117.25922, 33.92258], [-117.25917, 33.92262], [-117.25839, 33.92212], [-117.25822, 33.9223], [-117.25752, 33.92185], [-117.25782, 33.9217], [-117.25882, 33.92232], [-117.25907, 33.92254], [-117.25916, 33.92258], [-117.25922, 33.92258]]]]} | Open Access 1 | 4234 | CA Aqueduct Linear Park Site | 16631 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 4.849 | CA Aqueduct Linear Park Site | 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]);