units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where MNG_AGENCY = 147 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, LABEL_NAME, 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
- Vacaville, City of · 55 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
15992 | 15992 | 15991 | {"type": "Polygon", "coordinates": [[[-121.9799, 38.37625], [-121.97978, 38.37626], [-121.97969, 38.37632], [-121.97967, 38.37636], [-121.97967, 38.37641], [-121.97972, 38.3765], [-121.97906, 38.37666], [-121.97898, 38.37672], [-121.97889, 38.3767], [-121.97882, 38.3767], [-121.97877, 38.37672], [-121.97872, 38.37667], [-121.97795, 38.37669], [-121.97733, 38.37393], [-121.97713, 38.37363], [-121.97701, 38.37346], [-121.977, 38.37339], [-121.97718, 38.37325], [-121.97737, 38.37299], [-121.97738, 38.37294], [-121.9774, 38.3729], [-121.97744, 38.37276], [-121.97745, 38.37234], [-121.9775, 38.3723], [-121.97831, 38.37233], [-121.97891, 38.37241], [-121.97913, 38.37242], [-121.97914, 38.37278], [-121.97928, 38.37297], [-121.97928, 38.37308], [-121.9793, 38.37312], [-121.97931, 38.37328], [-121.97934, 38.37343], [-121.97935, 38.37375], [-121.97943, 38.3738], [-121.97942, 38.37399], [-121.97936, 38.37423], [-121.97943, 38.37455], [-121.97952, 38.37459], [-121.9795, 38.37467], [-121.97953, 38.37474], [-121.97948, 38.37477], [-121.97954, 38.37506], [-121.97976, 38.37535], [-121.97972, 38.3754], [-121.97972, 38.37545], [-121.97975, 38.37551], [-121.97981, 38.37556], [-121.9798, 38.37594], [-121.9799, 38.37625]]]} | No Public Access 3 | 1305 | Sunrise Woodcrest Open Space | 26039 | 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 | 20.516 | Sunrise Woodcrest OS | 0 | Local Recreation Area 3 | 4 | |
6300 | 6300 | 6299 | {"type": "Polygon", "coordinates": [[[-122.00948, 38.34308], [-122.00872, 38.34467], [-122.00701, 38.34922], [-122.00683, 38.34903], [-122.00699, 38.34894], [-122.00699, 38.34892], [-122.00674, 38.34867], [-122.00658, 38.34877], [-122.00653, 38.34873], [-122.00669, 38.34811], [-122.00525, 38.34739], [-122.00384, 38.34625], [-122.00365, 38.34649], [-122.00372, 38.3469], [-122.00364, 38.34691], [-122.00347, 38.34659], [-122.00335, 38.3466], [-122.00333, 38.34675], [-122.00313, 38.34708], [-122.00328, 38.34718], [-122.0034, 38.34738], [-122.00345, 38.34758], [-122.00328, 38.34776], [-122.00331, 38.34791], [-122.00325, 38.34817], [-122.00307, 38.34857], [-122.00277, 38.34889], [-122.00279, 38.3491], [-122.00256, 38.34887], [-122.00265, 38.34871], [-122.00284, 38.34855], [-122.00297, 38.34837], [-122.00309, 38.34797], [-122.00303, 38.34764], [-122.00318, 38.34745], [-122.00312, 38.34727], [-122.00301, 38.34719], [-122.00296, 38.34712], [-122.00307, 38.3466], [-122.00299, 38.34644], [-122.00268, 38.34637], [-122.00253, 38.3462], [-122.00226, 38.34601], [-122.00198, 38.34544], [-122.00181, 38.34515], [-122.00175, 38.34498], [-122.00215, 38.34482], [-122.00702, 38.34317], [-122.00825, 38.343], [-122.00928, 38.34317], [-122.00948, 38.34308]]]} | No Public Access 3 | 1417 | Alamo Terrace Open Space | 15323 | 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 | 55.193 | Alamo Terrace OS | 2000 | Local Recreation Area 3 | 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 | |
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 | |
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 | |
15909 | 15909 | 15908 | {"type": "Polygon", "coordinates": [[[-122.00042, 38.33116], [-121.99991, 38.33301], [-121.99991, 38.33305], [-121.99734, 38.3342], [-122.0001, 38.33632], [-121.99936, 38.33664], [-121.99849, 38.33711], [-121.99824, 38.33732], [-121.99804, 38.33741], [-121.99751, 38.33738], [-121.99731, 38.3372], [-121.99737, 38.33691], [-121.99733, 38.33673], [-121.99693, 38.3366], [-121.99696, 38.33657], [-121.99711, 38.33598], [-121.99698, 38.33582], [-121.99598, 38.33629], [-121.99519, 38.33606], [-121.99504, 38.33593], [-121.99493, 38.33561], [-121.99501, 38.33517], [-121.99522, 38.33477], [-121.9952, 38.3346], [-121.9947, 38.33448], [-121.99424, 38.33447], [-121.99393, 38.33436], [-121.9937, 38.3342], [-121.99358, 38.33397], [-121.99356, 38.33368], [-121.9934, 38.33348], [-121.99242, 38.33333], [-121.99239, 38.33268], [-121.99226, 38.33223], [-121.99232, 38.33207], [-121.99258, 38.33195], [-121.99279, 38.33189], [-121.99286, 38.33164], [-121.99296, 38.33155], [-121.99292, 38.33145], [-121.99228, 38.33125], [-121.9918, 38.33147], [-121.99162, 38.33148], [-121.9911, 38.33132], [-121.99109, 38.33128], [-121.99122, 38.33084], [-121.99141, 38.33051], [-121.99133, 38.33032], [-121.99133, 38.33021], [-121.99155, 38.32984], [-121.99185, 38.32959], [-121.99231, 38.32932], [-121.99255, 38.32925], [-121.99271, 38.32911], [-121.99289, 38.32901], [-121.99307, 38.32881], [-121.99349, 38.3286], [-121.99366, 38.32847], [-121.99317, 38.3272], [-121.99405, 38.32646], [-121.99511, 38.32587], [-121.99647, 38.32484], [-121.9968, 38.32506], [-121.9982, 38.32572], [-121.99821, 38.32574], [-121.99771, 38.3276], [-121.99774, 38.32765], [-121.99772, 38.32771], [-121.99839, 38.32952], [-121.99865, 38.33014], [-122.00042, 38.33116]]]} | Open Access 1 | 5175 | Gonzales Open Space | 19396 | 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 | 147.193 | Gonzales OS | 0 | Local Recreation Area 3 | 4 | |
6762 | 6762 | 6761 | {"type": "Polygon", "coordinates": [[[-121.98175, 38.38103], [-121.9817, 38.38136], [-121.98158, 38.38162], [-121.98158, 38.38195], [-121.98146, 38.3821], [-121.98104, 38.3824], [-121.98073, 38.38235], [-121.98066, 38.38237], [-121.98063, 38.38233], [-121.98053, 38.38229], [-121.98047, 38.38229], [-121.98038, 38.38233], [-121.98033, 38.38229], [-121.97998, 38.38224], [-121.97958, 38.38223], [-121.97939, 38.38187], [-121.97936, 38.38172], [-121.97937, 38.38118], [-121.9794, 38.38099], [-121.9794, 38.3808], [-121.97904, 38.38079], [-121.97898, 38.38074], [-121.98118, 38.38077], [-121.98167, 38.38094], [-121.98175, 38.38103]]]} | Open Access 1 | 5177 | Boulder Valley Park & Open Space | 16299 | 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.055 | Boulder Valley Park & OS | 0 | Local Recreation Area 3 | 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 |
8420 | 8420 | 8419 | {"type": "Polygon", "coordinates": [[[-121.97742, 38.36905], [-121.976, 38.37276], [-121.97317, 38.3709], [-121.97086, 38.36924], [-121.97043, 38.36895], [-121.96991, 38.36848], [-121.96955, 38.36806], [-121.96936, 38.36671], [-121.9695, 38.36664], [-121.96949, 38.36585], [-121.97013, 38.36585], [-121.97009, 38.364], [-121.97163, 38.36351], [-121.97331, 38.36248], [-121.97397, 38.36221], [-121.97429, 38.36265], [-121.9747, 38.36295], [-121.97565, 38.36655], [-121.97632, 38.36709], [-121.97683, 38.36701], [-121.97731, 38.36884], [-121.97742, 38.36905]]]} | Open Access 1 | 13051 | Allison | 15384 | 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 | 117.224 | Allison | None 706 | |||
8906 | 8906 | 8905 | {"type": "Polygon", "coordinates": [[[-121.97746, 38.33536], [-121.97613, 38.33537], [-121.97493, 38.33531], [-121.97494, 38.33448], [-121.97594, 38.3345], [-121.97638, 38.3345], [-121.97697, 38.33447], [-121.97703, 38.33448], [-121.97746, 38.33536]]]} | Open Access 1 | 14606 | Irene Larsen Park | 20230 | 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.766 | Irene Larsen Park | 0 | Local Park 2 | 4 | |
8907 | 8907 | 8906 | {"type": "Polygon", "coordinates": [[[-121.93771, 38.33788], [-121.93742, 38.33801], [-121.93737, 38.33801], [-121.93735, 38.33792], [-121.93726, 38.33783], [-121.93714, 38.33766], [-121.93745, 38.33754], [-121.93746, 38.33756], [-121.93748, 38.33755], [-121.93771, 38.33788]]]} | Open Access 1 | 14608 | Normandy Meadows Park | 22802 | 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 | 0.348 | Normandy Meadows Park | 0 | Local Park 2 | 4 | |
8909 | 8909 | 8908 | {"type": "Polygon", "coordinates": [[[-121.93802, 38.34747], [-121.93781, 38.34767], [-121.93757, 38.34785], [-121.93717, 38.34808], [-121.93699, 38.3479], [-121.9367, 38.34778], [-121.93632, 38.34772], [-121.93654, 38.3474], [-121.93659, 38.34724], [-121.93655, 38.3469], [-121.93738, 38.34715], [-121.93774, 38.34731], [-121.93802, 38.34747]]]} | Open Access 1 | 14616 | Arbor Oaks Park | 15557 | 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.503 | Arbor Oaks Park | 0 | Local Park 2 | 4 | |
9748 | 9748 | 9747 | {"type": "Polygon", "coordinates": [[[-121.98866, 38.35885], [-121.98857, 38.35893], [-121.98489, 38.35886], [-121.98493, 38.35843], [-121.98517, 38.35843], [-121.98537, 38.35827], [-121.98498, 38.35785], [-121.98504, 38.35727], [-121.98495, 38.35707], [-121.98476, 38.357], [-121.98317, 38.35716], [-121.98315, 38.35668], [-121.984, 38.35666], [-121.98554, 38.3566], [-121.98614, 38.35655], [-121.98634, 38.35662], [-121.98647, 38.35669], [-121.9865, 38.357], [-121.98673, 38.35701], [-121.98674, 38.35711], [-121.98675, 38.35712], [-121.98691, 38.35713], [-121.98691, 38.3574], [-121.98711, 38.35757], [-121.9877, 38.35759], [-121.98774, 38.35792], [-121.98819, 38.35837], [-121.98866, 38.35836], [-121.98866, 38.35885]]]} | Open Access 1 | 16539 | Andrews/Ulatis Park | 15487 | 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 | 15.768 | Andrews/Ulatis 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 |
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]);