units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where MNG_AGENCY = 156 and MNG_AG_TYP = 4 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 41
- Local Recreation Area 5
- None 1
MNG_AG_TYP 1
- Recreation/Parks District · 47 ✖
MNG_AGENCY 1
- Valley-Wide Recreation and Park District · 47 ✖
ACCESS_TYP 1
- Open Access 47
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14074 | 14074 | 14073 | {"type": "Polygon", "coordinates": [[[-117.15164, 33.6899], [-117.15158, 33.69017], [-117.15137, 33.69015], [-117.1511, 33.69024], [-117.15102, 33.69011], [-117.15102, 33.69006], [-117.15117, 33.68993], [-117.15129, 33.68976], [-117.15164, 33.6899]]]} | Open Access 1 | 39111 | Desert Green | 18111 | 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 | 0.454 | Desert Green | 0 | Local Park 2 | 4 | |
14073 | 14073 | 14072 | {"type": "Polygon", "coordinates": [[[-117.14326, 33.64858], [-117.1413, 33.64859], [-117.14122, 33.64855], [-117.14121, 33.64736], [-117.14148, 33.64737], [-117.14174, 33.64742], [-117.14201, 33.64743], [-117.14202, 33.64752], [-117.14256, 33.64752], [-117.14271, 33.64761], [-117.14326, 33.64761], [-117.14326, 33.64858]]]} | Open Access 1 | 39110 | Mira Park | 22276 | 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 | 5.662 | Mira Park | 0 | Local Park 2 | 4 | |
14072 | 14072 | 14071 | {"type": "Polygon", "coordinates": [[[-117.16259, 33.65631], [-117.16258, 33.65695], [-117.16219, 33.65695], [-117.16219, 33.65684], [-117.16222, 33.65663], [-117.16219, 33.65655], [-117.16212, 33.65649], [-117.16201, 33.65647], [-117.16168, 33.65649], [-117.16168, 33.65618], [-117.16239, 33.65618], [-117.16247, 33.65627], [-117.16259, 33.65631]]]} | Open Access 1 | 39109 | Menifee South Tot Lot | 22155 | 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 | 1.114 | Menifee South Tot Lot | 0 | Local Recreation Area 3 | 4 | |
14071 | 14071 | 14070 | {"type": "Polygon", "coordinates": [[[-117.16253, 33.66383], [-117.16252, 33.66493], [-117.16247, 33.66497], [-117.16218, 33.66497], [-117.16213, 33.66493], [-117.16211, 33.66466], [-117.16205, 33.66446], [-117.16195, 33.66425], [-117.16181, 33.66408], [-117.16181, 33.66403], [-117.16204, 33.6639], [-117.1621, 33.66382], [-117.16253, 33.66383]]]} | Open Access 1 | 39108 | Autumn Breeze Park | 15715 | 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 | 1.484 | Autumn Breeze Park | 0 | Local Park 2 | 4 | |
14070 | 14070 | 14069 | {"type": "Polygon", "coordinates": [[[-117.15436, 33.65971], [-117.15425, 33.65986], [-117.15419, 33.66001], [-117.15416, 33.66016], [-117.15416, 33.66038], [-117.15407, 33.66045], [-117.15396, 33.66045], [-117.15397, 33.66005], [-117.15418, 33.65966], [-117.15431, 33.65967], [-117.15436, 33.65971]]]} | Open Access 1 | 39107 | Rolling Hills Park | 24582 | 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 | 0.378 | Rolling Hills Park | 0 | Local Park 2 | 4 | |
12142 | 12142 | 12141 | {"type": "MultiPolygon", "coordinates": [[[[-116.97389, 33.8206], [-116.97385, 33.82061], [-116.97383, 33.82076], [-116.97369, 33.82132], [-116.97296, 33.82208], [-116.97298, 33.82244], [-116.97248, 33.82236], [-116.97231, 33.82235], [-116.97213, 33.82237], [-116.97195, 33.82241], [-116.97081, 33.82281], [-116.97085, 33.82284], [-116.97079, 33.82283], [-116.96955, 33.8221], [-116.96917, 33.82185], [-116.96942, 33.82193], [-116.96943, 33.82192], [-116.96882, 33.82151], [-116.96728, 33.82063], [-116.96925, 33.81896], [-116.96925, 33.81895], [-116.96475, 33.81713], [-116.96418, 33.81688], [-116.96355, 33.81655], [-116.96625, 33.81654], [-116.97061, 33.81781], [-116.97216, 33.81651], [-116.97221, 33.81651], [-116.97236, 33.81694], [-116.97251, 33.81729], [-116.97379, 33.82002], [-116.97388, 33.82032], [-116.97389, 33.8206]]], [[[-116.97209, 33.8164], [-116.97063, 33.81762], [-116.9669, 33.81654], [-116.96703, 33.81654], [-116.96704, 33.81653], [-116.96683, 33.81645], [-116.96679, 33.81605], [-116.97207, 33.81627], [-116.97209, 33.8164]]], [[[-116.97454, 33.82302], [-116.97444, 33.82314], [-116.97395, 33.82284], [-116.97396, 33.82281], [-116.97385, 33.82274], [-116.97377, 33.82265], [-116.9737, 33.8225], [-116.97369, 33.82241], [-116.97369, 33.82231], [-116.97398, 33.82117], [-116.97439, 33.82263], [-116.97454, 33.82302]]]]} | Open Access 1 | 25115 | San Jacinto River Park | 24905 | 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 | 88.777 | San Jacinto River Park | 0 | Local Park 2 | 4 | |
11964 | 11964 | 11963 | {"type": "Polygon", "coordinates": [[[-117.0966, 33.59065], [-117.09652, 33.59071], [-117.09467, 33.59071], [-117.09467, 33.59033], [-117.09462, 33.59028], [-117.09464, 33.59021], [-117.09463, 33.59014], [-117.09458, 33.5901], [-117.09451, 33.59007], [-117.09451, 33.58973], [-117.0966, 33.58973], [-117.0966, 33.59065]]]} | Open Access 1 | 48258 | Butterfield Park | 32812 | 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/butterfield-park | Riverside 10 | 5.011 | Butterfield Park | 0 | Local Park 2 | 4 |
11842 | 11842 | 11841 | {"type": "Polygon", "coordinates": [[[-116.89525, 33.7441], [-116.89337, 33.74412], [-116.89328, 33.74405], [-116.89328, 33.74281], [-116.89515, 33.74281], [-116.89518, 33.74327], [-116.89525, 33.74369], [-116.89525, 33.7441]]]} | Open Access 1 | 48257 | Valle Vista Community Center Park | 32811 | 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/valle-vista-community-center | Riverside 10 | 6.351 | Valle Vista Community Ctr. Park | 0 | Local Recreation Area 3 | 4 |
11359 | 11359 | 11358 | {"type": "Polygon", "coordinates": [[[-116.94753, 33.77378], [-116.94645, 33.77378], [-116.94643, 33.77353], [-116.94504, 33.7735], [-116.94411, 33.77344], [-116.94409, 33.77242], [-116.94607, 33.7724], [-116.94608, 33.7727], [-116.94639, 33.77271], [-116.94641, 33.77315], [-116.94752, 33.77314], [-116.94753, 33.77378]]]} | Open Access 1 | 22144 | Rancho Park | 24162 | 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 | 7.893 | Rancho Park | 0 | Local Park 2 | 4 | |
8487 | 8487 | 8486 | {"type": "Polygon", "coordinates": [[[-116.89516, 33.73953], [-116.89482, 33.73953], [-116.89475, 33.73958], [-116.89469, 33.73967], [-116.89468, 33.73973], [-116.89469, 33.73984], [-116.89473, 33.73995], [-116.8947, 33.73996], [-116.8947, 33.7402], [-116.89484, 33.74024], [-116.89493, 33.74035], [-116.89516, 33.74035], [-116.89515, 33.74049], [-116.89326, 33.74049], [-116.89328, 33.73866], [-116.89512, 33.73866], [-116.89515, 33.73902], [-116.89516, 33.73953]]]} | Open Access 1 | 48497 | Jim Venable Exchange Club Park | 33315 | 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 | 7.857 | Jim Venable Exchange Club Park | 2019 | Local Park 2 | 4 | |
6821 | 6821 | 6820 | {"type": "Polygon", "coordinates": [[[-116.95223, 33.78381], [-116.95117, 33.78381], [-116.95116, 33.78295], [-116.95223, 33.78295], [-116.95223, 33.78381]]]} | Open Access 1 | 5395 | Mistletoe Park | 22319 | 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 | 2.338 | Mistletoe Park | 0 | Local Park 2 | 4 | |
6654 | 6654 | 6653 | {"type": "MultiPolygon", "coordinates": [[[[-117.12789, 33.61483], [-117.12781, 33.61497], [-117.12736, 33.61482], [-117.12736, 33.61462], [-117.12789, 33.61483]]], [[[-117.13261, 33.61635], [-117.13258, 33.61637], [-117.13251, 33.61627], [-117.13216, 33.61628], [-117.1318, 33.61633], [-117.13175, 33.61638], [-117.13168, 33.61636], [-117.13159, 33.61638], [-117.13157, 33.61636], [-117.13119, 33.61627], [-117.13083, 33.61626], [-117.13079, 33.61632], [-117.1307, 33.6163], [-117.13063, 33.61632], [-117.13059, 33.61628], [-117.13025, 33.61622], [-117.12986, 33.61627], [-117.12979, 33.61625], [-117.12974, 33.61624], [-117.12967, 33.61627], [-117.12963, 33.61629], [-117.12928, 33.61634], [-117.12953, 33.61752], [-117.12898, 33.61754], [-117.12897, 33.61697], [-117.1289, 33.61693], [-117.12892, 33.61686], [-117.1289, 33.6168], [-117.12884, 33.61676], [-117.1288, 33.61674], [-117.12879, 33.61611], [-117.12881, 33.61605], [-117.12874, 33.61562], [-117.12851, 33.61563], [-117.12827, 33.61563], [-117.12826, 33.61543], [-117.12832, 33.61507], [-117.12803, 33.61495], [-117.12809, 33.61483], [-117.12838, 33.61496], [-117.12852, 33.61482], [-117.12871, 33.61474], [-117.12865, 33.61447], [-117.12905, 33.6144], [-117.12911, 33.61468], [-117.12905, 33.61474], [-117.12911, 33.6149], [-117.12917, 33.61569], [-117.12942, 33.61577], [-117.12942, 33.61586], [-117.12948, 33.61593], [-117.12957, 33.61595], [-117.12965, 33.61593], [-117.1297, 33.61603], [-117.13006, 33.61602], [-117.13037, 33.61593], [-117.13041, 33.61589], [-117.13048, 33.61591], [-117.13058, 33.61591], [-117.13061, 33.61596], [-117.13097, 33.61604], [-117.13137, 33.61605], [-117.13142, 33.61598], [-117.13148, 33.616], [-117.13156, 33.616], [-117.13161, 33.6161], [-117.13235, 33.61611], [-117.13241, 33.61602], [-117.13248, 33.61604], [-117.1325, 33.61602], [-117.13261, 33.61635]]]]} | Open Access 1 | 48402 | Linear Park | 32969 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/linear-park | Riverside 10 | 7.128 | Linear Park | 0 | Local Park 2 | 4 |
6473 | 6473 | 6472 | {"type": "Polygon", "coordinates": [[[-117.08763, 33.62003], [-117.08747, 33.62042], [-117.08731, 33.62075], [-117.08708, 33.62114], [-117.08686, 33.62144], [-117.08672, 33.62146], [-117.08613, 33.6211], [-117.08582, 33.62084], [-117.08558, 33.62059], [-117.08556, 33.62054], [-117.08589, 33.62021], [-117.08615, 33.62004], [-117.08763, 33.62003]]]} | Open Access 1 | 48393 | Washington Park | 32957 | 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/washington-park | Riverside 10 | 4.752 | Washington Park | 0 | Local Park 2 | 4 |
6465 | 6465 | 6464 | {"type": "Polygon", "coordinates": [[[-117.10035, 33.59259], [-117.10035, 33.59281], [-117.09998, 33.59281], [-117.09998, 33.59259], [-117.10035, 33.59259]]]} | Open Access 1 | 48392 | Watermill Park | 32956 | 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/watermill-park | Riverside 10 | 0.202 | Watermill Park | 0 | Local Park 2 | 4 |
6464 | 6464 | 6463 | {"type": "Polygon", "coordinates": [[[-117.12524, 33.61775], [-117.1252, 33.61781], [-117.12512, 33.61779], [-117.12504, 33.61781], [-117.12498, 33.61786], [-117.12497, 33.6179], [-117.12497, 33.61797], [-117.12508, 33.61815], [-117.1251, 33.61824], [-117.1251, 33.61875], [-117.12505, 33.61879], [-117.1246, 33.61878], [-117.12428, 33.61874], [-117.12289, 33.61845], [-117.12287, 33.61838], [-117.12314, 33.61751], [-117.12319, 33.61745], [-117.12411, 33.61765], [-117.1244, 33.6177], [-117.12469, 33.61772], [-117.12524, 33.61772], [-117.12524, 33.61775]]]} | Open Access 1 | 48391 | Victory Park | 32955 | 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/victory-park | Riverside 10 | 5.574 | Victory Park | 0 | Local Park 2 | 4 |
6463 | 6463 | 6462 | {"type": "Polygon", "coordinates": [[[-117.10368, 33.56934], [-117.10349, 33.5695], [-117.10328, 33.56964], [-117.10305, 33.56976], [-117.10281, 33.56986], [-117.10252, 33.56992], [-117.10235, 33.56998], [-117.1021, 33.57001], [-117.10184, 33.57002], [-117.1018, 33.56996], [-117.10181, 33.56909], [-117.10179, 33.56869], [-117.10174, 33.5683], [-117.10162, 33.56772], [-117.10331, 33.56894], [-117.10368, 33.56934]], [[-117.10326, 33.5692], [-117.10294, 33.5694], [-117.10314, 33.56961], [-117.10345, 33.56942], [-117.10326, 33.5692]]]} | Open Access 1 | 48390 | Tucalota Park | 32954 | 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/tucalota-park | Riverside 10 | 5.998 | Tucalota Park | 0 | Local Park 2 | 4 |
6461 | 6461 | 6460 | {"type": "Polygon", "coordinates": [[[-117.12666, 33.60337], [-117.12642, 33.60338], [-117.12634, 33.60344], [-117.12614, 33.60397], [-117.12609, 33.60403], [-117.126, 33.6041], [-117.12598, 33.60425], [-117.12589, 33.60441], [-117.12586, 33.6046], [-117.1258, 33.60466], [-117.1256, 33.60452], [-117.12526, 33.60422], [-117.1251, 33.60406], [-117.1251, 33.60402], [-117.12494, 33.60384], [-117.12488, 33.60381], [-117.12481, 33.60373], [-117.12455, 33.60333], [-117.12417, 33.60257], [-117.12433, 33.60226], [-117.12621, 33.60171], [-117.12635, 33.60165], [-117.12657, 33.60158], [-117.12657, 33.6023], [-117.12666, 33.60317], [-117.12666, 33.60337]]]} | Open Access 1 | 48389 | Spencer's Crossing Sports Park | 32953 | 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/spencer-s-crossing-sports-park | Riverside 10 | 11.573 | Spencer's Crossing Sports Park | 0 | Local Recreation Area 3 | 4 |
6442 | 6442 | 6441 | {"type": "Polygon", "coordinates": [[[-117.10414, 33.59578], [-117.10314, 33.59579], [-117.10235, 33.59573], [-117.10126, 33.59573], [-117.10119, 33.59566], [-117.10119, 33.59378], [-117.10149, 33.59377], [-117.10195, 33.5938], [-117.10217, 33.59384], [-117.10258, 33.59395], [-117.10252, 33.59434], [-117.10304, 33.59459], [-117.10341, 33.59472], [-117.10368, 33.59478], [-117.10413, 33.59481], [-117.10414, 33.59578]]]} | Open Access 1 | 48387 | Sheffield Park | 32951 | 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/sheffield-park | Riverside 10 | 11.161 | Sheffield Park | 0 | Local Park 2 | 4 |
6436 | 6436 | 6435 | {"type": "Polygon", "coordinates": [[[-117.10739, 33.5618], [-117.10726, 33.56198], [-117.10691, 33.56184], [-117.10667, 33.56178], [-117.10481, 33.5615], [-117.10488, 33.56124], [-117.10476, 33.56095], [-117.10462, 33.56091], [-117.10488, 33.56061], [-117.10506, 33.56033], [-117.10522, 33.56023], [-117.10531, 33.5602], [-117.1054, 33.56019], [-117.10553, 33.56021], [-117.10561, 33.56024], [-117.10568, 33.5603], [-117.10587, 33.56056], [-117.10606, 33.56072], [-117.10616, 33.56101], [-117.10622, 33.5611], [-117.10628, 33.56116], [-117.10641, 33.56124], [-117.10653, 33.56135], [-117.10666, 33.56143], [-117.10682, 33.56148], [-117.10704, 33.56151], [-117.10715, 33.56156], [-117.10725, 33.56164], [-117.10739, 33.5618]]]} | Open Access 1 | 48386 | Rancho Bella Vista Park | 32950 | 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/rancho-bella-vista-park-and-community-center | Riverside 10 | 5.344 | Rancho Bella Vista Park | 0 | Local Park 2 | 4 |
6391 | 6391 | 6390 | {"type": "Polygon", "coordinates": [[[-117.10569, 33.59244], [-117.10566, 33.59249], [-117.10549, 33.59255], [-117.10527, 33.59259], [-117.10527, 33.59237], [-117.10566, 33.59232], [-117.10569, 33.59244]]]} | Open Access 1 | 48388 | Sicily Pocket Park | 32952 | 6123 | Brindisi Owners Association 763 | Private 7 | Home Owners Association 16 | Private 14 | 2171 | Valley-Wide Recreation and Park District 156 | Special District 4 | Recreation/Parks District 4 | https://www.gorecreation.org/sicily-pocket-park | Riverside 10 | 0.212 | Sicily PP | 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]);