units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
229 rows where COUNTY = 26 sorted by DES_TP
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_ID, MNG_AG_LEV, PARK_URL, LABEL_NAME, YR_EST, GAP_STS
DES_TP 31
- Local Park 129
- Local Recreation Area 36
- State Conservation Area 13
- Private Conservation 9
- Local Other or Unknown 7
- State Recreation Area 4
- Local Conservation Area 3
- National Wildlife Refuge 3
- Local Historic or Cultural Area 2
- Private Recreation or Education 2
- National Public Lands 1
- State Resource Management Area 1
- State Other or Unknown 1
- None 1
- None 1
- State Historic or Cultural Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 21
- Vacaville, City of 55
- Greater Vallejo Recreation and Park District 33
- Fairfield, City of 32
- Benicia, City of 25
- Vallejo, City of 15
- California Department of Fish and Wildlife 14
- Suisun City, City of 11
- Rio Vista, City of 9
- Solano Land Trust 8
- Dixon, City of 6
- California Department of Water Resources 4
- United States Fish and Wildlife Service 3
- University of California 3
- California Department of Parks and Recreation 2
- Solano Tri-City and County Cooperative Planning Group 2
- Tuleyome 2
- United States Bureau of Land Management 1
- Other State 1
- United States Army Corps of Engineers 1
- Mare Island Historic Park Foundation 1
- Solano, County of 1
MNG_AG_TYP 8
ACCESS_TYP 3
- Open Access 192
- Restricted Access 20
- No Public Access 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11150 | 11150 | 11149 | {"type": "MultiPolygon", "coordinates": [[[[-122.03351, 38.48355], [-122.03249, 38.48361], [-122.03239, 38.48183], [-122.03345, 38.48187], [-122.03351, 38.48355]]], [[[-122.03946, 38.48542], [-122.03946, 38.48542], [-122.03322, 38.48545], [-122.03375, 38.48513], [-122.03417, 38.48477], [-122.03567, 38.48442], [-122.03631, 38.48379], [-122.0368, 38.48319], [-122.03723, 38.48287], [-122.03776, 38.48267], [-122.03808, 38.48219], [-122.03806, 38.48191], [-122.03944, 38.48188], [-122.03946, 38.48542]]], [[[-122.10663, 38.46777], [-122.10175, 38.46781], [-122.10178, 38.47137], [-122.09692, 38.47147], [-122.09695, 38.47847], [-122.10158, 38.47849], [-122.10165, 38.48238], [-122.09693, 38.48236], [-122.09689, 38.48559], [-122.0922, 38.4855], [-122.0925, 38.49092], [-122.09232, 38.49093], [-122.093, 38.50397], [-122.09305, 38.50722], [-122.09316, 38.50723], [-122.09324, 38.51097], [-122.0885, 38.51091], [-122.08834, 38.50388], [-122.07867, 38.50369], [-122.07839, 38.48927], [-122.0784, 38.48237], [-122.08233, 38.48242], [-122.08215, 38.47498], [-122.09179, 38.47496], [-122.09194, 38.47178], [-122.08706, 38.47171], [-122.08718, 38.46813], [-122.09221, 38.46813], [-122.09243, 38.4607], [-122.10661, 38.46096], [-122.10663, 38.46777]]], [[[-122.08306, 38.46779], [-122.08304, 38.4715], [-122.07841, 38.47151], [-122.07847, 38.46769], [-122.08306, 38.46779]]], [[[-122.10652, 38.43207], [-122.10612, 38.43946], [-122.09705, 38.43938], [-122.09698, 38.44612], [-122.09207, 38.44611], [-122.09225, 38.4394], [-122.09704, 38.43937], [-122.09694, 38.43196], [-122.10652, 38.43207]]], [[[-122.10648, 38.50743], [-122.10639, 38.50768], [-122.10582, 38.50758], [-122.10313, 38.50754], [-122.10294, 38.50043], [-122.10581, 38.50041], [-122.10572, 38.50064], [-122.10563, 38.50107], [-122.10562, 38.50191], [-122.10559, 38.50201], [-122.10535, 38.50345], [-122.10534, 38.50377], [-122.10536, 38.50404], [-122.10548, 38.50444], [-122.10562, 38.50509], [-122.10551, 38.5054], [-122.10549, 38.50567], [-122.10541, 38.50605], [-122.10548, 38.50623], [-122.1058, 38.50658], [-122.10596, 38.50682], [-122.10605, 38.50687], [-122.10622, 38.50713], [-122.10648, 38.50743]]], [[[-122.10898, 38.48246], [-122.10892, 38.48297], [-122.10882, 38.48345], [-122.10874, 38.48444], [-122.10865, 38.48497], [-122.10853, 38.48536], [-122.10844, 38.48559], [-122.10807, 38.48624], [-122.10791, 38.48639], [-122.10711, 38.48699], [-122.10692, 38.48719], [-122.10667, 38.4875], [-122.10633, 38.48814], [-122.10632, 38.48244], [-122.10898, 38.48246]]], [[[-122.10656, 38.49686], [-122.10655, 38.49628], [-122.10651, 38.4939], [-122.10673, 38.49398], [-122.1069, 38.49406], [-122.10707, 38.4942], [-122.10725, 38.49454], [-122.1073, 38.49486], [-122.1073, 38.49507], [-122.10721, 38.49546], [-122.10695, 38.49617], [-122.10686, 38.49636], [-122.10656, 38.49686]]], [[[-122.11892, 38.46099], [-122.11876, 38.46147], [-122.11852, 38.46199], [-122.11833, 38.46226], [-122.11817, 38.46255], [-122.11782, 38.46309], [-122.11763, 38.46348], [-122.11758, 38.46373], [-122.11743, 38.46414], [-122.11727, 38.46469], [-122.117, 38.4652], [-122.1166, 38.46574], [-122.11648, 38.46594], [-122.1156, 38.46759], [-122.11545, 38.4679], [-122.11533, 38.4682], [-122.11514, 38.46895], [-122.11462, 38.47026], [-122.11443, 38.47101], [-122.11413, 38.47165], [-122.11386, 38.47232], [-122.11363, 38.4733], [-122.11344, 38.47403], [-122.11318, 38.47487], [-122.1131, 38.47508], [-122.11299, 38.47528], [-122.11048, 38.47527], [-122.11038, 38.46479], [-122.11542, 38.4648], [-122.11552, 38.4611], [-122.11892, 38.46099]]], [[[-122.12518, 38.43695], [-122.12516, 38.44], [-122.12472, 38.44], [-122.12472, 38.44], [-122.12518, 38.43695]]]]} | Open Access 1 | 21506 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Solano 26 | 2071.269 | BLM | 1899 | National Public Lands 1 | 3 | |
189 | 189 | 188 | {"type": "Polygon", "coordinates": [[[-121.69813, 38.13724], [-121.69797, 38.13757], [-121.69794, 38.13778], [-121.698, 38.138], [-121.698, 38.13839], [-121.69766, 38.13941], [-121.69748, 38.13979], [-121.69707, 38.14119], [-121.69655, 38.14207], [-121.69614, 38.14262], [-121.69612, 38.14317], [-121.69601, 38.14374], [-121.69455, 38.14262], [-121.69398, 38.1421], [-121.69404, 38.14198], [-121.69415, 38.14179], [-121.69439, 38.14132], [-121.69453, 38.14097], [-121.69475, 38.14037], [-121.69492, 38.14001], [-121.6952, 38.13921], [-121.6953, 38.13884], [-121.69555, 38.13824], [-121.69594, 38.13708], [-121.6961, 38.13642], [-121.69719, 38.1368], [-121.69813, 38.13724]]]} | Open Access 1 | 520 | Sandy Beach Park | 25025 | 2187 | Solano Tri-City and County Cooperative Planning Group 74 | Special District 4 | Open Space District 6 | Special District 4 | 2187 | Solano Tri-City and County Cooperative Planning Group 72 | Special District 4 | Open Space District 6 | Solano 26 | 36.239 | Sandy Beach 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 | |
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 | |
564 | 564 | 563 | {"type": "Polygon", "coordinates": [[[-122.04514, 38.26755], [-122.04396, 38.26758], [-122.04393, 38.26754], [-122.04333, 38.26755], [-122.04331, 38.26645], [-122.04405, 38.26643], [-122.04513, 38.26644], [-122.04514, 38.26755]]]} | Open Access 1 | 1883 | Veteran's Memorial Park | 27011 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 4.887 | Veteran's Memorial 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 | |
748 | 748 | 747 | {"type": "Polygon", "coordinates": [[[-122.06423, 38.24698], [-122.06271, 38.24698], [-122.06272, 38.24918], [-122.05835, 38.24917], [-122.0583, 38.24668], [-122.05833, 38.24524], [-122.06423, 38.2453], [-122.06423, 38.24698]]]} | Open Access 1 | 4870 | Alan Witt Park | 15325 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 47.468 | Alan Witt Park | 0 | Local Park 2 | 4 | |
1285 | 1285 | 1284 | {"type": "Polygon", "coordinates": [[[-122.16939, 38.13727], [-122.1693, 38.1373], [-122.16926, 38.13734], [-122.16922, 38.13742], [-122.16905, 38.13739], [-122.16875, 38.1372], [-122.16875, 38.13718], [-122.16851, 38.137], [-122.16847, 38.13692], [-122.16846, 38.13684], [-122.16849, 38.13674], [-122.16854, 38.13669], [-122.16871, 38.13664], [-122.16872, 38.13655], [-122.16896, 38.1365], [-122.16909, 38.13685], [-122.16917, 38.13685], [-122.16919, 38.13698], [-122.16929, 38.13704], [-122.16937, 38.13716], [-122.16939, 38.13727]]]} | Open Access 1 | 47641 | Hiddenbrooke Park | 31383 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Hiddenbrooke | Solano 26 | 1.124 | Hiddenbrooke Park | 0 | 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 | |
1321 | 1321 | 1320 | {"type": "Polygon", "coordinates": [[[-122.19217, 38.12822], [-122.192, 38.12829], [-122.19189, 38.12829], [-122.19143, 38.12808], [-122.19086, 38.12773], [-122.19079, 38.12766], [-122.19072, 38.12752], [-122.18982, 38.12792], [-122.18795, 38.12517], [-122.18822, 38.125], [-122.18931, 38.12463], [-122.1904, 38.12448], [-122.19158, 38.12409], [-122.19132, 38.12454], [-122.19125, 38.12472], [-122.19119, 38.12493], [-122.19117, 38.12529], [-122.1912, 38.12567], [-122.19158, 38.127], [-122.19196, 38.12787], [-122.19217, 38.12822]]]} | Open Access 1 | 47620 | Blue Rock Springs Park | 31355 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Blue_Rock_Springs_Park | Solano 26 | 21.53 | Blue Rock Springs Park | 0 | Local Park 2 | 4 |
1322 | 1322 | 1321 | {"type": "Polygon", "coordinates": [[[-122.24455, 38.102], [-122.24448, 38.10265], [-122.24424, 38.10265], [-122.24424, 38.102], [-122.24455, 38.102]]]} | Open Access 1 | 47622 | Amador Bocce Ball Court | 31357 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Amador_Bocce_Ball | Solano 26 | 0.431 | Amador Bocce Ball Court | 0 | Local Park 2 | 4 |
1328 | 1328 | 1327 | {"type": "Polygon", "coordinates": [[[-122.15732, 38.0806], [-122.1569, 38.08087], [-122.15644, 38.08063], [-122.15466, 38.08044], [-122.15466, 38.08032], [-122.1548, 38.08004], [-122.15494, 38.07957], [-122.15567, 38.07968], [-122.15607, 38.07993], [-122.15624, 38.08012], [-122.15681, 38.08024], [-122.15732, 38.0806]]]} | Open Access 1 | 10834 | Frank Skillman Park | 19054 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.944 | Frank Skillman Park | 0 | Local Park 2 | 4 | |
1329 | 1329 | 1328 | {"type": "Polygon", "coordinates": [[[-122.18383, 38.09471], [-122.1838, 38.09489], [-122.18358, 38.09508], [-122.18317, 38.09495], [-122.18237, 38.09491], [-122.18239, 38.09454], [-122.18298, 38.09452], [-122.18335, 38.09437], [-122.18383, 38.09471]]]} | Open Access 1 | 10843 | Channing Circle Park | 17124 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 1.577 | Channing Circle Park | 0 | Local Park 2 | 4 | |
1334 | 1334 | 1333 | {"type": "Polygon", "coordinates": [[[-122.15933, 38.07512], [-122.15933, 38.07532], [-122.15829, 38.07543], [-122.15682, 38.07548], [-122.15563, 38.0758], [-122.15542, 38.07564], [-122.15525, 38.07575], [-122.15507, 38.07565], [-122.15491, 38.07575], [-122.15472, 38.07575], [-122.15485, 38.07472], [-122.15508, 38.07477], [-122.15591, 38.07472], [-122.15688, 38.07449], [-122.15786, 38.07409], [-122.15809, 38.07452], [-122.15852, 38.07478], [-122.15916, 38.07489], [-122.15933, 38.07512]]]} | Open Access 1 | 10860 | Southhampton Park | 25691 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 10.134 | Southhampton Park | 0 | Local Park 2 | 4 | |
1335 | 1335 | 1334 | {"type": "Polygon", "coordinates": [[[-122.16896, 38.0589], [-122.16836, 38.05972], [-122.16685, 38.05884], [-122.16731, 38.05817], [-122.16896, 38.0589]]]} | Open Access 1 | 10872 | Willow Glen Park | 27578 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 3.875 | Willow Glen 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 |
1528 | 1528 | 1527 | {"type": "Polygon", "coordinates": [[[-122.22958, 38.1515], [-122.22956, 38.15146], [-122.22963, 38.15108], [-122.22967, 38.15093], [-122.22976, 38.15069], [-122.22982, 38.15065], [-122.2301, 38.15071], [-122.23062, 38.15087], [-122.23115, 38.15107], [-122.23154, 38.15124], [-122.23158, 38.15129], [-122.23134, 38.15166], [-122.2313, 38.1517], [-122.23122, 38.15172], [-122.23115, 38.15172], [-122.22964, 38.15153], [-122.22958, 38.1515]]]} | Open Access 1 | 11032 | Borges Ranch Park | 16284 | 2224 | Greater Vallejo Recreation and Park District 341 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/ | Special District 4 | 2224 | Greater Vallejo Recreation and Park District 338 | Special District 4 | Recreation/Parks District 4 | http://www.gvrd.org/?page=Borges_Ranch_Park | Solano 26 | 3.378 | Borges Ranch Park | 0 | Local Park 2 | 4 |
1529 | 1529 | 1528 | {"type": "Polygon", "coordinates": [[[-122.14522, 38.04964], [-122.14497, 38.04998], [-122.14428, 38.04965], [-122.14451, 38.04933], [-122.14522, 38.04964]]]} | Open Access 1 | 10896 | Ethelree Saraiva Park | 18733 | 1027 | Benicia, City of 347 | City 2 | City Agency 2 | http://ci.benicia.ca.us/parks | City 2 | 1027 | Benicia, City of 344 | City 2 | City Agency 2 | Solano 26 | 0.741 | Ethelree Saraiva 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]);