units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
148 rows where MNG_AGENCY = 294 sorted by AGNCY_NAME
This data as json, copyable, CSV (advanced)
DES_TP 21
- Local Park 86
- Local Recreation Area 20
- Local Historic or Cultural Area 3
- Local Conservation Area 2
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 128
MNG_AGENCY 1
- Long Beach, City of · 128 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1134 | 1134 | 1133 | {"type": "Polygon", "coordinates": [[[-118.22322, 33.79713], [-118.2227, 33.79832], [-118.22143, 33.79833], [-118.22142, 33.79884], [-118.21988, 33.79884], [-118.21988, 33.7972], [-118.22031, 33.7972], [-118.22032, 33.79714], [-118.22322, 33.79713]]]} | Open Access 1 | 6632 | Hudson Park | 20134 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 11.236 | Hudson Park | 0 | Local Park 2 | 4 | |
1135 | 1135 | 1134 | {"type": "Polygon", "coordinates": [[[-118.16446, 33.76279], [-118.1643, 33.76333], [-118.15256, 33.76088], [-118.15255, 33.76085], [-118.15103, 33.76079], [-118.15064, 33.7607], [-118.15091, 33.75983], [-118.15284, 33.76035], [-118.15644, 33.76123], [-118.1582, 33.76158], [-118.15995, 33.76196], [-118.16349, 33.76263], [-118.16446, 33.76279]]]} | Open Access 1 | 6644 | Bluff Park | 16198 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 18.611 | Bluff Park | 0 | Local Park 2 | 4 | |
1136 | 1136 | 1135 | {"type": "Polygon", "coordinates": [[[-118.10845, 33.77696], [-118.10812, 33.77733], [-118.10811, 33.77767], [-118.1074, 33.77768], [-118.1063, 33.7776], [-118.10633, 33.77741], [-118.10608, 33.77704], [-118.10604, 33.77647], [-118.10563, 33.77642], [-118.10564, 33.77625], [-118.10604, 33.77629], [-118.10686, 33.77626], [-118.10722, 33.77607], [-118.10745, 33.77636], [-118.10787, 33.77635], [-118.10794, 33.77631], [-118.10845, 33.77696]]]} | Open Access 1 | 6659 | Rancho Los Alamitos Historic Site | 24152 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 7.405 | Rancho Los Alamitos Historic Site | 0 | Local Historic or Cultural Area 19 | 4 | |
1138 | 1138 | 1137 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | 6684 | Chittick Field | 29944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.181 | Chittick Field | 2014 | Local Recreation Area 3 | 4 | |
2391 | 2391 | 2390 | {"type": "Polygon", "coordinates": [[[-118.20432, 33.79536], [-118.20431, 33.79659], [-118.20427, 33.79663], [-118.20404, 33.79662], [-118.20404, 33.79554], [-118.20398, 33.79553], [-118.20397, 33.79536], [-118.20432, 33.79536]]]} | Open Access 1 | 45873 | 21st to Hill Mini Park | 28944 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://longbeach.granicus.com/MediaPlayer.php?view_id=12&clip_id=4470 | Los Angeles 6 | 0.91 | 21st to Hill MP | 0 | Local Park 2 | 4 |
2711 | 2711 | 2710 | {"type": "MultiPolygon", "coordinates": [[[[-118.19943, 33.79521], [-118.19929, 33.79521], [-118.19927, 33.79361], [-118.19943, 33.79359], [-118.19943, 33.79521]]], [[[-118.19942, 33.79542], [-118.19941, 33.79702], [-118.19929, 33.79703], [-118.19927, 33.79542], [-118.19942, 33.79542]]], [[[-118.19944, 33.79178], [-118.19943, 33.79341], [-118.19928, 33.79342], [-118.1993, 33.79177], [-118.19944, 33.79178]]], [[[-118.19946, 33.79006], [-118.19943, 33.7916], [-118.19929, 33.7916], [-118.19931, 33.79007], [-118.19946, 33.79006]]]]} | Open Access 1 | 6685 | Daisy Greenbelt | 17892 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.32 | Daisy Greenbelt | 0 | Local Recreation Area 3 | 4 | |
2714 | 2714 | 2713 | {"type": "MultiPolygon", "coordinates": [[[[-118.21183, 33.82355], [-118.21117, 33.82355], [-118.21118, 33.82341], [-118.21183, 33.82341], [-118.21183, 33.82355]]], [[[-118.21441, 33.82237], [-118.21313, 33.8242], [-118.21309, 33.82422], [-118.21282, 33.82418], [-118.21282, 33.82385], [-118.21441, 33.82237]]]]} | Open Access 1 | 6689 | Tanaka Park | 26179 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.624 | Tanaka Park | 0 | Local Park 2 | 4 | |
2951 | 2951 | 2950 | {"type": "Polygon", "coordinates": [[[-118.16535, 33.78974], [-118.16492, 33.78974], [-118.16342, 33.78877], [-118.16342, 33.78849], [-118.16535, 33.78974]]]} | Open Access 1 | 20230 | Rotary Centennial Park | 24683 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.209 | Rotary Centennial Park | 0 | Local Park 2 | 4 | |
3647 | 3647 | 3646 | {"type": "Polygon", "coordinates": [[[-118.18416, 33.84964], [-118.18416, 33.84977], [-118.1839, 33.84978], [-118.18368, 33.84995], [-118.18366, 33.85], [-118.18366, 33.85103], [-118.18368, 33.85107], [-118.1839, 33.85124], [-118.18415, 33.85125], [-118.18412, 33.8514], [-118.18406, 33.85154], [-118.18391, 33.85147], [-118.18377, 33.85139], [-118.18366, 33.85128], [-118.18358, 33.85119], [-118.18348, 33.85098], [-118.18344, 33.85061], [-118.18338, 33.85051], [-118.18271, 33.85006], [-118.18216, 33.84996], [-118.18039, 33.85003], [-118.18036, 33.85027], [-118.18017, 33.85029], [-118.18011, 33.85019], [-118.18008, 33.84977], [-118.17983, 33.84976], [-118.17975, 33.84957], [-118.17968, 33.84949], [-118.17974, 33.84942], [-118.17984, 33.84936], [-118.18021, 33.84922], [-118.18033, 33.84962], [-118.18037, 33.84983], [-118.18193, 33.84976], [-118.18192, 33.84935], [-118.18226, 33.84923], [-118.18204, 33.84878], [-118.18212, 33.84873], [-118.18233, 33.84879], [-118.18248, 33.84853], [-118.18292, 33.84865], [-118.18288, 33.84873], [-118.18271, 33.84886], [-118.18251, 33.84906], [-118.18305, 33.84956], [-118.18339, 33.84983], [-118.18349, 33.84986], [-118.18356, 33.84986], [-118.18363, 33.84983], [-118.18379, 33.8497], [-118.18388, 33.84966], [-118.18397, 33.84964], [-118.18416, 33.84964]]]} | Open Access 1 | 29559 | Atlantic Plaza Park | 15675 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 6.585 | Atlantic Plaza Park | 0 | Local Park 2 | 4 | |
3980 | 3980 | 3979 | {"type": "Polygon", "coordinates": [[[-118.12082, 33.75099], [-118.12081, 33.75102], [-118.12061, 33.75101], [-118.12037, 33.75104], [-118.12012, 33.75112], [-118.11995, 33.75121], [-118.11979, 33.75134], [-118.11882, 33.75237], [-118.11861, 33.75252], [-118.11819, 33.75271], [-118.11817, 33.75267], [-118.11847, 33.75255], [-118.11862, 33.75247], [-118.11878, 33.75235], [-118.11892, 33.75223], [-118.11977, 33.75131], [-118.11991, 33.75119], [-118.12011, 33.75109], [-118.12036, 33.751], [-118.12058, 33.75098], [-118.12082, 33.75099]]]} | Open Access 1 | 46618 | Vista del Golfo Parkway | 29933 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.273 | Vista del Golfo Parkway | 0 | Local Recreation Area 3 | 4 | |
3981 | 3981 | 3980 | {"type": "Polygon", "coordinates": [[[-118.09099, 33.82783], [-118.09001, 33.82754], [-118.09002, 33.82684], [-118.0909, 33.82686], [-118.09099, 33.82783]]]} | Open Access 1 | 46620 | Gemmrig Park | 29935 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 1.955 | Gemmrig Park | 0 | Local Park 2 | 4 | |
4318 | 4318 | 4317 | {"type": "Polygon", "coordinates": [[[-118.0838, 33.8066], [-118.08379, 33.80859], [-118.08207, 33.80859], [-118.08208, 33.80794], [-118.08217, 33.80718], [-118.08229, 33.80687], [-118.08247, 33.8066], [-118.0838, 33.8066]]]} | Restricted Access 2 | 48251 | El Dorado Community Gardens | 32803 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 8.255 | El Dorado Community Gardens | 0 | Local Park 2 | 4 | |
4375 | 4375 | 4374 | {"type": "Polygon", "coordinates": [[[-118.1965, 33.7631], [-118.19637, 33.76302], [-118.19634, 33.7629], [-118.19626, 33.76281], [-118.19616, 33.76275], [-118.19604, 33.76273], [-118.19594, 33.76275], [-118.19584, 33.76279], [-118.19578, 33.76284], [-118.19572, 33.76293], [-118.19569, 33.76295], [-118.19537, 33.76299], [-118.19512, 33.76308], [-118.19509, 33.76306], [-118.19499, 33.76286], [-118.19472, 33.76282], [-118.19432, 33.76268], [-118.19406, 33.76252], [-118.19384, 33.76233], [-118.19337, 33.76235], [-118.19334, 33.76226], [-118.19327, 33.76219], [-118.19355, 33.76191], [-118.19345, 33.76185], [-118.19323, 33.76178], [-118.1931, 33.76178], [-118.19313, 33.76213], [-118.19299, 33.76214], [-118.19294, 33.76179], [-118.19276, 33.76184], [-118.19266, 33.76189], [-118.19257, 33.76196], [-118.19243, 33.76212], [-118.19237, 33.7623], [-118.19236, 33.76241], [-118.19278, 33.76257], [-118.19269, 33.76272], [-118.19261, 33.76269], [-118.19259, 33.76272], [-118.19076, 33.76199], [-118.19029, 33.76183], [-118.19027, 33.7617], [-118.19036, 33.76167], [-118.19036, 33.76161], [-118.19164, 33.76205], [-118.19171, 33.76203], [-118.19177, 33.76204], [-118.19182, 33.76207], [-118.19185, 33.76214], [-118.19195, 33.76217], [-118.19204, 33.76218], [-118.19219, 33.76214], [-118.19226, 33.762], [-118.19236, 33.76188], [-118.19248, 33.76177], [-118.19263, 33.76168], [-118.1928, 33.76162], [-118.19296, 33.76159], [-118.19311, 33.76159], [-118.19327, 33.7616], [-118.19351, 33.76167], [-118.19366, 33.76175], [-118.19379, 33.76185], [-118.1939, 33.76186], [-118.194, 33.76191], [-118.19406, 33.76197], [-118.19408, 33.76204], [-118.19408, 33.76211], [-118.19406, 33.7622], [-118.19423, 33.76236], [-118.19443, 33.76248], [-118.19464, 33.76256], [-118.19487, 33.76261], [-118.1951, 33.76263], [-118.19535, 33.76261], [-118.19565, 33.76253], [-118.19591, 33.7624], [-118.19613, 33.76221], [-118.19629, 33.762], [-118.19636, 33.76184], [-118.1964, 33.76167], [-118.19641, 33.7615], [-118.19639, 33.76133], [-118.19633, 33.76115], [-118.19621, 33.76113], [-118.19612, 33.76108], [-118.19606, 33.76101], [-118.19604, 33.76091], [-118.19607, 33.76083], [-118.19614, 33.76076], [-118.19642, 33.76068], [-118.19652, 33.76076], [-118.19658, 33.76086], [-118.19659, 33.76093], [-118.19657, 33.761], [-118.19653, 33.76107], [-118.19646, 33.76112], [-118.19645, 33.76118], [-118.19647, 33.76123], [-118.19654, 33.76131], [-118.19658, 33.76138], [-118.19661, 33.76151], [-118.19659, 33.76166], [-118.19646, 33.76184], [-118.19642, 33.76195], [-118.19657, 33.76268], [-118.19655, 33.76293], [-118.1965, 33.7631]]]} | Open Access 1 | 45920 | Rainbow Harbor Esplanade | 28994 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/park-and-facilities/directory/rainbow-harbor-esplanade/ | Los Angeles 6 | 6.934 | Rainbow Harbor Esplanade | None 389 | ||
4380 | 4380 | 4379 | {"type": "Polygon", "coordinates": [[[-118.17688, 33.84102], [-118.17654, 33.8412], [-118.17644, 33.84116], [-118.17644, 33.84082], [-118.17673, 33.84082], [-118.17688, 33.84102]]]} | Open Access 1 | 45939 | Orange Park | 29014 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.301 | Orange Park | 0 | Local Park 2 | 4 | |
4457 | 4457 | 4456 | {"type": "Polygon", "coordinates": [[[-118.14809, 33.75779], [-118.14772, 33.75908], [-118.14638, 33.7588], [-118.14642, 33.75866], [-118.14626, 33.75863], [-118.14649, 33.75785], [-118.14496, 33.75754], [-118.14525, 33.75697], [-118.14662, 33.75743], [-118.14809, 33.75779]]]} | Open Access 1 | 46629 | Belmont Plaza Beach | 29954 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 7.27 | Belmont Plaza Beach | 0 | Local Park 2 | 4 | |
4458 | 4458 | 4457 | {"type": "Polygon", "coordinates": [[[-118.14947, 33.75539], [-118.14946, 33.75548], [-118.14907, 33.75548], [-118.14906, 33.75553], [-118.14897, 33.75553], [-118.14897, 33.75556], [-118.14888, 33.75557], [-118.14861, 33.75645], [-118.14864, 33.75647], [-118.14864, 33.75653], [-118.1486, 33.75667], [-118.14856, 33.75674], [-118.14852, 33.75674], [-118.14791, 33.75887], [-118.14838, 33.75898], [-118.14834, 33.75914], [-118.14824, 33.75913], [-118.14821, 33.75924], [-118.14797, 33.75913], [-118.14772, 33.75908], [-118.14809, 33.75779], [-118.14842, 33.75671], [-118.1484, 33.7567], [-118.1484, 33.75656], [-118.14847, 33.75645], [-118.14851, 33.75645], [-118.14865, 33.75594], [-118.14863, 33.75593], [-118.1487, 33.75568], [-118.1486, 33.75555], [-118.14853, 33.75562], [-118.14856, 33.75566], [-118.14836, 33.75576], [-118.14831, 33.75569], [-118.14849, 33.75561], [-118.1485, 33.75559], [-118.14846, 33.75556], [-118.14829, 33.75563], [-118.14823, 33.75556], [-118.14841, 33.75547], [-118.14847, 33.75552], [-118.14856, 33.75549], [-118.14859, 33.75548], [-118.14862, 33.75539], [-118.1483, 33.75524], [-118.14835, 33.75515], [-118.14869, 33.75531], [-118.14871, 33.75528], [-118.14891, 33.75528], [-118.14907, 33.75535], [-118.14908, 33.75539], [-118.14947, 33.75539]]]} | Open Access 1 | 46630 | Belmont Veterans Memorial Pier | 29955 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 2.094 | Belmont Veterans Memorial Pier | None 398 | |||
4500 | 4500 | 4499 | {"type": "Polygon", "coordinates": [[[-118.14894, 33.76065], [-118.14889, 33.76086], [-118.14849, 33.76069], [-118.14818, 33.7606], [-118.14798, 33.76055], [-118.14796, 33.76053], [-118.14796, 33.76047], [-118.14799, 33.76044], [-118.14804, 33.76043], [-118.14818, 33.76043], [-118.14894, 33.76065]]]} | Open Access 1 | 6605 | Unknown park - Long Beach, City of | 29921 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.432 | 0 | Local Other or Unknown 14 | 4 | ||
5091 | 5091 | 5090 | {"type": "Polygon", "coordinates": [[[-118.14026, 33.782], [-118.14026, 33.78244], [-118.13519, 33.78245], [-118.13518, 33.78214], [-118.13189, 33.78191], [-118.1286, 33.77948], [-118.1286, 33.77543], [-118.13159, 33.77543], [-118.13155, 33.77619], [-118.13253, 33.77718], [-118.13431, 33.77757], [-118.13696, 33.77795], [-118.1371, 33.77794], [-118.13729, 33.77819], [-118.13734, 33.77832], [-118.13746, 33.77879], [-118.13743, 33.77907], [-118.13769, 33.77961], [-118.13781, 33.77978], [-118.13825, 33.78024], [-118.1386, 33.78072], [-118.13873, 33.78094], [-118.13906, 33.78131], [-118.13928, 33.78148], [-118.13951, 33.78164], [-118.13984, 33.78183], [-118.14026, 33.782]]]} | Restricted Access 2 | 45923 | Recreation Park 18 Hole Golf Course | 33116 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 119.647 | Rec. Park 18 Hole GC | 0 | Local Recreation Area 3 | 4 | |
5166 | 5166 | 5165 | {"type": "Polygon", "coordinates": [[[-118.07283, 33.81486], [-118.07254, 33.81515], [-118.07246, 33.81527], [-118.07239, 33.81542], [-118.07195, 33.8153], [-118.07283, 33.81486]]]} | Open Access 1 | 6690 | Lilly Park | 21238 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.332 | Lilly Park | 0 | Local Park 2 | 4 | |
7239 | 7239 | 7238 | {"type": "MultiPolygon", "coordinates": [[[[-118.19906, 33.82499], [-118.1991, 33.825], [-118.19941, 33.82546], [-118.19942, 33.8255], [-118.19859, 33.82589], [-118.19854, 33.82589], [-118.19827, 33.82551], [-118.1982, 33.82544], [-118.1982, 33.8254], [-118.19906, 33.82499]]], [[[-118.20044, 33.8271], [-118.19882, 33.82786], [-118.1986, 33.82599], [-118.19944, 33.82559], [-118.20044, 33.8271]]]]} | Open Access 1 | 6574 | Los Cerritos Park | 21511 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 7.692 | Los Cerritos 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]);