units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 1970
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2375 | 2375 | 2374 | {"type": "Polygon", "coordinates": [[[-122.02155, 37.28917], [-122.01879, 37.28908], [-122.01896, 37.28635], [-122.01927, 37.28637], [-122.01962, 37.28677], [-122.02155, 37.28917]]]} | Open Access 1 | 17181 | Kevin Moran Park | 20638 | 1326 | Saratoga, City of 520 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | Santa Clara 19 | 10.277 | Kevin Moran Park | 1970 | Local Park 2 | 4 | |
3166 | 3166 | 3165 | {"type": "Polygon", "coordinates": [[[-122.64854, 38.45272], [-122.64847, 38.45267], [-122.64836, 38.45234], [-122.64825, 38.4523], [-122.64799, 38.45235], [-122.64736, 38.45268], [-122.64702, 38.45284], [-122.64642, 38.45304], [-122.64597, 38.4531], [-122.64534, 38.4531], [-122.64489, 38.45307], [-122.64496, 38.45367], [-122.64267, 38.45431], [-122.6435, 38.45134], [-122.64456, 38.45143], [-122.6482, 38.44901], [-122.64857, 38.45182], [-122.64859, 38.45262], [-122.64854, 38.45272]]]} | Open Access 1 | 21956 | Spring Lake Regional Park | 28940 | 2156 | Sonoma County Water Agency 90 | Special District 4 | Water District 13 | http://www.scwa.ca.gov/ | Special District 4 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Spring_Lake_Regional_Park.aspx | Sonoma 16 | 34.843 | Spring Lake RP | 1970 | Local Park 2 | 4 |
3627 | 3627 | 3626 | {"type": "Polygon", "coordinates": [[[-122.33499, 37.58558], [-122.33435, 37.58606], [-122.33414, 37.58587], [-122.33432, 37.58575], [-122.33434, 37.58563], [-122.33475, 37.58536], [-122.33499, 37.58558]]]} | Open Access 1 | 13522 | Victoria Park | 27078 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 0.618 | Victoria Park | 1970 | Local Park 2 | 4 | |
4252 | 4252 | 4251 | {"type": "Polygon", "coordinates": [[[-122.28056, 37.50434], [-122.28023, 37.50445], [-122.27997, 37.50403], [-122.28033, 37.50392], [-122.28056, 37.50434]]]} | Open Access 1 | 14357 | San Carlos Ave Neighborhood Park | 24844 | 1295 | San Carlos, City of 438 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | San Mateo 15 | 0.42 | San Carlos Ave Neighborhood Park | 1970 | Local Park 2 | 4 | |
6783 | 6783 | 6782 | {"type": "Polygon", "coordinates": [[[-122.6718, 38.45488], [-122.6715, 38.45491], [-122.67052, 38.45514], [-122.66999, 38.45567], [-122.66937, 38.45577], [-122.664, 38.4564], [-122.66195, 38.4572], [-122.66201, 38.45754], [-122.66181, 38.45757], [-122.66059, 38.45805], [-122.66056, 38.45805], [-122.65974, 38.45828], [-122.65973, 38.45625], [-122.66091, 38.45519], [-122.66091, 38.45518], [-122.66088, 38.45517], [-122.66194, 38.45409], [-122.66192, 38.45408], [-122.66197, 38.45406], [-122.66737, 38.45035], [-122.66768, 38.44951], [-122.66805, 38.44909], [-122.6682, 38.44925], [-122.66856, 38.44969], [-122.66934, 38.45101], [-122.6718, 38.45488]]]} | Open Access 1 | 5275 | Howarth Park | 20122 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 111.543 | Howarth Park | 1970 | Local Park 2 | 4 | |
8668 | 8668 | 8667 | {"type": "Polygon", "coordinates": [[[-122.25242, 37.52835], [-122.25194, 37.52877], [-122.25218, 37.52896], [-122.25152, 37.52954], [-122.25126, 37.52936], [-122.25076, 37.5298], [-122.25101, 37.53], [-122.25099, 37.53004], [-122.25099, 37.5301], [-122.25102, 37.53016], [-122.25107, 37.53021], [-122.25076, 37.53048], [-122.25069, 37.53043], [-122.25012, 37.53046], [-122.24915, 37.53133], [-122.24909, 37.5313], [-122.24808, 37.53219], [-122.2478, 37.53199], [-122.24802, 37.53178], [-122.24737, 37.53131], [-122.24892, 37.52996], [-122.24925, 37.53019], [-122.24948, 37.52999], [-122.24961, 37.53008], [-122.24968, 37.53007], [-122.25034, 37.5295], [-122.25059, 37.52968], [-122.25109, 37.52924], [-122.25085, 37.52905], [-122.25151, 37.52847], [-122.25176, 37.52865], [-122.25225, 37.52823], [-122.25242, 37.52835]]]} | Open Access 1 | 13937 | Marlin Park | 21880 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 10.974 | Marlin Park | 1970 | Local Park 2 | 4 | |
8807 | 8807 | 8806 | {"type": "Polygon", "coordinates": [[[-122.28634, 37.48596], [-122.28471, 37.48715], [-122.28549, 37.4878], [-122.28485, 37.48828], [-122.28461, 37.4881], [-122.28421, 37.48815], [-122.28328, 37.48773], [-122.28282, 37.48771], [-122.28311, 37.48728], [-122.28247, 37.48628], [-122.2814, 37.48627], [-122.28131, 37.48662], [-122.28168, 37.48719], [-122.28178, 37.48757], [-122.28183, 37.48786], [-122.28129, 37.48811], [-122.28062, 37.48864], [-122.27916, 37.48914], [-122.27859, 37.48926], [-122.27825, 37.4885], [-122.27793, 37.48827], [-122.27745, 37.48828], [-122.27681, 37.48874], [-122.27653, 37.4893], [-122.27607, 37.48889], [-122.2759, 37.48934], [-122.2748, 37.4889], [-122.27501, 37.48861], [-122.2757, 37.48893], [-122.27666, 37.48835], [-122.27684, 37.48737], [-122.27617, 37.48711], [-122.27602, 37.48735], [-122.2755, 37.48713], [-122.27626, 37.48661], [-122.27647, 37.48654], [-122.27659, 37.48676], [-122.27679, 37.48672], [-122.27698, 37.48674], [-122.27772, 37.48753], [-122.27811, 37.48826], [-122.2789, 37.48833], [-122.27918, 37.4878], [-122.27871, 37.48691], [-122.27798, 37.48621], [-122.27919, 37.48539], [-122.27978, 37.48516], [-122.28022, 37.48508], [-122.28133, 37.48519], [-122.2817, 37.48545], [-122.2817, 37.48541], [-122.28214, 37.48503], [-122.2827, 37.48444], [-122.2831, 37.48389], [-122.28339, 37.48326], [-122.28342, 37.48371], [-122.28364, 37.48452], [-122.28395, 37.48505], [-122.28451, 37.48559], [-122.28504, 37.48586], [-122.28572, 37.48588], [-122.28634, 37.48596]]]} | Open Access 1 | 14331 | Big Canyon Park | 16077 | 1295 | San Carlos, City of 438 | City 2 | City Agency 2 | http://www.cityofsancarlos.org/depts/pr/default.asp | City 2 | 1295 | San Carlos, City of 432 | City 2 | City Agency 2 | San Mateo 15 | 55.239 | Big Canyon Park | 1970 | Local Park 2 | 4 | |
11237 | 11237 | 11236 | {"type": "MultiPolygon", "coordinates": [[[[-121.68016, 37.57521], [-121.67954, 37.57523], [-121.66893, 37.57516], [-121.66892, 37.57152], [-121.67068, 37.57152], [-121.6707, 37.57206], [-121.68007, 37.57196], [-121.68016, 37.57521]]], [[[-121.69366, 37.59333], [-121.69366, 37.59375], [-121.6936, 37.59664], [-121.6894, 37.59661], [-121.68872, 37.59547], [-121.68857, 37.59518], [-121.68839, 37.59473], [-121.68833, 37.5945], [-121.68827, 37.59419], [-121.68823, 37.59388], [-121.68822, 37.5935], [-121.69366, 37.59333]]], [[[-121.68763, 37.58629], [-121.68667, 37.58946], [-121.68663, 37.58969], [-121.68664, 37.58991], [-121.68666, 37.59004], [-121.68672, 37.5902], [-121.68681, 37.59037], [-121.6869, 37.59049], [-121.68711, 37.59069], [-121.68782, 37.59122], [-121.68798, 37.59142], [-121.68809, 37.59164], [-121.68813, 37.59183], [-121.68814, 37.59201], [-121.68795, 37.59308], [-121.68791, 37.59354], [-121.68793, 37.59406], [-121.688, 37.59449], [-121.68814, 37.59499], [-121.68835, 37.59548], [-121.68956, 37.59759], [-121.6896, 37.59772], [-121.68963, 37.59788], [-121.68963, 37.59802], [-121.68961, 37.59815], [-121.68956, 37.59827], [-121.68948, 37.59843], [-121.68906, 37.59903], [-121.68895, 37.59926], [-121.68887, 37.59951], [-121.68869, 37.60059], [-121.68863, 37.60077], [-121.68854, 37.60094], [-121.68833, 37.60123], [-121.68728, 37.60233], [-121.68711, 37.60256], [-121.68695, 37.60284], [-121.68683, 37.60317], [-121.68676, 37.60352], [-121.68675, 37.60383], [-121.6868, 37.60417], [-121.6866, 37.60418], [-121.68661, 37.60453], [-121.68463, 37.60465], [-121.68453, 37.6046], [-121.6843, 37.60467], [-121.68351, 37.60473], [-121.68308, 37.60418], [-121.68272, 37.60366], [-121.68093, 37.60283], [-121.68043, 37.60258], [-121.6799, 37.60253], [-121.6803, 37.59464], [-121.68093, 37.59461], [-121.68124, 37.59364], [-121.68035, 37.59366], [-121.68021, 37.58657], [-121.68586, 37.58631], [-121.68745, 37.58626], [-121.68745, 37.58628], [-121.68763, 37.58629]]], [[[-121.75031, 37.61969], [-121.74973, 37.62053], [-121.7486, 37.62004], [-121.74918, 37.6192], [-121.75031, 37.61969]]], [[[-121.7593, 37.62106], [-121.75885, 37.62113], [-121.75837, 37.62142], [-121.75788, 37.62154], [-121.75721, 37.62193], [-121.75497, 37.62151], [-121.7542, 37.62109], [-121.75246, 37.62111], [-121.7515, 37.62024], [-121.7518, 37.6192], [-121.75182, 37.61916], [-121.75489, 37.6205], [-121.75517, 37.62051], [-121.75519, 37.62058], [-121.75559, 37.6206], [-121.75596, 37.6206], [-121.75706, 37.6205], [-121.75802, 37.62057], [-121.75821, 37.62055], [-121.75858, 37.62049], [-121.75876, 37.62049], [-121.75887, 37.62051], [-121.75899, 37.62055], [-121.75917, 37.62068], [-121.75923, 37.62076], [-121.75927, 37.62085], [-121.7593, 37.62106]]], [[[-121.76135, 37.62235], [-121.75914, 37.62234], [-121.75933, 37.6221], [-121.7594, 37.62197], [-121.75945, 37.62182], [-121.75949, 37.62162], [-121.75951, 37.62101], [-121.75947, 37.62081], [-121.75939, 37.62065], [-121.75925, 37.6205], [-121.75909, 37.62041], [-121.75887, 37.62035], [-121.75861, 37.62034], [-121.75811, 37.62042], [-121.7581, 37.62043], [-121.75817, 37.62048], [-121.75688, 37.62033], [-121.7556, 37.62044], [-121.75493, 37.62039], [-121.74908, 37.61784], [-121.74844, 37.61749], [-121.74804, 37.61697], [-121.75041, 37.61585], [-121.76126, 37.61632], [-121.75862, 37.61979], [-121.75943, 37.6205], [-121.76134, 37.62185], [-121.76135, 37.62235]]]]} | Open Access 1 | 25792 | Del Valle Regional Park | 3251 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/del_valle | Alameda 17 | 581.861 | Del Valle RP | 1970 | Local Park 2 | 4 |
16306 | 16306 | 16305 | {"type": "MultiPolygon", "coordinates": [[[[-122.64607, 38.45736], [-122.64388, 38.45708], [-122.64438, 38.45707], [-122.64506, 38.45703], [-122.64608, 38.45691], [-122.64721, 38.45669], [-122.64823, 38.45644], [-122.64828, 38.45644], [-122.64831, 38.45647], [-122.64848, 38.45735], [-122.64843, 38.45767], [-122.64835, 38.45774], [-122.64824, 38.45775], [-122.6469, 38.45746], [-122.64607, 38.45736]]], [[[-122.66092, 38.45518], [-122.65973, 38.45626], [-122.65975, 38.45936], [-122.65617, 38.45995], [-122.65546, 38.4601], [-122.65464, 38.46042], [-122.65457, 38.46055], [-122.65418, 38.46074], [-122.65383, 38.46065], [-122.65373, 38.46078], [-122.6537, 38.46089], [-122.65372, 38.46161], [-122.6533, 38.46124], [-122.65302, 38.46095], [-122.65167, 38.45939], [-122.65138, 38.45911], [-122.65106, 38.45885], [-122.65078, 38.45866], [-122.65049, 38.45849], [-122.64994, 38.45822], [-122.64936, 38.45801], [-122.64866, 38.45784], [-122.64862, 38.45782], [-122.64859, 38.45775], [-122.64865, 38.45749], [-122.64865, 38.45735], [-122.64848, 38.45642], [-122.64841, 38.45632], [-122.64833, 38.45627], [-122.64821, 38.45626], [-122.64716, 38.45652], [-122.64707, 38.45652], [-122.64701, 38.45649], [-122.64697, 38.45644], [-122.64697, 38.45638], [-122.64733, 38.45561], [-122.64859, 38.45566], [-122.64968, 38.455], [-122.64989, 38.45454], [-122.64988, 38.45453], [-122.649, 38.45479], [-122.64871, 38.45495], [-122.64857, 38.45478], [-122.64836, 38.45463], [-122.64792, 38.45453], [-122.64786, 38.45448], [-122.64827, 38.45362], [-122.64812, 38.45357], [-122.64859, 38.45262], [-122.64857, 38.45182], [-122.64782, 38.44613], [-122.64767, 38.44586], [-122.6476, 38.44565], [-122.64757, 38.44542], [-122.6476, 38.44518], [-122.64766, 38.44493], [-122.64761, 38.44458], [-122.64765, 38.44392], [-122.64764, 38.44359], [-122.64786, 38.44383], [-122.6481, 38.44392], [-122.64837, 38.44417], [-122.64868, 38.44435], [-122.6494, 38.44444], [-122.64969, 38.4444], [-122.64989, 38.44433], [-122.65007, 38.44418], [-122.65083, 38.44305], [-122.65083, 38.44301], [-122.65156, 38.44273], [-122.65161, 38.44288], [-122.65162, 38.44308], [-122.65159, 38.44324], [-122.6515, 38.44346], [-122.65093, 38.44418], [-122.65108, 38.44567], [-122.65145, 38.44877], [-122.65289, 38.44828], [-122.65288, 38.44824], [-122.65402, 38.44754], [-122.65408, 38.44759], [-122.65441, 38.44738], [-122.6548, 38.44829], [-122.65664, 38.44869], [-122.65663, 38.44906], [-122.6567, 38.44962], [-122.6572, 38.44987], [-122.65844, 38.45468], [-122.66092, 38.45518]]]]} | Open Access 1 | 1079 | Spring Lake Regional Park | 28940 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/Get_Outdoors/Parks/Spring_Lake_Regional_Park.aspx | Sonoma 16 | 317.518 | Spring Lake RP | 1970 | Local Park 2 | 4 |
16350 | 16350 | 16349 | {"type": "Polygon", "coordinates": [[[-121.71665, 37.58639], [-121.71589, 37.5859], [-121.71095, 37.58324], [-121.70798, 37.57891], [-121.69953, 37.57309], [-121.69811, 37.57218], [-121.69498, 37.56996], [-121.68898, 37.56577], [-121.68904, 37.5657], [-121.6895, 37.56405], [-121.69836, 37.564], [-121.69837, 37.56416], [-121.70745, 37.56418], [-121.70741, 37.57152], [-121.7165, 37.57154], [-121.71648, 37.57867], [-121.71665, 37.58639]]]} | Open Access 1 | 15608 | Del Valle Regional Park | 3251 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/del_valle | Alameda 17 | 616.732 | Del Valle RP | 1970 | Local Park 2 | 4 |
16841 | 16841 | 16840 | {"type": "MultiPolygon", "coordinates": [[[[-122.38721, 37.91001], [-122.38713, 37.91032], [-122.38701, 37.91098], [-122.38693, 37.91113], [-122.38689, 37.91118], [-122.38678, 37.9113], [-122.38394, 37.91371], [-122.38384, 37.91382], [-122.38373, 37.91398], [-122.38365, 37.9142], [-122.38373, 37.91649], [-122.3835, 37.91661], [-122.38349, 37.91712], [-122.38309, 37.91713], [-122.38315, 37.91721], [-122.38317, 37.91729], [-122.3835, 37.91726], [-122.38354, 37.91742], [-122.38363, 37.91758], [-122.38467, 37.91874], [-122.3842, 37.91906], [-122.38422, 37.91913], [-122.38446, 37.91899], [-122.38474, 37.9193], [-122.38499, 37.91913], [-122.38507, 37.91919], [-122.38568, 37.91987], [-122.38576, 37.91999], [-122.38581, 37.92017], [-122.3858, 37.92033], [-122.38544, 37.92124], [-122.3856, 37.92129], [-122.38527, 37.92214], [-122.38518, 37.92212], [-122.38505, 37.92215], [-122.38478, 37.92213], [-122.38468, 37.92191], [-122.38477, 37.92184], [-122.38426, 37.92122], [-122.38396, 37.92119], [-122.38363, 37.92112], [-122.38331, 37.92117], [-122.38315, 37.92117], [-122.3829, 37.92101], [-122.3825, 37.92088], [-122.38232, 37.92092], [-122.38189, 37.92113], [-122.3817, 37.92115], [-122.38201, 37.92065], [-122.38223, 37.92064], [-122.38237, 37.92056], [-122.38248, 37.9204], [-122.38193, 37.9202], [-122.38184, 37.92026], [-122.38179, 37.92023], [-122.38169, 37.92022], [-122.38162, 37.92028], [-122.38165, 37.92044], [-122.3815, 37.9211], [-122.38079, 37.92153], [-122.38052, 37.92201], [-122.38026, 37.9221], [-122.38034, 37.9218], [-122.38047, 37.9214], [-122.38075, 37.92075], [-122.38072, 37.92048], [-122.38043, 37.92005], [-122.38026, 37.91956], [-122.37989, 37.91915], [-122.37951, 37.91905], [-122.37945, 37.91881], [-122.37989, 37.9184], [-122.37971, 37.91783], [-122.37988, 37.91756], [-122.37981, 37.91743], [-122.37964, 37.91745], [-122.37956, 37.91719], [-122.37928, 37.91723], [-122.37916, 37.91719], [-122.3788, 37.91677], [-122.3787, 37.91654], [-122.37852, 37.91629], [-122.37813, 37.9161], [-122.37747, 37.91612], [-122.37719, 37.91603], [-122.37678, 37.91603], [-122.3759, 37.9165], [-122.37583, 37.91629], [-122.37602, 37.91606], [-122.37512, 37.91557], [-122.37505, 37.91561], [-122.37497, 37.91562], [-122.37456, 37.91553], [-122.3745, 37.91553], [-122.37441, 37.91555], [-122.37437, 37.91558], [-122.37406, 37.91609], [-122.37402, 37.91613], [-122.37395, 37.91616], [-122.37388, 37.91617], [-122.37306, 37.91739], [-122.37285, 37.91732], [-122.37264, 37.91719], [-122.3725, 37.91706], [-122.37241, 37.91692], [-122.37235, 37.91675], [-122.37234, 37.91657], [-122.37237, 37.91644], [-122.37246, 37.91614], [-122.37248, 37.916], [-122.37248, 37.91589], [-122.37318, 37.91605], [-122.37346, 37.91618], [-122.37354, 37.91614], [-122.37362, 37.91613], [-122.37379, 37.91604], [-122.37385, 37.91598], [-122.37391, 37.91587], [-122.37392, 37.91581], [-122.3737, 37.91222], [-122.37372, 37.91212], [-122.37378, 37.91204], [-122.37387, 37.91198], [-122.37398, 37.91195], [-122.3741, 37.91195], [-122.37426, 37.91201], [-122.37434, 37.91208], [-122.37508, 37.91307], [-122.37586, 37.91358], [-122.37678, 37.91355], [-122.3771, 37.91291], [-122.37724, 37.91279], [-122.37817, 37.91337], [-122.37778, 37.91411], [-122.37776, 37.91414], [-122.37812, 37.91443], [-122.37814, 37.91456], [-122.37851, 37.91466], [-122.37909, 37.91475], [-122.37948, 37.91472], [-122.37962, 37.91475], [-122.3812, 37.91464], [-122.38151, 37.91451], [-122.38243, 37.91208], [-122.38264, 37.91202], [-122.38273, 37.9118], [-122.3829, 37.91169], [-122.38301, 37.91152], [-122.38378, 37.91078], [-122.384, 37.91058], [-122.38422, 37.91043], [-122.38448, 37.91031], [-122.38477, 37.9102], [-122.38512, 37.91013], [-122.38538, 37.91], [-122.38634, 37.90989], [-122.38652, 37.91004], [-122.38678, 37.91007], [-122.38721, 37.91001]], [[-122.3845, 37.91986], [-122.38446, 37.91982], [-122.38418, 37.91997], [-122.38412, 37.91991], [-122.38396, 37.91957], [-122.38423, 37.91938], [-122.38399, 37.91887], [-122.38382, 37.91872], [-122.38369, 37.91867], [-122.38356, 37.91865], [-122.38346, 37.91865], [-122.38303, 37.91872], [-122.38294, 37.91873], [-122.38285, 37.91871], [-122.38266, 37.91896], [-122.38277, 37.91905], [-122.38256, 37.91923], [-122.38256, 37.91925], [-122.38273, 37.91933], [-122.38306, 37.91938], [-122.38321, 37.91949], [-122.38339, 37.91955], [-122.38346, 37.91956], [-122.3836, 37.91962], [-122.38367, 37.91971], [-122.38381, 37.92003], [-122.38389, 37.92015], [-122.38397, 37.92024], [-122.3841, 37.92032], [-122.38425, 37.92037], [-122.38449, 37.92018], [-122.38448, 37.92016], [-122.38435, 37.92013], [-122.3846, 37.91994], [-122.3845, 37.91986]], [[-122.38304, 37.91973], [-122.38327, 37.91994], [-122.38356, 37.91975], [-122.38353, 37.91969], [-122.38347, 37.91965], [-122.38322, 37.91959], [-122.38303, 37.91946], [-122.38292, 37.91942], [-122.38281, 37.91943], [-122.38276, 37.91971], [-122.38304, 37.91973]]], [[[-122.39571, 37.91673], [-122.38964, 37.91686], [-122.38973, 37.92265], [-122.38866, 37.92248], [-122.38786, 37.92183], [-122.38775, 37.92131], [-122.38755, 37.92108], [-122.38715, 37.92127], [-122.38698, 37.92125], [-122.38629, 37.92123], [-122.38612, 37.92119], [-122.3864, 37.92047], [-122.38649, 37.92016], [-122.38693, 37.91845], [-122.38725, 37.91708], [-122.38676, 37.91673], [-122.38598, 37.91963], [-122.3859, 37.91985], [-122.38527, 37.91913], [-122.3852, 37.919], [-122.38406, 37.91778], [-122.38399, 37.9176], [-122.38396, 37.91757], [-122.38398, 37.91754], [-122.38386, 37.91424], [-122.38393, 37.91403], [-122.3841, 37.91383], [-122.38522, 37.91284], [-122.38526, 37.91285], [-122.38695, 37.9114], [-122.38708, 37.91127], [-122.38713, 37.91119], [-122.3872, 37.91103], [-122.3875, 37.90962], [-122.38801, 37.9094], [-122.38819, 37.90853], [-122.39033, 37.90879], [-122.39058, 37.90901], [-122.39087, 37.90875], [-122.39154, 37.9081], [-122.3927, 37.90799], [-122.39283, 37.90815], [-122.39098, 37.90927], [-122.3909, 37.90922], [-122.39084, 37.90927], [-122.39306, 37.9119], [-122.39303, 37.91189], [-122.39305, 37.91192], [-122.39033, 37.91083], [-122.39058, 37.90998], [-122.39057, 37.90996], [-122.3897, 37.91061], [-122.38956, 37.91061], [-122.38913, 37.91109], [-122.38896, 37.91136], [-122.38888, 37.91151], [-122.38848, 37.91254], [-122.38826, 37.91318], [-122.3883, 37.91321], [-122.38823, 37.91348], [-122.38825, 37.91348], [-122.38834, 37.91318], [-122.39373, 37.91311], [-122.39571, 37.91673]], [[-122.39084, 37.90956], [-122.39085, 37.90955], [-122.39071, 37.90938], [-122.39069, 37.90938], [-122.39069, 37.9094], [-122.39084, 37.90956]]]]} | Open Access 1 | 17900 | Miller Knox Regional Shoreline | 3288 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/miller_knox | Contra Costa 12 | 320.048 | Miller Knox Reg. Shoreline | 1970 | 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]);