units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
43 rows where ACCESS_TYP = 1, GAP_STS = 4 and MNG_AGENCY = 147
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 | |
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 | |
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 | |
4983 | 4983 | 4982 | {"type": "Polygon", "coordinates": [[[-121.99578, 38.38941], [-121.99541, 38.38938], [-121.9954, 38.38939], [-121.9954, 38.39487], [-121.98277, 38.39487], [-121.98275, 38.39452], [-121.98281, 38.39448], [-121.98284, 38.39444], [-121.98298, 38.39446], [-121.98344, 38.39406], [-121.98509, 38.39423], [-121.9852, 38.39394], [-121.98515, 38.39389], [-121.9852, 38.39385], [-121.98521, 38.3938], [-121.9852, 38.39373], [-121.98521, 38.39365], [-121.98561, 38.39369], [-121.98566, 38.39366], [-121.9857, 38.39343], [-121.98564, 38.39316], [-121.98542, 38.39288], [-121.98513, 38.39271], [-121.98426, 38.39263], [-121.98388, 38.39246], [-121.984, 38.39216], [-121.98373, 38.39199], [-121.98379, 38.39197], [-121.98384, 38.39193], [-121.98387, 38.39186], [-121.98386, 38.3918], [-121.98379, 38.39173], [-121.98371, 38.39131], [-121.98326, 38.39124], [-121.98329, 38.39101], [-121.98338, 38.3906], [-121.98357, 38.39016], [-121.98388, 38.38964], [-121.98425, 38.3892], [-121.98472, 38.3888], [-121.98561, 38.38808], [-121.98587, 38.38791], [-121.9861, 38.38809], [-121.98582, 38.38831], [-121.98632, 38.38912], [-121.98712, 38.38899], [-121.98656, 38.38775], [-121.98618, 38.38803], [-121.98595, 38.38785], [-121.98695, 38.38703], [-121.98675, 38.3869], [-121.98674, 38.38531], [-121.98639, 38.38508], [-121.98621, 38.38464], [-121.98612, 38.3843], [-121.98606, 38.38321], [-121.9861, 38.38276], [-121.9862, 38.38228], [-121.98633, 38.38183], [-121.98641, 38.38138], [-121.98635, 38.38111], [-121.98604, 38.38032], [-121.98579, 38.37979], [-121.98575, 38.37942], [-121.98546, 38.37923], [-121.9854, 38.37918], [-121.98301, 38.37914], [-121.98305, 38.37835], [-121.98296, 38.37828], [-121.98284, 38.37828], [-121.98246, 38.37858], [-121.98236, 38.37854], [-121.98241, 38.37826], [-121.98238, 38.37819], [-121.98191, 38.37789], [-121.98175, 38.37749], [-121.98167, 38.37744], [-121.98098, 38.37737], [-121.98098, 38.37721], [-121.98095, 38.377], [-121.98147, 38.37671], [-121.98158, 38.37659], [-121.98163, 38.37643], [-121.98164, 38.37601], [-121.98191, 38.37561], [-121.98226, 38.37532], [-121.98277, 38.37297], [-121.98227, 38.37264], [-121.98232, 38.37258], [-121.98233, 38.37251], [-121.9829, 38.3728], [-121.98347, 38.3726], [-121.98351, 38.37198], [-121.98516, 38.37293], [-121.9859, 38.37317], [-121.9866, 38.37334], [-121.98869, 38.37534], [-121.98926, 38.3752], [-121.98991, 38.37676], [-121.98974, 38.37681], [-121.98969, 38.37725], [-121.98969, 38.37919], [-121.99094, 38.37919], [-121.99133, 38.38064], [-121.99129, 38.38068], [-121.99134, 38.38097], [-121.99139, 38.38147], [-121.99147, 38.38186], [-121.99158, 38.38213], [-121.99172, 38.3827], [-121.99175, 38.38301], [-121.99195, 38.38322], [-121.99207, 38.38325], [-121.9943, 38.3849], [-121.99458, 38.38558], [-121.99473, 38.38562], [-121.99522, 38.38666], [-121.99502, 38.38676], [-121.9954, 38.38784], [-121.9954, 38.3883], [-121.99571, 38.38858], [-121.99578, 38.38941]]]} | Open Access 1 | 18359 | Brown's Valley Ridge Open Space | 14377 | 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 | 425.414 | Brown's Valley Ridge OS | 0 | Local Recreation Area 3 | 4 | |
5259 | 5259 | 5258 | {"type": "Polygon", "coordinates": [[[-121.98321, 38.3821], [-121.98298, 38.38215], [-121.98292, 38.38219], [-121.98281, 38.3822], [-121.9828, 38.38225], [-121.98239, 38.38227], [-121.98219, 38.38216], [-121.9817, 38.38258], [-121.98166, 38.38269], [-121.98169, 38.38312], [-121.98133, 38.383], [-121.98129, 38.38281], [-121.98136, 38.38255], [-121.98145, 38.38239], [-121.98151, 38.38207], [-121.98162, 38.38199], [-121.98163, 38.38159], [-121.98169, 38.38144], [-121.98176, 38.3813], [-121.98175, 38.38118], [-121.98177, 38.38108], [-121.9817, 38.38091], [-121.98231, 38.38064], [-121.98292, 38.38144], [-121.98307, 38.38174], [-121.98321, 38.3821]]]} | Open Access 1 | 1945 | Boulder Valley Park | 16298 | 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.077 | Boulder Valley 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]);