units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
351 rows where MNG_AGENCY = 27
This data as json, copyable, CSV (advanced)
DES_TP >30
ACCESS_TYP 4
- Open Access 157
- Unknown Access 144
- No Public Access 9
- Restricted Access 1
MNG_AG_TYP 1
MNG_AGENCY 1
- Mountains Recreation and Conservation Authority · 311 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4482 | 4482 | 4481 | {"type": "Polygon", "coordinates": [[[-118.82809, 34.1109], [-118.82374, 34.11089], [-118.82373, 34.10731], [-118.82808, 34.10728], [-118.82809, 34.1109]]]} | Unknown Access 4 | 4333 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.614 | 0 | Local Other or Unknown 14 | 4 | ||
4483 | 4483 | 4482 | {"type": "Polygon", "coordinates": [[[-118.83243, 34.10717], [-118.83243, 34.10853], [-118.82873, 34.10863], [-118.82809, 34.10863], [-118.82808, 34.10727], [-118.82875, 34.10727], [-118.83243, 34.10717]]]} | Unknown Access 4 | 4342 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 14.94 | 0 | Local Other or Unknown 14 | 4 | ||
4489 | 4489 | 4488 | {"type": "MultiPolygon", "coordinates": [[[[-118.21759, 34.10846], [-118.21735, 34.1085], [-118.21726, 34.10813], [-118.21751, 34.10809], [-118.21759, 34.10846]]], [[[-118.21918, 34.10822], [-118.21901, 34.10857], [-118.21832, 34.10834], [-118.21784, 34.10842], [-118.21775, 34.10805], [-118.21837, 34.10795], [-118.21918, 34.10822]]]]} | Unknown Access 4 | 4922 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.517 | 0 | Local Other or Unknown 14 | 4 | ||
4494 | 4494 | 4493 | {"type": "MultiPolygon", "coordinates": [[[[-118.48772, 34.08391], [-118.48608, 34.08433], [-118.48643, 34.08403], [-118.48641, 34.0838], [-118.48584, 34.08367], [-118.48547, 34.08363], [-118.48523, 34.08321], [-118.48495, 34.08305], [-118.48428, 34.08244], [-118.48405, 34.08227], [-118.48404, 34.08202], [-118.48463, 34.08151], [-118.48463, 34.08149], [-118.48417, 34.0812], [-118.4839, 34.08119], [-118.48367, 34.08055], [-118.48292, 34.08084], [-118.48286, 34.08076], [-118.48285, 34.0806], [-118.48289, 34.08051], [-118.48297, 34.08043], [-118.48317, 34.0803], [-118.48326, 34.08018], [-118.48328, 34.08012], [-118.48328, 34.07998], [-118.48324, 34.07986], [-118.48355, 34.07978], [-118.48394, 34.07935], [-118.48368, 34.07917], [-118.48344, 34.07892], [-118.48336, 34.07889], [-118.48328, 34.07888], [-118.48317, 34.07892], [-118.48311, 34.07896], [-118.48289, 34.07935], [-118.48269, 34.07953], [-118.48254, 34.07962], [-118.48232, 34.0797], [-118.48228, 34.07956], [-118.48232, 34.07959], [-118.48237, 34.07958], [-118.48254, 34.0795], [-118.48269, 34.0794], [-118.48282, 34.07926], [-118.48301, 34.0789], [-118.48309, 34.07884], [-118.48318, 34.0788], [-118.48332, 34.07878], [-118.48341, 34.0788], [-118.48349, 34.07883], [-118.48374, 34.07908], [-118.48385, 34.07916], [-118.48394, 34.07908], [-118.48445, 34.079], [-118.48445, 34.07898], [-118.48415, 34.07889], [-118.48396, 34.07875], [-118.48384, 34.07863], [-118.48446, 34.0785], [-118.48438, 34.07781], [-118.48492, 34.07793], [-118.48528, 34.07785], [-118.48533, 34.07853], [-118.48703, 34.08031], [-118.48658, 34.08035], [-118.48608, 34.0803], [-118.4858, 34.08015], [-118.48551, 34.08012], [-118.48549, 34.08052], [-118.48531, 34.08051], [-118.48524, 34.08052], [-118.48522, 34.08048], [-118.48494, 34.08073], [-118.4849, 34.08089], [-118.48507, 34.08107], [-118.48499, 34.08114], [-118.48513, 34.08124], [-118.48487, 34.08145], [-118.48542, 34.08176], [-118.4851, 34.08231], [-118.48522, 34.08266], [-118.48577, 34.08254], [-118.48602, 34.08284], [-118.48633, 34.0829], [-118.48701, 34.08282], [-118.48705, 34.08368], [-118.48753, 34.08379], [-118.48757, 34.0837], [-118.48772, 34.08391]]], [[[-118.48863, 34.08368], [-118.48838, 34.08375], [-118.48802, 34.08326], [-118.48819, 34.08317], [-118.48834, 34.08321], [-118.48831, 34.08326], [-118.48838, 34.08346], [-118.48863, 34.08368]]]]} | Open Access 1 | 6379 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 26.137 | 0 | Local Other or Unknown 14 | 4 | ||
4495 | 4495 | 4494 | {"type": "Polygon", "coordinates": [[[-118.43891, 34.09306], [-118.43861, 34.0933], [-118.43858, 34.0933], [-118.43856, 34.09326], [-118.43886, 34.09303], [-118.43891, 34.09306]]]} | Open Access 1 | 6391 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.059 | 0 | Local Other or Unknown 14 | 4 | ||
4496 | 4496 | 4495 | {"type": "Polygon", "coordinates": [[[-118.60626, 34.1253], [-118.60623, 34.13266], [-118.59929, 34.1327], [-118.59961, 34.13183], [-118.59966, 34.13163], [-118.59969, 34.13142], [-118.59969, 34.13121], [-118.59966, 34.13101], [-118.59961, 34.1308], [-118.59943, 34.13031], [-118.59942, 34.13019], [-118.59944, 34.13007], [-118.59949, 34.12996], [-118.59957, 34.12985], [-118.60041, 34.12913], [-118.60052, 34.12902], [-118.60059, 34.1289], [-118.60064, 34.12877], [-118.60066, 34.12864], [-118.60065, 34.1285], [-118.6006, 34.12837], [-118.60053, 34.12825], [-118.60038, 34.12809], [-118.60024, 34.12801], [-118.60002, 34.12793], [-118.59987, 34.12791], [-118.599, 34.12792], [-118.59881, 34.12789], [-118.59869, 34.12784], [-118.59855, 34.12772], [-118.59848, 34.12757], [-118.59847, 34.12746], [-118.59851, 34.12731], [-118.59858, 34.12721], [-118.59868, 34.12714], [-118.59879, 34.12708], [-118.59892, 34.12705], [-118.59959, 34.12704], [-118.59986, 34.127], [-118.60003, 34.12695], [-118.60018, 34.12688], [-118.60032, 34.12678], [-118.60044, 34.12667], [-118.60058, 34.12645], [-118.60063, 34.12625], [-118.60063, 34.12602], [-118.60059, 34.12587], [-118.60052, 34.12573], [-118.60043, 34.12561], [-118.60019, 34.12535], [-118.60626, 34.1253]]]} | Open Access 1 | 6422 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 119.03 | 0 | Local Other or Unknown 14 | 4 | ||
4497 | 4497 | 4496 | {"type": "MultiPolygon", "coordinates": [[[[-118.61094, 34.12902], [-118.6108, 34.12935], [-118.61077, 34.12954], [-118.61082, 34.12973], [-118.61094, 34.12991], [-118.60624, 34.12989], [-118.60625, 34.129], [-118.61094, 34.12902]]], [[[-118.61483, 34.12903], [-118.61482, 34.12993], [-118.6113, 34.12992], [-118.61127, 34.12984], [-118.61114, 34.12966], [-118.61111, 34.12957], [-118.61111, 34.12943], [-118.6113, 34.12902], [-118.61483, 34.12903]]]]} | Open Access 1 | 6425 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 18.661 | 0 | Local Other or Unknown 14 | 4 | ||
4498 | 4498 | 4497 | {"type": "Polygon", "coordinates": [[[-118.634, 34.0408], [-118.63396, 34.04093], [-118.63385, 34.04103], [-118.63373, 34.04109], [-118.63327, 34.0412], [-118.63319, 34.04126], [-118.63316, 34.04135], [-118.63256, 34.04136], [-118.63187, 34.04073], [-118.63262, 34.04016], [-118.63324, 34.04077], [-118.63362, 34.04088], [-118.634, 34.0408]]]} | Open Access 1 | 6461 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 3.063 | 0 | Local Other or Unknown 14 | 4 | ||
4501 | 4501 | 4500 | {"type": "Polygon", "coordinates": [[[-118.37435, 34.11711], [-118.37403, 34.11705], [-118.37409, 34.11687], [-118.37412, 34.11683], [-118.37422, 34.1168], [-118.3743, 34.11685], [-118.37432, 34.11689], [-118.37435, 34.11711]]]} | Open Access 1 | 6903 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.175 | 0 | Local Other or Unknown 14 | 4 | ||
4502 | 4502 | 4501 | {"type": "Polygon", "coordinates": [[[-118.3487, 34.22826], [-118.34868, 34.2308], [-118.34849, 34.2308], [-118.34809, 34.23097], [-118.3474, 34.23114], [-118.3467, 34.23152], [-118.34636, 34.23087], [-118.34599, 34.23099], [-118.34557, 34.23118], [-118.34552, 34.23116], [-118.34545, 34.23116], [-118.3454, 34.23097], [-118.34505, 34.23057], [-118.34435, 34.23104], [-118.34439, 34.22813], [-118.3487, 34.22826]]]} | Open Access 1 | 6853 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 30.789 | 0 | Local Other or Unknown 14 | 4 | ||
4504 | 4504 | 4503 | {"type": "MultiPolygon", "coordinates": [[[[-118.27189, 34.25899], [-118.2716, 34.25922], [-118.2716, 34.25779], [-118.27178, 34.25778], [-118.27189, 34.25756], [-118.27189, 34.25899]]], [[[-118.27237, 34.25554], [-118.27236, 34.25643], [-118.27206, 34.25642], [-118.27207, 34.25578], [-118.27217, 34.25566], [-118.27237, 34.25554]]], [[[-118.27285, 34.2587], [-118.27285, 34.25987], [-118.27263, 34.25987], [-118.27263, 34.25887], [-118.27285, 34.2587]]], [[[-118.27406, 34.25636], [-118.27354, 34.2563], [-118.27351, 34.25638], [-118.27362, 34.25645], [-118.27348, 34.25653], [-118.27348, 34.25563], [-118.27335, 34.25554], [-118.27335, 34.25468], [-118.27359, 34.25468], [-118.27359, 34.25569], [-118.27369, 34.25576], [-118.27406, 34.25565], [-118.27406, 34.25636]]]]} | Unknown Access 4 | 6855 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 3.721 | 0 | Local Other or Unknown 14 | 4 | ||
4505 | 4505 | 4504 | {"type": "Polygon", "coordinates": [[[-118.37787, 34.11964], [-118.37787, 34.12193], [-118.37762, 34.12197], [-118.37744, 34.12203], [-118.37736, 34.12203], [-118.37713, 34.12195], [-118.37717, 34.11964], [-118.37787, 34.11964]]]} | Open Access 1 | 6888 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 4.289 | 0 | Local Other or Unknown 14 | 4 | ||
4506 | 4506 | 4505 | {"type": "MultiPolygon", "coordinates": [[[[-118.37478, 34.11664], [-118.37453, 34.11673], [-118.37446, 34.11661], [-118.37475, 34.1165], [-118.37478, 34.11664]]], [[[-118.37538, 34.11762], [-118.37508, 34.11773], [-118.37474, 34.11711], [-118.37503, 34.117], [-118.37538, 34.11762]]]]} | Open Access 1 | 6889 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.668 | 0 | Local Other or Unknown 14 | 4 | ||
4507 | 4507 | 4506 | {"type": "Polygon", "coordinates": [[[-118.37116, 34.12047], [-118.37096, 34.12061], [-118.37088, 34.12062], [-118.37083, 34.12058], [-118.37088, 34.12031], [-118.37103, 34.12024], [-118.37116, 34.12047]]]} | Unknown Access 4 | 6890 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.191 | 0 | Local Other or Unknown 14 | 4 | ||
4508 | 4508 | 4507 | {"type": "Polygon", "coordinates": [[[-118.34372, 34.1194], [-118.34372, 34.11929], [-118.34358, 34.11895], [-118.34331, 34.11856], [-118.34283, 34.11838], [-118.34277, 34.11827], [-118.3425, 34.11819], [-118.34244, 34.11812], [-118.34226, 34.1181], [-118.34186, 34.11792], [-118.34163, 34.11776], [-118.34125, 34.11772], [-118.34131, 34.11719], [-118.33774, 34.11599], [-118.33761, 34.11579], [-118.33752, 34.11561], [-118.33746, 34.11542], [-118.33733, 34.11489], [-118.3373, 34.11488], [-118.33714, 34.11426], [-118.33668, 34.11316], [-118.3369, 34.11309], [-118.33688, 34.11302], [-118.33796, 34.11422], [-118.34016, 34.11581], [-118.34219, 34.11649], [-118.34209, 34.11665], [-118.34205, 34.11676], [-118.34206, 34.11695], [-118.34214, 34.11712], [-118.34228, 34.11726], [-118.34283, 34.11765], [-118.34385, 34.11885], [-118.34396, 34.11913], [-118.34397, 34.11923], [-118.34393, 34.1193], [-118.34388, 34.11935], [-118.3438, 34.11939], [-118.34372, 34.1194]]]} | Open Access 1 | 6894 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 20.897 | 0 | Local Other or Unknown 14 | 4 | ||
4509 | 4509 | 4508 | {"type": "Polygon", "coordinates": [[[-118.35605, 34.11531], [-118.35604, 34.11544], [-118.35595, 34.11553], [-118.35563, 34.11566], [-118.35575, 34.11594], [-118.35567, 34.1163], [-118.35515, 34.11646], [-118.35515, 34.11606], [-118.35543, 34.11557], [-118.35583, 34.11544], [-118.35588, 34.11538], [-118.35589, 34.11533], [-118.35605, 34.11531]]]} | Open Access 1 | 6896 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 1.11 | 0 | Local Other or Unknown 14 | 4 | ||
4510 | 4510 | 4509 | {"type": "Polygon", "coordinates": [[[-118.05241, 34.18273], [-118.05234, 34.1863], [-118.04795, 34.18635], [-118.04802, 34.18273], [-118.05241, 34.18273]]]} | Open Access 1 | 6978 | Unnamed site - Santa Monica Mountains Conservancy | 29566 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 39.911 | 0 | Local Other or Unknown 14 | 4 | ||
4511 | 4511 | 4510 | {"type": "Polygon", "coordinates": [[[-118.75427, 34.16206], [-118.7528, 34.16289], [-118.75305, 34.16324], [-118.75218, 34.16381], [-118.75052, 34.1638], [-118.75016, 34.1634], [-118.74922, 34.16397], [-118.74932, 34.16485], [-118.74577, 34.16484], [-118.74578, 34.15444], [-118.75019, 34.15445], [-118.75017, 34.15687], [-118.75077, 34.15683], [-118.75171, 34.15863], [-118.75245, 34.15924], [-118.75258, 34.15956], [-118.75315, 34.16008], [-118.75269, 34.16057], [-118.75282, 34.16118], [-118.75304, 34.16161], [-118.75416, 34.1616], [-118.75427, 34.16206]]]} | Unknown Access 4 | 7093 | Unnamed site - Santa Monica Mountains Conservancy | 29513 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 154.044 | 0 | Local Other or Unknown 14 | 4 | ||
4514 | 4514 | 4513 | {"type": "Polygon", "coordinates": [[[-118.36336, 34.26205], [-118.36208, 34.26532], [-118.36242, 34.26582], [-118.36086, 34.2658], [-118.36086, 34.2641], [-118.36323, 34.26203], [-118.36336, 34.26205]]]} | Unknown Access 4 | 12349 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 10.984 | 0 | Local Other or Unknown 14 | 4 | ||
4515 | 4515 | 4514 | {"type": "MultiPolygon", "coordinates": [[[[-118.64895, 34.12981], [-118.64844, 34.13005], [-118.64835, 34.12994], [-118.64828, 34.12958], [-118.64857, 34.12955], [-118.6485, 34.12907], [-118.64877, 34.12907], [-118.64887, 34.12969], [-118.64895, 34.12981]]], [[[-118.64944, 34.13051], [-118.64912, 34.13073], [-118.64901, 34.13071], [-118.64871, 34.1304], [-118.64861, 34.13016], [-118.64849, 34.13008], [-118.64898, 34.12985], [-118.64944, 34.13051]]], [[[-118.64947, 34.12956], [-118.649, 34.12979], [-118.64892, 34.12968], [-118.64883, 34.12907], [-118.6494, 34.12907], [-118.64947, 34.12956]]], [[[-118.64997, 34.13028], [-118.64972, 34.13037], [-118.64949, 34.13048], [-118.64903, 34.12983], [-118.6495, 34.1296], [-118.64997, 34.13028]]], [[[-118.65, 34.12907], [-118.64999, 34.12924], [-118.64997, 34.1302], [-118.64953, 34.12955], [-118.64945, 34.12907], [-118.65, 34.12907]]]]} | Open Access 1 | 12478 | Unnamed site - Mountains Recreation and Conservation Authority | 29458 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 4.915 | 0 | Local Other or Unknown 14 | 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]);