units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
25 rows where DES_TP = 2 and MNG_AGENCY = 12 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Conejo Recreation and Park District · 25 ✖
DES_TP 1
- Local Park · 25 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18 | 18 | 17 | {"type": "Polygon", "coordinates": [[[-118.95325, 34.18233], [-118.94954, 34.18265], [-118.94921, 34.18001], [-118.94982, 34.17958], [-118.95014, 34.17942], [-118.95045, 34.17932], [-118.95086, 34.17926], [-118.95165, 34.17922], [-118.9523, 34.17926], [-118.95325, 34.18233]]]} | Open Access 1 | 58 | Borchard Park | 16277 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 27.263 | Borchard Park | 0 | Local Park 2 | 4 | |
358 | 358 | 357 | {"type": "Polygon", "coordinates": [[[-118.84164, 34.14351], [-118.84162, 34.14361], [-118.84153, 34.1437], [-118.84153, 34.14379], [-118.84163, 34.14385], [-118.84147, 34.14417], [-118.84155, 34.14456], [-118.8412, 34.14464], [-118.84027, 34.14465], [-118.83984, 34.1442], [-118.83987, 34.14412], [-118.84004, 34.14402], [-118.84058, 34.14361], [-118.84113, 34.14306], [-118.84128, 34.14315], [-118.84155, 34.14336], [-118.84164, 34.14351]]]} | Open Access 1 | 1009 | Southshore Hills Park | 25696 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.475 | Southshore Hills Park | 0 | Local Park 2 | 4 | |
303 | 303 | 302 | {"type": "Polygon", "coordinates": [[[-118.87425, 34.22586], [-118.87258, 34.2261], [-118.87258, 34.22433], [-118.87408, 34.22434], [-118.87409, 34.22539], [-118.87418, 34.22551], [-118.87425, 34.22586]]]} | Open Access 1 | 1040 | Spring Meadow Park | 25741 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.467 | Spring Meadow Park | 0 | Local Park 2 | 4 | |
368 | 368 | 367 | {"type": "Polygon", "coordinates": [[[-118.91305, 34.18088], [-118.91256, 34.18067], [-118.912, 34.18037], [-118.91123, 34.18041], [-118.91136, 34.17666], [-118.91295, 34.17687], [-118.91305, 34.18088]]]} | Open Access 1 | 1056 | Stagecoach Inn Park | 25777 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 16.214 | Stagecoach Inn Park | 0 | Local Park 2 | 4 | |
6157 | 6157 | 6156 | {"type": "Polygon", "coordinates": [[[-118.88711, 34.21497], [-118.88689, 34.21498], [-118.88666, 34.21501], [-118.88646, 34.21506], [-118.88596, 34.2153], [-118.88574, 34.21535], [-118.88576, 34.21449], [-118.88637, 34.21451], [-118.88663, 34.21455], [-118.88693, 34.21469], [-118.88707, 34.21482], [-118.88711, 34.21497]]]} | Open Access 1 | 1170 | Suburbia Park | 25941 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 1.891 | Suburbia Park | 0 | Local Park 2 | 4 | |
6200 | 6200 | 6199 | {"type": "Polygon", "coordinates": [[[-118.84264, 34.22414], [-118.84277, 34.2245], [-118.84284, 34.22504], [-118.8428, 34.22545], [-118.84258, 34.22591], [-118.84137, 34.22564], [-118.84038, 34.22537], [-118.84049, 34.22512], [-118.84112, 34.2251], [-118.84156, 34.22492], [-118.84187, 34.22457], [-118.84223, 34.22426], [-118.84264, 34.22414]]]} | Open Access 1 | 1240 | Sunset Hills Park | 26049 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.612 | Sunset Hills Park | 0 | Local Park 2 | 4 | |
450 | 450 | 449 | {"type": "Polygon", "coordinates": [[[-118.84969, 34.15691], [-118.84861, 34.15729], [-118.8484, 34.15705], [-118.84823, 34.15692], [-118.8481, 34.15686], [-118.84745, 34.15669], [-118.8474, 34.15675], [-118.84724, 34.15671], [-118.84701, 34.15669], [-118.84647, 34.15673], [-118.84613, 34.15674], [-118.84609, 34.15669], [-118.84529, 34.15636], [-118.84513, 34.15634], [-118.84475, 34.15615], [-118.84455, 34.15601], [-118.84392, 34.15522], [-118.84377, 34.15509], [-118.84351, 34.15491], [-118.84278, 34.1546], [-118.84282, 34.15435], [-118.84282, 34.15411], [-118.84286, 34.15404], [-118.84303, 34.154], [-118.84331, 34.15383], [-118.84351, 34.15362], [-118.84361, 34.1534], [-118.8436, 34.15311], [-118.84357, 34.15296], [-118.84413, 34.15317], [-118.84731, 34.15444], [-118.84968, 34.15512], [-118.84969, 34.15691]]]} | Open Access 1 | 1427 | Triunfo Park | 7237 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.lamountains.com/parks.asp?parkid=62 | Ventura 8 | 38.958 | Triunfo Park | 0 | Local Park 2 | 4 |
5733 | 5733 | 5732 | {"type": "Polygon", "coordinates": [[[-118.889, 34.19027], [-118.88799, 34.19209], [-118.88636, 34.19336], [-118.88457, 34.19262], [-118.88288, 34.19236], [-118.88275, 34.19202], [-118.88268, 34.19161], [-118.88253, 34.19161], [-118.88252, 34.19146], [-118.88264, 34.1915], [-118.88284, 34.19119], [-118.88317, 34.19133], [-118.88578, 34.19087], [-118.88625, 34.18977], [-118.88788, 34.18977], [-118.88858, 34.18921], [-118.88873, 34.18936], [-118.88887, 34.18964], [-118.88894, 34.19005], [-118.889, 34.19027]]]} | Open Access 1 | 1649 | California Botanic Garden | 16686 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 32.578 | California Botanic Garden | 0 | Local Park 2 | 4 | |
540 | 540 | 539 | {"type": "Polygon", "coordinates": [[[-118.8993, 34.1842], [-118.89897, 34.18424], [-118.89814, 34.18437], [-118.89767, 34.18434], [-118.89715, 34.18448], [-118.89638, 34.18443], [-118.89611, 34.18408], [-118.89593, 34.18404], [-118.89683, 34.18341], [-118.8969, 34.18346], [-118.89768, 34.18368], [-118.89819, 34.18346], [-118.89872, 34.18292], [-118.89889, 34.18303], [-118.89887, 34.18356], [-118.8993, 34.1842]]]} | Open Access 1 | 1801 | Walnut Grove Park | 27233 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.623 | Walnut Grove Park | 0 | Local Park 2 | 4 | |
547 | 547 | 546 | {"type": "Polygon", "coordinates": [[[-118.85957, 34.20397], [-118.85928, 34.20419], [-118.85956, 34.20468], [-118.85943, 34.20577], [-118.85902, 34.20577], [-118.85882, 34.2057], [-118.85753, 34.20575], [-118.85776, 34.20423], [-118.85881, 34.20412], [-118.85882, 34.20405], [-118.85957, 34.20397]]]} | Open Access 1 | 1822 | Waverly Park | 27320 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 7.419 | Waverly Park | 0 | Local Park 2 | 4 | |
4242 | 4242 | 4241 | {"type": "Polygon", "coordinates": [[[-118.94369, 34.16333], [-118.94355, 34.16348], [-118.94315, 34.16401], [-118.94287, 34.16382], [-118.94286, 34.16377], [-118.94279, 34.16371], [-118.9427, 34.1637], [-118.94262, 34.16372], [-118.94225, 34.1635], [-118.94154, 34.16295], [-118.94176, 34.16283], [-118.94193, 34.16276], [-118.94216, 34.1627], [-118.94291, 34.16259], [-118.94299, 34.16255], [-118.94306, 34.16249], [-118.94351, 34.16271], [-118.94365, 34.16329], [-118.94369, 34.16333]]]} | Open Access 1 | 1828 | Wendy Park | 27346 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.537 | Wendy Park | 0 | Local Park 2 | 4 | |
7852 | 7852 | 7851 | {"type": "Polygon", "coordinates": [[[-118.88693, 34.1936], [-118.88605, 34.19425], [-118.88556, 34.19474], [-118.88529, 34.19526], [-118.88504, 34.19557], [-118.88467, 34.19583], [-118.88431, 34.19598], [-118.8841, 34.19575], [-118.88457, 34.19548], [-118.88322, 34.19378], [-118.88286, 34.19373], [-118.8822, 34.19458], [-118.88163, 34.19428], [-118.87974, 34.19429], [-118.87942, 34.19353], [-118.87967, 34.19336], [-118.87947, 34.1931], [-118.87883, 34.19284], [-118.87883, 34.19248], [-118.87846, 34.19222], [-118.87706, 34.19211], [-118.8771, 34.19192], [-118.87688, 34.19167], [-118.87658, 34.19161], [-118.8762, 34.19174], [-118.8758, 34.19176], [-118.8758, 34.1912], [-118.87655, 34.19114], [-118.87705, 34.19087], [-118.8775, 34.19095], [-118.87799, 34.19092], [-118.87834, 34.19115], [-118.87874, 34.19139], [-118.87875, 34.19143], [-118.87921, 34.19158], [-118.87955, 34.19163], [-118.87983, 34.19158], [-118.88013, 34.19136], [-118.88139, 34.19171], [-118.88198, 34.19221], [-118.88275, 34.19202], [-118.88288, 34.19236], [-118.88457, 34.19262], [-118.88693, 34.1936]]]} | Open Access 1 | 9395 | Conejo Community Park | 17582 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 48.818 | Conejo Community Park | 0 | Local Park 2 | 4 | |
7550 | 7550 | 7549 | {"type": "MultiPolygon", "coordinates": [[[[-118.85586, 34.20075], [-118.85552, 34.20133], [-118.85456, 34.2024], [-118.85365, 34.20308], [-118.85249, 34.20389], [-118.85159, 34.20457], [-118.85081, 34.20525], [-118.85077, 34.19982], [-118.85142, 34.19948], [-118.85273, 34.19968], [-118.85277, 34.19964], [-118.85267, 34.20015], [-118.85226, 34.20012], [-118.8518, 34.20047], [-118.85212, 34.20082], [-118.85285, 34.20081], [-118.85351, 34.20135], [-118.85417, 34.20118], [-118.85464, 34.20079], [-118.85586, 34.20075]]], [[[-118.85721, 34.20575], [-118.85509, 34.20574], [-118.85147, 34.20573], [-118.85154, 34.20564], [-118.85523, 34.20494], [-118.85566, 34.20491], [-118.85631, 34.20503], [-118.85682, 34.20528], [-118.85709, 34.20552], [-118.85721, 34.20575]]], [[[-118.86101, 34.19934], [-118.85883, 34.20094], [-118.85882, 34.20405], [-118.85776, 34.20424], [-118.85753, 34.20575], [-118.85723, 34.20543], [-118.85691, 34.20516], [-118.85651, 34.20495], [-118.85607, 34.20482], [-118.85547, 34.20478], [-118.85487, 34.20487], [-118.85169, 34.20547], [-118.85207, 34.20509], [-118.85256, 34.20466], [-118.85313, 34.20426], [-118.85521, 34.20285], [-118.85566, 34.20252], [-118.85651, 34.20187], [-118.85698, 34.20162], [-118.85729, 34.20149], [-118.8577, 34.20126], [-118.85817, 34.20096], [-118.85837, 34.20066], [-118.85836, 34.20007], [-118.85885, 34.1999], [-118.85944, 34.19962], [-118.86002, 34.1994], [-118.86059, 34.19933], [-118.86101, 34.19934]]], [[[-118.8615, 34.1907], [-118.86119, 34.19173], [-118.86094, 34.19248], [-118.86051, 34.19346], [-118.86006, 34.19432], [-118.85888, 34.19626], [-118.85762, 34.19789], [-118.8572, 34.19823], [-118.85668, 34.19851], [-118.85425, 34.19659], [-118.85835, 34.19274], [-118.85903, 34.19214], [-118.85913, 34.19222], [-118.85934, 34.19244], [-118.85974, 34.19206], [-118.86069, 34.19132], [-118.86118, 34.19088], [-118.8615, 34.1907]]], [[[-118.8644, 34.18775], [-118.86422, 34.18815], [-118.86408, 34.18915], [-118.86378, 34.18964], [-118.8633, 34.19], [-118.86264, 34.19021], [-118.86273, 34.18989], [-118.86282, 34.18946], [-118.8629, 34.18846], [-118.86282, 34.18775], [-118.8644, 34.18775]]], [[[-118.86575, 34.18907], [-118.86462, 34.19003], [-118.86325, 34.19042], [-118.86319, 34.19031], [-118.86357, 34.19012], [-118.86395, 34.18983], [-118.86423, 34.18947], [-118.86442, 34.18897], [-118.86446, 34.18838], [-118.86455, 34.18804], [-118.86473, 34.18775], [-118.86563, 34.18775], [-118.86575, 34.18907]]]]} | Open Access 1 | 9515 | Conejo Creek Park | 17583 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 149.713 | Conejo Creek Park | 0 | Local Park 2 | 4 | |
8575 | 8575 | 8574 | {"type": "Polygon", "coordinates": [[[-118.98597, 34.17405], [-118.98534, 34.17429], [-118.98482, 34.17571], [-118.98465, 34.17578], [-118.98442, 34.17624], [-118.98432, 34.17615], [-118.98419, 34.17613], [-118.98406, 34.17619], [-118.984, 34.17629], [-118.98401, 34.17641], [-118.98362, 34.1773], [-118.98345, 34.17755], [-118.98315, 34.17745], [-118.98276, 34.17726], [-118.98181, 34.17667], [-118.98116, 34.17623], [-118.98143, 34.1758], [-118.98156, 34.17552], [-118.98164, 34.17528], [-118.98169, 34.17509], [-118.98172, 34.17484], [-118.98172, 34.17429], [-118.98175, 34.17397], [-118.98229, 34.17391], [-118.98262, 34.17385], [-118.98302, 34.17375], [-118.98333, 34.17366], [-118.9837, 34.17351], [-118.98445, 34.17315], [-118.9849, 34.17297], [-118.98522, 34.17335], [-118.98538, 34.17351], [-118.98564, 34.17371], [-118.98595, 34.1739], [-118.98597, 34.17405]]]} | Open Access 1 | 13609 | Dos Vientos Community Park | 18231 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 29.335 | Dos Vientos Community Park | 0 | Local Park 2 | 4 | |
1608 | 1608 | 1607 | {"type": "Polygon", "coordinates": [[[-118.98067, 34.15665], [-118.98043, 34.15685], [-118.97905, 34.15751], [-118.97881, 34.15752], [-118.97855, 34.15748], [-118.97839, 34.15782], [-118.97816, 34.15771], [-118.97809, 34.1576], [-118.97801, 34.15756], [-118.97793, 34.15755], [-118.97789, 34.15752], [-118.97777, 34.15737], [-118.97769, 34.15723], [-118.97762, 34.15702], [-118.97761, 34.15655], [-118.98042, 34.15656], [-118.98067, 34.15665]]]} | Open Access 1 | 13637 | Dos Vientos Neighborhood Park | 18232 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 5.87 | Dos Vientos Neighborhood Park | 0 | Local Park 2 | 4 | |
1827 | 1827 | 1826 | {"type": "Polygon", "coordinates": [[[-118.84808, 34.18053], [-118.84789, 34.18078], [-118.84725, 34.18056], [-118.84696, 34.18068], [-118.84674, 34.18092], [-118.84648, 34.1808], [-118.84699, 34.18001], [-118.84808, 34.18053]]]} | Open Access 1 | 15708 | Estella Park | 18723 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 1.604 | Estella Park | 0 | Local Park 2 | 4 | |
9385 | 9385 | 9384 | {"type": "Polygon", "coordinates": [[[-118.83634, 34.15327], [-118.83465, 34.1532], [-118.83495, 34.15262], [-118.83501, 34.15232], [-118.835, 34.15207], [-118.8353, 34.15199], [-118.8356, 34.15199], [-118.83615, 34.15185], [-118.83612, 34.15261], [-118.83634, 34.15327]]]} | Open Access 1 | 15730 | Evenstar Park | 18760 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.108 | Evenstar Park | 0 | Local Park 2 | 4 | |
9819 | 9819 | 9818 | {"type": "Polygon", "coordinates": [[[-118.96149, 34.16087], [-118.96122, 34.1609], [-118.96066, 34.16092], [-118.96027, 34.16088], [-118.9604, 34.15998], [-118.96022, 34.15978], [-118.96016, 34.15962], [-118.9605, 34.1595], [-118.96059, 34.1595], [-118.96074, 34.15945], [-118.96081, 34.15937], [-118.96082, 34.15923], [-118.96079, 34.15912], [-118.96071, 34.15906], [-118.96068, 34.15899], [-118.96091, 34.15887], [-118.96094, 34.15889], [-118.96111, 34.15883], [-118.96149, 34.1606], [-118.96149, 34.16087]]]} | Open Access 1 | 16853 | Hickory Park | 19898 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 4.494 | Hickory Park | 0 | Local Park 2 | 4 | |
2022 | 2022 | 2021 | {"type": "Polygon", "coordinates": [[[-118.95258, 34.15965], [-118.95191, 34.15988], [-118.95174, 34.15957], [-118.9516, 34.15941], [-118.95136, 34.15924], [-118.95118, 34.15915], [-118.95127, 34.15911], [-118.95136, 34.15904], [-118.95142, 34.15891], [-118.95142, 34.15885], [-118.95126, 34.15851], [-118.95089, 34.15712], [-118.94997, 34.15676], [-118.94971, 34.15665], [-118.94978, 34.15661], [-118.95097, 34.15694], [-118.95211, 34.15752], [-118.95204, 34.15762], [-118.95258, 34.15965]]]} | Open Access 1 | 17010 | Banyan Park | 15803 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 6.96 | Banyan Park | 0 | Local Park 2 | 4 | |
2354 | 2354 | 2353 | {"type": "Polygon", "coordinates": [[[-118.94699, 34.17408], [-118.94513, 34.17507], [-118.94487, 34.17473], [-118.9438, 34.17365], [-118.9441, 34.17336], [-118.94427, 34.17341], [-118.94451, 34.17344], [-118.94473, 34.17342], [-118.9456, 34.1733], [-118.94577, 34.17331], [-118.94592, 34.17334], [-118.94611, 34.17343], [-118.94631, 34.17355], [-118.94646, 34.1736], [-118.94669, 34.17364], [-118.9469, 34.17363], [-118.94699, 34.17408]]]} | Open Access 1 | 17105 | Kimber Park | 20647 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 8.259 | Kimber 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]);