units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 273 sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME, GAP_STS
SUID_NMA 63 ✖
- 32477 2
- 32640 2
- 32455 1
- 32456 1
- 32457 1
- 32458 1
- 32459 1
- 32460 1
- 32461 1
- 32462 1
- 32464 1
- 32466 1
- 32467 1
- 32468 1
- 32469 1
- 32470 1
- 32471 1
- 32472 1
- 32473 1
- 32474 1
- 32475 1
- 32476 1
- 32478 1
- 32479 1
- 32480 1
- 32481 1
- 32482 1
- 32483 1
- 32484 1
- 32485 1
- 32486 1
- 32487 1
- 32488 1
- 32489 1
- 32490 1
- 32491 1
- 32492 1
- 32493 1
- 32494 1
- 32495 1
- 32496 1
- 32497 1
- 32498 1
- 32499 1
- 32500 1
- 32501 1
- 32502 1
- 32614 1
- 32634 1
- 32636 1
- 32637 1
- 32666 1
- 32668 1
- 32669 1
- 32670 1
- 32682 1
- 32684 1
- 32685 1
- 32687 1
- 32689 1
- 32690 1
- 32692 1
- 32698 1
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
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15073 | 15073 | 15072 | {"type": "Polygon", "coordinates": [[[-118.18749, 33.88301], [-118.18743, 33.88376], [-118.18718, 33.88544], [-118.18669, 33.88544], [-118.18708, 33.88292], [-118.18749, 33.88301]]]} | Open Access 1 | 45852 | 72nd Street Equestrian Park | 32687 | 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/72nd-street-equestrian-park/ | Los Angeles 6 | 2.957 | 72nd Street Equestrian Park | 0 | Local Recreation Area 3 | 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 |
11447 | 11447 | 11446 | {"type": "Polygon", "coordinates": [[[-117.92427, 33.98937], [-117.92229, 33.98922], [-117.92235, 33.98879], [-117.92237, 33.98878], [-117.9235, 33.98886], [-117.92365, 33.98889], [-117.92386, 33.98897], [-117.92404, 33.98909], [-117.92417, 33.98922], [-117.92427, 33.98937]]]} | Open Access 1 | 48140 | Albatross Road Rest Area | 32670 | 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/albatross-road-rest-area/ | Los Angeles 6 | 1.94 | Albatross Road Rest Area | None 1016 | ||
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 | |
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 |
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 |
14995 | 14995 | 14994 | {"type": "Polygon", "coordinates": [[[-117.92523, 34.60934], [-117.92517, 34.61656], [-117.91631, 34.61658], [-117.91639, 34.60934], [-117.92523, 34.60934]]]} | Open Access 1 | 45642 | Big Rock Wash Wildlife Sanctuary | 32685 | 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/big-rock-wash-wildlife-sanctuary/ | Los Angeles 6 | 160.845 | Big Rock Wash Wildlife Sanctuary | 0 | Local Conservation Area 4 | 2 |
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 |
15041 | 15041 | 15040 | {"type": "Polygon", "coordinates": [[[-117.79158, 34.70472], [-117.79153, 34.70476], [-117.77431, 34.7053], [-117.77425, 34.70526], [-117.77425, 34.69802], [-117.78289, 34.69778], [-117.78289, 34.69592], [-117.7873, 34.6958], [-117.78731, 34.69468], [-117.78841, 34.69465], [-117.78842, 34.69539], [-117.78952, 34.69536], [-117.78952, 34.69759], [-117.79156, 34.69753], [-117.79158, 34.70472]]]} | Open Access 1 | 45703 | Butte Valley Wildflower Sanctuary | 32690 | 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/butte-valley-wildflower-sanctuary/ | Los Angeles 6 | 350.624 | Butte Valley Wildflower Sanctuary | None 1300 | ||
4255 | 4255 | 4254 | {"type": "Polygon", "coordinates": [[[-117.90325, 33.97998], [-117.90158, 33.98014], [-117.90166, 33.97993], [-117.90157, 33.97938], [-117.90144, 33.97842], [-117.90299, 33.97827], [-117.90325, 33.97998]]]} | Open Access 1 | 14365 | Carolyn Rosas Park | 32479 | 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.897 | Carolyn Rosas 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 | |
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 |
7110 | 7110 | 7109 | {"type": "Polygon", "coordinates": [[[-118.37652, 33.91718], [-118.37652, 33.91844], [-118.37531, 33.91844], [-118.37531, 33.9191], [-118.37445, 33.9191], [-118.37445, 33.91718], [-118.37652, 33.91718]]]} | Open Access 1 | 6186 | Del Aire Park | 32481 | 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.059 | Del Aire Park | 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 | |
16339 | 16339 | 16338 | {"type": "Polygon", "coordinates": [[[-118.06336, 33.8503], [-118.0633, 33.85031], [-118.06335, 33.85328], [-118.06326, 33.85335], [-118.05934, 33.85338], [-118.05904, 33.85334], [-118.05875, 33.85324], [-118.05855, 33.85311], [-118.05843, 33.853], [-118.05832, 33.85285], [-118.05823, 33.85266], [-118.05818, 33.85242], [-118.05816, 33.8514], [-118.05811, 33.85119], [-118.05803, 33.85098], [-118.05782, 33.85073], [-118.05764, 33.85059], [-118.05741, 33.85046], [-118.05714, 33.85036], [-118.05687, 33.85032], [-118.05662, 33.85031], [-118.05635, 33.85035], [-118.05612, 33.85042], [-118.05592, 33.85051], [-118.05574, 33.85063], [-118.05557, 33.85078], [-118.0554, 33.85099], [-118.05525, 33.85111], [-118.05512, 33.85118], [-118.05499, 33.85122], [-118.05475, 33.85125], [-118.05475, 33.85123], [-118.05491, 33.85112], [-118.05501, 33.85093], [-118.05543, 33.85064], [-118.05572, 33.85041], [-118.05607, 33.85008], [-118.05631, 33.84983], [-118.05658, 33.84949], [-118.05747, 33.84819], [-118.05826, 33.84819], [-118.05834, 33.84982], [-118.0591, 33.84981], [-118.05911, 33.84985], [-118.06336, 33.84982], [-118.06336, 33.8503]]]} | Open Access 1 | 15250 | Don Knabe Community Regional Park | 32684 | 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/don-knabe-community-regional-park/ | Los Angeles 6 | 55.828 | Don Knabe Community RP | 0 | Local Park 2 | 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 |
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]);