units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
55 rows where MNG_AGENCY = 147 sorted by COUNTY
This data as json, copyable, CSV (advanced)
DES_TP 4
- Local Park 17
- Local Recreation Area 16
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 35
MNG_AGENCY 1
- Vacaville, City of · 35 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
5347 | 5347 | 5346 | {"type": "Polygon", "coordinates": [[[-122.00394, 38.33651], [-122.00342, 38.33696], [-122.0018, 38.33955], [-121.99917, 38.33814], [-121.99914, 38.33738], [-121.99936, 38.33664], [-122.00059, 38.3361], [-122.00121, 38.33573], [-122.00143, 38.33553], [-122.00235, 38.33524], [-122.00274, 38.33502], [-122.00394, 38.33651]]]} | Open Access 1 | 35076 | Alpine Open Space | 15407 | 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 | 29.282 | Alpine OS | 0 | Local Recreation Area 3 | 4 | |
5468 | 5468 | 5467 | {"type": "Polygon", "coordinates": [[[-121.97027, 38.32362], [-121.97026, 38.32469], [-121.96781, 38.3247], [-121.9669, 38.32472], [-121.96688, 38.32522], [-121.96659, 38.32523], [-121.9665, 38.32514], [-121.96653, 38.32505], [-121.96642, 38.32498], [-121.96647, 38.32489], [-121.96627, 38.32474], [-121.96611, 38.32474], [-121.96563, 38.32464], [-121.96545, 38.3247], [-121.96449, 38.32546], [-121.96358, 38.32469], [-121.96559, 38.32255], [-121.96622, 38.32294], [-121.96757, 38.3234], [-121.96851, 38.32358], [-121.97027, 38.32362]]]} | Open Access 1 | 17315 | Arlington Park | 15592 | 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 | 22.737 | Arlington Park | 0 | Local Park 2 | 4 | |
5533 | 5533 | 5532 | {"type": "Polygon", "coordinates": [[[-121.99558, 38.35148], [-121.99557, 38.35246], [-121.99455, 38.35242], [-121.99456, 38.35201], [-121.99463, 38.35204], [-121.99477, 38.35189], [-121.99494, 38.35198], [-121.9955, 38.35142], [-121.99558, 38.35148]]]} | Open Access 1 | 28308 | City Hall Park | 17297 | 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 | 1.604 | City Hall Park | 0 | Local Park 2 | 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 | |
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 | |
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 | |
10299 | 10299 | 10298 | {"type": "Polygon", "coordinates": [[[-121.98466, 38.34086], [-121.98464, 38.34235], [-121.98409, 38.34235], [-121.98391, 38.34241], [-121.98377, 38.3425], [-121.9837, 38.3425], [-121.98344, 38.34239], [-121.98326, 38.34234], [-121.98295, 38.34233], [-121.98292, 38.34226], [-121.98292, 38.34209], [-121.98289, 38.34198], [-121.98282, 38.34182], [-121.98276, 38.34172], [-121.98274, 38.34156], [-121.98275, 38.34126], [-121.98279, 38.34108], [-121.98296, 38.34101], [-121.98302, 38.34093], [-121.98312, 38.34087], [-121.98466, 38.34086]]]} | Open Access 1 | 18448 | Padan Park | 23313 | 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.609 | Padan Park | 0 | Local Park 2 | 4 | |
10383 | 10383 | 10382 | {"type": "Polygon", "coordinates": [[[-122.01592, 38.33745], [-122.01541, 38.33809], [-122.01471, 38.33888], [-122.01378, 38.33972], [-122.01295, 38.34032], [-122.01236, 38.34048], [-122.01211, 38.3406], [-122.01207, 38.33932], [-122.01272, 38.3377], [-122.01336, 38.33575], [-122.01469, 38.33439], [-122.01521, 38.3342], [-122.01521, 38.33503], [-122.01512, 38.3351], [-122.01507, 38.33517], [-122.015, 38.33626], [-122.01496, 38.33722], [-122.01503, 38.33727], [-122.01516, 38.3371], [-122.01592, 38.33745]]]} | Open Access 1 | 18591 | Pena Adobe Park | 23574 | 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 | 27.862 | Pena Adobe Park | 0 | Local Park 2 | 4 | |
10484 | 10484 | 10483 | {"type": "Polygon", "coordinates": [[[-121.93713, 38.35011], [-121.9371, 38.35129], [-121.93419, 38.35123], [-121.93413, 38.35121], [-121.93412, 38.35071], [-121.93458, 38.35072], [-121.93493, 38.35078], [-121.93534, 38.35094], [-121.93547, 38.35091], [-121.9358, 38.35049], [-121.93598, 38.35031], [-121.93639, 38.35036], [-121.93664, 38.35006], [-121.93713, 38.35011]]]} | Open Access 1 | 18568 | Patwin Park | 23525 | 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.201 | Patwin Park | 0 | Local Park 2 | 4 | |
10486 | 10486 | 10485 | {"type": "Polygon", "coordinates": [[[-121.96102, 38.34372], [-121.96098, 38.34418], [-121.95996, 38.34417], [-121.95962, 38.34419], [-121.95942, 38.34426], [-121.95929, 38.34436], [-121.95911, 38.34456], [-121.9591, 38.34461], [-121.95905, 38.34472], [-121.95863, 38.34452], [-121.95828, 38.34438], [-121.96021, 38.34292], [-121.96031, 38.34294], [-121.96038, 38.34319], [-121.96045, 38.34331], [-121.96072, 38.34351], [-121.96097, 38.34362], [-121.96102, 38.34372]]]} | Open Access 1 | 18577 | Beelard Park | 15952 | 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.892 | Beelard Park | 0 | Local Park 2 | 4 | |
11331 | 11331 | 11330 | {"type": "Polygon", "coordinates": [[[-122.01841, 38.32477], [-122.01821, 38.32489], [-122.018, 38.32506], [-122.01783, 38.32526], [-122.0177, 38.32549], [-122.01567, 38.32821], [-122.01534, 38.33212], [-122.01512, 38.33214], [-122.01529, 38.33347], [-122.01529, 38.33361], [-122.01521, 38.33362], [-122.01521, 38.33419], [-122.01469, 38.3344], [-122.01336, 38.33575], [-122.01314, 38.33641], [-122.01294, 38.33583], [-122.01277, 38.33548], [-122.01239, 38.33526], [-122.01239, 38.33499], [-122.01215, 38.33462], [-122.01187, 38.33449], [-122.01159, 38.33443], [-122.01065, 38.33438], [-122.01031, 38.33462], [-122.01031, 38.33707], [-122.00995, 38.33726], [-122.00952, 38.33699], [-122.00902, 38.33686], [-122.00871, 38.33667], [-122.00844, 38.33632], [-122.00768, 38.33624], [-122.00746, 38.33595], [-122.00746, 38.33528], [-122.00763, 38.33509], [-122.00804, 38.33496], [-122.00825, 38.33487], [-122.00839, 38.33416], [-122.00847, 38.33366], [-122.00821, 38.3329], [-122.00808, 38.33272], [-122.0076, 38.33259], [-122.00724, 38.33278], [-122.00706, 38.33277], [-122.0067, 38.33279], [-122.0066, 38.33277], [-122.00653, 38.33273], [-122.00649, 38.33268], [-122.00586, 38.33217], [-122.00527, 38.33192], [-122.00535, 38.33177], [-122.00551, 38.33159], [-122.00573, 38.33143], [-122.00593, 38.33136], [-122.00599, 38.3313], [-122.00601, 38.33122], [-122.00594, 38.33089], [-122.00608, 38.33073], [-122.00611, 38.33061], [-122.0061, 38.33051], [-122.00603, 38.33039], [-122.00524, 38.33001], [-122.00462, 38.32985], [-122.00462, 38.32935], [-122.00494, 38.32886], [-122.00503, 38.32879], [-122.00509, 38.32872], [-122.00512, 38.32862], [-122.00512, 38.32854], [-122.0051, 38.32842], [-122.00512, 38.32831], [-122.00521, 38.3282], [-122.00537, 38.32809], [-122.00542, 38.32799], [-122.00541, 38.32792], [-122.00537, 38.32785], [-122.00532, 38.32781], [-122.0052, 38.32776], [-122.0045, 38.32771], [-122.00393, 38.32763], [-122.00383, 38.32757], [-122.00378, 38.3275], [-122.00376, 38.32745], [-122.00371, 38.32697], [-122.00375, 38.3269], [-122.00378, 38.3268], [-122.00379, 38.32671], [-122.00376, 38.32661], [-122.00396, 38.32651], [-122.00422, 38.32642], [-122.0046, 38.32633], [-122.00459, 38.32639], [-122.00461, 38.32645], [-122.00468, 38.32654], [-122.00476, 38.32657], [-122.00482, 38.32658], [-122.00491, 38.32658], [-122.005, 38.32654], [-122.00507, 38.32647], [-122.00514, 38.32636], [-122.00531, 38.32593], [-122.00514, 38.32564], [-122.00532, 38.32559], [-122.00564, 38.32587], [-122.00561, 38.32594], [-122.00562, 38.32602], [-122.00568, 38.3261], [-122.00575, 38.32614], [-122.0059, 38.32616], [-122.00602, 38.32612], [-122.0061, 38.32603], [-122.00612, 38.32599], [-122.0061, 38.32594], [-122.00601, 38.32575], [-122.00587, 38.32556], [-122.00572, 38.32544], [-122.0055, 38.32532], [-122.00525, 38.32524], [-122.00493, 38.3252], [-122.00467, 38.32522], [-122.0044, 38.32528], [-122.00356, 38.32494], [-122.00361, 38.32472], [-122.00328, 38.32416], [-122.00293, 38.32384], [-122.00339, 38.32387], [-122.0066, 38.32394], [-122.00992, 38.32416], [-122.0099, 38.3243], [-122.01008, 38.32432], [-122.0153, 38.32438], [-122.01554, 38.32438], [-122.01615, 38.32444], [-122.01688, 38.32465], [-122.01709, 38.32475], [-122.01841, 38.32477]]]} | Open Access 1 | 22072 | Lagoon Valley Park | 14399 | 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 | 276.53 | Lagoon Valley Park | 0 | Local Park 2 | 4 |
11334 | 11334 | 11333 | {"type": "Polygon", "coordinates": [[[-122.03688, 38.31196], [-122.03629, 38.31305], [-122.03366, 38.31645], [-122.03216, 38.31563], [-122.03232, 38.31462], [-122.03293, 38.31293], [-122.03356, 38.30987], [-122.03451, 38.30962], [-122.03456, 38.30784], [-122.03685, 38.3093], [-122.03577, 38.3104], [-122.03688, 38.31196]]]} | No Public Access 3 | 22071 | Lagoon Valley Gateway Open Space | 30788 | 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 | 50.705 | Lagoon Valley Gateway OS | 0 | Local Recreation Area 3 | 4 | |
11338 | 11338 | 11337 | {"type": "Polygon", "coordinates": [[[-121.99693, 38.3399], [-121.99577, 38.34086], [-121.99406, 38.34217], [-121.99346, 38.34176], [-121.99261, 38.34113], [-121.99289, 38.34091], [-121.9936, 38.3404], [-121.99383, 38.34032], [-121.99401, 38.34023], [-121.99425, 38.34004], [-121.99457, 38.33986], [-121.99499, 38.33954], [-121.99492, 38.33946], [-121.99477, 38.33904], [-121.99459, 38.33877], [-121.9945, 38.33855], [-121.99436, 38.33852], [-121.99429, 38.33846], [-121.99407, 38.33836], [-121.99396, 38.33824], [-121.99389, 38.33811], [-121.99381, 38.33811], [-121.99363, 38.3383], [-121.99361, 38.33829], [-121.99375, 38.33808], [-121.99376, 38.33797], [-121.99371, 38.33792], [-121.99365, 38.3379], [-121.99355, 38.33789], [-121.99342, 38.33792], [-121.99329, 38.338], [-121.99322, 38.33809], [-121.99288, 38.33819], [-121.99283, 38.33818], [-121.99272, 38.33815], [-121.99281, 38.33792], [-121.99275, 38.33787], [-121.99273, 38.33779], [-121.99252, 38.3377], [-121.99249, 38.33765], [-121.99242, 38.33765], [-121.99233, 38.33762], [-121.9921, 38.33758], [-121.99175, 38.33757], [-121.99145, 38.33732], [-121.99115, 38.33701], [-121.99102, 38.33696], [-121.99087, 38.33699], [-121.99045, 38.33689], [-121.99029, 38.33667], [-121.99014, 38.33642], [-121.98992, 38.33612], [-121.98972, 38.33599], [-121.98959, 38.33599], [-121.98952, 38.33606], [-121.98949, 38.33606], [-121.98944, 38.33611], [-121.98929, 38.33619], [-121.98913, 38.33634], [-121.98898, 38.33642], [-121.98865, 38.33666], [-121.98856, 38.33665], [-121.98848, 38.33669], [-121.98835, 38.33666], [-121.98821, 38.3366], [-121.98803, 38.33659], [-121.98791, 38.33656], [-121.9876, 38.33663], [-121.98727, 38.33662], [-121.98696, 38.33652], [-121.98662, 38.33648], [-121.98631, 38.33624], [-121.98634, 38.33622], [-121.98666, 38.33619], [-121.98688, 38.33625], [-121.98709, 38.33627], [-121.98734, 38.33627], [-121.98749, 38.3363], [-121.98765, 38.33625], [-121.98788, 38.33623], [-121.98806, 38.33626], [-121.98832, 38.33627], [-121.98852, 38.33631], [-121.98854, 38.3363], [-121.98866, 38.33628], [-121.98885, 38.33615], [-121.98898, 38.33602], [-121.98898, 38.3359], [-121.9891, 38.33585], [-121.98922, 38.33573], [-121.9893, 38.33566], [-121.98937, 38.33552], [-121.98963, 38.33556], [-121.9898, 38.33561], [-121.98998, 38.33581], [-121.99017, 38.33599], [-121.99055, 38.3364], [-121.99083, 38.33656], [-121.99099, 38.33658], [-121.99116, 38.33642], [-121.99122, 38.33646], [-121.99129, 38.33654], [-121.99152, 38.33687], [-121.99164, 38.337], [-121.99179, 38.33708], [-121.99207, 38.33717], [-121.99253, 38.33722], [-121.99297, 38.33733], [-121.99303, 38.33736], [-121.99304, 38.3375], [-121.99311, 38.33754], [-121.99322, 38.33755], [-121.9933, 38.33754], [-121.99337, 38.33745], [-121.99396, 38.33745], [-121.99402, 38.33744], [-121.99425, 38.33761], [-121.99458, 38.33796], [-121.99484, 38.33826], [-121.99491, 38.33827], [-121.99505, 38.33845], [-121.99558, 38.33901], [-121.99585, 38.33923], [-121.9961, 38.33939], [-121.9967, 38.33973], [-121.99693, 38.3399]]]} | Open Access 1 | 22104 | Three Oaks Park | 26333 | 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.071 | Three Oaks Park | 0 | Local Park 2 | 4 | |
12476 | 12476 | 12475 | {"type": "Polygon", "coordinates": [[[-122.00372, 38.35245], [-122.00296, 38.35252], [-122.00294, 38.3523], [-122.00275, 38.35231], [-122.00272, 38.35216], [-122.00244, 38.35216], [-122.00227, 38.35204], [-122.00224, 38.35177], [-122.00199, 38.35177], [-122.00197, 38.35154], [-122.00179, 38.35153], [-122.00176, 38.35144], [-122.00151, 38.35143], [-122.00148, 38.35103], [-122.0019, 38.35074], [-122.00199, 38.35076], [-122.00224, 38.35092], [-122.00243, 38.35107], [-122.00248, 38.35121], [-122.00263, 38.35141], [-122.00357, 38.35193], [-122.00365, 38.352], [-122.00372, 38.35245]]]} | Restricted Access 2 | 28306 | Alamo School Park | 31601 | 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.025 | Alamo School 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]);