units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
647 rows where COUNTY = 17
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_LEV, PARK_URL, ACRES, LABEL_NAME, YR_EST, GAP_STS
SUID_NMA 631 ✖
- 19761 3
- 30594 3
- 1486 2
- 3244 2
- 3247 2
- 3251 2
- 3259 2
- 3268 2
- 3285 2
- 3318 2
- 3844 2
- 10841 2
- 17607 2
- 29199 2
- 1434 1
- 1594 1
- 2727 1
- 3205 1
- 3208 1
- 3240 1
- 3282 1
- 3301 1
- 3307 1
- 3312 1
- 3324 1
- 3820 1
- 3837 1
- 3858 1
- 4363 1
- 5287 1
- 5294 1
- 7825 1
- 7828 1
- 8732 1
- 10826 1
- 13902 1
- 15188 1
- 15195 1
- 15207 1
- 15208 1
- 15217 1
- 15218 1
- 15247 1
- 15262 1
- 15272 1
- 15278 1
- 15307 1
- 15327 1
- 15328 1
- 15344 1
- 15380 1
- 15397 1
- 15435 1
- 15436 1
- 15548 1
- 15608 1
- 15613 1
- 15619 1
- 15635 1
- 15649 1
- 15654 1
- 15669 1
- 15726 1
- 15739 1
- 15860 1
- 15882 1
- 15909 1
- 15914 1
- 15940 1
- 15943 1
- 15947 1
- 15954 1
- 15981 1
- 16023 1
- 16024 1
- 16065 1
- 16069 1
- 16094 1
- 16103 1
- 16116 1
- 16118 1
- 16146 1
- 16201 1
- 16254 1
- 16273 1
- 16293 1
- 16337 1
- 16377 1
- 16420 1
- 16436 1
- 16437 1
- 16451 1
- 16455 1
- 16456 1
- 16491 1
- 16515 1
- 16540 1
- 16617 1
- 16639 1
- 16646 1
- 16729 1
- 16803 1
- 16828 1
- 16860 1
- 16884 1
- 16885 1
- 16886 1
- 16931 1
- 16993 1
- 17022 1
- 17027 1
- 17031 1
- 17042 1
- 17073 1
- 17093 1
- 17097 1
- 17100 1
- 17108 1
- 17109 1
- 17121 1
- 17138 1
- 17145 1
- 17169 1
- 17174 1
- 17175 1
- 17224 1
- 17227 1
- 17298 1
- 17360 1
- 17361 1
- 17372 1
- 17381 1
- 17422 1
- 17456 1
- 17472 1
- 17479 1
- 17499 1
- 17504 1
- 17550 1
- 17577 1
- 17606 1
- 17717 1
- 17721 1
- 17741 1
- 17751 1
- 17755 1
- 17777 1
- 17799 1
- 17824 1
- 17862 1
- 17873 1
- 17939 1
- 17942 1
- 17964 1
- 17969 1
- 17987 1
- 17989 1
- 18011 1
- 18017 1
- 18047 1
- 18079 1
- 18154 1
- 18177 1
- 18189 1
- 18199 1
- 18204 1
- 18222 1
- 18241 1
- 18259 1
- 18270 1
- 18273 1
- 18292 1
- 18293 1
- 18309 1
- 18311 1
- 18355 1
- 18360 1
- 18418 1
- 18427 1
- 18430 1
- 18523 1
- 18554 1
- 18598 1
- 18614 1
- 18732 1
- 18736 1
- 18737 1
- 18780 1
- 18801 1
- 18804 1
- 18809 1
- 18818 1
- 18823 1
- 18854 1
- 18930 1
- 18933 1
- 18963 1
- 19049 1
- 19060 1
- 19063 1
- 19073 1
- 19079 1
- 19137 1
- 19186 1
- 19189 1
- 19213 1
- 19235 1
- 19264 1
- 19320 1
- 19328 1
- 19352 1
- 19360 1
- 19388 1
- 19408 1
- 19458 1
- 19472 1
- 19482 1
- 19483 1
- 19491 1
- 19496 1
- 19525 1
- 19531 1
- 19532 1
- 19535 1
- 19593 1
- 19600 1
- 19601 1
- 19608 1
- 19650 1
- 19677 1
- 19701 1
- 19723 1
- 19730 1
- 19758 1
- 19759 1
- 19762 1
- 19779 1
- 19786 1
- 19798 1
- 19807 1
- 19838 1
- 19883 1
- 19966 1
- 20077 1
- 20098 1
- 20171 1
- 20194 1
- 20206 1
- 20226 1
- 20273 1
- 20274 1
- 20314 1
- 20319 1
- 20339 1
- 20346 1
- 20362 1
- 20383 1
- 20445 1
- 20554 1
- 20602 1
- 20606 1
- 20660 1
- 20715 1
- 20720 1
- 20727 1
- 20788 1
- 20833 1
- 20953 1
- 20970 1
- 20972 1
- 20973 1
- 20979 1
- 21074 1
- 21092 1
- 21171 1
- 21183 1
- 21200 1
- 21224 1
- 21260 1
- 21275 1
- 21281 1
- 21291 1
- 21304 1
- 21328 1
- 21365 1
- 21367 1
- 21380 1
- 21381 1
- 21382 1
- 21442 1
- 21454 1
- 21458 1
- 21510 1
- 21557 1
- 21570 1
- 21613 1
- 21628 1
- 21648 1
- 21649 1
- 21660 1
- 21696 1
- 21736 1
- 21738 1
- 21771 1
- 21830 1
- 21831 1
- 21833 1
- 21836 1
- 21854 1
- 21878 1
- 21897 1
- 21899 1
- 21906 1
- 21963 1
- 21971 1
- 21977 1
- 21985 1
- 21986 1
- 21996 1
- 22003 1
- 22046 1
- 22047 1
- 22049 1
- 22090 1
- 22098 1
- 22104 1
- 22132 1
- 22208 1
- 22280 1
- 22300 1
- 22310 1
- 22335 1
- 22336 1
- 22361 1
- 22370 1
- 22386 1
- 22472 1
- 22485 1
- 22508 1
- 22516 1
- 22577 1
- 22585 1
- 22589 1
- 22615 1
- 22700 1
- 22712 1
- 22713 1
- 22755 1
- 22761 1
- 22784 1
- 22791 1
- 22835 1
- 22869 1
- 22872 1
- 22876 1
- 22935 1
- 22967 1
- 22996 1
- 23028 1
- 23034 1
- 23035 1
- 23058 1
- 23074 1
- 23076 1
- 23081 1
- 23086 1
- 23094 1
- 23136 1
- 23205 1
- 23239 1
- 23276 1
- 23283 1
- 23304 1
- 23349 1
- 23366 1
- 23369 1
- 23426 1
- 23437 1
- 23483 1
- 23520 1
- 23591 1
- 23605 1
- 23606 1
- 23607 1
- 23659 1
- 23660 1
- 23681 1
- 23708 1
- 23735 1
- 23782 1
- 23804 1
- 23806 1
- 23807 1
- 23810 1
- 23812 1
- 23819 1
- 23889 1
- 23893 1
- 23911 1
- 23986 1
- 23999 1
- 24009 1
- 24081 1
- 24096 1
- 24104 1
- 24127 1
- 24128 1
- 24199 1
- 24288 1
- 24403 1
- 24472 1
- 24491 1
- 24497 1
- 24533 1
- 24600 1
- 24705 1
- 24757 1
- 24823 1
- 24832 1
- 24884 1
- 24889 1
- 24923 1
- 24925 1
- 24969 1
- 25005 1
- 25179 1
- 25229 1
- 25325 1
- 25359 1
- 25383 1
- 25390 1
- 25420 1
- 25426 1
- 25431 1
- 25441 1
- 25584 1
- 25587 1
- 25595 1
- 25624 1
- 25676 1
- 25689 1
- 25726 1
- 25728 1
- 25738 1
- 25761 1
- 25779 1
- 25788 1
- 25829 1
- 25890 1
- 25900 1
- 25907 1
- 25914 1
- 25943 1
- 25947 1
- 25966 1
- 25999 1
- 26056 1
- 26078 1
- 26084 1
- 26129 1
- 26153 1
- 26183 1
- 26193 1
- 26194 1
- 26198 1
- 26213 1
- 26230 1
- 26233 1
- 26243 1
- 26245 1
- 26259 1
- 26263 1
- 26273 1
- 26329 1
- 26350 1
- 26365 1
- 26482 1
- 26488 1
- 26500 1
- 26610 1
- 26656 1
- 26658 1
- 26659 1
- 26684 1
- 26734 1
- 26757 1
- 26774 1
- 26781 1
- 26782 1
- 26803 1
- 26835 1
- 26987 1
- 27055 1
- 27060 1
- 27081 1
- 27146 1
- 27153 1
- 27178 1
- 27206 1
- 27231 1
- 27252 1
- 27255 1
- 27260 1
- 27270 1
- 27272 1
- 27330 1
- 27420 1
- 27533 1
- 27539 1
- 27540 1
- 27547 1
- 27563 1
- 27580 1
- 27585 1
- 27626 1
- 27677 1
- 27748 1
- 27749 1
- 28080 1
- 28126 1
- 28714 1
- 28716 1
- 29020 1
- 29182 1
- 29198 1
- 29208 1
- 29211 1
- 30357 1
- 30358 1
- 30359 1
- 30360 1
- 30562 1
- 30564 1
- 30568 1
- 30571 1
- 30574 1
- 30577 1
- 30579 1
- 30582 1
- 30596 1
- 30597 1
- 30605 1
- 30628 1
- 30630 1
- 30634 1
- 30695 1
- 30698 1
- 30700 1
- 30702 1
- 30710 1
- 30817 1
- 30821 1
- 30822 1
- 30823 1
- 30824 1
- 30825 1
- 30826 1
- 30828 1
- 30829 1
- 30830 1
- 30894 1
- 30895 1
- 30896 1
- 31232 1
- 31391 1
- 31435 1
- 31436 1
- 31437 1
- 31448 1
- 31450 1
- 31451 1
- 31452 1
- 31454 1
- 31455 1
- 31456 1
- 31505 1
- 31506 1
- 31508 1
- 31509 1
- 31518 1
- 31754 1
- 31818 1
- 31819 1
- 31820 1
- 31949 1
- 31951 1
- 31952 1
- 31953 1
- 32076 1
- 32113 1
- 32155 1
- 32293 1
- 32417 1
- 32418 1
- 32419 1
- 32420 1
- 32421 1
- 32424 1
- 32425 1
- 32426 1
- 32427 1
- 32504 1
- 32515 1
- 32816 1
- 32907 1
- 32908 1
- 32909 1
- 32910 1
- 32911 1
- 32912 1
- 32913 1
- 32914 1
- 32915 1
- 32916 1
- 32917 1
- 33002 1
- 33042 1
- 33043 1
- 33079 1
- 33120 1
- 33200 1
- 33332 1
- 33376 1
- 33380 1
- 33465 1
- 33501 1
- 33640 1
- 33672 1
- 33749 1
- 33753 1
- 33754 1
DES_TP 57
- Local Park 478
- Local Recreation Area 67
- Local Conservation Area 22
- Local Other or Unknown 10
- Local Historic or Cultural Area 8
- Private Recreation or Education 5
- State Recreation Area 3
- State Resource Management Area 3
- Local Resource Management Area 2
- National Wildlife Refuge 2
- State Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- Private Agricultural 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
- 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
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 31
- Oakland, City of 122
- Hayward Area Recreation and Park District 84
- East Bay Regional Park District 77
- Fremont, City of 58
- Berkeley, City of 49
- Pleasanton, City of 44
- Livermore, City of 35
- Union City, City of 34
- Alameda, City of 28
- San Leandro, City of 23
- Dublin, City of 21
- Newark, City of 14
- Livermore Area Recreation and Park District 13
- Emeryville, City of 8
- Albany, City of 7
- Piedmont, City of 7
- California Department of Fish and Wildlife 4
- San Francisco - Public Utilities Commission, City and County of 2
- United States Fish and Wildlife Service 2
- California Department of Parks and Recreation 2
- University of California 2
- California Department of Water Resources 2
- Liberty Park Homeowners Association 1
- East Bay Municipal Utility District 1
- Tri-Valley Conservancy 1
- Alameda County Flood Control and Water Conservation District 1
- Private Landowner 1
- Marcella Renaissance Owners Association 1
- Lakeshore Homes Association 1
- Contra Costa Water District 1
- City Slicker Farms 1
MNG_AG_TYP 11
ACCESS_TYP 3
- Open Access 591
- Restricted Access 31
- No Public Access 25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
64 | 64 | 63 | {"type": "Polygon", "coordinates": [[[-121.91483, 37.63509], [-121.91478, 37.64364], [-121.9097, 37.64611], [-121.90561, 37.63248], [-121.90568, 37.63243], [-121.91279, 37.63249], [-121.9128, 37.63255], [-121.91326, 37.63289], [-121.91409, 37.63322], [-121.91427, 37.63348], [-121.91481, 37.63393], [-121.91472, 37.63444], [-121.91458, 37.63451], [-121.91479, 37.63476], [-121.9147, 37.63482], [-121.91478, 37.63509], [-121.91483, 37.63509]]]} | Open Access 1 | 185 | Augustin Bernal Park | 8732 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/services/recreation/rec-augustinpark.html | Alameda 17 | 217.388 | Augustin Bernal Park | 0 | Local Park 2 | 4 |
146 | 146 | 145 | {"type": "Polygon", "coordinates": [[[-122.24241, 37.79003], [-122.24099, 37.79152], [-122.23911, 37.7904], [-122.24053, 37.78891], [-122.24241, 37.79003]]]} | Open Access 1 | 366 | San Antonio Park | 24832 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 10.619 | San Antonio Park | 0 | Local Park 2 | 4 | |
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-122.00283, 37.56787], [-122.00528, 37.56886], [-122.00536, 37.56876], [-122.00637, 37.56915], [-122.00646, 37.56905], [-122.00694, 37.56924], [-122.00841, 37.57037], [-122.00605, 37.57247], [-122.00581, 37.57272], [-122.00563, 37.57245], [-122.00561, 37.57245], [-122.00486, 37.57485], [-122.00167, 37.57418], [-122.00088, 37.57663], [-122.00033, 37.5765], [-121.99656, 37.57363], [-121.99685, 37.57277], [-121.99721, 37.57285], [-121.99723, 37.57284], [-121.99743, 37.56696], [-121.99852, 37.56669], [-121.99871, 37.5667], [-121.9987, 37.56677], [-121.99916, 37.56686], [-121.99961, 37.56698], [-122.00112, 37.56756], [-122.0012, 37.56746], [-122.00224, 37.56786], [-122.00235, 37.56771], [-122.00283, 37.56787]]], [[[-122.00227, 37.57706], [-122.00224, 37.57716], [-122.00227, 37.57718], [-122.00203, 37.57784], [-122.0005, 37.57666], [-122.00227, 37.57706]]], [[[-122.01347, 37.57268], [-122.01183, 37.57446], [-122.01014, 37.57619], [-122.00994, 37.57635], [-122.00973, 37.57651], [-122.00895, 37.57696], [-122.00821, 37.57742], [-122.00796, 37.57759], [-122.0077, 37.57782], [-122.00748, 37.57808], [-122.0073, 37.57835], [-122.00718, 37.57862], [-122.00706, 37.5786], [-122.00686, 37.57917], [-122.00811, 37.57947], [-122.00818, 37.57956], [-122.00772, 37.58092], [-122.00605, 37.58056], [-122.00568, 37.58164], [-122.00418, 37.58051], [-122.00216, 37.57896], [-122.00209, 37.57889], [-122.00203, 37.5788], [-122.00198, 37.57866], [-122.002, 37.57851], [-122.00244, 37.57734], [-122.00248, 37.57728], [-122.00258, 37.57724], [-122.003, 37.57733], [-122.00424, 37.57807], [-122.00588, 37.57674], [-122.00592, 37.57631], [-122.01114, 37.57138], [-122.01347, 37.57268]]]]} | Open Access 1 | 586 | Quarry Lakes Regional Recreation Area | 30594 | 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 | 254.616 | Quarry Lakes Reg. Rec. Area | 2001 | Local Recreation Area 3 | 4 | |
394 | 394 | 393 | {"type": "Polygon", "coordinates": [[[-121.90274, 37.6751], [-121.89877, 37.67675], [-121.89728, 37.6759], [-121.89877, 37.67439], [-121.89993, 37.67487], [-121.90048, 37.67498], [-121.90108, 37.67494], [-121.90163, 37.67477], [-121.90224, 37.67434], [-121.90254, 37.67469], [-121.90274, 37.6751]]]} | Open Access 1 | 1438 | Tennis & Community Park | 26243 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 15.595 | Tennis & Community Park | 0 | Local Park 2 | 4 | |
409 | 409 | 408 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | 48353 | Sean Diamond Park | 32917 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | Alameda 17 | 4.986 | Sean Diamond Park | 2018 | Local Park 2 | 4 |
480 | 480 | 479 | {"type": "Polygon", "coordinates": [[[-122.25181, 37.74294], [-122.25094, 37.74333], [-122.2502, 37.74331], [-122.2502, 37.74256], [-122.25026, 37.74211], [-122.25158, 37.74235], [-122.25161, 37.74252], [-122.25168, 37.74271], [-122.25181, 37.74294]]]} | Open Access 1 | 1631 | Tillman Park | 26365 | 1001 | Alameda, City of 180 | City 2 | City Agency 2 | http://alamedaca.gov/recreation | City 2 | 1001 | Alameda, City of 176 | City 2 | City Agency 2 | Alameda 17 | 3.586 | Tillman Park | 0 | Local Park 2 | 4 | |
490 | 490 | 489 | {"type": "Polygon", "coordinates": [[[-122.14785, 37.69505], [-122.1456, 37.69512], [-122.14527, 37.69542], [-122.14472, 37.69503], [-122.1447, 37.69334], [-122.14783, 37.69326], [-122.14785, 37.69505]]]} | Open Access 1 | 1962 | Washington Manor | 27270 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 13.829 | Washington Manor | None 51 | |||
576 | 576 | 575 | {"type": "Polygon", "coordinates": [[[-122.14526, 37.74311], [-122.14524, 37.74315], [-122.14492, 37.74341], [-122.14434, 37.74398], [-122.14423, 37.74406], [-122.1437, 37.7433], [-122.14342, 37.74306], [-122.14482, 37.7425], [-122.14526, 37.74311]]]} | Open Access 1 | 3448 | Poaks Headquarters | 23819 | 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 | 3.419 | Poaks Headquarters | None 57 | |||
681 | 681 | 680 | {"type": "Polygon", "coordinates": [[[-122.19178, 37.73593], [-122.19137, 37.73616], [-122.19116, 37.73688], [-122.19077, 37.73841], [-122.18827, 37.73776], [-122.18881, 37.73569], [-122.19025, 37.736], [-122.19031, 37.73606], [-122.19074, 37.7357], [-122.19104, 37.73566], [-122.19126, 37.73533], [-122.19178, 37.73593]]]} | Open Access 1 | 3504 | Ira Jenkins Park | 20226 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 15.161 | Ira Jenkins Park | 0 | Local Park 2 | 4 | |
781 | 781 | 780 | {"type": "Polygon", "coordinates": [[[-121.83892, 37.69284], [-121.83892, 37.69497], [-121.83838, 37.69541], [-121.83777, 37.69567], [-121.83724, 37.69614], [-121.83653, 37.69638], [-121.83615, 37.6966], [-121.8359, 37.6971], [-121.83545, 37.69735], [-121.83435, 37.69759], [-121.83308, 37.69793], [-121.83316, 37.69844], [-121.83289, 37.69879], [-121.83205, 37.69921], [-121.83202, 37.6983], [-121.82998, 37.69835], [-121.82998, 37.70055], [-121.82094, 37.70062], [-121.81888, 37.69912], [-121.81883, 37.69713], [-121.82405, 37.69676], [-121.8243, 37.69635], [-121.82403, 37.6952], [-121.82983, 37.6953], [-121.83021, 37.69279], [-121.83892, 37.69284]]]} | Restricted Access 2 | 5062 | Las Positas Golf Course | 33002 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 216.12 | Las Positas GC | 0 | Local Recreation Area 3 | 4 | |
783 | 783 | 782 | {"type": "Polygon", "coordinates": [[[-122.09551, 37.63544], [-122.09549, 37.63615], [-122.0955, 37.63682], [-122.09501, 37.63684], [-122.09505, 37.63746], [-122.09413, 37.63754], [-122.0942, 37.63815], [-122.09387, 37.63819], [-122.09387, 37.63901], [-122.09249, 37.63911], [-122.09222, 37.63912], [-122.0919, 37.63901], [-122.09449, 37.63532], [-122.09496, 37.63539], [-122.09551, 37.63544]]]} | Open Access 1 | 5069 | Southgate Park | 25689 | 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 | 14.46 | Southgate Park | 1965 | Local Park 2 | 4 | |
813 | 813 | 812 | {"type": "Polygon", "coordinates": [[[-121.78193, 37.67297], [-121.78197, 37.67334], [-121.78197, 37.67383], [-121.78189, 37.67423], [-121.78035, 37.67389], [-121.78048, 37.67298], [-121.78193, 37.67297]]]} | Open Access 1 | 5241 | Mocho Park | 22336 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 4.098 | Mocho Park | 0 | Local Park 2 | 4 | |
816 | 816 | 815 | {"type": "Polygon", "coordinates": [[[-121.80478, 37.67824], [-121.80306, 37.67892], [-121.80129, 37.67953], [-121.80062, 37.67969], [-121.79957, 37.67975], [-121.79748, 37.67946], [-121.79627, 37.67965], [-121.7953, 37.67994], [-121.79396, 37.67982], [-121.79254, 37.67974], [-121.7915, 37.67976], [-121.79158, 37.67946], [-121.79158, 37.67939], [-121.79205, 37.6795], [-121.79326, 37.67955], [-121.79464, 37.67963], [-121.79547, 37.6796], [-121.79602, 37.67934], [-121.7967, 37.67905], [-121.79774, 37.6791], [-121.79887, 37.67934], [-121.79991, 37.67942], [-121.80079, 37.67936], [-121.80188, 37.67901], [-121.80281, 37.67855], [-121.80429, 37.6779], [-121.80478, 37.67824]]]} | Open Access 1 | 5263 | Arroyo Mocho | 15613 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 10.963 | Arroyo Mocho | None 75 | |||
855 | 855 | 854 | {"type": "Polygon", "coordinates": [[[-122.18754, 37.70419], [-122.18658, 37.70459], [-122.18625, 37.70409], [-122.18721, 37.70369], [-122.18754, 37.70419]]]} | Open Access 1 | 24933 | Mulford Park | 22589 | 1306 | San Leandro, City of 183 | City 2 | City Agency 2 | http://www.sanleandro.org/depts/rec/parks/default.asp | City 2 | 1306 | San Leandro, City of 179 | City 2 | City Agency 2 | Alameda 17 | 1.495 | Mulford Park | 0 | Local Park 2 | 4 | |
864 | 864 | 863 | {"type": "Polygon", "coordinates": [[[-122.29161, 37.89499], [-122.29154, 37.89662], [-122.28999, 37.89658], [-122.29007, 37.89494], [-122.29161, 37.89499]]]} | Open Access 1 | 5579 | Albany Memorial Park | 15328 | 1002 | Albany, City of 274 | City 2 | City Agency 2 | http://www.albanyca.org/index.aspx?page=473 | City 2 | 1002 | Albany, City of 269 | City 2 | City Agency 2 | Alameda 17 | 6.13 | Albany Memorial Park | 1920 | Local Park 2 | 4 | |
1101 | 1101 | 1100 | {"type": "Polygon", "coordinates": [[[-122.06832, 37.64878], [-122.0678, 37.64887], [-122.06776, 37.64853], [-122.06779, 37.64844], [-122.06798, 37.64835], [-122.06832, 37.64878]]]} | Open Access 1 | 15630 | Haymont Mini Park | 19758 | 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 | 0.431 | Haymont MP | 0 | Local Park 2 | 4 | |
1218 | 1218 | 1217 | {"type": "MultiPolygon", "coordinates": [[[[-122.1451, 37.64851], [-122.14511, 37.64897], [-122.14509, 37.64903], [-122.14501, 37.64917], [-122.14486, 37.64934], [-122.14456, 37.64957], [-122.14429, 37.64973], [-122.14412, 37.64979], [-122.14409, 37.64745], [-122.14507, 37.64744], [-122.1451, 37.64851]]], [[[-122.14586, 37.6471], [-122.14517, 37.64711], [-122.14517, 37.64682], [-122.14586, 37.64682], [-122.14586, 37.6471]]]]} | Open Access 1 | 8671 | Hayward Shoreline | 19762 | 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 | 5.421 | Hayward Shoreline | 1977 | Local Park 2 | 4 | |
1226 | 1226 | 1225 | {"type": "Polygon", "coordinates": [[[-122.2621, 37.81037], [-122.26187, 37.81046], [-122.26141, 37.8104], [-122.26121, 37.81003], [-122.26124, 37.80951], [-122.26139, 37.80882], [-122.26145, 37.80722], [-122.26125, 37.80701], [-122.26115, 37.80678], [-122.26059, 37.80677], [-122.26018, 37.80656], [-122.26, 37.80604], [-122.25945, 37.80556], [-122.25897, 37.80479], [-122.25862, 37.80467], [-122.25787, 37.80485], [-122.2566, 37.80538], [-122.25631, 37.8057], [-122.25625, 37.80655], [-122.25573, 37.80703], [-122.25541, 37.80719], [-122.25475, 37.80716], [-122.254, 37.80703], [-122.25305, 37.80712], [-122.25224, 37.80751], [-122.25146, 37.8081], [-122.25109, 37.80815], [-122.24995, 37.80847], [-122.24972, 37.80838], [-122.24972, 37.80785], [-122.24999, 37.80721], [-122.2503, 37.80668], [-122.25074, 37.80566], [-122.2511, 37.80499], [-122.25117, 37.80494], [-122.2534, 37.80418], [-122.25372, 37.80369], [-122.2539, 37.80321], [-122.25472, 37.80211], [-122.25473, 37.80206], [-122.25483, 37.80191], [-122.25473, 37.80158], [-122.25473, 37.80085], [-122.25507, 37.80057], [-122.25551, 37.80043], [-122.25654, 37.80053], [-122.25712, 37.80039], [-122.25836, 37.79968], [-122.25882, 37.7992], [-122.25917, 37.79895], [-122.26125, 37.79996], [-122.26139, 37.80021], [-122.26151, 37.80087], [-122.2613, 37.80222], [-122.26104, 37.80261], [-122.26049, 37.80382], [-122.26049, 37.80451], [-122.26147, 37.80527], [-122.26245, 37.80641], [-122.2628, 37.80726], [-122.2628, 37.80815], [-122.2626, 37.8087], [-122.26228, 37.81014], [-122.2621, 37.81037]]]} | Open Access 1 | 8847 | Lake Merritt | 20953 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 141.432 | Lake Merritt | 1957 | None 107 | ||
1246 | 1246 | 1245 | {"type": "Polygon", "coordinates": [[[-122.27628, 37.89224], [-122.2759, 37.8923], [-122.27586, 37.89215], [-122.2762, 37.89203], [-122.27628, 37.89224]]]} | Open Access 1 | 44896 | Contra Costa Rock Park | 17607 | 1028 | Berkeley, City of 337 | City 2 | City Agency 2 | http://www.ci.berkeley.ca.us/PRW/ | City 2 | 1028 | Berkeley, City of 334 | City 2 | City Agency 2 | Alameda 17 | 0.169 | Contra Costa Rock Park | 0 | Local Park 2 | 4 | |
1390 | 1390 | 1389 | {"type": "Polygon", "coordinates": [[[-121.79075, 37.65873], [-121.78962, 37.65876], [-121.78926, 37.6589], [-121.78862, 37.65791], [-121.79066, 37.65786], [-121.79072, 37.65809], [-121.79075, 37.65873]]]} | Open Access 1 | 12195 | Jack Williams | 20314 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 3.928 | Jack Williams | None 118 |
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]);