units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
57 rows where MNG_AGENCY = 42
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Other or Unknown 20
- Local Park 8
- Local Recreation Area 3
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 37
MNG_AGENCY 1
- Encinitas, City of · 37 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6249 | 6249 | 6248 | {"type": "MultiPolygon", "coordinates": [[[[-117.28398, 33.03442], [-117.28166, 33.03455], [-117.28165, 33.03474], [-117.28129, 33.03475], [-117.28081, 33.03422], [-117.28023, 33.03329], [-117.27949, 33.03238], [-117.2791, 33.03201], [-117.27911, 33.03199], [-117.27912, 33.03168], [-117.27912, 33.0313], [-117.27856, 33.03131], [-117.27778, 33.03006], [-117.27734, 33.02908], [-117.27734, 33.02899], [-117.2791, 33.02898], [-117.27911, 33.02902], [-117.27912, 33.02989], [-117.28088, 33.02986], [-117.28107, 33.02987], [-117.28164, 33.03032], [-117.28164, 33.03258], [-117.28272, 33.03258], [-117.28276, 33.03281], [-117.28378, 33.03278], [-117.28377, 33.03312], [-117.28378, 33.03345], [-117.28398, 33.03442]]], [[[-117.28379, 33.0324], [-117.28271, 33.03241], [-117.28264, 33.03161], [-117.28377, 33.0316], [-117.28379, 33.03181], [-117.28379, 33.0324]]]]} | Open Access 1 | 1338 | Encinitas Community Park | 29087 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 43.17 | Encinitas Community Park | 0 | Local Park 2 | 4 |
6586 | 6586 | 6585 | {"type": "Polygon", "coordinates": [[[-117.26461, 33.06108], [-117.26455, 33.06117], [-117.26448, 33.0613], [-117.26387, 33.06304], [-117.26366, 33.06348], [-117.26361, 33.0636], [-117.26311, 33.06359], [-117.26311, 33.06351], [-117.2632, 33.06304], [-117.2632, 33.0629], [-117.26317, 33.06286], [-117.2635, 33.06179], [-117.26335, 33.06149], [-117.26332, 33.06135], [-117.26342, 33.06107], [-117.26368, 33.06107], [-117.26368, 33.06086], [-117.26372, 33.06078], [-117.26379, 33.06074], [-117.26391, 33.06092], [-117.2641, 33.06086], [-117.26461, 33.06108]]]} | Open Access 1 | 3993 | Leo Mullen Sports Park | 29090 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 5.639 | Leo Mullen Sports Park | 0 | Local Recreation Area 3 | 4 |
6681 | 6681 | 6680 | {"type": "Polygon", "coordinates": [[[-117.29165, 33.03944], [-117.29132, 33.03948], [-117.29118, 33.03833], [-117.29147, 33.03831], [-117.29165, 33.03944]]]} | Open Access 1 | 4957 | Mildred Macpherson Mini-Park | 22214 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 0.914 | Mildred Macpherson Mini-Park | 0 | Local Park 2 | 4 |
7095 | 7095 | 7094 | {"type": "Polygon", "coordinates": [[[-117.267, 33.04596], [-117.26684, 33.046], [-117.2666, 33.04603], [-117.26623, 33.04604], [-117.26454, 33.04597], [-117.26402, 33.04593], [-117.26407, 33.04381], [-117.26554, 33.04382], [-117.26554, 33.04419], [-117.26595, 33.0442], [-117.267, 33.04596]]]} | Open Access 1 | 6161 | Oakcrest Park | 23021 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 12.712 | Oakcrest Park | 0 | Local Park 2 | 4 |
7383 | 7383 | 7382 | {"type": "Polygon", "coordinates": [[[-117.28854, 33.05442], [-117.28768, 33.05441], [-117.28768, 33.05453], [-117.28561, 33.05452], [-117.28569, 33.05184], [-117.28762, 33.05184], [-117.28819, 33.05336], [-117.28839, 33.05414], [-117.28854, 33.05442]]]} | Open Access 1 | 8114 | Paul Ecke Sports Park | 23530 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 16.607 | Paul Ecke Sports Park | 0 | Local Recreation Area 3 | 4 |
7621 | 7621 | 7620 | {"type": "Polygon", "coordinates": [[[-117.28518, 33.02562], [-117.28529, 33.02578], [-117.28529, 33.02582], [-117.28512, 33.0259], [-117.28506, 33.02592], [-117.28492, 33.02592], [-117.28455, 33.02589], [-117.28394, 33.02578], [-117.28407, 33.02539], [-117.28421, 33.02491], [-117.28411, 33.02487], [-117.28368, 33.02416], [-117.2841, 33.02397], [-117.28416, 33.02397], [-117.28518, 33.02562]]]} | Restricted Access 2 | 47635 | George Berkich Park | 31614 | 2412 | Cardiff School District 875 | Special District 4 | School District 14 | http://cardiffschools.com/ | Special District 4 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.697 | George Berkich Park | 0 | Local Park 2 | 4 | |
7949 | 7949 | 7948 | {"type": "Polygon", "coordinates": [[[-117.29603, 33.03791], [-117.29483, 33.03802], [-117.29481, 33.0378], [-117.29594, 33.0377], [-117.29603, 33.03791]]]} | Open Access 1 | 12338 | J Street Viewpoint | 20290 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.676 | J Street Viewpoint | None 661 | ||
8136 | 8136 | 8135 | {"type": "Polygon", "coordinates": [[[-117.2968, 33.04049], [-117.29618, 33.04056], [-117.29616, 33.04042], [-117.29669, 33.04039], [-117.2968, 33.04049]]]} | Open Access 1 | 12319 | H Street Viewpoint | 19582 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.181 | H Street Viewpoint | None 678 | ||
8140 | 8140 | 8139 | {"type": "Polygon", "coordinates": [[[-117.29635, 33.03919], [-117.2957, 33.03926], [-117.29568, 33.03904], [-117.29629, 33.03898], [-117.29635, 33.03919]]]} | Open Access 1 | 12335 | I Street Viewpoint | 20169 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.357 | I Street Viewpoint | None 679 | ||
8281 | 8281 | 8280 | {"type": "Polygon", "coordinates": [[[-117.29747, 33.04483], [-117.29745, 33.04483], [-117.29732, 33.04423], [-117.29724, 33.04395], [-117.29724, 33.04372], [-117.29715, 33.04331], [-117.29707, 33.04312], [-117.29708, 33.0429], [-117.29704, 33.04258], [-117.29695, 33.04237], [-117.2969, 33.04217], [-117.29686, 33.04195], [-117.29686, 33.04186], [-117.29681, 33.0416], [-117.29663, 33.0408], [-117.29663, 33.04067], [-117.29658, 33.04052], [-117.29678, 33.04049], [-117.29678, 33.04048], [-117.29669, 33.04039], [-117.29652, 33.0404], [-117.2965, 33.04035], [-117.2965, 33.0402], [-117.29646, 33.03997], [-117.29646, 33.03974], [-117.29636, 33.03948], [-117.29629, 33.03938], [-117.29625, 33.0392], [-117.29635, 33.03919], [-117.29629, 33.03898], [-117.29631, 33.0389], [-117.29616, 33.0387], [-117.29608, 33.03852], [-117.29601, 33.03843], [-117.29595, 33.03831], [-117.29588, 33.03807], [-117.29583, 33.03793], [-117.29602, 33.03792], [-117.29602, 33.0379], [-117.29594, 33.0377], [-117.29584, 33.03771], [-117.29579, 33.03752], [-117.29551, 33.03684], [-117.29536, 33.03653], [-117.29517, 33.03633], [-117.29459, 33.03587], [-117.29451, 33.03574], [-117.29427, 33.03552], [-117.29399, 33.0353], [-117.29383, 33.03523], [-117.29343, 33.03521], [-117.29333, 33.03517], [-117.29321, 33.03511], [-117.29293, 33.03491], [-117.29268, 33.03479], [-117.29248, 33.03506], [-117.29227, 33.03498], [-117.29158, 33.03506], [-117.29142, 33.03477], [-117.29147, 33.03478], [-117.29154, 33.03464], [-117.29196, 33.03416], [-117.29216, 33.0343], [-117.2923, 33.03437], [-117.29249, 33.03444], [-117.29262, 33.03451], [-117.29284, 33.03458], [-117.29298, 33.03466], [-117.29315, 33.03479], [-117.29329, 33.03493], [-117.29348, 33.03502], [-117.29393, 33.03512], [-117.2942, 33.03524], [-117.29441, 33.03538], [-117.29458, 33.03561], [-117.29488, 33.03596], [-117.29503, 33.03609], [-117.29511, 33.0362], [-117.29545, 33.03645], [-117.29551, 33.03655], [-117.29561, 33.03663], [-117.29569, 33.03675], [-117.29572, 33.03686], [-117.29588, 33.0372], [-117.29602, 33.03737], [-117.29613, 33.03746], [-117.29626, 33.03766], [-117.29626, 33.03778], [-117.29631, 33.03789], [-117.29634, 33.03814], [-117.29642, 33.03826], [-117.29646, 33.03842], [-117.29652, 33.03856], [-117.29664, 33.03907], [-117.29684, 33.03977], [-117.2968, 33.04015], [-117.29692, 33.04064], [-117.29692, 33.04082], [-117.297, 33.04112], [-117.29725, 33.04237], [-117.29724, 33.04257], [-117.29727, 33.04284], [-117.29726, 33.04298], [-117.29727, 33.04302], [-117.29725, 33.04311], [-117.29747, 33.04483]]]} | Open Access 1 | 12670 | Swami's Beach | 26093 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 8.916 | Swami's Beach | 0 | Local Park 2 | 4 |
8379 | 8379 | 8378 | {"type": "Polygon", "coordinates": [[[-117.29408, 33.07322], [-117.2938, 33.07333], [-117.29357, 33.07338], [-117.2929, 33.0736], [-117.29243, 33.0734], [-117.29146, 33.07338], [-117.29145, 33.07319], [-117.29139, 33.07298], [-117.29241, 33.07275], [-117.29248, 33.07295], [-117.29268, 33.07316], [-117.29396, 33.07285], [-117.29408, 33.07322]]]} | Open Access 1 | 12973 | Standard Pacific Park Site | 25781 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.163 | Standard Pacific Park Site | 0 | Local Park 2 | 4 | |
8894 | 8894 | 8893 | {"type": "Polygon", "coordinates": [[[-117.24144, 33.05991], [-117.24138, 33.05992], [-117.24142, 33.06043], [-117.24142, 33.06076], [-117.24122, 33.06079], [-117.24096, 33.06088], [-117.24074, 33.06103], [-117.24066, 33.06111], [-117.24057, 33.06111], [-117.23958, 33.06051], [-117.23968, 33.0605], [-117.23967, 33.05988], [-117.23974, 33.05987], [-117.23978, 33.05985], [-117.23991, 33.05995], [-117.24043, 33.05995], [-117.24045, 33.05849], [-117.24067, 33.05831], [-117.24096, 33.0583], [-117.24124, 33.05853], [-117.24144, 33.05991]]]} | Open Access 1 | 14550 | Sun Vista | 25983 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 7.726 | Sun Vista | None 744 | ||
9275 | 9275 | 9274 | {"type": "Polygon", "coordinates": [[[-117.23595, 33.05083], [-117.23587, 33.05124], [-117.23545, 33.05139], [-117.23553, 33.05113], [-117.23514, 33.05103], [-117.23532, 33.05054], [-117.23565, 33.05063], [-117.23571, 33.05071], [-117.23576, 33.05074], [-117.2359, 33.05074], [-117.23595, 33.05083]]]} | Open Access 1 | 15445 | Wiro Park | 27660 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 1.035 | Wiro Park | 0 | Local Park 2 | 4 |
12549 | 12549 | 12548 | {"type": "Polygon", "coordinates": [[[-117.27771, 33.05534], [-117.27694, 33.05549], [-117.27667, 33.05524], [-117.27649, 33.05488], [-117.27664, 33.05484], [-117.27689, 33.05484], [-117.27712, 33.0549], [-117.27729, 33.05498], [-117.27753, 33.05517], [-117.27771, 33.05526], [-117.27771, 33.05534]]]} | Open Access 1 | 36585 | Las Verdes Park | 28588 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Parks | San Diego 4 | 1.212 | Las Verdes Park | 0 | Local Park 2 | 4 |
13416 | 13416 | 13415 | {"type": "Polygon", "coordinates": [[[-117.28517, 33.08411], [-117.28517, 33.08713], [-117.28478, 33.08714], [-117.28429, 33.08718], [-117.28299, 33.08738], [-117.28297, 33.08412], [-117.28517, 33.08411]]]} | Open Access 1 | 35528 | Encinitas holding 29 | 18656 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 17.436 | Encinitas holding 29 | 0 | Local Other or Unknown 14 | 4 | |
13417 | 13417 | 13416 | {"type": "Polygon", "coordinates": [[[-117.28529, 33.07544], [-117.2852, 33.07638], [-117.2851, 33.07638], [-117.28509, 33.07542], [-117.28506, 33.07538], [-117.28525, 33.0754], [-117.28529, 33.07544]]]} | Open Access 1 | 35529 | Encinitas holding 31 | 18657 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.384 | Encinitas holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13419 | 13419 | 13418 | {"type": "Polygon", "coordinates": [[[-117.24702, 33.0564], [-117.24692, 33.05685], [-117.24691, 33.05685], [-117.24689, 33.05683], [-117.2469, 33.05662], [-117.24702, 33.0564]]]} | Open Access 1 | 35537 | Encinitas holding 36 | 18658 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.044 | Encinitas holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13420 | 13420 | 13419 | {"type": "Polygon", "coordinates": [[[-117.25554, 33.03255], [-117.25419, 33.03259], [-117.25425, 33.03238], [-117.25435, 33.0322], [-117.25409, 33.03203], [-117.25412, 33.03199], [-117.25439, 33.03213], [-117.25449, 33.03195], [-117.25455, 33.03175], [-117.25454, 33.03156], [-117.2545, 33.03127], [-117.25453, 33.03099], [-117.25448, 33.03085], [-117.2544, 33.03057], [-117.25438, 33.03034], [-117.25454, 33.03041], [-117.25463, 33.03047], [-117.25474, 33.03058], [-117.25485, 33.03073], [-117.25491, 33.03087], [-117.25502, 33.03152], [-117.25508, 33.03166], [-117.25522, 33.0318], [-117.2553, 33.03184], [-117.25546, 33.03189], [-117.25554, 33.03189], [-117.25554, 33.03255]]]} | Open Access 1 | 35538 | Encinitas holding 12 | 18647 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.895 | Encinitas holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13421 | 13421 | 13420 | {"type": "Polygon", "coordinates": [[[-117.25119, 33.02892], [-117.25116, 33.02906], [-117.24968, 33.02909], [-117.24971, 33.02907], [-117.24974, 33.02897], [-117.24991, 33.02881], [-117.24992, 33.02878], [-117.24992, 33.02865], [-117.24995, 33.02859], [-117.25001, 33.02853], [-117.25075, 33.02804], [-117.25081, 33.02804], [-117.25084, 33.02805], [-117.25088, 33.0281], [-117.25089, 33.02815], [-117.25081, 33.02827], [-117.25054, 33.02853], [-117.2505, 33.02861], [-117.25049, 33.02867], [-117.25051, 33.02876], [-117.25055, 33.0288], [-117.25063, 33.02884], [-117.2508, 33.02884], [-117.25102, 33.02881], [-117.25113, 33.02882], [-117.25118, 33.02885], [-117.25119, 33.02892]]]} | Open Access 1 | 35539 | Encinitas holding 47 | 18663 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.83 | Encinitas holding 47 | 0 | Local Other or Unknown 14 | 4 | |
13423 | 13423 | 13422 | {"type": "Polygon", "coordinates": [[[-117.25097, 33.02595], [-117.25082, 33.02602], [-117.25066, 33.02604], [-117.25034, 33.02612], [-117.24989, 33.02611], [-117.24982, 33.02614], [-117.24939, 33.02641], [-117.24938, 33.02662], [-117.24941, 33.02672], [-117.24949, 33.02681], [-117.24953, 33.02685], [-117.24963, 33.02688], [-117.24997, 33.02692], [-117.24915, 33.02722], [-117.24916, 33.0291], [-117.24825, 33.02912], [-117.24825, 33.02901], [-117.24853, 33.02901], [-117.24852, 33.02874], [-117.24826, 33.02831], [-117.24789, 33.0283], [-117.24788, 33.02811], [-117.24859, 33.02811], [-117.24858, 33.02777], [-117.24844, 33.02778], [-117.24805, 33.0273], [-117.2485, 33.02721], [-117.24848, 33.02711], [-117.2487, 33.02709], [-117.2487, 33.02682], [-117.24777, 33.02649], [-117.24794, 33.02643], [-117.24793, 33.02623], [-117.24817, 33.02577], [-117.24817, 33.02571], [-117.24807, 33.02552], [-117.24913, 33.02551], [-117.24913, 33.02413], [-117.24932, 33.02414], [-117.24939, 33.02417], [-117.24926, 33.02429], [-117.24928, 33.02435], [-117.24945, 33.02447], [-117.24962, 33.02456], [-117.24966, 33.02456], [-117.24973, 33.02449], [-117.24978, 33.02449], [-117.24999, 33.02457], [-117.25006, 33.02469], [-117.25007, 33.02474], [-117.2501, 33.02514], [-117.25033, 33.02515], [-117.25038, 33.02475], [-117.25075, 33.02474], [-117.25077, 33.02476], [-117.25076, 33.02488], [-117.25073, 33.02495], [-117.25067, 33.02503], [-117.25052, 33.02515], [-117.2505, 33.0252], [-117.25053, 33.02524], [-117.25088, 33.02547], [-117.25094, 33.02554], [-117.25097, 33.02574], [-117.25097, 33.02595]]]} | Open Access 1 | 35540 | Encinitas holding 41 | 18661 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 15.302 | Encinitas holding 41 | 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]);