units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
135 rows where ACCESS_TYP = 1 and MNG_AGENCY = 294 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 19
- Local Park 80
- Local Recreation Area 17
- Local Historic or Cultural 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
MNG_AG_TYP 1
- City Agency 115
MNG_AGENCY 1
- Long Beach, City of · 115 ✖
ACCESS_TYP 1
- Open Access · 115 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1126 | 1126 | 1125 | {"type": "MultiPolygon", "coordinates": [[[[-118.19262, 33.86033], [-118.1925, 33.86059], [-118.19247, 33.86057], [-118.19244, 33.8605], [-118.1922, 33.86042], [-118.19216, 33.86047], [-118.19211, 33.86043], [-118.19206, 33.86043], [-118.19206, 33.86014], [-118.19229, 33.86016], [-118.19238, 33.86019], [-118.19262, 33.86033]]], [[[-118.19495, 33.86197], [-118.1949, 33.86207], [-118.19487, 33.86207], [-118.19485, 33.86197], [-118.1935, 33.86102], [-118.19314, 33.86081], [-118.19274, 33.86062], [-118.19263, 33.86064], [-118.19277, 33.86047], [-118.19278, 33.86047], [-118.19475, 33.86186], [-118.19494, 33.86194], [-118.19494, 33.86196], [-118.19495, 33.86197]]], [[[-118.19511, 33.86172], [-118.19507, 33.86179], [-118.195, 33.86182], [-118.19478, 33.86171], [-118.19288, 33.86037], [-118.19326, 33.86055], [-118.19364, 33.86077], [-118.195, 33.86172], [-118.19508, 33.86171], [-118.19511, 33.86172]]]]} | Open Access 1 | 6601 | South Street Parkway | 25680 | 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.42 | South Street Parkway | 0 | Local Recreation Area 3 | 4 | |
1127 | 1127 | 1126 | {"type": "Polygon", "coordinates": [[[-118.15552, 33.87377], [-118.15359, 33.87378], [-118.15358, 33.87208], [-118.15446, 33.87208], [-118.15457, 33.87214], [-118.15466, 33.87229], [-118.15471, 33.87236], [-118.15487, 33.87246], [-118.15506, 33.8725], [-118.15552, 33.8725], [-118.15552, 33.87377]]]} | Open Access 1 | 6602 | Ramona Park | 24119 | 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.46 | Ramona Park | 0 | Local Park 2 | 4 | |
967 | 967 | 966 | {"type": "Polygon", "coordinates": [[[-118.18557, 33.87069], [-118.18217, 33.87067], [-118.18215, 33.86744], [-118.1851, 33.86743], [-118.18557, 33.87069]]]} | Open Access 1 | 6603 | Houghton Park | 20109 | 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 | 26.14 | Houghton Park | 0 | Local Park 2 | 4 | |
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 | ||
16323 | 16323 | 16322 | {"type": "MultiPolygon", "coordinates": [[[[-118.0908, 33.81768], [-118.09047, 33.81769], [-118.0906, 33.81868], [-118.08945, 33.81869], [-118.0885, 33.81861], [-118.0879, 33.81852], [-118.08434, 33.81774], [-118.08378, 33.81764], [-118.08341, 33.81758], [-118.08287, 33.81754], [-118.08224, 33.81751], [-118.08174, 33.81752], [-118.08176, 33.81394], [-118.08195, 33.81393], [-118.08196, 33.81266], [-118.0827, 33.81114], [-118.08279, 33.811], [-118.08295, 33.81085], [-118.08305, 33.81079], [-118.08332, 33.81069], [-118.08445, 33.81057], [-118.08673, 33.81058], [-118.08732, 33.81055], [-118.09009, 33.81055], [-118.09014, 33.8117], [-118.0905, 33.81171], [-118.09051, 33.81179], [-118.0906, 33.81391], [-118.0908, 33.81768]]], [[[-118.09232, 33.82822], [-118.09099, 33.82783], [-118.09091, 33.82687], [-118.09069, 33.82686], [-118.09069, 33.82486], [-118.08925, 33.82485], [-118.08923, 33.8273], [-118.08223, 33.82523], [-118.08214, 33.82485], [-118.0819, 33.82348], [-118.08181, 33.82263], [-118.08175, 33.82191], [-118.08173, 33.8205], [-118.08174, 33.82047], [-118.08175, 33.81779], [-118.08278, 33.81781], [-118.08335, 33.81786], [-118.08389, 33.81793], [-118.08736, 33.81869], [-118.08744, 33.81869], [-118.08787, 33.81882], [-118.08834, 33.81889], [-118.08886, 33.81894], [-118.08923, 33.81896], [-118.09064, 33.81895], [-118.09076, 33.81978], [-118.09109, 33.81978], [-118.09232, 33.82822]]]]} | Open Access 1 | 6606 | El Dorado East Regional Park | 5426 | 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/parks_and_open_spaces/parks/el_dorado_regional_park.asp | Los Angeles 6 | 354.173 | El Dorado East RP | 0 | Local Park 2 | 4 |
969 | 969 | 968 | {"type": "MultiPolygon", "coordinates": [[[[-118.19734, 33.76719], [-118.19543, 33.76709], [-118.19542, 33.76707], [-118.19499, 33.76705], [-118.19499, 33.76694], [-118.19543, 33.76696], [-118.1963, 33.76696], [-118.19734, 33.76699], [-118.19734, 33.76719]]], [[[-118.19792, 33.767], [-118.19792, 33.76721], [-118.19746, 33.7672], [-118.19745, 33.76699], [-118.19792, 33.767]]], [[[-118.19929, 33.76702], [-118.19929, 33.76707], [-118.19921, 33.76714], [-118.19825, 33.76714], [-118.19821, 33.7671], [-118.1982, 33.76721], [-118.19814, 33.76721], [-118.19814, 33.76703], [-118.19929, 33.76702]]], [[[-118.20049, 33.76703], [-118.20049, 33.76709], [-118.20043, 33.76714], [-118.19954, 33.76714], [-118.19949, 33.76707], [-118.19949, 33.76702], [-118.20049, 33.76703]]], [[[-118.20174, 33.76703], [-118.20174, 33.76709], [-118.20167, 33.76714], [-118.20076, 33.76714], [-118.2007, 33.76709], [-118.2007, 33.76703], [-118.20174, 33.76703]]]]} | Open Access 1 | 6608 | Santa Cruz Park | 25082 | 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.096 | Santa Cruz Park | 0 | Local Park 2 | 4 | |
970 | 970 | 969 | {"type": "Polygon", "coordinates": [[[-118.19511, 33.76865], [-118.19493, 33.76865], [-118.19494, 33.76918], [-118.19389, 33.76918], [-118.19389, 33.76817], [-118.1949, 33.76817], [-118.19491, 33.76828], [-118.19494, 33.76834], [-118.19502, 33.76837], [-118.19511, 33.76837], [-118.19511, 33.76865]]]} | Open Access 1 | 6609 | Lincoln Park | 21264 | 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.816 | Lincoln Park | 0 | Local Park 2 | 4 | |
971 | 971 | 970 | {"type": "Polygon", "coordinates": [[[-118.20138, 33.84854], [-118.20124, 33.85039], [-118.20107, 33.85039], [-118.20104, 33.85032], [-118.20116, 33.84873], [-118.20105, 33.84872], [-118.20105, 33.84854], [-118.20138, 33.84854]]]} | Open Access 1 | 6612 | 51st St Greenbelt | 29907 | 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.011 | 51st St Greenbelt | 2008 | Local Recreation Area 3 | 4 | |
972 | 972 | 971 | {"type": "Polygon", "coordinates": [[[-118.18037, 33.84032], [-118.18037, 33.84033], [-118.17814, 33.84152], [-118.17816, 33.84104], [-118.17814, 33.8409], [-118.17808, 33.84071], [-118.17988, 33.83974], [-118.18009, 33.84001], [-118.18012, 33.84], [-118.18037, 33.84032]]]} | Open Access 1 | 6613 | Bixby Knolls Park | 16130 | 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 | 4.268 | Bixby Knolls Park | 0 | Local Park 2 | 4 | |
973 | 973 | 972 | {"type": "Polygon", "coordinates": [[[-118.15882, 33.78532], [-118.15882, 33.78581], [-118.15806, 33.78532], [-118.15684, 33.78532], [-118.15684, 33.78449], [-118.15846, 33.78449], [-118.15846, 33.78475], [-118.15833, 33.78476], [-118.15833, 33.78497], [-118.15846, 33.78497], [-118.15846, 33.7853], [-118.15849, 33.78532], [-118.15882, 33.78532]]]} | Open Access 1 | 6614 | Orizaba Park | 23204 | 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 | 3.776 | Orizaba Park | 0 | Local Park 2 | 4 | |
7315 | 7315 | 7314 | {"type": "Polygon", "coordinates": [[[-118.16917, 33.76286], [-118.16902, 33.7637], [-118.16866, 33.76365], [-118.1687, 33.76342], [-118.16848, 33.7634], [-118.16848, 33.76328], [-118.16805, 33.76321], [-118.1681, 33.76292], [-118.16333, 33.76211], [-118.16329, 33.76239], [-118.16467, 33.76266], [-118.16452, 33.76307], [-118.16439, 33.76304], [-118.16446, 33.76281], [-118.16445, 33.76279], [-118.16349, 33.76263], [-118.15995, 33.76196], [-118.1582, 33.76158], [-118.15644, 33.76123], [-118.15284, 33.76035], [-118.15092, 33.75983], [-118.15086, 33.76], [-118.14821, 33.75924], [-118.14824, 33.75912], [-118.14834, 33.75913], [-118.14838, 33.75898], [-118.14791, 33.75888], [-118.1482, 33.75782], [-118.15107, 33.7587], [-118.15116, 33.7588], [-118.15507, 33.75983], [-118.15767, 33.76048], [-118.16043, 33.76106], [-118.16264, 33.76158], [-118.16496, 33.76209], [-118.16842, 33.76269], [-118.16917, 33.76286]]]} | Open Access 1 | 6629 | Junipero Beach | 20529 | 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 | 48.486 | Junipero Beach | 0 | Local Park 2 | 4 | |
7321 | 7321 | 7320 | {"type": "Polygon", "coordinates": [[[-118.19583, 33.75484], [-118.1958, 33.7549], [-118.19566, 33.75492], [-118.19552, 33.75499], [-118.19539, 33.75504], [-118.19534, 33.75504], [-118.19526, 33.75502], [-118.19505, 33.75519], [-118.19498, 33.75519], [-118.19489, 33.75516], [-118.19473, 33.75496], [-118.19454, 33.7548], [-118.19449, 33.75476], [-118.19437, 33.75471], [-118.19433, 33.75467], [-118.19427, 33.75456], [-118.19424, 33.75444], [-118.19423, 33.75426], [-118.19419, 33.75416], [-118.19416, 33.75412], [-118.19408, 33.75409], [-118.19398, 33.75407], [-118.19373, 33.75397], [-118.19404, 33.75334], [-118.19536, 33.75382], [-118.19536, 33.75457], [-118.19537, 33.75465], [-118.19547, 33.75475], [-118.19583, 33.75484]]]} | Open Access 1 | 6630 | Queen Mary Events Park | 24061 | 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 | 4.722 | Queen Mary Events Park | 0 | Local Park 2 | 4 | |
7322 | 7322 | 7321 | {"type": "Polygon", "coordinates": [[[-118.21763, 33.79448], [-118.21763, 33.79704], [-118.21597, 33.79703], [-118.21597, 33.79622], [-118.21554, 33.79621], [-118.21554, 33.7953], [-118.21586, 33.79531], [-118.21587, 33.79525], [-118.21586, 33.79524], [-118.21561, 33.79524], [-118.21561, 33.79448], [-118.21763, 33.79448]]]} | Open Access 1 | 6631 | Admiral Issac C. Kidd Park | 29925 | 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 | 12.494 | Admiral Issac C. Kidd Park | 0 | Local Park 2 | 4 | |
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 | |
7323 | 7323 | 7322 | {"type": "Polygon", "coordinates": [[[-118.19536, 33.87403], [-118.19508, 33.874], [-118.19483, 33.87391], [-118.19479, 33.87373], [-118.19471, 33.87356], [-118.19449, 33.87322], [-118.19443, 33.87308], [-118.19439, 33.87291], [-118.19437, 33.87267], [-118.19437, 33.8726], [-118.19457, 33.87162], [-118.19472, 33.87105], [-118.19496, 33.8704], [-118.19529, 33.86975], [-118.19535, 33.86975], [-118.19534, 33.87241], [-118.19536, 33.87403]]]} | Open Access 1 | 6633 | Coolidge Park | 17621 | 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.124 | Coolidge Park | 0 | Local Park 2 | 4 | |
7324 | 7324 | 7323 | {"type": "Polygon", "coordinates": [[[-118.18924, 33.76079], [-118.18923, 33.76161], [-118.1892, 33.76167], [-118.1889, 33.76173], [-118.18823, 33.76179], [-118.18785, 33.76188], [-118.18762, 33.76195], [-118.18723, 33.76212], [-118.18697, 33.76226], [-118.18545, 33.76317], [-118.18538, 33.76318], [-118.18534, 33.76316], [-118.18518, 33.76325], [-118.1852, 33.76332], [-118.18516, 33.76336], [-118.18447, 33.76377], [-118.18422, 33.76395], [-118.18368, 33.7645], [-118.18357, 33.7645], [-118.18361, 33.76438], [-118.18333, 33.76403], [-118.18347, 33.76392], [-118.18498, 33.76301], [-118.18513, 33.7629], [-118.18688, 33.76188], [-118.18819, 33.76118], [-118.18924, 33.76079]]]} | Open Access 1 | 6634 | Marina Green | 21822 | 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.806 | Marina Green | 0 | Local Park 2 | 4 | |
7325 | 7325 | 7324 | {"type": "Polygon", "coordinates": [[[-118.18561, 33.78421], [-118.18515, 33.78421], [-118.18515, 33.78386], [-118.18561, 33.78387], [-118.18561, 33.78421]]]} | Open Access 1 | 6636 | Peace Park | 23539 | 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.401 | Peace Park | 0 | Local Park 2 | 4 | |
7327 | 7327 | 7326 | {"type": "MultiPolygon", "coordinates": [[[[-118.19093, 33.78373], [-118.19093, 33.78389], [-118.19012, 33.78389], [-118.19012, 33.78373], [-118.19093, 33.78373]]], [[[-118.19225, 33.78389], [-118.1912, 33.78389], [-118.1912, 33.78373], [-118.19225, 33.78373], [-118.19225, 33.78389]]], [[[-118.19492, 33.78372], [-118.19492, 33.78389], [-118.19388, 33.78389], [-118.19388, 33.78372], [-118.19492, 33.78372]]], [[[-118.19623, 33.78372], [-118.19623, 33.78389], [-118.19519, 33.78389], [-118.19519, 33.78372], [-118.19623, 33.78372]]]]} | Open Access 1 | 6641 | 14th Street Park and Playground | 15173 | 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.661 | 14th Street Park and Playground | 0 | Local Recreation Area 3 | 4 | |
7329 | 7329 | 7328 | {"type": "MultiPolygon", "coordinates": [[[[-118.16786, 33.76675], [-118.16779, 33.76716], [-118.16686, 33.76704], [-118.16596, 33.76685], [-118.16609, 33.76645], [-118.16696, 33.76664], [-118.16786, 33.76675]]], [[[-118.16806, 33.76568], [-118.1679, 33.76655], [-118.16701, 33.76644], [-118.16614, 33.76625], [-118.1664, 33.7654], [-118.16722, 33.76558], [-118.16806, 33.76568]]], [[[-118.16849, 33.76328], [-118.16831, 33.76434], [-118.16756, 33.76424], [-118.16632, 33.76398], [-118.16646, 33.76351], [-118.16629, 33.76346], [-118.16642, 33.76296], [-118.16849, 33.76328]]], [[[-118.16827, 33.76461], [-118.1681, 33.76548], [-118.16727, 33.76538], [-118.16646, 33.7652], [-118.16671, 33.76434], [-118.16748, 33.76452], [-118.16827, 33.76461]]]]} | Open Access 1 | 6642 | Bixby Park | 16131 | 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 | 15.024 | Bixby Park | 0 | Local Park 2 | 4 | |
7330 | 7330 | 7329 | {"type": "MultiPolygon", "coordinates": [[[[-118.1632, 33.76891], [-118.16311, 33.76896], [-118.16311, 33.76887], [-118.16315, 33.76889], [-118.1632, 33.76891]]], [[[-118.16334, 33.77076], [-118.16323, 33.77082], [-118.16314, 33.7709], [-118.16315, 33.77079], [-118.16313, 33.77068], [-118.16334, 33.77076]]], [[[-118.16428, 33.76891], [-118.16414, 33.769], [-118.16403, 33.76911], [-118.16392, 33.769], [-118.16378, 33.76891], [-118.16392, 33.76882], [-118.16403, 33.76871], [-118.16414, 33.76882], [-118.16428, 33.76891]]], [[[-118.16441, 33.77044], [-118.16441, 33.77044], [-118.16398, 33.77055], [-118.16404, 33.77047], [-118.16408, 33.77039], [-118.1641, 33.7703], [-118.1641, 33.7702], [-118.16423, 33.77032], [-118.16441, 33.77044]]]]} | Open Access 1 | 6643 | Carroll Parks | 16919 | 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.426 | Carroll Parks | None 606 |
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]);