units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where DES_TP = 3, GAP_STS = 4, MNG_AGENCY = 147 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, LABEL_NAME, YR_EST
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 17 ✖
MNG_AGENCY 1
- Vacaville, City of · 17 ✖
DES_TP 1
- Local Recreation Area · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
12858 | 12858 | 12857 | {"type": "Polygon", "coordinates": [[[-122.03267, 38.31034], [-122.03263, 38.31122], [-122.03261, 38.31135], [-122.03212, 38.3133], [-122.02898, 38.31232], [-122.02885, 38.31231], [-122.02696, 38.31291], [-122.0254, 38.31237], [-122.02458, 38.31092], [-122.02115, 38.30989], [-122.0203, 38.30958], [-122.01987, 38.30887], [-122.01952, 38.30865], [-122.01898, 38.3085], [-122.01805, 38.30781], [-122.01789, 38.30725], [-122.0191, 38.30705], [-122.02055, 38.30706], [-122.02129, 38.30724], [-122.02334, 38.30805], [-122.02476, 38.30814], [-122.02476, 38.30826], [-122.02483, 38.30887], [-122.0281, 38.30887], [-122.02811, 38.30884], [-122.02937, 38.30929], [-122.02941, 38.30957], [-122.02961, 38.30975], [-122.02986, 38.30979], [-122.03025, 38.30968], [-122.0305, 38.30968], [-122.03063, 38.31002], [-122.03106, 38.31005], [-122.03113, 38.30985], [-122.03152, 38.31008], [-122.03182, 38.31012], [-122.03188, 38.3105], [-122.03204, 38.31066], [-122.03224, 38.31115], [-122.03235, 38.31105], [-122.03267, 38.31034]]]} | Restricted Access 2 | 22288 | Lagoon Valley Gateway Open Space | 30789 | 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 | 96.658 | Lagoon Valley Gateway OS | 0 | Local Recreation Area 3 | 4 | |
13142 | 13142 | 13141 | {"type": "Polygon", "coordinates": [[[-121.99936, 38.33664], [-121.99914, 38.33738], [-121.99915, 38.33769], [-121.99913, 38.33762], [-121.99905, 38.33754], [-121.99895, 38.33751], [-121.99884, 38.33751], [-121.99873, 38.33756], [-121.99847, 38.3378], [-121.99825, 38.3379], [-121.99811, 38.33793], [-121.99755, 38.33794], [-121.99736, 38.33801], [-121.99725, 38.3381], [-121.99718, 38.33821], [-121.997, 38.33895], [-121.99696, 38.339], [-121.99628, 38.33926], [-121.99594, 38.33904], [-121.99567, 38.33881], [-121.99606, 38.33865], [-121.99624, 38.33847], [-121.99647, 38.33758], [-121.99646, 38.33752], [-121.99643, 38.33749], [-121.99622, 38.33734], [-121.99624, 38.3373], [-121.99624, 38.33725], [-121.99693, 38.3366], [-121.99733, 38.33673], [-121.99737, 38.33691], [-121.99731, 38.3372], [-121.99751, 38.33737], [-121.99804, 38.33741], [-121.99824, 38.33732], [-121.99849, 38.33711], [-121.99936, 38.33664]]]} | Open Access 1 | 35077 | Hidden Oaks Open Space | 19910 | 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.409 | Hidden Oaks OS | 0 | Local Recreation Area 3 | 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 | |
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 | |
16132 | 16132 | 16131 | {"type": "Polygon", "coordinates": [[[-122.01314, 38.33641], [-122.01272, 38.3377], [-122.01207, 38.33932], [-122.01211, 38.3406], [-122.01207, 38.34063], [-122.01195, 38.3409], [-122.00985, 38.34186], [-122.0084, 38.34237], [-122.00697, 38.34276], [-122.00416, 38.34191], [-122.00387, 38.34233], [-122.00373, 38.3423], [-122.00366, 38.3423], [-122.00351, 38.34233], [-122.00342, 38.34238], [-122.00342, 38.34115], [-122.00293, 38.34125], [-122.00275, 38.34127], [-122.00248, 38.34125], [-122.0023, 38.34113], [-122.0019, 38.34082], [-122.00162, 38.34072], [-122.00137, 38.34055], [-122.0012, 38.34051], [-122.00341, 38.33696], [-122.00394, 38.33651], [-122.0045, 38.33468], [-122.00499, 38.33362], [-122.00477, 38.33304], [-122.00442, 38.33301], [-122.00123, 38.33327], [-122.00101, 38.33371], [-121.99996, 38.33324], [-121.99989, 38.33312], [-121.99992, 38.33303], [-121.99991, 38.33301], [-122.00042, 38.33116], [-121.99865, 38.33014], [-121.99839, 38.32952], [-121.99772, 38.32771], [-121.99774, 38.32765], [-121.99771, 38.3276], [-121.99821, 38.32574], [-121.9982, 38.32572], [-121.9968, 38.32506], [-121.99654, 38.32489], [-121.99536, 38.32374], [-121.99432, 38.32243], [-121.99278, 38.32029], [-121.99208, 38.31894], [-121.99045, 38.31569], [-121.99873, 38.31576], [-121.99868, 38.31606], [-121.99862, 38.31621], [-121.99853, 38.31634], [-121.99833, 38.31654], [-121.99859, 38.31675], [-121.99887, 38.31672], [-121.99927, 38.31678], [-121.99958, 38.31688], [-122.00022, 38.31718], [-122.00036, 38.31783], [-122.00033, 38.31796], [-122.00016, 38.31818], [-122.00015, 38.31825], [-122.00017, 38.31832], [-122.00025, 38.31841], [-122.00107, 38.31887], [-122.00115, 38.31949], [-122.00101, 38.31978], [-122.00093, 38.31985], [-122.00076, 38.31989], [-122.00062, 38.31988], [-121.9996, 38.31954], [-121.99933, 38.31988], [-121.99934, 38.31989], [-121.9995, 38.31986], [-121.9997, 38.31987], [-121.99988, 38.31994], [-121.99996, 38.31999], [-122.00002, 38.32005], [-122.00009, 38.32016], [-122.00038, 38.32051], [-122.00075, 38.32065], [-122.00097, 38.32085], [-122.00124, 38.32127], [-122.00097, 38.32152], [-122.00111, 38.32161], [-122.00135, 38.32156], [-122.00144, 38.32169], [-122.00069, 38.32212], [-122.00068, 38.32213], [-122.0008, 38.32227], [-122.00182, 38.32206], [-122.00234, 38.32186], [-122.00267, 38.3219], [-122.00318, 38.32209], [-122.00345, 38.32238], [-122.00354, 38.32253], [-122.00356, 38.32267], [-122.00319, 38.32333], [-122.00334, 38.32372], [-122.003, 38.32381], [-122.00294, 38.32384], [-122.00328, 38.32416], [-122.00361, 38.32472], [-122.00357, 38.32494], [-122.0044, 38.32528], [-122.00456, 38.32524], [-122.00488, 38.3252], [-122.00509, 38.32521], [-122.00535, 38.32527], [-122.00559, 38.32536], [-122.0058, 38.3255], [-122.00596, 38.32567], [-122.00607, 38.32586], [-122.00612, 38.32599], [-122.00607, 38.32608], [-122.00602, 38.32612], [-122.00594, 38.32615], [-122.00579, 38.32615], [-122.00569, 38.32611], [-122.00564, 38.32605], [-122.00561, 38.32597], [-122.00563, 38.32587], [-122.00532, 38.32559], [-122.00515, 38.32563], [-122.00531, 38.32593], [-122.00514, 38.32636], [-122.00507, 38.32647], [-122.005, 38.32654], [-122.00486, 38.32658], [-122.00478, 38.32658], [-122.0047, 38.32655], [-122.00465, 38.32651], [-122.00461, 38.32646], [-122.00459, 38.32634], [-122.00422, 38.32642], [-122.00396, 38.32651], [-122.00376, 38.3266], [-122.00379, 38.32671], [-122.00378, 38.3268], [-122.00375, 38.3269], [-122.00371, 38.32697], [-122.00376, 38.32745], [-122.00378, 38.3275], [-122.00383, 38.32757], [-122.00393, 38.32763], [-122.0045, 38.32771], [-122.0052, 38.32776], [-122.00532, 38.32781], [-122.00537, 38.32785], [-122.00541, 38.32792], [-122.00542, 38.32799], [-122.00537, 38.32809], [-122.00521, 38.3282], [-122.00512, 38.32831], [-122.0051, 38.32842], [-122.00512, 38.32854], [-122.00512, 38.32862], [-122.00509, 38.32872], [-122.00503, 38.32879], [-122.00494, 38.32886], [-122.00462, 38.32935], [-122.00462, 38.32984], [-122.00524, 38.33001], [-122.00603, 38.33039], [-122.0061, 38.33051], [-122.00611, 38.33061], [-122.00608, 38.33073], [-122.00594, 38.33089], [-122.00601, 38.33122], [-122.00599, 38.3313], [-122.00593, 38.33135], [-122.00573, 38.33143], [-122.00551, 38.33159], [-122.00535, 38.33177], [-122.00528, 38.33192], [-122.00586, 38.33217], [-122.00649, 38.33268], [-122.00653, 38.33273], [-122.0066, 38.33277], [-122.0067, 38.33279], [-122.00706, 38.33277], [-122.00724, 38.33278], [-122.0076, 38.33259], [-122.00808, 38.33273], [-122.00821, 38.3329], [-122.00847, 38.33366], [-122.00839, 38.33416], [-122.00825, 38.33487], [-122.00804, 38.33496], [-122.00763, 38.33509], [-122.00746, 38.33528], [-122.00746, 38.33595], [-122.00768, 38.33624], [-122.00844, 38.33632], [-122.00871, 38.33667], [-122.00902, 38.33686], [-122.00952, 38.33699], [-122.00996, 38.33726], [-122.01031, 38.33707], [-122.01031, 38.33462], [-122.01065, 38.33438], [-122.01159, 38.33443], [-122.01187, 38.33449], [-122.01215, 38.33462], [-122.01239, 38.33499], [-122.01239, 38.33526], [-122.01277, 38.33548], [-122.01294, 38.33583], [-122.01314, 38.33641]]]} | Open Access 1 | 17230 | Lagoon Valley Hills Open Space | 14397 | 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 | 480.368 | Lagoon Valley Hills OS | 0 | Local Recreation Area 3 | 4 | |
16141 | 16141 | 16140 | {"type": "MultiPolygon", "coordinates": [[[[-122.03212, 38.31331], [-122.03196, 38.3141], [-122.0313, 38.31544], [-122.03096, 38.31544], [-122.03056, 38.31614], [-122.0301, 38.31688], [-122.03005, 38.31707], [-122.03027, 38.31735], [-122.02952, 38.31821], [-122.02738, 38.32038], [-122.02634, 38.32147], [-122.02566, 38.32227], [-122.02487, 38.32309], [-122.0247, 38.32296], [-122.02481, 38.32271], [-122.02483, 38.32231], [-122.02483, 38.32091], [-122.02485, 38.32029], [-122.0247, 38.32019], [-122.02475, 38.31971], [-122.0241, 38.31956], [-122.0236, 38.31937], [-122.02353, 38.3194], [-122.02348, 38.31936], [-122.02274, 38.31931], [-122.02228, 38.31923], [-122.02192, 38.31888], [-122.0215, 38.31869], [-122.02116, 38.31849], [-122.02102, 38.31823], [-122.02092, 38.31819], [-122.02096, 38.31815], [-122.02096, 38.31813], [-122.02055, 38.31799], [-122.01993, 38.31769], [-122.01946, 38.3173], [-122.01902, 38.31716], [-122.01847, 38.31693], [-122.018, 38.31679], [-122.01748, 38.3165], [-122.01657, 38.31619], [-122.0151, 38.3158], [-122.01478, 38.31549], [-122.01664, 38.31423], [-122.01662, 38.31401], [-122.01662, 38.31386], [-122.01666, 38.31363], [-122.0167, 38.3135], [-122.01679, 38.3133], [-122.01718, 38.31269], [-122.01719, 38.31264], [-122.01713, 38.31259], [-122.01662, 38.31255], [-122.01647, 38.31252], [-122.01631, 38.31243], [-122.01624, 38.31236], [-122.01617, 38.31227], [-122.01613, 38.31219], [-122.01612, 38.31209], [-122.01615, 38.31194], [-122.01619, 38.31185], [-122.01642, 38.31155], [-122.01651, 38.31136], [-122.01649, 38.31128], [-122.01645, 38.31124], [-122.0164, 38.31121], [-122.01614, 38.31119], [-122.01585, 38.3112], [-122.01556, 38.31124], [-122.01526, 38.31132], [-122.01513, 38.3114], [-122.01506, 38.31147], [-122.01501, 38.31158], [-122.015, 38.31175], [-122.01495, 38.31183], [-122.01488, 38.31189], [-122.01477, 38.31193], [-122.01466, 38.31195], [-122.01453, 38.31193], [-122.01442, 38.31187], [-122.01427, 38.31127], [-122.01425, 38.31107], [-122.01427, 38.31084], [-122.01435, 38.31059], [-122.01478, 38.30969], [-122.01478, 38.30965], [-122.01477, 38.3096], [-122.01473, 38.30955], [-122.0145, 38.30941], [-122.01443, 38.30938], [-122.01382, 38.30946], [-122.01352, 38.30948], [-122.01333, 38.30946], [-122.01311, 38.3094], [-122.01293, 38.30928], [-122.01278, 38.30911], [-122.01274, 38.30903], [-122.0127, 38.30886], [-122.01269, 38.30872], [-122.01858, 38.30883], [-122.01866, 38.30895], [-122.01898, 38.30911], [-122.02115, 38.30989], [-122.02458, 38.31092], [-122.0254, 38.31237], [-122.02696, 38.31291], [-122.02885, 38.31231], [-122.02898, 38.31232], [-122.03212, 38.31331]], [[-122.02474, 38.31963], [-122.02475, 38.31964], [-122.02476, 38.31963], [-122.02475, 38.31962], [-122.02474, 38.31963]]], [[[-122.03081, 38.3203], [-122.03054, 38.32057], [-122.03033, 38.32076], [-122.02936, 38.32075], [-122.02948, 38.32125], [-122.02987, 38.32264], [-122.02992, 38.32293], [-122.03005, 38.3234], [-122.03005, 38.32493], [-122.02932, 38.325], [-122.02804, 38.32553], [-122.02611, 38.32602], [-122.02533, 38.32521], [-122.02522, 38.325], [-122.02514, 38.32475], [-122.02511, 38.32448], [-122.02514, 38.32422], [-122.02521, 38.32396], [-122.02543, 38.32374], [-122.0258, 38.32326], [-122.02614, 38.32278], [-122.0283, 38.32044], [-122.02862, 38.32014], [-122.03003, 38.31861], [-122.03081, 38.3203]]]]} | No Public Access 3 | 17793 | Lagoon Valley Open Space | 30790 | 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 | 346.712 | Lagoon Valley OS | 0 | Local Recreation Area 3 | 4 | |
16172 | 16172 | 16171 | {"type": "Polygon", "coordinates": [[[-121.99711, 38.33597], [-121.99696, 38.33658], [-121.99624, 38.33724], [-121.99624, 38.33727], [-121.99622, 38.33729], [-121.99618, 38.33722], [-121.99598, 38.33713], [-121.99592, 38.33707], [-121.9959, 38.33707], [-121.99558, 38.3369], [-121.9953, 38.3368], [-121.99497, 38.33653], [-121.9947, 38.33614], [-121.99455, 38.3357], [-121.99448, 38.33566], [-121.99442, 38.33555], [-121.99457, 38.33541], [-121.99466, 38.33526], [-121.99474, 38.33509], [-121.99478, 38.33493], [-121.99488, 38.33482], [-121.99491, 38.33477], [-121.9949, 38.3347], [-121.99482, 38.33466], [-121.99468, 38.33465], [-121.99458, 38.33456], [-121.99437, 38.33453], [-121.99421, 38.33453], [-121.99402, 38.33444], [-121.99364, 38.33418], [-121.99354, 38.33409], [-121.99357, 38.33405], [-121.9936, 38.33403], [-121.9937, 38.3342], [-121.99393, 38.33436], [-121.99423, 38.33447], [-121.9947, 38.33448], [-121.99521, 38.3346], [-121.99522, 38.33477], [-121.99501, 38.33517], [-121.99493, 38.33561], [-121.99504, 38.33593], [-121.99519, 38.33606], [-121.99598, 38.33629], [-121.99698, 38.33581], [-121.99711, 38.33597]]]} | Open Access 1 | 22095 | California Drive Open Space | 16717 | 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.805 | California Drive OS | 0 | Local Recreation Area 3 | 4 | |
16173 | 16173 | 16172 | {"type": "Polygon", "coordinates": [[[-122.01907, 38.36268], [-122.01801, 38.3627], [-122.01722, 38.36269], [-122.01692, 38.3627], [-122.01674, 38.36274], [-122.01612, 38.36323], [-122.01603, 38.36324], [-122.01575, 38.36316], [-122.01568, 38.36303], [-122.01546, 38.36301], [-122.01514, 38.36284], [-122.01505, 38.36275], [-122.01487, 38.36264], [-122.01485, 38.36257], [-122.01469, 38.36256], [-122.01446, 38.36247], [-122.01446, 38.3624], [-122.01436, 38.3624], [-122.01413, 38.36224], [-122.01412, 38.36206], [-122.01394, 38.36187], [-122.01372, 38.36176], [-122.01351, 38.36151], [-122.0132, 38.36188], [-122.01327, 38.36198], [-122.01287, 38.36241], [-122.01247, 38.36287], [-122.01131, 38.36425], [-122.01107, 38.36415], [-122.01164, 38.36351], [-122.01209, 38.36296], [-122.01312, 38.3618], [-122.01305, 38.36166], [-122.0133, 38.36136], [-122.01329, 38.36133], [-122.01345, 38.36123], [-122.01345, 38.36111], [-122.0133, 38.36097], [-122.01317, 38.36079], [-122.01298, 38.36059], [-122.01282, 38.36038], [-122.01272, 38.36018], [-122.01258, 38.36], [-122.01238, 38.35981], [-122.01212, 38.35966], [-122.01162, 38.35965], [-122.01102, 38.35973], [-122.01048, 38.35977], [-122.01044, 38.35981], [-122.01015, 38.35983], [-122.01015, 38.35987], [-122.01007, 38.35989], [-122.00989, 38.36001], [-122.0097, 38.35998], [-122.00963, 38.35988], [-122.00969, 38.35977], [-122.00952, 38.35963], [-122.00966, 38.35954], [-122.00999, 38.35964], [-122.01007, 38.35962], [-122.01202, 38.3595], [-122.01228, 38.3596], [-122.0126, 38.35978], [-122.01269, 38.3599], [-122.0129, 38.36006], [-122.01293, 38.36023], [-122.01305, 38.36036], [-122.01315, 38.36043], [-122.01332, 38.36066], [-122.01341, 38.36081], [-122.01364, 38.36103], [-122.01385, 38.36085], [-122.01395, 38.36088], [-122.014, 38.36093], [-122.01399, 38.36095], [-122.01402, 38.361], [-122.01368, 38.36139], [-122.01377, 38.3615], [-122.01399, 38.3615], [-122.01406, 38.36152], [-122.01412, 38.36158], [-122.01418, 38.36158], [-122.01434, 38.36166], [-122.01443, 38.36175], [-122.01452, 38.362], [-122.01457, 38.36201], [-122.0146, 38.36207], [-122.0149, 38.36209], [-122.01493, 38.36213], [-122.01513, 38.36216], [-122.01528, 38.36221], [-122.01528, 38.36223], [-122.0154, 38.36227], [-122.0154, 38.36238], [-122.01529, 38.36257], [-122.01525, 38.3626], [-122.01523, 38.36265], [-122.01541, 38.3628], [-122.01562, 38.36282], [-122.01574, 38.36274], [-122.01598, 38.36287], [-122.01613, 38.36273], [-122.01636, 38.36272], [-122.0166, 38.36252], [-122.0166, 38.36241], [-122.01688, 38.36218], [-122.01696, 38.36221], [-122.01698, 38.36217], [-122.01704, 38.36217], [-122.01708, 38.36214], [-122.01746, 38.36224], [-122.01751, 38.36228], [-122.01771, 38.36234], [-122.01789, 38.36232], [-122.01799, 38.36226], [-122.01821, 38.36224], [-122.01838, 38.36229], [-122.01848, 38.36237], [-122.0186, 38.36236], [-122.01886, 38.36227], [-122.01907, 38.36217], [-122.01907, 38.36268]]]} | Open Access 1 | 22096 | Encinosa Creek Open Space | 18671 | 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 | 10.374 | Encinosa Creek OS | 0 | Local Recreation Area 3 | 4 | |
16174 | 16174 | 16173 | {"type": "Polygon", "coordinates": [[[-121.97031, 38.31595], [-121.97027, 38.31703], [-121.97025, 38.31815], [-121.97026, 38.31936], [-121.97023, 38.32043], [-121.96886, 38.31754], [-121.96803, 38.31595], [-121.97008, 38.31593], [-121.97031, 38.31595]]]} | Open Access 1 | 22097 | Foxboro Open Space | 19034 | 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 | 11.942 | Foxboro OS | 0 | Local Recreation Area 3 | 4 | |
16175 | 16175 | 16174 | {"type": "Polygon", "coordinates": [[[-122.01522, 38.3655], [-122.01519, 38.36605], [-122.01351, 38.36602], [-122.01341, 38.36593], [-122.01331, 38.36602], [-122.01274, 38.36641], [-122.012, 38.36514], [-122.01221, 38.36504], [-122.01232, 38.36505], [-122.01258, 38.36485], [-122.01306, 38.36492], [-122.0152, 38.36545], [-122.01522, 38.3655]]]} | Open Access 1 | 22099 | Nob Hill Open Space | 22773 | 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.859 | Nob Hill OS | 0 | Local Recreation Area 3 | 4 | |
16177 | 16177 | 16176 | {"type": "MultiPolygon", "coordinates": [[[[-121.95571, 38.35608], [-121.9555, 38.35613], [-121.95521, 38.35625], [-121.95502, 38.35639], [-121.95503, 38.35702], [-121.95478, 38.35712], [-121.95462, 38.35729], [-121.95419, 38.35762], [-121.95375, 38.35784], [-121.9536, 38.35798], [-121.9535, 38.35802], [-121.95331, 38.35819], [-121.95276, 38.35858], [-121.95268, 38.35856], [-121.95056, 38.36024], [-121.95006, 38.36059], [-121.94989, 38.36061], [-121.94993, 38.36032], [-121.94997, 38.36025], [-121.94998, 38.36019], [-121.95007, 38.36002], [-121.95026, 38.35972], [-121.95044, 38.35949], [-121.951, 38.35907], [-121.95164, 38.35879], [-121.952, 38.35861], [-121.95228, 38.35843], [-121.95277, 38.35801], [-121.95296, 38.35777], [-121.95334, 38.35753], [-121.95407, 38.3574], [-121.9543, 38.35722], [-121.95476, 38.35673], [-121.95481, 38.35649], [-121.95477, 38.35628], [-121.95485, 38.35608], [-121.95508, 38.35594], [-121.95567, 38.35584], [-121.95571, 38.35608]]], [[[-121.97239, 38.35857], [-121.97235, 38.35865], [-121.97212, 38.35854], [-121.97199, 38.35838], [-121.97176, 38.35825], [-121.97142, 38.35824], [-121.97079, 38.35795], [-121.97026, 38.35735], [-121.97015, 38.35727], [-121.97006, 38.35712], [-121.9698, 38.35699], [-121.96954, 38.35694], [-121.9695, 38.35689], [-121.96922, 38.35676], [-121.96909, 38.3564], [-121.96901, 38.35622], [-121.96882, 38.35604], [-121.96832, 38.35587], [-121.968, 38.35574], [-121.96771, 38.35555], [-121.96721, 38.35526], [-121.96682, 38.35522], [-121.96653, 38.35525], [-121.96645, 38.35521], [-121.96606, 38.35524], [-121.96552, 38.35552], [-121.96494, 38.35554], [-121.96475, 38.3554], [-121.96413, 38.35529], [-121.96407, 38.35514], [-121.96392, 38.35498], [-121.96359, 38.35482], [-121.96329, 38.35477], [-121.96246, 38.35476], [-121.96212, 38.35482], [-121.962, 38.35498], [-121.9596, 38.35567], [-121.95957, 38.35566], [-121.95943, 38.35573], [-121.9591, 38.35572], [-121.95883, 38.3557], [-121.95846, 38.35563], [-121.9581, 38.35564], [-121.9578, 38.35578], [-121.95767, 38.35587], [-121.95759, 38.356], [-121.9576, 38.35614], [-121.95733, 38.35614], [-121.95732, 38.35583], [-121.95735, 38.35575], [-121.95735, 38.35572], [-121.95754, 38.35546], [-121.95772, 38.35537], [-121.95787, 38.35531], [-121.95826, 38.3553], [-121.95877, 38.35535], [-121.95899, 38.35536], [-121.95907, 38.35534], [-121.95911, 38.35534], [-121.95919, 38.35533], [-121.95939, 38.35538], [-121.95948, 38.35544], [-121.96001, 38.35529], [-121.96012, 38.35518], [-121.96036, 38.35508], [-121.96124, 38.35489], [-121.96164, 38.35472], [-121.96201, 38.35451], [-121.96238, 38.35441], [-121.96273, 38.35441], [-121.96317, 38.35444], [-121.96391, 38.35454], [-121.96424, 38.35474], [-121.96434, 38.35495], [-121.96435, 38.35502], [-121.9647, 38.35514], [-121.96478, 38.35512], [-121.96507, 38.35519], [-121.96544, 38.35518], [-121.96572, 38.35514], [-121.96586, 38.35497], [-121.96617, 38.35487], [-121.96662, 38.35483], [-121.96712, 38.35488], [-121.96752, 38.35509], [-121.96776, 38.35531], [-121.96904, 38.35584], [-121.96935, 38.35627], [-121.96955, 38.35661], [-121.96993, 38.35678], [-121.97014, 38.3568], [-121.97046, 38.3568], [-121.97066, 38.35696], [-121.97067, 38.35743], [-121.9707, 38.35757], [-121.97084, 38.3578], [-121.97106, 38.35792], [-121.9712, 38.35792], [-121.97163, 38.35799], [-121.97185, 38.35805], [-121.97206, 38.35818], [-121.97229, 38.35842], [-121.97234, 38.35844], [-121.97239, 38.35857]]]]} | Open Access 1 | 22105 | Ulatis Creek Open Space | 26647 | 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.437 | Ulatis Creek OS | 0 | Local Recreation Area 3 | 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]);