units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where ACCESS_TYP = 3, COUNTY = 6, DES_TP = 3 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
Suggested facets: SUID_NMA, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID
MNG_AGENCY 6
MNG_AG_TYP 3
DES_TP 1
- Local Recreation Area · 48 ✖
ACCESS_TYP 1
- No Public Access · 48 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1410 | 1410 | 1409 | {"type": "Polygon", "coordinates": [[[-118.22677, 34.25192], [-118.22147, 34.25178], [-118.21696, 34.25173], [-118.21705, 34.24813], [-118.22159, 34.24846], [-118.22162, 34.24484], [-118.22168, 34.24273], [-118.22273, 34.24274], [-118.22322, 34.24194], [-118.22394, 34.24193], [-118.22353, 34.24295], [-118.22307, 34.24366], [-118.22309, 34.24373], [-118.22331, 34.24422], [-118.2239, 34.24472], [-118.22419, 34.24556], [-118.22416, 34.24562], [-118.22416, 34.24572], [-118.22422, 34.24582], [-118.22435, 34.24591], [-118.2245, 34.24592], [-118.22486, 34.24607], [-118.22514, 34.24612], [-118.22528, 34.24618], [-118.22546, 34.24632], [-118.22551, 34.24641], [-118.22555, 34.24651], [-118.22555, 34.24667], [-118.22531, 34.24754], [-118.22529, 34.24766], [-118.2253, 34.24776], [-118.22533, 34.24792], [-118.22539, 34.24805], [-118.22551, 34.24825], [-118.22539, 34.24843], [-118.22556, 34.24872], [-118.22597, 34.24856], [-118.22597, 34.25048], [-118.22621, 34.25075], [-118.22637, 34.251], [-118.22652, 34.2513], [-118.22672, 34.25162], [-118.22677, 34.25192]]]} | No Public Access 3 | 12350 | La Canada Irrigation District Open Space | 20744 | 2055 | La Canada Irrigation District 363 | Special District 4 | Irrigation District 17 | http://lacanadairrigation.org/ | Special District 4 | 2055 | La Canada Irrigation District 359 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 120.857 | La Canada Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
1629 | 1629 | 1628 | {"type": "Polygon", "coordinates": [[[-118.63073, 34.13978], [-118.63062, 34.1398], [-118.63058, 34.13967], [-118.63066, 34.13966], [-118.63073, 34.13978]]]} | No Public Access 3 | 12421 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.034 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
1702 | 1702 | 1701 | {"type": "MultiPolygon", "coordinates": [[[[-118.10957, 33.99118], [-118.10841, 33.99393], [-118.10812, 33.99414], [-118.10776, 33.99428], [-118.10723, 33.99468], [-118.1056, 33.99616], [-118.1049, 33.99713], [-118.10463, 33.99726], [-118.10446, 33.99744], [-118.10439, 33.99781], [-118.104, 33.99834], [-118.10373, 33.99899], [-118.1034, 33.99955], [-118.09727, 34.00134], [-118.09715, 34.00171], [-118.09154, 33.99932], [-118.09273, 33.99735], [-118.09448, 33.99594], [-118.09703, 33.99726], [-118.09734, 33.99688], [-118.09773, 33.99673], [-118.09793, 33.99653], [-118.10047, 33.99561], [-118.10232, 33.9928], [-118.10204, 33.99241], [-118.10691, 33.99146], [-118.10957, 33.99118]]], [[[-118.10991, 33.9911], [-118.1069, 33.99141], [-118.102, 33.99238], [-118.10139, 33.99156], [-118.10665, 33.98858], [-118.10706, 33.9888], [-118.10745, 33.98908], [-118.10935, 33.99074], [-118.10962, 33.99093], [-118.10991, 33.9911]]]]} | No Public Access 3 | 6693 | Rio Hondo & Bike Trail | 24380 | 2272 | Los Angeles County Flood Control District 287 | Special District 4 | Flood District 8 | http://dpw.lacounty.gov/lacfcd/ | Special District 4 | 2272 | Los Angeles County Flood Control District 284 | Special District 4 | Flood District 9 | Los Angeles 6 | 234.812 | Rio Hondo & Bike Trail | 0 | Local Recreation Area 3 | 4 | |
2014 | 2014 | 2013 | {"type": "MultiPolygon", "coordinates": [[[[-118.65797, 34.15108], [-118.65776, 34.15113], [-118.65762, 34.15114], [-118.65756, 34.15098], [-118.65791, 34.15089], [-118.65797, 34.15108]]], [[[-118.65916, 34.15322], [-118.65899, 34.15369], [-118.65869, 34.15384], [-118.65822, 34.15383], [-118.65821, 34.15311], [-118.6587, 34.15288], [-118.65916, 34.15322]]]]} | No Public Access 3 | 12419 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 1.898 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
2066 | 2066 | 2065 | {"type": "Polygon", "coordinates": [[[-118.67437, 34.13917], [-118.67424, 34.13936], [-118.67408, 34.13928], [-118.67422, 34.13909], [-118.67437, 34.13917]]]} | No Public Access 3 | 12422 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.103 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
2606 | 2606 | 2605 | {"type": "MultiPolygon", "coordinates": [[[[-118.65203, 34.0785], [-118.65188, 34.07884], [-118.65156, 34.07893], [-118.65122, 34.07868], [-118.65139, 34.07845], [-118.65163, 34.07837], [-118.65203, 34.0785]]], [[[-118.68181, 34.15509], [-118.68163, 34.15516], [-118.68156, 34.155], [-118.68174, 34.15494], [-118.68181, 34.15509]]]]} | No Public Access 3 | 12427 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.817 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
3551 | 3551 | 3550 | {"type": "Polygon", "coordinates": [[[-117.98918, 34.51959], [-117.98917, 34.52033], [-117.98818, 34.52034], [-117.98817, 34.51959], [-117.98918, 34.51959]]]} | No Public Access 3 | 12453 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 1.865 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
5391 | 5391 | 5390 | {"type": "MultiPolygon", "coordinates": [[[[-118.66507, 34.15839], [-118.66506, 34.15847], [-118.66487, 34.15842], [-118.66489, 34.15835], [-118.66507, 34.15839]]], [[[-118.85833, 34.10443], [-118.85824, 34.10458], [-118.85822, 34.10467], [-118.85819, 34.10505], [-118.85775, 34.10504], [-118.85751, 34.10457], [-118.85765, 34.10434], [-118.85779, 34.10439], [-118.85801, 34.10443], [-118.85833, 34.10443]]]]} | No Public Access 3 | 12428 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 1.035 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
5505 | 5505 | 5504 | {"type": "MultiPolygon", "coordinates": [[[[-118.66773, 34.17325], [-118.66736, 34.17323], [-118.66731, 34.17311], [-118.66769, 34.17301], [-118.66773, 34.17316], [-118.66773, 34.17325]]], [[[-118.70599, 34.16395], [-118.70581, 34.16401], [-118.70578, 34.16393], [-118.70589, 34.16376], [-118.70595, 34.16381], [-118.70594, 34.16384], [-118.70599, 34.16395]]]]} | No Public Access 3 | 12408 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.26 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
5568 | 5568 | 5567 | {"type": "Polygon", "coordinates": [[[-117.98819, 34.51876], [-117.98807, 34.51874], [-117.98806, 34.51756], [-117.98818, 34.51757], [-117.98819, 34.51876]]]} | No Public Access 3 | 12452 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.356 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
6982 | 6982 | 6981 | {"type": "MultiPolygon", "coordinates": [[[[-118.31938, 33.77027], [-118.31935, 33.77028], [-118.31914, 33.77032], [-118.31909, 33.77036], [-118.31907, 33.77043], [-118.31903, 33.77046], [-118.31865, 33.77054], [-118.31831, 33.77074], [-118.31831, 33.77026], [-118.31938, 33.77027]]], [[[-118.32632, 33.77272], [-118.3254, 33.77314], [-118.32507, 33.77327], [-118.32482, 33.77335], [-118.32046, 33.77449], [-118.32015, 33.77368], [-118.31841, 33.7731], [-118.31841, 33.77242], [-118.31838, 33.7724], [-118.31838, 33.77139], [-118.31843, 33.77138], [-118.31843, 33.77072], [-118.31867, 33.77057], [-118.31905, 33.77049], [-118.31911, 33.77044], [-118.31912, 33.7704], [-118.31915, 33.77036], [-118.31937, 33.77032], [-118.31941, 33.77029], [-118.31943, 33.77026], [-118.32399, 33.77026], [-118.32422, 33.77048], [-118.32453, 33.77071], [-118.32556, 33.7714], [-118.32574, 33.77154], [-118.32591, 33.77172], [-118.32611, 33.77201], [-118.32619, 33.77216], [-118.32629, 33.77248], [-118.32632, 33.77272]]]]} | No Public Access 3 | 5905 | Palos Verdes Reservoir | 23373 | 2078 | Metropolitan Water District of Southern California 413 | Special District 4 | Water District 13 | http://www.mwdh2o.com/ | Special District 4 | 2078 | Metropolitan Water District of Southern California 407 | Special District 4 | Water District 13 | Los Angeles 6 | 62.667 | Palos Verdes Reservoir | 0 | Local Recreation Area 3 | 4 | |
7256 | 7256 | 7255 | {"type": "Polygon", "coordinates": [[[-118.65889, 34.09126], [-118.65889, 34.09173], [-118.6584, 34.09174], [-118.65839, 34.09126], [-118.65889, 34.09126]]]} | No Public Access 3 | 6445 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 0.59 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
7701 | 7701 | 7700 | {"type": "Polygon", "coordinates": [[[-118.71132, 34.10934], [-118.71126, 34.10965], [-118.71107, 34.11041], [-118.71108, 34.11058], [-118.70847, 34.11717], [-118.70838, 34.1174], [-118.70657, 34.12441], [-118.70645, 34.12478], [-118.70624, 34.12516], [-118.70603, 34.12543], [-118.70587, 34.1256], [-118.70552, 34.12589], [-118.70475, 34.12641], [-118.7044, 34.12672], [-118.70419, 34.12678], [-118.70412, 34.12704], [-118.70385, 34.12739], [-118.70373, 34.12763], [-118.70368, 34.12777], [-118.70359, 34.12817], [-118.7035, 34.12903], [-118.70357, 34.12904], [-118.70339, 34.13084], [-118.70331, 34.13084], [-118.7031, 34.13266], [-118.70316, 34.13267], [-118.70299, 34.13344], [-118.70261, 34.13343], [-118.70237, 34.13353], [-118.70221, 34.13372], [-118.70211, 34.13395], [-118.70207, 34.13416], [-118.70198, 34.1343], [-118.70197, 34.13438], [-118.70199, 34.13442], [-118.70232, 34.13449], [-118.70245, 34.13444], [-118.70254, 34.1346], [-118.70253, 34.13472], [-118.70246, 34.13481], [-118.70242, 34.13503], [-118.70263, 34.13507], [-118.70257, 34.13538], [-118.70243, 34.13572], [-118.7023, 34.13598], [-118.70208, 34.13647], [-118.70191, 34.13675], [-118.70187, 34.13682], [-118.6992, 34.13682], [-118.69879, 34.13703], [-118.69803, 34.13714], [-118.69363, 34.13714], [-118.69359, 34.1309], [-118.68924, 34.13091], [-118.68922, 34.12902], [-118.69358, 34.12908], [-118.69797, 34.12906], [-118.69797, 34.12762], [-118.69688, 34.12761], [-118.69682, 34.12542], [-118.68939, 34.12542], [-118.68938, 34.1236], [-118.69137, 34.1236], [-118.69136, 34.12176], [-118.69354, 34.12176], [-118.69351, 34.11812], [-118.69795, 34.11812], [-118.69795, 34.11629], [-118.70448, 34.11629], [-118.70447, 34.11447], [-118.70671, 34.11447], [-118.70668, 34.11082], [-118.70768, 34.11083], [-118.7077, 34.11069], [-118.70916, 34.10902], [-118.71132, 34.10934]]]} | No Public Access 3 | 12403 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 667.757 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
7716 | 7716 | 7715 | {"type": "MultiPolygon", "coordinates": [[[[-118.63818, 34.15701], [-118.63803, 34.15709], [-118.63794, 34.15698], [-118.63809, 34.1569], [-118.63818, 34.15701]]], [[[-118.65947, 34.13273], [-118.65873, 34.13273], [-118.65873, 34.13191], [-118.65947, 34.13191], [-118.65947, 34.13273]]]]} | No Public Access 3 | 12404 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 1.61 | Las Virgenes Municipal Water District OS | 0 | Local Recreation Area 3 | 4 | |
7806 | 7806 | 7805 | {"type": "Polygon", "coordinates": [[[-118.08938, 34.16909], [-118.08897, 34.16934], [-118.08889, 34.16941], [-118.08876, 34.16917], [-118.08927, 34.16897], [-118.08938, 34.16909]]]} | No Public Access 3 | 12343 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.297 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
7827 | 7827 | 7826 | {"type": "Polygon", "coordinates": [[[-117.97928, 34.51891], [-117.97908, 34.51905], [-117.97879, 34.51923], [-117.97862, 34.51929], [-117.97826, 34.51953], [-117.97804, 34.51962], [-117.97781, 34.51968], [-117.97733, 34.51992], [-117.97708, 34.51998], [-117.97707, 34.51981], [-117.97662, 34.5198], [-117.97662, 34.52021], [-117.97538, 34.5207], [-117.97538, 34.52106], [-117.97504, 34.52106], [-117.97505, 34.52051], [-117.97508, 34.5205], [-117.97507, 34.52017], [-117.97516, 34.51847], [-117.97592, 34.5181], [-117.97708, 34.51764], [-117.97708, 34.51974], [-117.97726, 34.51971], [-117.97739, 34.51962], [-117.9777, 34.51949], [-117.97794, 34.51942], [-117.9781, 34.51934], [-117.97834, 34.51917], [-117.97866, 34.51903], [-117.97892, 34.51888], [-117.97927, 34.5186], [-117.97928, 34.51891]]]} | No Public Access 3 | 12441 | Littlerock Creek Irrigation District Open Space | 21360 | 2061 | Littlerock Creek Irrigation District 659 | Special District 4 | Irrigation District 17 | http://www.lrcid.com/ | Special District 4 | 2061 | Littlerock Creek Irrigation District 646 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 13.15 | Littlerock Creek Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
8151 | 8151 | 8150 | {"type": "Polygon", "coordinates": [[[-118.08762, 34.17103], [-118.08718, 34.17144], [-118.08687, 34.17134], [-118.08698, 34.1711], [-118.08685, 34.17111], [-118.08712, 34.17061], [-118.08762, 34.17103]]]} | No Public Access 3 | 12341 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.868 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
8152 | 8152 | 8151 | {"type": "Polygon", "coordinates": [[[-118.08668, 34.18493], [-118.08668, 34.18564], [-118.08613, 34.18563], [-118.08613, 34.18492], [-118.08668, 34.18493]]]} | No Public Access 3 | 12342 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.996 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
8153 | 8153 | 8152 | {"type": "Polygon", "coordinates": [[[-118.08451, 34.18147], [-118.08446, 34.18154], [-118.08433, 34.18161], [-118.08405, 34.18134], [-118.08424, 34.18129], [-118.08446, 34.18139], [-118.08451, 34.18147]]]} | No Public Access 3 | 12344 | Kinneloa Irrigation District Open Space | 20674 | 2054 | Kinneloa Irrigation District 320 | Special District 4 | Irrigation District 17 | http://www.kinneloairrigationdistrict.info/ | Special District 4 | 2054 | Kinneloa Irrigation District 317 | Special District 4 | Irrigation District 16 | Los Angeles 6 | 0.194 | Kinneloa Irrigation District OS | 0 | Local Recreation Area 3 | 4 | |
8284 | 8284 | 8283 | {"type": "MultiPolygon", "coordinates": [[[[-118.84108, 34.10194], [-118.84103, 34.10198], [-118.84096, 34.10191], [-118.84089, 34.10182], [-118.84087, 34.10175], [-118.84081, 34.10139], [-118.84077, 34.10126], [-118.84039, 34.10074], [-118.8404, 34.10073], [-118.84045, 34.10071], [-118.84083, 34.10124], [-118.84089, 34.10141], [-118.84094, 34.10175], [-118.841, 34.10186], [-118.84108, 34.10194]]], [[[-118.84241, 34.10312], [-118.84223, 34.10331], [-118.84192, 34.10338], [-118.84154, 34.10307], [-118.84148, 34.1027], [-118.84155, 34.10264], [-118.84174, 34.1026], [-118.84202, 34.10282], [-118.84236, 34.10286], [-118.84241, 34.10312]]]]} | No Public Access 3 | 12406 | Las Virgenes Municipal Water District Open Space | 21072 | 2059 | Las Virgenes Municipal Water District 398 | Special District 4 | Water District 13 | http://www.lvmwd.com/ | Special District 4 | 2059 | Las Virgenes Municipal Water District 392 | Special District 4 | Water District 13 | Los Angeles 6 | 1.412 | Las Virgenes Municipal Water District OS | 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]);