units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where AGNCY_NAME = 151 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 6
- Local Park 34
- Local Recreation Area 17
- Local Other or Unknown 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 55 ✖
MNG_AGENCY 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
367 | 367 | 366 | {"type": "Polygon", "coordinates": [[[-121.97916, 38.3386], [-121.97897, 38.3387], [-121.97854, 38.33903], [-121.97832, 38.33915], [-121.9779, 38.33933], [-121.97754, 38.33938], [-121.97698, 38.33931], [-121.97687, 38.33916], [-121.97685, 38.33905], [-121.97684, 38.33888], [-121.97677, 38.33872], [-121.97662, 38.33863], [-121.97638, 38.3386], [-121.97607, 38.33854], [-121.97557, 38.33841], [-121.97526, 38.33838], [-121.97427, 38.33859], [-121.97412, 38.33833], [-121.97479, 38.33815], [-121.97508, 38.3381], [-121.97549, 38.3381], [-121.97579, 38.33815], [-121.9764, 38.33833], [-121.97679, 38.3385], [-121.97683, 38.33855], [-121.97688, 38.33857], [-121.97694, 38.33858], [-121.97702, 38.33855], [-121.97708, 38.33849], [-121.97733, 38.33851], [-121.97744, 38.33855], [-121.97823, 38.33856], [-121.97833, 38.33858], [-121.9785, 38.33859], [-121.9787, 38.33856], [-121.97909, 38.33843], [-121.97916, 38.3386]]]} | Open Access 1 | 1048 | Southwood Park | 25704 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.256 | Southwood Park | 0 | Local Park 2 | 4 | |
400 | 400 | 399 | {"type": "Polygon", "coordinates": [[[-121.93951, 38.36208], [-121.9394, 38.3621], [-121.93921, 38.36218], [-121.93907, 38.36221], [-121.93876, 38.36222], [-121.93861, 38.36224], [-121.93817, 38.36246], [-121.938, 38.36247], [-121.93788, 38.36242], [-121.93768, 38.36205], [-121.93759, 38.36196], [-121.93748, 38.36181], [-121.93743, 38.36171], [-121.93741, 38.36157], [-121.93736, 38.36147], [-121.93732, 38.36111], [-121.93771, 38.36102], [-121.93861, 38.36076], [-121.93867, 38.36075], [-121.93871, 38.36078], [-121.93918, 38.36149], [-121.93951, 38.36208]]]} | Open Access 1 | 1215 | Stonegate Park | 25888 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 5.702 | Stonegate Park | 0 | Local Park 2 | 4 | |
427 | 427 | 426 | {"type": "Polygon", "coordinates": [[[-121.98272, 38.36571], [-121.98118, 38.36563], [-121.9812, 38.36528], [-121.98124, 38.36513], [-121.98126, 38.36473], [-121.98231, 38.36477], [-121.98241, 38.3648], [-121.98251, 38.36487], [-121.98263, 38.36502], [-121.9827, 38.36517], [-121.98273, 38.36528], [-121.98274, 38.36538], [-121.98272, 38.36571]]]} | Open Access 1 | 1707 | Trower Park | 26551 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 3.156 | Trower Park | 0 | Local Park 2 | 4 | |
609 | 609 | 608 | {"type": "Polygon", "coordinates": [[[-121.99599, 38.34541], [-121.996, 38.34585], [-121.99597, 38.34627], [-121.99595, 38.3463], [-121.99545, 38.34591], [-121.99482, 38.34547], [-121.99467, 38.34534], [-121.99471, 38.34529], [-121.99483, 38.34527], [-121.99493, 38.34517], [-121.99495, 38.34513], [-121.99517, 38.345], [-121.99541, 38.34498], [-121.99553, 38.34509], [-121.99599, 38.34541]]]} | Open Access 1 | 2135 | Willows Park | 27595 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 2.146 | Willows Park | 0 | Local Park 2 | 4 | |
656 | 656 | 655 | {"type": "Polygon", "coordinates": [[[-122.01041, 38.35673], [-122.00892, 38.35725], [-122.00846, 38.35701], [-122.00814, 38.35671], [-122.00769, 38.35685], [-122.0075, 38.35677], [-122.00736, 38.35667], [-122.00728, 38.35618], [-122.00767, 38.35609], [-122.00751, 38.35562], [-122.00947, 38.35527], [-122.01041, 38.35673]]]} | Open Access 1 | 3220 | Alamo Creek Park | 15317 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 9.429 | Alamo Creek Park | 2000 | Local Park 2 | 4 | |
1314 | 1314 | 1313 | {"type": "Polygon", "coordinates": [[[-121.95495, 38.3235], [-121.95351, 38.3235], [-121.95349, 38.32364], [-121.9532, 38.32352], [-121.95304, 38.32352], [-121.95289, 38.32347], [-121.95235, 38.32348], [-121.95234, 38.32251], [-121.95241, 38.32246], [-121.95487, 38.32245], [-121.95491, 38.32249], [-121.95492, 38.32321], [-121.95495, 38.3235]]]} | Open Access 1 | 7375 | Cannon Station Park | 16805 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 6.485 | Cannon Station Park | 0 | Local Park 2 | 4 | |
1445 | 1445 | 1444 | {"type": "MultiPolygon", "coordinates": [[[[-121.96952, 38.368], [-121.96865, 38.36697], [-121.96865, 38.36697], [-121.96936, 38.36672], [-121.96952, 38.36784], [-121.96952, 38.368]]], [[[-121.97601, 38.37279], [-121.97442, 38.37692], [-121.97337, 38.37952], [-121.97228, 38.38237], [-121.97079, 38.38635], [-121.96709, 38.38651], [-121.96528, 38.38665], [-121.96512, 38.38613], [-121.96489, 38.38546], [-121.96482, 38.38545], [-121.96457, 38.38384], [-121.96459, 38.38369], [-121.96442, 38.38233], [-121.96462, 38.38185], [-121.96554, 38.38052], [-121.96572, 38.38021], [-121.96574, 38.38021], [-121.96579, 38.38014], [-121.96578, 38.38012], [-121.96631, 38.3794], [-121.96673, 38.37888], [-121.96773, 38.37756], [-121.96778, 38.37744], [-121.96781, 38.37706], [-121.96776, 38.3766], [-121.96784, 38.37624], [-121.96789, 38.37461], [-121.96788, 38.37444], [-121.9679, 38.37261], [-121.96792, 38.37188], [-121.96794, 38.3716], [-121.9681, 38.36995], [-121.96855, 38.36817], [-121.96846, 38.36803], [-121.96818, 38.36764], [-121.96796, 38.36765], [-121.96759, 38.36733], [-121.96833, 38.36707], [-121.96974, 38.36866], [-121.97015, 38.36908], [-121.9703, 38.36922], [-121.9706, 38.36942], [-121.97061, 38.36955], [-121.97019, 38.36997], [-121.96982, 38.3703], [-121.96968, 38.37047], [-121.96961, 38.37061], [-121.96957, 38.3708], [-121.96956, 38.37095], [-121.96958, 38.37108], [-121.96972, 38.37102], [-121.96974, 38.37084], [-121.9698, 38.37071], [-121.96986, 38.37062], [-121.97002, 38.37046], [-121.97081, 38.36971], [-121.97084, 38.36969], [-121.97098, 38.36968], [-121.97138, 38.36993], [-121.97098, 38.37041], [-121.97098, 38.37043], [-121.97166, 38.37012], [-121.97189, 38.36999], [-121.97317, 38.3709], [-121.976, 38.37276], [-121.97601, 38.37279]]]]} | Open Access 1 | 9627 | Centennial Park | 14382 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=128 | Solano 26 | 283.173 | Centennial Park | 0 | Local Park 2 | 4 |
2289 | 2289 | 2288 | {"type": "MultiPolygon", "coordinates": [[[[-122.00451, 38.37315], [-122.00451, 38.37447], [-122.00217, 38.37446], [-122.00312, 38.3734], [-122.00328, 38.37315], [-122.00451, 38.37315]]], [[[-122.00452, 38.37195], [-122.00451, 38.37304], [-122.0034, 38.37304], [-122.00392, 38.37241], [-122.00432, 38.37195], [-122.00452, 38.37195]]]]} | Open Access 1 | 18241 | North Orchard Park | 22837 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 7.264 | North Orchard Park | 0 | Local Park 2 | 4 | |
2303 | 2303 | 2302 | {"type": "MultiPolygon", "coordinates": [[[[-122.01651, 38.36711], [-122.01645, 38.36725], [-122.01642, 38.36746], [-122.01642, 38.36766], [-122.01633, 38.36766], [-122.01565, 38.36754], [-122.01541, 38.36761], [-122.01499, 38.36726], [-122.01446, 38.36698], [-122.0141, 38.36737], [-122.01399, 38.36731], [-122.01434, 38.36691], [-122.01351, 38.36602], [-122.01519, 38.36605], [-122.01524, 38.3661], [-122.01586, 38.36652], [-122.01606, 38.36669], [-122.01629, 38.36692], [-122.01649, 38.36706], [-122.01651, 38.36711]]], [[[-122.01956, 38.36849], [-122.01848, 38.36825], [-122.01801, 38.36812], [-122.0176, 38.36803], [-122.01695, 38.36782], [-122.01665, 38.36768], [-122.01667, 38.36736], [-122.01673, 38.36718], [-122.01705, 38.36721], [-122.01911, 38.36726], [-122.01947, 38.36809], [-122.01941, 38.36814], [-122.01956, 38.36849]]]]} | Open Access 1 | 16943 | Hidden Valley Openspace | 19916 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 12.161 | Hidden Valley Openspace | None 191 | |||
2365 | 2365 | 2364 | {"type": "Polygon", "coordinates": [[[-121.98722, 38.33109], [-121.98714, 38.33338], [-121.98603, 38.33329], [-121.98501, 38.33329], [-121.98257, 38.33326], [-121.98242, 38.33108], [-121.98263, 38.33104], [-121.98722, 38.33109]]]} | Open Access 1 | 17154 | Keating Park | 20567 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 25.005 | Keating Park | 0 | Local Park 2 | 4 | |
2503 | 2503 | 2502 | {"type": "Polygon", "coordinates": [[[-121.99456, 38.36909], [-121.99411, 38.3691], [-121.99408, 38.36876], [-121.99398, 38.36861], [-121.99375, 38.36861], [-121.99349, 38.36854], [-121.99343, 38.36841], [-121.9933, 38.36817], [-121.99323, 38.36786], [-121.99312, 38.36768], [-121.99282, 38.36767], [-121.99271, 38.3675], [-121.99255, 38.36745], [-121.99243, 38.36729], [-121.99246, 38.36718], [-121.99266, 38.3671], [-121.9927, 38.36702], [-121.99259, 38.36691], [-121.99254, 38.3668], [-121.99247, 38.36628], [-121.99303, 38.36629], [-121.99302, 38.36652], [-121.99312, 38.36671], [-121.99354, 38.36721], [-121.99358, 38.36746], [-121.9938, 38.36762], [-121.99395, 38.36809], [-121.99404, 38.36819], [-121.99432, 38.36844], [-121.99453, 38.36879], [-121.99455, 38.36887], [-121.99456, 38.36909]]]} | Open Access 1 | 22094 | Burton Estates Open Space | 16531 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 4.783 | Burton Estates OS | 0 | Local Recreation Area 3 | 4 | |
2570 | 2570 | 2569 | {"type": "Polygon", "coordinates": [[[-121.94501, 38.34018], [-121.94498, 38.342], [-121.94481, 38.342], [-121.94475, 38.34204], [-121.94332, 38.34207], [-121.94331, 38.34156], [-121.94316, 38.34087], [-121.94291, 38.34006], [-121.944, 38.34008], [-121.94421, 38.34016], [-121.94501, 38.34018]]]} | Open Access 1 | 17854 | Meadowlands Park | 22086 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 8.404 | Meadowlands Park | 0 | Local Park 2 | 4 | |
2670 | 2670 | 2669 | {"type": "Polygon", "coordinates": [[[-121.95309, 38.34744], [-121.95187, 38.34744], [-121.95186, 38.34764], [-121.95078, 38.34765], [-121.95044, 38.34751], [-121.95006, 38.3475], [-121.94945, 38.34772], [-121.94916, 38.34773], [-121.94891, 38.34763], [-121.94871, 38.3474], [-121.94869, 38.34696], [-121.94884, 38.34673], [-121.94905, 38.34666], [-121.94932, 38.34661], [-121.94961, 38.34638], [-121.94961, 38.34618], [-121.94918, 38.34605], [-121.94937, 38.34573], [-121.95005, 38.34565], [-121.95035, 38.34515], [-121.95043, 38.34516], [-121.95084, 38.34536], [-121.9512, 38.34559], [-121.9516, 38.34597], [-121.95186, 38.3462], [-121.95216, 38.3463], [-121.95269, 38.34638], [-121.953, 38.3464], [-121.95306, 38.34646], [-121.95309, 38.34669], [-121.95309, 38.34744]]]} | Open Access 1 | 18195 | Nelson Park | 22698 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 16.691 | Nelson Park | 0 | Local Park 2 | 4 | |
2815 | 2815 | 2814 | {"type": "Polygon", "coordinates": [[[-121.96614, 38.32851], [-121.96612, 38.3291], [-121.96613, 38.3305], [-121.96517, 38.33049], [-121.96492, 38.33057], [-121.96477, 38.33058], [-121.96476, 38.32979], [-121.96478, 38.32969], [-121.96485, 38.32961], [-121.96498, 38.32955], [-121.96519, 38.32935], [-121.96521, 38.32926], [-121.96471, 38.32864], [-121.96508, 38.32834], [-121.96614, 38.32851]]]} | Open Access 1 | 18669 | Pheasant Country Park | 23639 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 6.213 | Pheasant Country Park | 0 | Local Park 2 | 4 | |
3185 | 3185 | 3184 | {"type": "Polygon", "coordinates": [[[-121.95731, 38.35578], [-121.95713, 38.3558], [-121.95691, 38.35576], [-121.9559, 38.35575], [-121.95516, 38.35589], [-121.95513, 38.35581], [-121.95508, 38.35509], [-121.95524, 38.35507], [-121.95571, 38.35509], [-121.95729, 38.35512], [-121.95731, 38.35578]]]} | Open Access 1 | 22098 | Hawkins Park | 19747 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 3.62 | Hawkins Park | 0 | Local Park 2 | 4 | |
3186 | 3186 | 3185 | {"type": "Polygon", "coordinates": [[[-121.97524, 38.38991], [-121.97523, 38.38996], [-121.97491, 38.39019], [-121.97457, 38.39046], [-121.97438, 38.39066], [-121.97412, 38.391], [-121.97374, 38.39084], [-121.97236, 38.39046], [-121.97306, 38.38966], [-121.97336, 38.38929], [-121.9738, 38.38898], [-121.97412, 38.3888], [-121.97524, 38.38991]]]} | Open Access 1 | 22102 | Ridgeview Park | 24361 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 7.844 | Ridgeview Park | 0 | Local Park 2 | 4 | |
3223 | 3223 | 3222 | {"type": "Polygon", "coordinates": [[[-121.97521, 38.33324], [-121.97061, 38.33321], [-121.97063, 38.33], [-121.97405, 38.32959], [-121.97519, 38.3317], [-121.97521, 38.33324]]]} | Open Access 1 | 28305 | Al Patch Park | 15309 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 35.367 | Al Patch Park | 0 | Local Park 2 | 4 | |
3546 | 3546 | 3545 | {"type": "Polygon", "coordinates": [[[-121.94776, 38.35645], [-121.94605, 38.35706], [-121.94576, 38.3565], [-121.94534, 38.35665], [-121.94491, 38.35597], [-121.94666, 38.35525], [-121.94676, 38.35524], [-121.94734, 38.35568], [-121.94757, 38.3557], [-121.94774, 38.35584], [-121.94776, 38.35645]]]} | Restricted Access 2 | 28309 | Cooper School Park | 31609 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 7.337 | Cooper School Park | 0 | Local Park 2 | 4 | |
3942 | 3942 | 3941 | {"type": "Polygon", "coordinates": [[[-121.96018, 38.34251], [-121.95925, 38.34317], [-121.95888, 38.3435], [-121.95879, 38.34331], [-121.95865, 38.34325], [-121.95856, 38.34319], [-121.95843, 38.34306], [-121.95841, 38.3429], [-121.95844, 38.34278], [-121.95839, 38.34272], [-121.95832, 38.34273], [-121.95806, 38.34289], [-121.95744, 38.34313], [-121.95728, 38.34315], [-121.95708, 38.34314], [-121.95687, 38.3431], [-121.95677, 38.34313], [-121.95666, 38.3432], [-121.95654, 38.34332], [-121.95649, 38.34339], [-121.95645, 38.3435], [-121.95622, 38.34364], [-121.95602, 38.3438], [-121.95594, 38.34394], [-121.95593, 38.3442], [-121.9559, 38.34432], [-121.95572, 38.34448], [-121.95548, 38.34459], [-121.95519, 38.34469], [-121.95466, 38.34491], [-121.9543, 38.34514], [-121.95404, 38.34527], [-121.95334, 38.3455], [-121.95335, 38.34531], [-121.95334, 38.34466], [-121.95369, 38.34465], [-121.95405, 38.34447], [-121.9543, 38.34445], [-121.9545, 38.34439], [-121.95493, 38.34439], [-121.95497, 38.34427], [-121.95506, 38.34424], [-121.95534, 38.34422], [-121.95571, 38.34376], [-121.95574, 38.34359], [-121.95582, 38.34356], [-121.95586, 38.3435], [-121.9559, 38.34349], [-121.95614, 38.34326], [-121.95648, 38.34299], [-121.95649, 38.34293], [-121.95655, 38.34289], [-121.95662, 38.3429], [-121.9568, 38.34276], [-121.95782, 38.34275], [-121.95823, 38.34253], [-121.95852, 38.34243], [-121.95867, 38.34241], [-121.96018, 38.34251]]]} | Open Access 1 | 36342 | Vacaville holding 1 | 26753 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 8.609 | Vacaville holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4957 | 4957 | 4956 | {"type": "Polygon", "coordinates": [[[-121.95816, 38.33944], [-121.95762, 38.3395], [-121.95738, 38.33972], [-121.95716, 38.33985], [-121.95693, 38.33969], [-121.95616, 38.33968], [-121.95527, 38.33976], [-121.95516, 38.33913], [-121.95519, 38.33875], [-121.95525, 38.33857], [-121.95572, 38.33855], [-121.95611, 38.33882], [-121.95629, 38.33868], [-121.95673, 38.33901], [-121.95731, 38.33858], [-121.95738, 38.33863], [-121.95781, 38.33829], [-121.9581, 38.33849], [-121.95813, 38.33907], [-121.95816, 38.33944]]]} | Open Access 1 | 800 | Sierra Vista Park | 25472 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | Solano 26 | 7.151 | Sierra Vista 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]);