units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
65 rows where MNG_AGENCY = 273 sorted by YR_EST
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, PARK_URL, LABEL_NAME, 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
AGNCY_TYP 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3251 | 3251 | 3250 | {"type": "Polygon", "coordinates": [[[-118.29179, 33.95328], [-118.2918, 33.95365], [-118.29183, 33.9538], [-118.29183, 33.9539], [-118.29183, 33.95646], [-118.29181, 33.95682], [-118.29178, 33.957], [-118.29171, 33.95701], [-118.29167, 33.95699], [-118.29163, 33.95683], [-118.29164, 33.95301], [-118.29179, 33.95328]]]} | Open Access 1 | 48155 | Vermont Median | 32692 | 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/vermont-median/ | Los Angeles 6 | 1.804 | Vermont Median | None 267 | ||
4300 | 4300 | 4299 | {"type": "Polygon", "coordinates": [[[-118.65766, 34.07478], [-118.65661, 34.07478], [-118.65657, 34.07158], [-118.65675, 34.0718], [-118.65699, 34.072], [-118.65748, 34.07234], [-118.65765, 34.0724], [-118.65766, 34.07478]]]} | No Public Access 3 | 48151 | Saddle Peak | 32682 | 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 | 7.314 | Saddle Peak | None 378 | |||
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 | ||
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 | ||
16545 | 16545 | 16544 | {"type": "Polygon", "coordinates": [[[-118.47215, 34.37798], [-118.4698, 34.37797], [-118.46941, 34.37814], [-118.46787, 34.37869], [-118.46751, 34.37884], [-118.46721, 34.37901], [-118.46691, 34.37922], [-118.46662, 34.37947], [-118.46656, 34.37798], [-118.45784, 34.37806], [-118.44845, 34.37819], [-118.44591, 34.37819], [-118.44558, 34.37818], [-118.44434, 34.3781], [-118.44193, 34.37808], [-118.44195, 34.37454], [-118.43979, 34.37452], [-118.43984, 34.37077], [-118.43763, 34.37076], [-118.43768, 34.36702], [-118.44865, 34.36697], [-118.44855, 34.37077], [-118.44637, 34.37078], [-118.44628, 34.37455], [-118.44846, 34.37457], [-118.44846, 34.37502], [-118.44954, 34.37498], [-118.4508, 34.3763], [-118.45314, 34.37623], [-118.45315, 34.37668], [-118.45553, 34.37708], [-118.46218, 34.3768], [-118.46217, 34.37599], [-118.46648, 34.37589], [-118.46642, 34.37381], [-118.47113, 34.37386], [-118.47116, 34.37591], [-118.47212, 34.37593], [-118.47213, 34.37611], [-118.47187, 34.37622], [-118.4716, 34.37638], [-118.47142, 34.37651], [-118.47129, 34.37664], [-118.47121, 34.37659], [-118.47117, 34.37662], [-118.47118, 34.37709], [-118.47119, 34.37709], [-118.4715, 34.37681], [-118.47143, 34.37674], [-118.47158, 34.37661], [-118.47194, 34.37638], [-118.47213, 34.37629], [-118.47215, 34.37798]]]} | Open Access 1 | 12567 | Placerita Canyon State Park | 32485 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 381 | Los Angeles - Department of Parks and Recreation, County of 273 | County 3 | County Agency - Parks 7 | http://www.parks.ca.gov/?page_id=622 | Los Angeles 6 | 359.799 | Placerita Canyon SP | None 1412 | ||
881 | 881 | 880 | {"type": "MultiPolygon", "coordinates": [[[[-118.36105, 33.98786], [-118.35981, 33.98824], [-118.35975, 33.98824], [-118.3597, 33.98821], [-118.35964, 33.9879], [-118.35959, 33.98773], [-118.35831, 33.98481], [-118.35827, 33.98459], [-118.35827, 33.98439], [-118.35831, 33.98418], [-118.35836, 33.98403], [-118.35839, 33.98399], [-118.35847, 33.98397], [-118.35977, 33.98425], [-118.35986, 33.98504], [-118.35999, 33.98544], [-118.36105, 33.98786]]], [[[-118.35973, 33.98401], [-118.35883, 33.98382], [-118.35904, 33.98312], [-118.35965, 33.98323], [-118.35973, 33.98401]]]]} | Open Access 1 | 6296 | Ladera Park | 32637 | 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/Ladera_Park | Los Angeles 6 | 15.808 | Ladera Park | 0 | Local Park 2 | 4 |
1102 | 1102 | 1101 | {"type": "Polygon", "coordinates": [[[-117.9216, 34.03221], [-117.92061, 34.0323], [-117.92052, 34.03227], [-117.92007, 34.03231], [-117.91957, 34.03233], [-117.91955, 34.03229], [-117.91964, 34.0311], [-117.91978, 34.03062], [-117.91984, 34.03031], [-117.9202, 34.03031], [-117.92158, 34.03021], [-117.92152, 34.03167], [-117.9216, 34.03221]]]} | Open Access 1 | 7055 | Rimgrove Park | 32498 | 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 | 9.626 | Rimgrove Park | 0 | Local Park 2 | 4 | |
1142 | 1142 | 1141 | {"type": "MultiPolygon", "coordinates": [[[[-118.15899, 34.20112], [-118.15798, 34.20099], [-118.15803, 34.20185], [-118.15593, 34.20201], [-118.15628, 34.20126], [-118.15588, 34.20113], [-118.15642, 34.19994], [-118.15896, 34.20076], [-118.15899, 34.20112]]], [[[-118.1575, 34.20252], [-118.15539, 34.20268], [-118.15534, 34.20222], [-118.15742, 34.20206], [-118.15745, 34.2021], [-118.1575, 34.20252]]], [[[-118.15918, 34.20422], [-118.1569, 34.20411], [-118.15721, 34.20392], [-118.15738, 34.20379], [-118.15741, 34.20376], [-118.15741, 34.20374], [-118.15755, 34.20359], [-118.15768, 34.20337], [-118.15774, 34.20316], [-118.15776, 34.20299], [-118.15766, 34.20208], [-118.15768, 34.20204], [-118.15909, 34.20194], [-118.15918, 34.20422]]]]} | Open Access 1 | 6712 | Loma Alta Park | 32482 | 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 | 20.497 | Loma Alta 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 | |
1318 | 1318 | 1317 | {"type": "Polygon", "coordinates": [[[-118.19118, 34.02197], [-118.19118, 34.02211], [-118.19106, 34.02258], [-118.19107, 34.02339], [-118.19103, 34.0234], [-118.19104, 34.02342], [-118.19107, 34.02342], [-118.19107, 34.02376], [-118.19106, 34.02379], [-118.19101, 34.02381], [-118.1894, 34.02381], [-118.18936, 34.0238], [-118.18935, 34.02377], [-118.18934, 34.02201], [-118.19019, 34.02199], [-118.19018, 34.02203], [-118.19012, 34.02208], [-118.19011, 34.02214], [-118.19014, 34.0222], [-118.19022, 34.02222], [-118.19028, 34.02221], [-118.19032, 34.02217], [-118.19033, 34.02199], [-118.19118, 34.02197]]]} | Open Access 1 | 10714 | Ruben F. Salazar Park | 32499 | 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 | 7.928 | Ruben F. Salazar 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 |
2419 | 2419 | 2418 | {"type": "Polygon", "coordinates": [[[-118.19323, 33.89597], [-118.19317, 33.89601], [-118.19241, 33.89603], [-118.19236, 33.896], [-118.19235, 33.89575], [-118.19232, 33.8957], [-118.19227, 33.89498], [-118.19219, 33.89361], [-118.19265, 33.8936], [-118.19265, 33.89352], [-118.19306, 33.89352], [-118.19315, 33.89475], [-118.19323, 33.89597]]]} | Open Access 1 | 6260 | East Rancho Dominguez Park | 32484 | 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.518 | East Rancho Dominguez Park | 0 | Local Park 2 | 4 | |
3106 | 3106 | 3105 | {"type": "Polygon", "coordinates": [[[-118.06276, 33.9794], [-118.06276, 33.97946], [-118.06244, 33.97978], [-118.0624, 33.97979], [-118.06229, 33.9799], [-118.06229, 33.97994], [-118.06156, 33.98068], [-118.06148, 33.98069], [-118.05955, 33.97935], [-118.06083, 33.97806], [-118.06276, 33.9794]]]} | Open Access 1 | 12858 | Sorensen Park | 32486 | 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 | 10.894 | Sorensen Park | 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 | |
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 | |
4302 | 4302 | 4301 | {"type": "Polygon", "coordinates": [[[-118.1262, 34.18898], [-118.12621, 34.18904], [-118.12603, 34.18933], [-118.12602, 34.18935], [-118.12595, 34.18934], [-118.12593, 34.18924], [-118.12595, 34.18897], [-118.12609, 34.18896], [-118.1262, 34.18898]]]} | Open Access 1 | 48153 | Ganesha Park | 32689 | 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 | 0.181 | Ganesha 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 |
4893 | 4893 | 4892 | {"type": "Polygon", "coordinates": [[[-118.16594, 33.93752], [-118.16221, 33.93558], [-118.16115, 33.93702], [-118.16153, 33.93723], [-118.16126, 33.93762], [-118.165, 33.9395], [-118.16218, 33.94234], [-118.16209, 33.94232], [-118.15913, 33.94078], [-118.16046, 33.93896], [-118.15653, 33.93691], [-118.15822, 33.93461], [-118.15991, 33.93242], [-118.16013, 33.93217], [-118.16097, 33.93257], [-118.16356, 33.93388], [-118.16407, 33.93321], [-118.16436, 33.9333], [-118.16477, 33.93321], [-118.16508, 33.93298], [-118.16609, 33.93537], [-118.16594, 33.93752]]]} | Restricted Access 2 | 45855 | Los Amigos Golf Course | 32491 | 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/!ut/p/b0/04_Sj9CPykssy0xPLMnMz0vMAfGjzOLdDAwM3P2dgo0MggwcDTxdQl3MnI3D3ANNDPULsh0VAQpfACU!/ | Los Angeles 6 | 120.886 | Los Amigos GC | 0 | Local Recreation Area 3 | 4 |
5764 | 5764 | 5763 | {"type": "Polygon", "coordinates": [[[-118.31393, 33.94717], [-118.31391, 33.94733], [-118.31392, 33.949], [-118.31321, 33.949], [-118.3132, 33.94905], [-118.31299, 33.94906], [-118.31298, 33.949], [-118.31178, 33.94901], [-118.31177, 33.94775], [-118.31161, 33.94728], [-118.3116, 33.94704], [-118.3124, 33.94704], [-118.31241, 33.94717], [-118.3133, 33.94717], [-118.31329, 33.94588], [-118.31393, 33.94588], [-118.31393, 33.94717]]]} | Restricted Access 2 | 6211 | Maggie Hathaway Golf Course | 32489 | 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 | 12.466 | Maggie Hathaway GC | 0 | Local Recreation Area 3 | 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 |
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]);