units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 273 and MNG_AG_TYP = 7 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, GAP_STS
DES_TP 8
- Local Park 44
- Local Recreation Area 15
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- County Agency - Parks · 65 ✖
MNG_AGENCY 1
- Los Angeles - Department of Parks and Recreation, County of · 65 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12120 | 12120 | 12119 | {"type": "Polygon", "coordinates": [[[-117.88105, 33.97321], [-117.88105, 33.97363], [-117.88019, 33.97411], [-117.87969, 33.97351], [-117.87952, 33.97333], [-117.87924, 33.97313], [-117.87907, 33.97304], [-117.87886, 33.97296], [-117.8791, 33.97249], [-117.88026, 33.97249], [-117.88105, 33.97321]]]} | Open Access 1 | 25065 | Bill Blevins Park | 32455 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov | Los Angeles 6 | 5.317 | Bill Blevins Park | 0 | Local Park 2 | 4 |
6112 | 6112 | 6111 | {"type": "Polygon", "coordinates": [[[-117.91477, 33.97855], [-117.91474, 33.97872], [-117.91467, 33.9789], [-117.91458, 33.97906], [-117.91447, 33.9792], [-117.91429, 33.97937], [-117.91354, 33.97991], [-117.91338, 33.97973], [-117.91239, 33.97956], [-117.91121, 33.9794], [-117.9115, 33.97867], [-117.91156, 33.97822], [-117.91205, 33.97826], [-117.91261, 33.97823], [-117.91293, 33.97824], [-117.91369, 33.97831], [-117.91395, 33.97836], [-117.91442, 33.97848], [-117.91473, 33.97852], [-117.91477, 33.97855]]]} | Open Access 1 | 1063 | Gloria Heer Park | 32456 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov | Los Angeles 6 | 10.353 | Gloria Heer Park | 0 | Local Park 2 | 4 |
10265 | 10265 | 10264 | {"type": "Polygon", "coordinates": [[[-118.20365, 34.7434], [-118.20188, 34.74388], [-118.19751, 34.74446], [-118.19744, 34.74052], [-118.20145, 34.74049], [-118.20357, 34.74045], [-118.20356, 34.74107], [-118.20365, 34.7434]]]} | Open Access 1 | 17972 | Apollo Community Regional Park | 32457 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov | Los Angeles 6 | 54.281 | Apollo Community RP | 0 | Local Park 2 | 4 |
14200 | 14200 | 14199 | {"type": "Polygon", "coordinates": [[[-117.97406, 34.57248], [-117.974, 34.57419], [-117.97185, 34.57418], [-117.97192, 34.57247], [-117.97406, 34.57248]]]} | Open Access 1 | 44051 | Jackie Robinson Park | 32458 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov | Los Angeles 6 | 9.226 | Jackie Robinson Park | 0 | Local Park 2 | 4 |
5791 | 5791 | 5790 | {"type": "Polygon", "coordinates": [[[-118.41968, 34.3167], [-118.41529, 34.3206], [-118.40962, 34.31621], [-118.41066, 34.31544], [-118.41064, 34.31535], [-118.411, 34.31509], [-118.41316, 34.3157], [-118.41337, 34.31573], [-118.41355, 34.31572], [-118.4138, 34.31568], [-118.41495, 34.31527], [-118.41544, 34.31527], [-118.41571, 34.31529], [-118.41571, 34.31521], [-118.41609, 34.31522], [-118.4161, 34.31503], [-118.41592, 34.31502], [-118.41577, 34.31471], [-118.4158, 34.31462], [-118.4166, 34.31401], [-118.41968, 34.3167]]]} | Open Access 1 | 38 | El Cariso Community Regional Park | 32459 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 79.976 | El Cariso Community RP | 0 | Local Park 2 | 4 | |
3123 | 3123 | 3122 | {"type": "Polygon", "coordinates": [[[-118.41805, 34.31271], [-118.4166, 34.314], [-118.4166, 34.31401], [-118.41582, 34.3146], [-118.41577, 34.31471], [-118.41592, 34.31502], [-118.41611, 34.31503], [-118.41609, 34.31522], [-118.41572, 34.31521], [-118.41572, 34.31529], [-118.41544, 34.31527], [-118.41495, 34.31527], [-118.4138, 34.31568], [-118.41347, 34.31573], [-118.41317, 34.3157], [-118.411, 34.31509], [-118.41012, 34.31425], [-118.41031, 34.31237], [-118.41054, 34.3115], [-118.41012, 34.31103], [-118.41026, 34.31092], [-118.41148, 34.31205], [-118.41155, 34.31189], [-118.4113, 34.31165], [-118.41147, 34.31141], [-118.412, 34.31043], [-118.41191, 34.30973], [-118.41258, 34.3094], [-118.41299, 34.3091], [-118.41356, 34.30864], [-118.4136, 34.30864], [-118.41634, 34.31122], [-118.41805, 34.31271]]]} | Restricted Access 2 | 48023 | El Cariso Golf Course | 32460 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 85.199 | El Cariso GC | 0 | Local Recreation Area 3 | 4 | |
7136 | 7136 | 7135 | {"type": "Polygon", "coordinates": [[[-118.25168, 33.92627], [-118.25166, 33.92628], [-118.25155, 33.92629], [-118.24941, 33.92628], [-118.2494, 33.92627], [-118.24939, 33.92597], [-118.24941, 33.92501], [-118.25156, 33.92501], [-118.25156, 33.92543], [-118.25145, 33.92544], [-118.25168, 33.92627]]]} | Open Access 1 | 6232 | George Washington Carver Park | 32461 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 6.973 | George Washington Carver Park | 0 | Local Park 2 | 4 | |
1500 | 1500 | 1499 | {"type": "Polygon", "coordinates": [[[-117.88084, 33.98997], [-117.87854, 33.99011], [-117.87879, 33.9878], [-117.88042, 33.9879], [-117.88032, 33.98876], [-117.88034, 33.98896], [-117.88037, 33.98907], [-117.88043, 33.98918], [-117.88078, 33.98962], [-117.88084, 33.98979], [-117.88084, 33.98997]]]} | Open Access 1 | 10511 | Rowland Heights Park | 32462 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov | Los Angeles 6 | 10.174 | Rowland Heights Park | 0 | Local Park 2 | 4 |
4330 | 4330 | 4329 | {"type": "Polygon", "coordinates": [[[-118.20079, 34.47351], [-118.1974, 34.47353], [-118.19737, 34.47181], [-118.19937, 34.4718], [-118.19969, 34.47185], [-118.1999, 34.4719], [-118.20024, 34.47204], [-118.20055, 34.47224], [-118.20078, 34.47245], [-118.20079, 34.47351]]]} | Open Access 1 | 45479 | Acton Park | 32464 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Acton_Park | Los Angeles 6 | 13.925 | Acton Park | 0 | Local Park 2 | 4 |
15075 | 15075 | 15074 | {"type": "MultiPolygon", "coordinates": [[[[-118.25097, 33.92044], [-118.25063, 33.92044], [-118.24952, 33.91637], [-118.24986, 33.91637], [-118.25097, 33.92044]]], [[[-118.25181, 33.92354], [-118.25148, 33.92354], [-118.25064, 33.92046], [-118.25098, 33.92046], [-118.25181, 33.92354]]]]} | Open Access 1 | 45854 | Compton Creek Walking Path | 32466 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 6.121 | Compton Creek Walking Path | 0 | Local Recreation Area 3 | 4 | |
9757 | 9757 | 9756 | {"type": "Polygon", "coordinates": [[[-118.13253, 34.18988], [-118.13208, 34.1899], [-118.13157, 34.19001], [-118.1315, 34.18999], [-118.13147, 34.18994], [-118.13148, 34.18975], [-118.13166, 34.18963], [-118.13189, 34.1897], [-118.13207, 34.18969], [-118.13216, 34.18976], [-118.13253, 34.18988]]]} | Open Access 1 | 47869 | Altadena Triangle Park | 32467 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/altadena-triangle-park/ | Los Angeles 6 | 0.524 | Altadena Triangle Park | 0 | Local Park 2 | 4 |
14361 | 14361 | 14360 | {"type": "Polygon", "coordinates": [[[-118.06988, 33.99872], [-118.06952, 33.9999], [-118.06946, 33.99989], [-118.06895, 34.00172], [-118.06907, 33.9998], [-118.06853, 33.99908], [-118.06839, 33.99832], [-118.06841, 33.99817], [-118.06988, 33.99872]]]} | Open Access 1 | 44426 | Amigo Park | 32468 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 4.805 | Amigo Park | 0 | Local Park 2 | 4 | |
11926 | 11926 | 11925 | {"type": "Polygon", "coordinates": [[[-117.98939, 34.03587], [-117.98835, 34.03691], [-117.98681, 34.03585], [-117.98694, 34.0357], [-117.98631, 34.03527], [-117.98645, 34.03513], [-117.98709, 34.03556], [-117.98778, 34.03487], [-117.98818, 34.03514], [-117.9886, 34.03472], [-117.98924, 34.03517], [-117.98891, 34.03551], [-117.98916, 34.03568], [-117.98915, 34.0357], [-117.98939, 34.03587]]]} | Open Access 1 | 24531 | Avocado Heights Park | 32469 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 8.15 | Avocado Heights Park | 0 | Local Park 2 | 4 | |
6587 | 6587 | 6586 | {"type": "Polygon", "coordinates": [[[-118.16168, 34.03967], [-118.16012, 34.03967], [-118.16012, 34.0405], [-118.15734, 34.04052], [-118.15729, 34.03717], [-118.15935, 34.03714], [-118.15937, 34.03806], [-118.16035, 34.03843], [-118.16043, 34.03843], [-118.16044, 34.03842], [-118.16043, 34.03712], [-118.16113, 34.03713], [-118.16162, 34.03716], [-118.16166, 34.03721], [-118.16168, 34.03967]]]} | Open Access 1 | 4090 | Belvedere Community Regional Park | 32470 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/belvedere-community-regional-park/ | Los Angeles 6 | 30.749 | Belvedere Community RP | 0 | Local Park 2 | 4 |
16330 | 16330 | 16329 | {"type": "Polygon", "coordinates": [[[-118.26006, 34.22393], [-118.25962, 34.22724], [-118.25917, 34.22697], [-118.25759, 34.22581], [-118.25648, 34.22515], [-118.25322, 34.22315], [-118.25321, 34.22001], [-118.25442, 34.22075], [-118.25464, 34.22193], [-118.25522, 34.22299], [-118.25617, 34.22326], [-118.25733, 34.22376], [-118.25757, 34.22391], [-118.25784, 34.22423], [-118.25813, 34.22411], [-118.26006, 34.22393]]]} | Open Access 1 | 6830 | Crescenta Valley Community Regional Park | 32471 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Crescenta_Valley_Community_Regional_Park | Los Angeles 6 | 38.387 | Crescenta Valley Community RP | 0 | Local Park 2 | 4 |
1298 | 1298 | 1297 | {"type": "MultiPolygon", "coordinates": [[[[-118.63104, 34.48996], [-118.62998, 34.48997], [-118.63, 34.49077], [-118.6298, 34.49064], [-118.62911, 34.4906], [-118.62852, 34.49022], [-118.62868, 34.49003], [-118.62891, 34.48982], [-118.62916, 34.48964], [-118.62959, 34.48941], [-118.62992, 34.48929], [-118.62996, 34.48928], [-118.62997, 34.48932], [-118.63014, 34.48925], [-118.63046, 34.48916], [-118.63071, 34.4891], [-118.63102, 34.48905], [-118.63104, 34.48996]]], [[[-118.63006, 34.48904], [-118.63005, 34.48905], [-118.62996, 34.48909], [-118.62996, 34.48904], [-118.63006, 34.48904]]]]} | Open Access 1 | 7290 | Del Valle Park | 32472 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 5.473 | Del Valle Park | 0 | Local Park 2 | 4 | |
7393 | 7393 | 7392 | {"type": "Polygon", "coordinates": [[[-118.2177, 34.20115], [-118.21768, 34.20295], [-118.2157, 34.20324], [-118.21548, 34.20354], [-118.21333, 34.20352], [-118.21332, 34.20457], [-118.21156, 34.20393], [-118.21147, 34.20383], [-118.21132, 34.20373], [-118.20854, 34.20257], [-118.20856, 34.19793], [-118.21281, 34.19534], [-118.2146, 34.19619], [-118.21534, 34.19727], [-118.21672, 34.19778], [-118.217, 34.20047], [-118.21721, 34.20098], [-118.2177, 34.20115]]]} | Open Access 1 | 6941 | Descanso Gardens | 32473 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 149.078 | Descanso Gardens | 0 | Local Park 2 | 4 | |
15670 | 15670 | 15669 | {"type": "MultiPolygon", "coordinates": [[[[-117.82298, 34.00931], [-117.82283, 34.00935], [-117.82285, 34.00942], [-117.82262, 34.00997], [-117.82239, 34.0103], [-117.8221, 34.01066], [-117.82141, 34.01145], [-117.82045, 34.01247], [-117.81939, 34.01369], [-117.81895, 34.01423], [-117.81792, 34.01559], [-117.81716, 34.0165], [-117.81428, 34.01933], [-117.81308, 34.01781], [-117.81286, 34.0177], [-117.81479, 34.01516], [-117.81665, 34.01383], [-117.81651, 34.01257], [-117.81514, 34.01064], [-117.81561, 34.01027], [-117.81631, 34.00983], [-117.82166, 34.00683], [-117.82172, 34.00683], [-117.82176, 34.00685], [-117.82194, 34.0071], [-117.82233, 34.00774], [-117.82252, 34.00813], [-117.82274, 34.00866], [-117.82298, 34.00931]]], [[[-117.82998, 34.00371], [-117.82917, 34.00439], [-117.82774, 34.00547], [-117.82702, 34.00603], [-117.82699, 34.00606], [-117.82701, 34.00608], [-117.82489, 34.00787], [-117.82467, 34.00809], [-117.82428, 34.00843], [-117.82418, 34.00849], [-117.82414, 34.00859], [-117.82372, 34.00894], [-117.82358, 34.00893], [-117.82338, 34.00909], [-117.82333, 34.00903], [-117.82323, 34.0089], [-117.82265, 34.00767], [-117.82228, 34.00704], [-117.82203, 34.00671], [-117.82201, 34.00664], [-117.82205, 34.00659], [-117.82244, 34.00638], [-117.82264, 34.00625], [-117.82287, 34.00606], [-117.82311, 34.00581], [-117.82333, 34.00548], [-117.82391, 34.0044], [-117.82417, 34.00405], [-117.82451, 34.00371], [-117.82484, 34.00346], [-117.825, 34.00336], [-117.82538, 34.00316], [-117.82579, 34.00299], [-117.8264, 34.00283], [-117.82673, 34.00279], [-117.82725, 34.00277], [-117.82757, 34.00278], [-117.82785, 34.00282], [-117.82993, 34.00368], [-117.82998, 34.00371]]]]} | Restricted Access 2 | 7047 | Diamond Bar Golf Course | 32474 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 172.308 | Diamond Bar GC | 0 | Local Recreation Area 3 | 4 | |
16496 | 16496 | 16495 | {"type": "MultiPolygon", "coordinates": [[[[-118.25943, 33.9168], [-118.25939, 33.91821], [-118.25786, 33.9182], [-118.25785, 33.91879], [-118.25783, 33.91879], [-118.25779, 33.91871], [-118.2577, 33.91867], [-118.25747, 33.9187], [-118.25637, 33.9187], [-118.25635, 33.91868], [-118.25636, 33.91772], [-118.25639, 33.91758], [-118.2566, 33.91695], [-118.25662, 33.91684], [-118.25663, 33.91652], [-118.25665, 33.9165], [-118.25937, 33.91649], [-118.25942, 33.91654], [-118.25943, 33.9168]]], [[[-118.26507, 33.9181], [-118.26506, 33.92099], [-118.26088, 33.92099], [-118.26086, 33.92364], [-118.25652, 33.92364], [-118.25651, 33.92361], [-118.25612, 33.92361], [-118.25612, 33.92103], [-118.25635, 33.92102], [-118.25636, 33.92093], [-118.25939, 33.92093], [-118.2594, 33.92099], [-118.25955, 33.92099], [-118.25957, 33.91649], [-118.26343, 33.91649], [-118.26343, 33.9181], [-118.26507, 33.9181]]]]} | Open Access 1 | 6229 | Earvin 'Magic' Johnson Recreation Area | 32475 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | Los Angeles 6 | 102.9 | Earvin 'Magic' Johnson Rec. Area | 0 | Local Recreation Area 3 | 4 | |
7161 | 7161 | 7160 | {"type": "Polygon", "coordinates": [[[-118.17745, 34.0368], [-118.17845, 34.03652], [-118.1785, 34.03652], [-118.17853, 34.03656], [-118.17854, 34.03743], [-118.1785, 34.0376], [-118.17842, 34.03774], [-118.17779, 34.03844], [-118.17777, 34.03857], [-118.17772, 34.03859], [-118.17582, 34.0386], [-118.17582, 34.03706], [-118.17587, 34.03704], [-118.17633, 34.03704], [-118.17674, 34.03701], [-118.17745, 34.03682], [-118.17745, 34.0368]]]} | Open Access 1 | 6283 | Eugene A. Obregon Park | 32476 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Eugene_A_Obregon_Park | Los Angeles 6 | 10.912 | Eugene A. Obregon 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]);