units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where DES_TP = 3 and MNG_AGENCY = 100 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME, YR_EST
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 24
MNG_AGENCY 1
- Glendale, City of · 24 ✖
DES_TP 1
- Local Recreation Area · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1269 | 1269 | 1268 | {"type": "Polygon", "coordinates": [[[-118.26461, 34.17807], [-118.26461, 34.17807], [-118.26442, 34.17818], [-118.2644, 34.17805], [-118.26441, 34.17804], [-118.26459, 34.17797], [-118.26461, 34.17807]]]} | Open Access 1 | 7148 | City of Glendale Verdugo Mountains Open Space | 4153 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.061 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
16937 | 16937 | 16936 | {"type": "Polygon", "coordinates": [[[-118.26513, 34.17801], [-118.26487, 34.17804], [-118.26484, 34.17792], [-118.2651, 34.1779], [-118.26513, 34.17801]]]} | Open Access 1 | 7149 | City of Glendale Verdugo Mountains Open Space | 4153 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.075 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
7635 | 7635 | 7634 | {"type": "Polygon", "coordinates": [[[-118.25546, 34.22082], [-118.25537, 34.22087], [-118.25538, 34.22104], [-118.25521, 34.22098], [-118.25528, 34.22083], [-118.25519, 34.2208], [-118.25539, 34.2207], [-118.25546, 34.22082]]]} | Open Access 1 | 7155 | City of Glendale Verdugo Mountains Open Space | 4153 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.115 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
7634 | 7634 | 7633 | {"type": "Polygon", "coordinates": [[[-118.25521, 34.22126], [-118.25496, 34.22127], [-118.25483, 34.22122], [-118.25495, 34.22109], [-118.25521, 34.22114], [-118.25521, 34.22126]]]} | Open Access 1 | 7154 | City of Glendale Verdugo Mountains Open Space | 4153 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.128 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
16894 | 16894 | 16893 | {"type": "Polygon", "coordinates": [[[-118.25507, 34.22173], [-118.25501, 34.22183], [-118.25501, 34.22186], [-118.25476, 34.22188], [-118.25472, 34.22164], [-118.25499, 34.2216], [-118.25501, 34.22174], [-118.25507, 34.22173]]]} | Open Access 1 | 7153 | City of Glendale Verdugo Mountains Open Space | 4153 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.178 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
16967 | 16967 | 16966 | {"type": "Polygon", "coordinates": [[[-118.25611, 34.22203], [-118.2561, 34.22216], [-118.25605, 34.22218], [-118.25594, 34.22219], [-118.25582, 34.22216], [-118.25578, 34.22213], [-118.25573, 34.22206], [-118.25573, 34.22201], [-118.25577, 34.22187], [-118.25583, 34.22183], [-118.2559, 34.22181], [-118.25601, 34.22182], [-118.25607, 34.22186], [-118.25611, 34.22198], [-118.25611, 34.22203]]]} | Open Access 1 | 7152 | City of Glendale Verdugo Mountains Open Space | 4153 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.299 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
15294 | 15294 | 15293 | {"type": "Polygon", "coordinates": [[[-118.23026, 34.16966], [-118.23015, 34.16981], [-118.2301, 34.16985], [-118.23004, 34.16995], [-118.22998, 34.16996], [-118.2299, 34.16992], [-118.22991, 34.16982], [-118.22989, 34.16978], [-118.22982, 34.16973], [-118.22962, 34.1697], [-118.22975, 34.16956], [-118.2298, 34.16948], [-118.23026, 34.16966]]]} | Restricted Access 2 | 46426 | Verdugo Skate Park | 29697 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/verdugo-skate-park | Los Angeles 6 | 0.355 | Verdugo Skate Park | 2004 | Local Recreation Area 3 | 4 |
4394 | 4394 | 4393 | {"type": "Polygon", "coordinates": [[[-118.23041, 34.19871], [-118.23092, 34.19917], [-118.23092, 34.19922], [-118.23089, 34.19923], [-118.23031, 34.19921], [-118.23026, 34.19919], [-118.23025, 34.19914], [-118.23034, 34.19874], [-118.23037, 34.19871], [-118.23041, 34.19871]]]} | Restricted Access 2 | 46024 | Sparr Heights Community Center | 29349 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/sparr-heights-community-center | Los Angeles 6 | 0.504 | Sparr Heights Community Ctr. | 0 | Local Recreation Area 3 | 4 |
1243 | 1243 | 1242 | {"type": "Polygon", "coordinates": [[[-118.25098, 34.17212], [-118.25095, 34.17243], [-118.25087, 34.17251], [-118.25076, 34.17252], [-118.25042, 34.17245], [-118.25036, 34.17242], [-118.25034, 34.17238], [-118.25034, 34.17208], [-118.2503, 34.17197], [-118.25018, 34.17186], [-118.24999, 34.1718], [-118.24996, 34.17176], [-118.25, 34.17174], [-118.2503, 34.17172], [-118.25062, 34.1719], [-118.25084, 34.17211], [-118.25098, 34.17212]]]} | Open Access 1 | 7146 | City of Glendale Open Space | 17315 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 0.988 | City of Glendale OS | 0 | Local Recreation Area 3 | 4 | |
1268 | 1268 | 1267 | {"type": "Polygon", "coordinates": [[[-118.25078, 34.1714], [-118.25076, 34.17144], [-118.25067, 34.17152], [-118.25055, 34.17158], [-118.24999, 34.17163], [-118.24993, 34.17162], [-118.24985, 34.17158], [-118.24975, 34.17141], [-118.25004, 34.17087], [-118.25034, 34.17093], [-118.25056, 34.17087], [-118.25078, 34.17138], [-118.25078, 34.1714]]]} | Open Access 1 | 7144 | City of Glendale Open Space | 17315 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 1.454 | City of Glendale OS | 0 | Local Recreation Area 3 | 4 | |
16947 | 16947 | 16946 | {"type": "MultiPolygon", "coordinates": [[[[-118.25672, 34.22182], [-118.25668, 34.22188], [-118.25664, 34.22198], [-118.2566, 34.22203], [-118.25639, 34.2213], [-118.25648, 34.22117], [-118.25649, 34.22109], [-118.25642, 34.22099], [-118.25636, 34.22096], [-118.25629, 34.22095], [-118.25619, 34.22057], [-118.25626, 34.22051], [-118.2563, 34.22056], [-118.25635, 34.22057], [-118.25666, 34.22162], [-118.25657, 34.22176], [-118.25659, 34.22177], [-118.25667, 34.22165], [-118.25672, 34.22182]]], [[[-118.25635, 34.22055], [-118.25629, 34.22052], [-118.2563, 34.22046], [-118.25626, 34.2205], [-118.25614, 34.22037], [-118.25612, 34.22026], [-118.25623, 34.22012], [-118.25626, 34.22011], [-118.25626, 34.22008], [-118.25653, 34.21972], [-118.2566, 34.21988], [-118.25639, 34.22017], [-118.25627, 34.22012], [-118.25626, 34.22013], [-118.25626, 34.2203], [-118.25628, 34.22032], [-118.25632, 34.22042], [-118.25631, 34.22044], [-118.25635, 34.22055]]], [[[-118.25642, 34.22109], [-118.25641, 34.22115], [-118.25637, 34.22122], [-118.25631, 34.22102], [-118.25637, 34.22103], [-118.25642, 34.22109]]], [[[-118.2574, 34.22379], [-118.2572, 34.2237], [-118.25679, 34.22242], [-118.25673, 34.22244], [-118.25662, 34.2221], [-118.2567, 34.22201], [-118.25674, 34.22191], [-118.25681, 34.22216], [-118.25672, 34.22224], [-118.25673, 34.22224], [-118.25682, 34.22219], [-118.25687, 34.22236], [-118.25694, 34.22235], [-118.25695, 34.22236], [-118.2574, 34.22379]], [[-118.25671, 34.22225], [-118.2567, 34.22224], [-118.25668, 34.22226], [-118.2567, 34.22227], [-118.25671, 34.22225]]]]} | Open Access 1 | 7151 | City of Glendale Verdugo Mountains Open Space | 4153 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 1.571 | City of Glendale Verdugo Mtns. OS | 0 | Local Recreation Area 3 | 4 | |
15166 | 15166 | 15165 | {"type": "Polygon", "coordinates": [[[-118.22889, 34.17235], [-118.22885, 34.17311], [-118.22852, 34.17309], [-118.22846, 34.17311], [-118.2284, 34.17322], [-118.22786, 34.17311], [-118.22818, 34.17231], [-118.22889, 34.17235]]]} | Open Access 1 | 46053 | Babe Herman Little League Field | 29382 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/babe-herman-little-league-field-photos#ad-image-1 | Los Angeles 6 | 1.758 | Babe Herman Little League Field | 0 | Local Recreation Area 3 | 4 |
5228 | 5228 | 5227 | {"type": "Polygon", "coordinates": [[[-118.25429, 34.14353], [-118.25348, 34.14354], [-118.25269, 34.14354], [-118.25268, 34.14271], [-118.25429, 34.14269], [-118.25429, 34.14353]]]} | Open Access 1 | 1047 | Central Park & Adult Recreation Center | 29376 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 3.389 | Central Park & Adult Rec. Ctr. | 0 | Local Recreation Area 3 | 4 | |
921 | 921 | 920 | {"type": "Polygon", "coordinates": [[[-118.24617, 34.13854], [-118.24617, 34.13892], [-118.24479, 34.13892], [-118.24396, 34.13894], [-118.24396, 34.13817], [-118.24548, 34.13816], [-118.24548, 34.13854], [-118.24617, 34.13854]]]} | Open Access 1 | 5095 | Maple Park & Community Center | 29370 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/maple-park-and-community-center | Los Angeles 6 | 3.583 | Maple Park & Community Ctr. | 0 | Local Recreation Area 3 | 4 |
15179 | 15179 | 15178 | {"type": "Polygon", "coordinates": [[[-118.2315, 34.16842], [-118.23133, 34.16937], [-118.23121, 34.16952], [-118.23103, 34.1697], [-118.22982, 34.1692], [-118.23013, 34.16875], [-118.23049, 34.16829], [-118.2315, 34.16842]]]} | Open Access 1 | 46050 | Stengel Field | 29377 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/stengel-field- | Los Angeles 6 | 3.852 | Stengel Field | 0 | Local Recreation Area 3 | 4 |
1034 | 1034 | 1033 | {"type": "MultiPolygon", "coordinates": [[[[-118.23666, 34.17567], [-118.23647, 34.17586], [-118.23619, 34.17567], [-118.23572, 34.17578], [-118.23554, 34.17587], [-118.23499, 34.17561], [-118.23476, 34.17536], [-118.23454, 34.17541], [-118.23446, 34.17549], [-118.234, 34.17501], [-118.23397, 34.17453], [-118.23454, 34.17416], [-118.23381, 34.17346], [-118.23415, 34.17304], [-118.23413, 34.17291], [-118.23421, 34.17251], [-118.2343, 34.17251], [-118.23447, 34.17271], [-118.23477, 34.17283], [-118.23504, 34.17279], [-118.23504, 34.17283], [-118.23508, 34.17287], [-118.23516, 34.17287], [-118.23518, 34.17285], [-118.23524, 34.17296], [-118.23558, 34.17323], [-118.23509, 34.17382], [-118.23608, 34.17433], [-118.23613, 34.17509], [-118.23627, 34.17509], [-118.23633, 34.1751], [-118.23648, 34.17532], [-118.23654, 34.17532], [-118.23656, 34.17545], [-118.2366, 34.17554], [-118.23666, 34.17561], [-118.23666, 34.17567]]], [[[-118.23693, 34.17586], [-118.23692, 34.17586], [-118.23663, 34.17592], [-118.23676, 34.17579], [-118.23693, 34.17586]]]]} | Open Access 1 | 6844 | Bachman Open Space | 15749 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 12.374 | Bachman OS | 0 | Local Recreation Area 3 | 4 | |
15184 | 15184 | 15183 | {"type": "Polygon", "coordinates": [[[-118.21676, 34.18598], [-118.21615, 34.18605], [-118.21606, 34.18604], [-118.21594, 34.18601], [-118.21577, 34.18589], [-118.21569, 34.18587], [-118.21468, 34.18586], [-118.21455, 34.18584], [-118.21422, 34.18577], [-118.21372, 34.18562], [-118.21345, 34.18547], [-118.21323, 34.18524], [-118.21319, 34.18516], [-118.21317, 34.18508], [-118.21317, 34.18484], [-118.21324, 34.18447], [-118.21326, 34.18442], [-118.21334, 34.18433], [-118.21351, 34.18426], [-118.21387, 34.18423], [-118.21418, 34.18423], [-118.21444, 34.18419], [-118.21456, 34.18413], [-118.21467, 34.18401], [-118.21469, 34.18394], [-118.21467, 34.18386], [-118.21453, 34.1837], [-118.21447, 34.18358], [-118.21443, 34.18348], [-118.21445, 34.18333], [-118.21437, 34.18325], [-118.2143, 34.18308], [-118.2144, 34.18281], [-118.21454, 34.18278], [-118.21471, 34.18279], [-118.21479, 34.18276], [-118.21488, 34.18275], [-118.21494, 34.18267], [-118.21506, 34.18245], [-118.21572, 34.18256], [-118.21598, 34.18262], [-118.21675, 34.18296], [-118.21652, 34.18393], [-118.21612, 34.18543], [-118.21618, 34.18581], [-118.21675, 34.18577], [-118.21676, 34.18598]]]} | Open Access 1 | 46054 | Glendale Sports Complex | 29383 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/departments/community-services-parks/parks-facilities-historic-sites/glendale-sports-complex- | Los Angeles 6 | 20.652 | Glendale Sports Complex | 0 | Local Recreation Area 3 | 4 |
16063 | 16063 | 16062 | {"type": "Polygon", "coordinates": [[[-118.23087, 34.16093], [-118.23078, 34.16105], [-118.22958, 34.16278], [-118.22894, 34.16302], [-118.22873, 34.16373], [-118.22842, 34.16373], [-118.22791, 34.16331], [-118.22731, 34.16373], [-118.22598, 34.16374], [-118.2267, 34.16336], [-118.2267, 34.16285], [-118.22667, 34.16102], [-118.22667, 34.15986], [-118.22913, 34.16014], [-118.22914, 34.16062], [-118.23075, 34.16075], [-118.23087, 34.16093]]]} | Open Access 1 | 6949 | Polygon Open Space | 23876 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 28.497 | Polygon OS | 0 | Local Recreation Area 3 | 4 | |
1205 | 1205 | 1204 | {"type": "Polygon", "coordinates": [[[-118.20232, 34.16387], [-118.20106, 34.1656], [-118.19947, 34.16766], [-118.19941, 34.16746], [-118.19749, 34.16476], [-118.19693, 34.16344], [-118.19696, 34.1634], [-118.19691, 34.16337], [-118.19799, 34.1627], [-118.19908, 34.16182], [-118.19934, 34.16179], [-118.19954, 34.16174], [-118.20232, 34.16387]]]} | Open Access 1 | 6952 | Poulsen Open Space | 23929 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 42.171 | Poulsen OS | 0 | Local Recreation Area 3 | 4 | |
16065 | 16065 | 16064 | {"type": "Polygon", "coordinates": [[[-118.20902, 34.1575], [-118.20902, 34.15757], [-118.20898, 34.15769], [-118.20885, 34.15784], [-118.20874, 34.15791], [-118.20861, 34.15796], [-118.2084, 34.15798], [-118.20828, 34.15795], [-118.20816, 34.15791], [-118.20768, 34.15755], [-118.2075, 34.15744], [-118.20731, 34.15737], [-118.20703, 34.15732], [-118.20676, 34.15734], [-118.2065, 34.15739], [-118.20622, 34.15755], [-118.20604, 34.15774], [-118.20594, 34.15791], [-118.20432, 34.15731], [-118.20393, 34.15731], [-118.20386, 34.1581], [-118.20379, 34.15814], [-118.20381, 34.15872], [-118.20384, 34.15885], [-118.20366, 34.15889], [-118.20361, 34.15821], [-118.20344, 34.15779], [-118.20279, 34.15761], [-118.20282, 34.15819], [-118.20109, 34.15797], [-118.2004, 34.15772], [-118.20004, 34.15771], [-118.19992, 34.15761], [-118.19978, 34.1576], [-118.19957, 34.15728], [-118.19928, 34.15707], [-118.19849, 34.15663], [-118.19798, 34.1561], [-118.19777, 34.15584], [-118.19729, 34.15491], [-118.19718, 34.15464], [-118.19706, 34.15442], [-118.19702, 34.15407], [-118.19724, 34.154], [-118.19743, 34.15403], [-118.19753, 34.154], [-118.19759, 34.15394], [-118.19761, 34.15389], [-118.19762, 34.15365], [-118.19765, 34.15361], [-118.19774, 34.15356], [-118.19779, 34.15356], [-118.19805, 34.15366], [-118.19832, 34.15365], [-118.19855, 34.15524], [-118.199, 34.15505], [-118.20061, 34.15486], [-118.20057, 34.15516], [-118.20107, 34.15532], [-118.20172, 34.15436], [-118.20227, 34.15441], [-118.20238, 34.15443], [-118.20248, 34.15458], [-118.2026, 34.15471], [-118.20272, 34.15481], [-118.20294, 34.15493], [-118.20316, 34.15502], [-118.2041, 34.15525], [-118.20433, 34.15533], [-118.20456, 34.15551], [-118.20494, 34.15604], [-118.20512, 34.15622], [-118.20526, 34.15634], [-118.20546, 34.15646], [-118.20572, 34.15658], [-118.20581, 34.1566], [-118.20594, 34.15665], [-118.20629, 34.15669], [-118.20661, 34.15668], [-118.20805, 34.15648], [-118.20822, 34.15649], [-118.20832, 34.15651], [-118.20841, 34.15654], [-118.20856, 34.15665], [-118.20867, 34.15679], [-118.20896, 34.15726], [-118.20902, 34.1575]]]} | Open Access 1 | 6954 | Lower Scholl Canyon Open Space | 29374 | 1119 | Glendale, City of 103 | City 2 | City Agency 2 | http://www.glendaleca.gov/government/city-departments/community-services-parks | City 2 | 1119 | Glendale, City of 100 | City 2 | City Agency 2 | Los Angeles 6 | 61.043 | Lower Scholl Canyon 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]);