units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where YR_EST = 1970
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AG_TYP, DES_TP
MNG_AGENCY 13
- United States Fish and Wildlife Service 10
- East Bay Regional Park District 4
- Sonoma County Regional Parks Dept., County of 3
- California Department of Fish and Wildlife 2
- San Carlos, City of 2
- Santa Rosa, City of 1
- California Department of Parks and Recreation 1
- Sonoma Land Trust 1
- Hayward Area Recreation and Park District 1
- Burlingame, City of 1
- Redwood City, City of 1
- Millbrae, City of 1
- Saratoga, City of 1
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 | |
2892 | 2892 | 2891 | {"type": "Polygon", "coordinates": [[[-122.3644, 38.14004], [-122.36438, 38.1412], [-122.36339, 38.14077], [-122.36341, 38.13972], [-122.36362, 38.13981], [-122.3644, 38.14004]]]} | Open Access 1 | 23003 | San Pablo Bay National Wildlife Refuge | 24963 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Solano 26 | 2.6 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
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 | |
3703 | 3703 | 3702 | {"type": "MultiPolygon", "coordinates": [[[[-122.39206, 38.19858], [-122.39175, 38.19903], [-122.3912, 38.1995], [-122.38991, 38.20004], [-122.38904, 38.20025], [-122.38812, 38.2004], [-122.38725, 38.20045], [-122.38627, 38.20039], [-122.38547, 38.20031], [-122.38464, 38.20032], [-122.38426, 38.20029], [-122.38372, 38.20009], [-122.38356, 38.20011], [-122.38313, 38.20021], [-122.38239, 38.20046], [-122.38198, 38.20067], [-122.38177, 38.2008], [-122.38142, 38.20105], [-122.38101, 38.20138], [-122.3802, 38.20223], [-122.37999, 38.20255], [-122.37985, 38.2029], [-122.37981, 38.20305], [-122.37973, 38.20354], [-122.37949, 38.20556], [-122.37936, 38.20647], [-122.3793, 38.20667], [-122.3792, 38.20679], [-122.37902, 38.2069], [-122.37891, 38.20692], [-122.37865, 38.20695], [-122.37836, 38.20691], [-122.37806, 38.20681], [-122.37776, 38.20664], [-122.37736, 38.20636], [-122.37719, 38.20622], [-122.37676, 38.20578], [-122.37654, 38.20554], [-122.37621, 38.20522], [-122.37575, 38.20468], [-122.37559, 38.20454], [-122.37543, 38.20442], [-122.37531, 38.20436], [-122.37513, 38.20429], [-122.3745, 38.2041], [-122.37389, 38.20395], [-122.3732, 38.20376], [-122.37298, 38.20367], [-122.3728, 38.20364], [-122.37209, 38.20364], [-122.37128, 38.20368], [-122.36941, 38.20378], [-122.36847, 38.20385], [-122.36815, 38.20383], [-122.36766, 38.20376], [-122.36751, 38.2037], [-122.36741, 38.20364], [-122.3673, 38.20355], [-122.36726, 38.20348], [-122.36722, 38.20337], [-122.36717, 38.20304], [-122.36721, 38.20292], [-122.36737, 38.20262], [-122.36738, 38.20237], [-122.36736, 38.20224], [-122.36725, 38.20205], [-122.36702, 38.20183], [-122.36677, 38.20166], [-122.36665, 38.2016], [-122.36641, 38.20153], [-122.3662, 38.20153], [-122.36581, 38.20158], [-122.36566, 38.20157], [-122.36539, 38.20153], [-122.36274, 38.20054], [-122.36014, 38.19988], [-122.35976, 38.19985], [-122.3592, 38.19985], [-122.359, 38.19983], [-122.35887, 38.19976], [-122.35882, 38.19967], [-122.35881, 38.19893], [-122.35878, 38.19845], [-122.35881, 38.19831], [-122.35886, 38.19818], [-122.35893, 38.19812], [-122.35961, 38.1978], [-122.36075, 38.19739], [-122.36092, 38.19732], [-122.36105, 38.19724], [-122.36132, 38.19702], [-122.36151, 38.19679], [-122.36158, 38.19667], [-122.36161, 38.19659], [-122.36162, 38.19645], [-122.36159, 38.19621], [-122.36143, 38.19554], [-122.36138, 38.19536], [-122.36121, 38.19495], [-122.36101, 38.19465], [-122.3608, 38.19438], [-122.36038, 38.19396], [-122.35977, 38.19331], [-122.35964, 38.19314], [-122.35927, 38.19274], [-122.35902, 38.1924], [-122.35857, 38.19167], [-122.35847, 38.19152], [-122.35839, 38.19137], [-122.35827, 38.19097], [-122.35814, 38.19043], [-122.35809, 38.19013], [-122.35803, 38.18988], [-122.35792, 38.18905], [-122.35793, 38.1884], [-122.35799, 38.18745], [-122.35802, 38.18678], [-122.35807, 38.18613], [-122.35824, 38.18473], [-122.3584, 38.184], [-122.35852, 38.18359], [-122.35859, 38.1834], [-122.35873, 38.18312], [-122.3589, 38.18287], [-122.35902, 38.18278], [-122.35912, 38.18271], [-122.35936, 38.18261], [-122.35948, 38.18259], [-122.35969, 38.18258], [-122.35991, 38.18263], [-122.36027, 38.18274], [-122.36094, 38.18302], [-122.36201, 38.18341], [-122.36279, 38.18362], [-122.36427, 38.18397], [-122.36486, 38.18405], [-122.36534, 38.18409], [-122.36619, 38.18407], [-122.36662, 38.18404], [-122.36717, 38.18395], [-122.36739, 38.18389], [-122.36762, 38.18379], [-122.36804, 38.18359], [-122.36848, 38.18329], [-122.36865, 38.18321], [-122.36884, 38.1831], [-122.36936, 38.18266], [-122.36965, 38.18249], [-122.36991, 38.18239], [-122.37012, 38.18227], [-122.37118, 38.18212], [-122.37269, 38.182], [-122.37282, 38.18195], [-122.3729, 38.18197], [-122.37333, 38.18193], [-122.37377, 38.18187], [-122.37381, 38.18186], [-122.37416, 38.18185], [-122.37423, 38.18181], [-122.37448, 38.18177], [-122.37581, 38.18134], [-122.37587, 38.18129], [-122.37595, 38.18128], [-122.37615, 38.18118], [-122.37615, 38.18115], [-122.37637, 38.18107], [-122.37647, 38.18102], [-122.37675, 38.18092], [-122.3769, 38.18083], [-122.37766, 38.18056], [-122.37782, 38.18054], [-122.37793, 38.1805], [-122.37819, 38.18049], [-122.37846, 38.18052], [-122.37891, 38.18063], [-122.37933, 38.18089], [-122.37959, 38.18101], [-122.37965, 38.18107], [-122.37969, 38.18124], [-122.37976, 38.18146], [-122.3798, 38.1819], [-122.37975, 38.18205], [-122.37968, 38.18219], [-122.37968, 38.18229], [-122.37947, 38.18275], [-122.37916, 38.18335], [-122.37907, 38.18345], [-122.37906, 38.1835], [-122.37898, 38.18364], [-122.37888, 38.18372], [-122.37869, 38.18401], [-122.37776, 38.18496], [-122.37742, 38.18525], [-122.37695, 38.18557], [-122.37626, 38.1859], [-122.37553, 38.1862], [-122.375, 38.18631], [-122.37424, 38.1864], [-122.37389, 38.18642], [-122.37359, 38.18649], [-122.37332, 38.1866], [-122.37312, 38.18672], [-122.37297, 38.18695], [-122.37287, 38.18716], [-122.37287, 38.18752], [-122.37293, 38.18804], [-122.37307, 38.18842], [-122.3732, 38.18864], [-122.37335, 38.18883], [-122.37341, 38.18887], [-122.37392, 38.18946], [-122.37442, 38.18977], [-122.37538, 38.19024], [-122.37546, 38.19026], [-122.37616, 38.19057], [-122.377, 38.19081], [-122.37725, 38.19094], [-122.37758, 38.19104], [-122.37825, 38.19116], [-122.37891, 38.19131], [-122.37943, 38.19137], [-122.37958, 38.19135], [-122.37964, 38.19132], [-122.37986, 38.19136], [-122.38027, 38.19136], [-122.38037, 38.19132], [-122.38071, 38.19128], [-122.38076, 38.19126], [-122.38207, 38.19116], [-122.38218, 38.19114], [-122.38227, 38.19116], [-122.3825, 38.19119], [-122.38295, 38.19122], [-122.38351, 38.19132], [-122.38408, 38.1915], [-122.38447, 38.19167], [-122.38493, 38.19193], [-122.38565, 38.19247], [-122.38598, 38.19276], [-122.38601, 38.19282], [-122.38616, 38.19298], [-122.38817, 38.19228], [-122.38982, 38.19295], [-122.3906, 38.19243], [-122.39105, 38.19265], [-122.39052, 38.19429], [-122.39062, 38.19495], [-122.39093, 38.19574], [-122.39188, 38.19767], [-122.39203, 38.19817], [-122.39206, 38.19858]]], [[[-122.49376, 38.11703], [-122.49205, 38.11836], [-122.48389, 38.1232], [-122.47161, 38.12781], [-122.47161, 38.12782], [-122.47197, 38.1283], [-122.47164, 38.12826], [-122.47067, 38.12757], [-122.47206, 38.12591], [-122.47326, 38.12358], [-122.47451, 38.11926], [-122.47456, 38.11893], [-122.4745, 38.11878], [-122.47439, 38.11865], [-122.47175, 38.11735], [-122.47077, 38.11682], [-122.47014, 38.11694], [-122.46924, 38.1173], [-122.46856, 38.11787], [-122.46755, 38.11832], [-122.46687, 38.1184], [-122.46604, 38.11802], [-122.46431, 38.11785], [-122.45945, 38.1183], [-122.45865, 38.11863], [-122.45771, 38.11917], [-122.45577, 38.1208], [-122.45528, 38.12149], [-122.45455, 38.12282], [-122.45402, 38.12467], [-122.45381, 38.12498], [-122.45358, 38.12529], [-122.45333, 38.12558], [-122.45307, 38.12587], [-122.45278, 38.12614], [-122.45195, 38.1269], [-122.45165, 38.12713], [-122.45134, 38.12733], [-122.45101, 38.12753], [-122.45066, 38.1277], [-122.4503, 38.12785], [-122.44994, 38.12799], [-122.44956, 38.1281], [-122.44917, 38.12819], [-122.44877, 38.12827], [-122.44837, 38.12832], [-122.44811, 38.12857], [-122.44742, 38.12858], [-122.44627, 38.12844], [-122.44514, 38.12834], [-122.44398, 38.12814], [-122.44347, 38.12808], [-122.44281, 38.12797], [-122.44213, 38.12776], [-122.44135, 38.12749], [-122.44065, 38.1272], [-122.44001, 38.12703], [-122.43955, 38.12687], [-122.43921, 38.1267], [-122.43891, 38.12662], [-122.43876, 38.1266], [-122.43836, 38.12669], [-122.43765, 38.12695], [-122.43736, 38.12716], [-122.43723, 38.12734], [-122.43713, 38.12755], [-122.43709, 38.12781], [-122.43711, 38.12807], [-122.43717, 38.1284], [-122.43735, 38.12893], [-122.43755, 38.1294], [-122.43771, 38.12967], [-122.43811, 38.13023], [-122.43886, 38.1314], [-122.43917, 38.13194], [-122.43958, 38.13247], [-122.44062, 38.13357], [-122.44168, 38.13464], [-122.44175, 38.13459], [-122.44276, 38.13578], [-122.44371, 38.13768], [-122.44356, 38.13763], [-122.44341, 38.13799], [-122.44347, 38.13839], [-122.44273, 38.13902], [-122.44194, 38.13975], [-122.44009, 38.14139], [-122.43858, 38.14212], [-122.43581, 38.14269], [-122.43463, 38.14305], [-122.43428, 38.14323], [-122.43428, 38.14347], [-122.43452, 38.14398], [-122.43544, 38.14477], [-122.43736, 38.14574], [-122.44119, 38.1476], [-122.44332, 38.14857], [-122.44386, 38.14899], [-122.44458, 38.14983], [-122.44481, 38.14975], [-122.44507, 38.15027], [-122.44568, 38.15076], [-122.44618, 38.15155], [-122.44472, 38.1519], [-122.44289, 38.15052], [-122.44116, 38.14994], [-122.4406, 38.14972], [-122.44026, 38.14972], [-122.43992, 38.14989], [-122.43953, 38.1502], [-122.43902, 38.15041], [-122.43846, 38.15037], [-122.43824, 38.15023], [-122.43785, 38.14988], [-122.43758, 38.14944], [-122.43719, 38.14873], [-122.43352, 38.14575], [-122.43246, 38.1453], [-122.4314, 38.14503], [-122.43039, 38.14463], [-122.42923, 38.14325], [-122.42929, 38.1429], [-122.43064, 38.14145], [-122.43423, 38.14018], [-122.43821, 38.13919], [-122.44034, 38.13785], [-122.44014, 38.13626], [-122.4388, 38.13479], [-122.43875, 38.13448], [-122.43786, 38.13377], [-122.43753, 38.13315], [-122.43736, 38.13275], [-122.43715, 38.13191], [-122.43593, 38.13023], [-122.43537, 38.12974], [-122.43504, 38.12934], [-122.43482, 38.12867], [-122.43483, 38.12814], [-122.43533, 38.12696], [-122.42823, 38.1274], [-122.42723, 38.12665], [-122.42655, 38.12638], [-122.42498, 38.12712], [-122.4229, 38.12839], [-122.42228, 38.12919], [-122.4216, 38.12993], [-122.42104, 38.1302], [-122.42009, 38.13046], [-122.41879, 38.13111], [-122.41688, 38.13234], [-122.41452, 38.13419], [-122.41373, 38.13467], [-122.41349, 38.13477], [-122.41337, 38.13526], [-122.41303, 38.13574], [-122.41241, 38.13614], [-122.41185, 38.13684], [-122.41094, 38.13838], [-122.41009, 38.14028], [-122.40963, 38.14094], [-122.40857, 38.14133], [-122.40811, 38.14164], [-122.40686, 38.14486], [-122.40634, 38.14605], [-122.40589, 38.14689], [-122.40554, 38.14797], [-122.40735, 38.15138], [-122.40802, 38.15196], [-122.4099, 38.1551], [-122.4099, 38.15581], [-122.40701, 38.1558], [-122.40649, 38.15446], [-122.40584, 38.1534], [-122.40548, 38.15285], [-122.40492, 38.15219], [-122.40435, 38.15143], [-122.40393, 38.15092], [-122.40366, 38.15067], [-122.40338, 38.15027], [-122.40308, 38.14995], [-122.40201, 38.14838], [-122.40173, 38.14786], [-122.40133, 38.14727], [-122.40084, 38.14642], [-122.40043, 38.14576], [-122.39999, 38.14523], [-122.39947, 38.14445], [-122.39867, 38.14315], [-122.3981, 38.14212], [-122.39768, 38.14148], [-122.39728, 38.14077], [-122.39688, 38.14018], [-122.3965, 38.13957], [-122.39602, 38.13888], [-122.39494, 38.13713], [-122.39433, 38.13619], [-122.39286, 38.13382], [-122.39201, 38.13255], [-122.39096, 38.13086], [-122.38859, 38.12709], [-122.37881, 38.1114], [-122.37609, 38.10709], [-122.37608, 38.10703], [-122.37578, 38.10654], [-122.37487, 38.10534], [-122.45452, 38.10507], [-122.46556, 38.10994], [-122.4853, 38.1113], [-122.49218, 38.11182], [-122.49048, 38.11561], [-122.49245, 38.11561], [-122.49376, 38.11703]], [[-122.44977, 38.12227], [-122.44993, 38.12215], [-122.44997, 38.1217], [-122.45051, 38.12042], [-122.45071, 38.12005], [-122.45072, 38.11987], [-122.45069, 38.11962], [-122.45053, 38.11935], [-122.45042, 38.119], [-122.45023, 38.11872], [-122.44909, 38.11763], [-122.44893, 38.11754], [-122.44865, 38.11743], [-122.44807, 38.11716], [-122.44795, 38.11707], [-122.44771, 38.11713], [-122.44688, 38.11696], [-122.44576, 38.11658], [-122.44463, 38.11632], [-122.4437, 38.11626], [-122.44295, 38.11662], [-122.44133, 38.11721], [-122.44046, 38.11737], [-122.43995, 38.11765], [-122.43948, 38.11769], [-122.43899, 38.11781], [-122.43775, 38.11894], [-122.43694, 38.12018], [-122.43655, 38.12044], [-122.43478, 38.12108], [-122.43421, 38.12145], [-122.43677, 38.12567], [-122.43739, 38.12522], [-122.43776, 38.12506], [-122.43889, 38.12424], [-122.43963, 38.12438], [-122.43978, 38.12433], [-122.44203, 38.12452], [-122.44261, 38.12454], [-122.44339, 38.1246], [-122.44384, 38.12469], [-122.44487, 38.12528], [-122.44506, 38.12543], [-122.44752, 38.12626], [-122.4481, 38.12618], [-122.44865, 38.12577], [-122.44897, 38.12491], [-122.44915, 38.1241], [-122.4492, 38.12382], [-122.4494, 38.12316], [-122.44977, 38.12227]]]]} | Restricted Access 2 | 44493 | San Pablo Bay National Wildlife Refuge | 24964 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 6942.1 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
3755 | 3755 | 3754 | {"type": "Polygon", "coordinates": [[[-122.43372, 38.14591], [-122.43337, 38.1458], [-122.43311, 38.14563], [-122.4322, 38.14524], [-122.43246, 38.1453], [-122.43352, 38.14575], [-122.43372, 38.14591]]]} | Open Access 1 | 461 | San Pablo Bay National Wildlife Refuge | 24963 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 0.21 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
3916 | 3916 | 3915 | {"type": "Polygon", "coordinates": [[[-122.51009, 38.36459], [-122.51009, 38.36459], [-122.5059, 38.36725], [-122.50542, 38.36613], [-122.50569, 38.36589], [-122.50569, 38.36502], [-122.50624, 38.36486], [-122.50574, 38.36403], [-122.50846, 38.36297], [-122.51009, 38.36459]]]} | Open Access 1 | 2030 | Bouverie Wildflower Preserve | 16304 | 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 | Sonoma 16 | 24.503 | Bouverie Wildflower Preserve | 1970 | Local Conservation Area 4 | 2 | |
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 | |
4850 | 4850 | 4849 | {"type": "MultiPolygon", "coordinates": [[[[-118.40479, 37.45191], [-118.40479, 37.45525], [-118.40465, 37.45578], [-118.4045, 37.45651], [-118.40444, 37.45692], [-118.40442, 37.45733], [-118.40444, 37.45794], [-118.4045, 37.45834], [-118.40459, 37.45874], [-118.40462, 37.45912], [-118.39548, 37.45917], [-118.39548, 37.45195], [-118.40479, 37.45191]]], [[[-118.40479, 37.4561], [-118.40479, 37.45871], [-118.40479, 37.45871], [-118.40471, 37.45832], [-118.40465, 37.45793], [-118.40463, 37.45733], [-118.40467, 37.45674], [-118.40479, 37.4561]]]]} | Open Access 1 | 6995 | Fish Slough Ecological Reserve | 32166 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fish-Slough-ER | Inyo 43 | 161.221 | Fish Slough ER | 1970 | State Conservation Area 8 | 2 |
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 | |
9491 | 9491 | 9490 | {"type": "MultiPolygon", "coordinates": [[[[-122.09248, 37.63911], [-122.0841, 37.6505], [-122.08146, 37.65183], [-122.07932, 37.65272], [-122.07691, 37.65391], [-122.07795, 37.65562], [-122.07648, 37.65631], [-122.07596, 37.6575], [-122.07548, 37.65686], [-122.0758, 37.65603], [-122.07718, 37.65545], [-122.07612, 37.65385], [-122.07844, 37.65278], [-122.07985, 37.65207], [-122.08117, 37.65159], [-122.08237, 37.65106], [-122.0835, 37.65035], [-122.09167, 37.63886], [-122.09176, 37.63896], [-122.09222, 37.63912], [-122.09248, 37.63911]]], [[[-122.09853, 37.63425], [-122.09587, 37.63524], [-122.0951, 37.63524], [-122.09477, 37.63517], [-122.09827, 37.63389], [-122.09853, 37.63425]]], [[[-122.10894, 37.62975], [-122.10565, 37.63124], [-122.0989, 37.63411], [-122.09867, 37.63374], [-122.10872, 37.62921], [-122.10894, 37.62975]]]]} | Open Access 1 | 15886 | Eden Greenway | 18427 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 54.736 | Eden Greenway | 1970 | Local Recreation Area 3 | 4 | |
10345 | 10345 | 10344 | {"type": "Polygon", "coordinates": [[[-122.49129, 38.13979], [-122.49094, 38.14008], [-122.48862, 38.14022], [-122.48113, 38.14024], [-122.47877, 38.13707], [-122.47885, 38.13608], [-122.47845, 38.13542], [-122.47841, 38.13517], [-122.47842, 38.13501], [-122.47835, 38.1349], [-122.47867, 38.13424], [-122.47892, 38.1332], [-122.48981, 38.12658], [-122.48962, 38.12671], [-122.48963, 38.12824], [-122.48905, 38.12978], [-122.48998, 38.13368], [-122.4902, 38.13411], [-122.49102, 38.13642], [-122.49032, 38.13713], [-122.49049, 38.13859], [-122.49111, 38.13928], [-122.49127, 38.13954], [-122.49129, 38.13979]]]} | No Public Access 3 | 18245 | San Pablo Bay National Wildlife Refuge | 30385 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 272.673 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
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 |
11407 | 11407 | 11406 | {"type": "Polygon", "coordinates": [[[-122.4184, 37.60888], [-122.41819, 37.60887], [-122.41805, 37.60889], [-122.41726, 37.60916], [-122.41646, 37.60929], [-122.41644, 37.60926], [-122.4166, 37.60917], [-122.41668, 37.60909], [-122.41675, 37.60897], [-122.41686, 37.60875], [-122.41689, 37.60866], [-122.41688, 37.60847], [-122.41682, 37.60835], [-122.41562, 37.60661], [-122.41524, 37.60598], [-122.41429, 37.60425], [-122.41482, 37.60395], [-122.41507, 37.60389], [-122.41574, 37.60502], [-122.41588, 37.60505], [-122.4161, 37.6053], [-122.41615, 37.60556], [-122.4163, 37.60578], [-122.41648, 37.60593], [-122.41662, 37.60611], [-122.41699, 37.60641], [-122.41751, 37.6067], [-122.41763, 37.60683], [-122.41798, 37.60758], [-122.4182, 37.60776], [-122.41805, 37.60783], [-122.41779, 37.60848], [-122.41784, 37.60861], [-122.41803, 37.60881], [-122.41822, 37.60882], [-122.4184, 37.60888]]]} | Open Access 1 | 48091 | Lomita Spur Trail | 32594 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | https://www.ci.millbrae.ca.us/home/showdocument?id=19758 | San Mateo 15 | 16.268 | Lomita Spur Trail | 1970 | Local Recreation Area 3 | 4 |
13017 | 13017 | 13016 | {"type": "Polygon", "coordinates": [[[-121.68009, 37.56802], [-121.67092, 37.56801], [-121.67087, 37.56432], [-121.68008, 37.56426], [-121.68009, 37.56802]]]} | No Public Access 3 | 46956 | Del Valle Regional Park | 30579 | 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 | Alameda 17 | 82.963 | Del Valle RP | 1970 | Local Park 2 | 4 | |
14675 | 14675 | 14674 | {"type": "Polygon", "coordinates": [[[-122.47515, 38.13287], [-122.47433, 38.13449], [-122.47417, 38.13476], [-122.47263, 38.1359], [-122.47016, 38.13751], [-122.46989, 38.13761], [-122.45908, 38.14432], [-122.45902, 38.14444], [-122.4586, 38.14458], [-122.45822, 38.14483], [-122.45782, 38.14507], [-122.45741, 38.14529], [-122.45698, 38.1455], [-122.45654, 38.14569], [-122.45609, 38.14586], [-122.45563, 38.14601], [-122.45503, 38.14618], [-122.45426, 38.14635], [-122.45113, 38.13668], [-122.45572, 38.13485], [-122.46439, 38.13148], [-122.47061, 38.12912], [-122.47065, 38.12918], [-122.46943, 38.12969], [-122.46948, 38.12974], [-122.4707, 38.12925], [-122.47091, 38.12953], [-122.47242, 38.12891], [-122.47469, 38.13179], [-122.47508, 38.13258], [-122.47514, 38.1326], [-122.47515, 38.13287]]]} | Restricted Access 2 | 44952 | San Pablo Bay National Wildlife Refuge | 24964 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Sonoma 16 | 490.121 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 | |
15634 | 15634 | 15633 | {"type": "Polygon", "coordinates": [[[-118.41528, 37.50655], [-118.41424, 37.51016], [-118.41131, 37.5101], [-118.41137, 37.5067], [-118.41305, 37.50674], [-118.41305, 37.5065], [-118.41528, 37.50655]]]} | Restricted Access 2 | 29431 | Fish Slough Ecological Reserve | 18918 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Fish-Slough-ER | Mono 32 | 29.181 | Fish Slough ER | 1970 | State Conservation Area 8 | 2 |
15834 | 15834 | 15833 | {"type": "Polygon", "coordinates": [[[-122.33934, 38.15573], [-122.33919, 38.15592], [-122.33894, 38.15637], [-122.33875, 38.15679], [-122.33872, 38.15693], [-122.33861, 38.15714], [-122.33856, 38.15758], [-122.33841, 38.15832], [-122.33829, 38.15856], [-122.33809, 38.15884], [-122.33779, 38.1591], [-122.33759, 38.15913], [-122.33741, 38.15909], [-122.33694, 38.15895], [-122.33503, 38.15824], [-122.33482, 38.15813], [-122.33419, 38.15741], [-122.33391, 38.15692], [-122.33396, 38.15657], [-122.33421, 38.15609], [-122.33447, 38.15581], [-122.33474, 38.15559], [-122.33545, 38.15565], [-122.33538, 38.15569], [-122.33539, 38.15571], [-122.33934, 38.15573]]]} | Restricted Access 2 | 35998 | San Pablo Bay National Wildlife Refuge | 24964 | 106 | United States Fish and Wildlife Service 45 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | Napa 11 | 31.587 | San Pablo Bay NWR | 1970 | National Wildlife Refuge 105 | 2 |
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]);