units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_NAME
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 9,822
- County Agency 1,146
- Recreation/Parks District 1,088
- State Agency 1,068
- Non Profit - Land Trust 577
- Federal Agency 425
- Open Space District 413
- Water District 233
- County Agency - Parks 218
- Home Owners Association 194
- Community Services District 185
- Non Profit - Conservation 142
- Flood District 80
- Cemetery District 59
- Irrigation District 50
- Non Profit - Other 45
- School District 36
- County Agency - Other 34
- Port/Harbor District 31
- Commercial 15
- Special District - Other 12
- Sanitation District 9
- Joint Powers Authority 8
- Other 5
- Non Profit - Cemetery District 5
- Conservation District 5
- Mitigation Bank 4
- Transportation Agency 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 507
- Los Angeles, City of 442
- California Department of Fish and Wildlife 413
- California Department of Parks and Recreation 347
- Mountains Recreation and Conservation Authority 339
- San Jose, City of 239
- San Francisco, City and County of 218
- Sacramento, City of 205
- East Bay Regional Park District 157
- Los Angeles, County of 155
- Ventura, City of 148
- Long Beach, City of 133
- Roseville, City of 126
- San Diego, County of 114
- Santa Barbara, County of 110
- Oakland, City of 108
- United States Forest Service 107
- Irvine, City of 100
- Orange, County of 89
- Fresno, City of 88
- Consumnes Community Services District 87
- California State Lands Commission 86
- United States National Park Service 85
- Modesto, City of 80
- Hayward Area Recreation and Park District 79
- United States Fish and Wildlife Service 78
- Santa Rosa, City of 77
- Napa, City of 77
- Stockton, City of 73
- Huntington Beach, City of 70
- …
DES_TP >30
- Local Park 8,739
- Local Recreation Area 1,853
- Local Other or Unknown 1,164
- Private Conservation 603
- Local Conservation Area 456
- State Conservation Area 355
- Private Recreation or Education 255
- State Park 193
- State Resource Management Area 155
- State Recreation Area 130
- Local Historic or Cultural Area 110
- National Forest 95
- National Wildlife Refuge 74
- State Other or Unknown 67
- State Historic or Cultural Area 60
- Recreation Management Area 54
- Private Other or Unknown 51
- National Monument or Landmark 39
- National Recreation Area 37
- National Park 26
- Resource Management Area 26
- Federal Other or Unknown 24
- Local Resource Management Area 22
- Private Agricultural 12
- Conservation Area 11
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- National Public Lands 3
- …
ACCESS_TYP 4
- Open Access 13,509
- Restricted Access 1,123
- No Public Access 916
- Unknown Access 372
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9618 | 9618 | 9617 | {"type": "Polygon", "coordinates": [[[-122.4896, 37.90065], [-122.48895, 37.9], [-122.48871, 37.89969], [-122.48866, 37.89959], [-122.48863, 37.89925], [-122.4886, 37.89911], [-122.48829, 37.89811], [-122.48851, 37.89808], [-122.48865, 37.89802], [-122.48898, 37.8993], [-122.48938, 37.90012], [-122.48955, 37.90034], [-122.4896, 37.90065]]]} | Open Access 1 | 16199 | Belveron Mini Park | 16001 | 1348 | Tiburon, Town of 486 | City 2 | City Agency 2 | http://www.ci.tiburon.ca.us/ | City 2 | 1348 | Tiburon, Town of 477 | City 2 | City Agency 2 | Marin 23 | 2.094 | Belveron MP | 0 | Local Park 2 | 4 | |
2692 | 2692 | 2691 | {"type": "MultiPolygon", "coordinates": [[[[-122.08941, 37.08847], [-122.08867, 37.0882], [-122.0887, 37.08805], [-122.0888, 37.08808], [-122.08909, 37.08823], [-122.08938, 37.08835], [-122.08941, 37.08847]]], [[[-122.09254, 37.08896], [-122.0925, 37.08902], [-122.09228, 37.08886], [-122.09149, 37.08889], [-122.09142, 37.08887], [-122.09137, 37.08877], [-122.09012, 37.08881], [-122.09009, 37.08845], [-122.09002, 37.08845], [-122.09019, 37.08817], [-122.09026, 37.08819], [-122.09035, 37.08816], [-122.09053, 37.08823], [-122.09047, 37.08832], [-122.09038, 37.08833], [-122.09042, 37.08845], [-122.09038, 37.08844], [-122.09039, 37.08849], [-122.09058, 37.08852], [-122.09111, 37.08856], [-122.09112, 37.08855], [-122.09111, 37.08848], [-122.09135, 37.08849], [-122.09136, 37.08857], [-122.09139, 37.08858], [-122.09176, 37.08858], [-122.09193, 37.08861], [-122.09225, 37.08874], [-122.09234, 37.08883], [-122.09245, 37.08889], [-122.09254, 37.08896]]]]} | Open Access 1 | 17802 | Ben Lomond Park | 16002 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | http://www.scparks.com/ | County 3 | 327 | Santa Cruz, County of 5 | County 3 | County Agency 3 | Santa Cruz 5 | 1.953 | Ben Lomond Park | 0 | Local Park 2 | 4 | |
9060 | 9060 | 9059 | {"type": "Polygon", "coordinates": [[[-121.86868, 37.42908], [-121.86866, 37.42913], [-121.86821, 37.42913], [-121.86811, 37.42885], [-121.86779, 37.42872], [-121.86771, 37.429], [-121.86767, 37.429], [-121.86761, 37.42873], [-121.8668, 37.42895], [-121.86674, 37.42899], [-121.86671, 37.42896], [-121.86679, 37.42889], [-121.8667, 37.42863], [-121.86709, 37.42853], [-121.867, 37.42827], [-121.86694, 37.42825], [-121.86695, 37.42817], [-121.86677, 37.42764], [-121.86672, 37.42758], [-121.86679, 37.42751], [-121.86669, 37.42724], [-121.86672, 37.42722], [-121.86654, 37.42696], [-121.86649, 37.42693], [-121.86654, 37.42675], [-121.86654, 37.42662], [-121.86652, 37.42643], [-121.86653, 37.42632], [-121.86656, 37.4262], [-121.86664, 37.42605], [-121.86669, 37.42604], [-121.86701, 37.42607], [-121.86727, 37.42605], [-121.86762, 37.42703], [-121.86798, 37.42704], [-121.86794, 37.42709], [-121.86794, 37.42716], [-121.868, 37.42722], [-121.86807, 37.42725], [-121.86809, 37.42751], [-121.86819, 37.42778], [-121.86824, 37.42781], [-121.86823, 37.42784], [-121.86823, 37.42789], [-121.86842, 37.42842], [-121.86847, 37.42849], [-121.86845, 37.42854], [-121.86863, 37.42906], [-121.86868, 37.42908]]]} | Open Access 1 | 15000 | Ben Rogers Park | 16003 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 8.681 | Ben Rogers Park | 1973 | Local Park 2 | 4 | |
4099 | 4099 | 4098 | {"type": "Polygon", "coordinates": [[[-121.71938, 38.54626], [-121.71797, 38.54658], [-121.71751, 38.54664], [-121.71526, 38.54715], [-121.71524, 38.54707], [-121.71633, 38.54682], [-121.71628, 38.5467], [-121.71624, 38.54667], [-121.71627, 38.54659], [-121.71764, 38.54644], [-121.71754, 38.54613], [-121.71761, 38.54612], [-121.71773, 38.54643], [-121.71792, 38.54641], [-121.71932, 38.54609], [-121.71938, 38.54626]]]} | Open Access 1 | 47212 | Benbow Greenbelt | 30918 | 1081 | Davis, City of 171 | City 2 | City Agency 2 | http://parks.cityofdavis.org/ | City 2 | 1081 | Davis, City of 167 | City 2 | City Agency 2 | Yolo 33 | 1.845 | Benbow Greenbelt | 0 | Local Recreation Area 3 | 4 | |
16660 | 16660 | 16659 | {"type": "Polygon", "coordinates": [[[-123.82852, 40.06923], [-123.8284, 40.06931], [-123.82833, 40.06939], [-123.82828, 40.06949], [-123.82826, 40.06959], [-123.82827, 40.07021], [-123.82842, 40.07231], [-123.82843, 40.07264], [-123.8284, 40.07297], [-123.82833, 40.0733], [-123.82808, 40.07413], [-123.82689, 40.07376], [-123.82684, 40.0739], [-123.82676, 40.07407], [-123.82658, 40.07434], [-123.8256, 40.07545], [-123.82526, 40.07581], [-123.82483, 40.07622], [-123.82452, 40.07647], [-123.82412, 40.07673], [-123.82374, 40.06606], [-123.80985, 40.06641], [-123.80979, 40.06534], [-123.80793, 40.06484], [-123.80484, 40.06488], [-123.80483, 40.06482], [-123.80471, 40.06483], [-123.8042, 40.0651], [-123.80364, 40.06525], [-123.80347, 40.06558], [-123.80301, 40.06575], [-123.80266, 40.06613], [-123.80256, 40.06617], [-123.80256, 40.06644], [-123.80024, 40.06774], [-123.80024, 40.0678], [-123.80016, 40.06779], [-123.79981, 40.06784], [-123.7995, 40.06776], [-123.79917, 40.06752], [-123.79772, 40.06758], [-123.79738, 40.06753], [-123.79627, 40.06769], [-123.79588, 40.0676], [-123.79569, 40.06768], [-123.79552, 40.06801], [-123.79547, 40.06804], [-123.79534, 40.0674], [-123.7951, 40.06749], [-123.79484, 40.06755], [-123.79474, 40.06762], [-123.7947, 40.0676], [-123.79468, 40.06756], [-123.79457, 40.06756], [-123.79453, 40.06765], [-123.79448, 40.06771], [-123.79439, 40.06774], [-123.79427, 40.06772], [-123.79413, 40.06777], [-123.79392, 40.06782], [-123.79367, 40.06795], [-123.79372, 40.06816], [-123.79287, 40.06815], [-123.7926, 40.06816], [-123.79233, 40.06823], [-123.79191, 40.06816], [-123.79158, 40.06816], [-123.79115, 40.06823], [-123.79111, 40.06822], [-123.79117, 40.06798], [-123.79118, 40.06779], [-123.79115, 40.0676], [-123.79108, 40.06741], [-123.79098, 40.06723], [-123.79085, 40.06707], [-123.7907, 40.06692], [-123.79042, 40.06673], [-123.7903, 40.06668], [-123.79021, 40.06679], [-123.78984, 40.06661], [-123.78964, 40.06684], [-123.78808, 40.06607], [-123.78779, 40.06582], [-123.7876, 40.0656], [-123.78713, 40.06543], [-123.78523, 40.0648], [-123.78464, 40.06456], [-123.78358, 40.06403], [-123.78338, 40.06392], [-123.7832, 40.06379], [-123.78213, 40.06291], [-123.78185, 40.06274], [-123.78164, 40.06264], [-123.78142, 40.06256], [-123.78119, 40.0625], [-123.78087, 40.06245], [-123.78032, 40.06239], [-123.77935, 40.06218], [-123.77916, 40.06213], [-123.77899, 40.06205], [-123.77875, 40.06191], [-123.77863, 40.06179], [-123.77854, 40.06167], [-123.77837, 40.06134], [-123.77835, 40.06121], [-123.77835, 40.06109], [-123.77838, 40.06096], [-123.77863, 40.06044], [-123.7787, 40.06024], [-123.77874, 40.06006], [-123.77886, 40.05898], [-123.77926, 40.05863], [-123.7813, 40.05827], [-123.78128, 40.05728], [-123.7815, 40.05719], [-123.78192, 40.05699], [-123.78352, 40.05645], [-123.78374, 40.0564], [-123.78396, 40.05637], [-123.78418, 40.05636], [-123.7847, 40.05642], [-123.78558, 40.05629], [-123.78578, 40.05624], [-123.78663, 40.05596], [-123.78729, 40.05583], [-123.78786, 40.05578], [-123.78825, 40.05577], [-123.78947, 40.05585], [-123.79003, 40.05584], [-123.79041, 40.0558], [-123.7918, 40.05562], [-123.79169, 40.05432], [-123.79151, 40.05406], [-123.79142, 40.05389], [-123.79137, 40.05372], [-123.79135, 40.05354], [-123.79137, 40.05336], [-123.79164, 40.05219], [-123.79172, 40.0517], [-123.79141, 40.05007], [-123.79106, 40.04968], [-123.79508, 40.05025], [-123.80534, 40.05096], [-123.80536, 40.05429], [-123.81047, 40.05452], [-123.81046, 40.06236], [-123.81511, 40.06221], [-123.82203, 40.06227], [-123.82216, 40.06203], [-123.82224, 40.06162], [-123.82227, 40.06152], [-123.82239, 40.06132], [-123.82246, 40.06124], [-123.82272, 40.06102], [-123.82291, 40.06089], [-123.82318, 40.06078], [-123.82344, 40.06072], [-123.82362, 40.06223], [-123.8255, 40.06223], [-123.82538, 40.06249], [-123.82526, 40.06297], [-123.82519, 40.06337], [-123.82524, 40.06358], [-123.82541, 40.06413], [-123.82557, 40.06458], [-123.8257, 40.06488], [-123.82606, 40.06571], [-123.82615, 40.06587], [-123.82649, 40.06624], [-123.8272, 40.0669], [-123.82734, 40.06707], [-123.82746, 40.06728], [-123.8276, 40.06762], [-123.82788, 40.06854], [-123.82796, 40.06897], [-123.82789, 40.06923], [-123.82852, 40.06923]]]} | Open Access 1 | 20458 | Benbow State Recreation Area | 30556 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=426 | Humboldt 45 | 1137.787 | Benbow SRA | 1958 | State Recreation Area 39 | 4 |
2573 | 2573 | 2572 | {"type": "Polygon", "coordinates": [[[-122.22395, 40.26271], [-122.2237, 40.26323], [-122.22328, 40.26376], [-122.22186, 40.26304], [-122.22219, 40.26302], [-122.22269, 40.26218], [-122.22395, 40.26271]]]} | Open Access 1 | 17891 | Bend Bridge Public Access | 32046 | 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 | Tehama 18 | 3.867 | Bend Bridge PA | 0 | State Recreation Area 39 | 4 | |
2481 | 2481 | 2480 | {"type": "Polygon", "coordinates": [[[-122.19661, 40.26979], [-122.19658, 40.27249], [-122.19162, 40.27297], [-122.18953, 40.27326], [-122.19087, 40.26973], [-122.19661, 40.26979]]]} | No Public Access 3 | 17478 | Bend Ferry Road | 32047 | 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 | Tehama 18 | 45.388 | Bend Ferry Road | 0 | State Resource Management Area 55 | 3 | |
6201 | 6201 | 6200 | {"type": "Polygon", "coordinates": [[[-119.37383, 36.21451], [-119.37382, 36.21675], [-119.37153, 36.2167], [-119.37157, 36.21455], [-119.37383, 36.21451]]]} | Open Access 1 | 1241 | Bender Park | 16006 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 12.281 | Bender Park | 0 | Local Park 2 | 4 | |
16255 | 16255 | 16254 | {"type": "Polygon", "coordinates": [[[-118.43531, 34.11052], [-118.4348, 34.11052], [-118.43482, 34.11034], [-118.43522, 34.11034], [-118.43531, 34.11052]]]} | Open Access 1 | 46496 | Benedict Canyon Open Space | 16009 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.203 | Benedict Canyon OS | 0 | Local Recreation Area 3 | 4 | |
13135 | 13135 | 13134 | {"type": "Polygon", "coordinates": [[[-122.15956, 38.05035], [-122.15934, 38.05064], [-122.15844, 38.05023], [-122.15866, 38.04993], [-122.15956, 38.05035]]]} | Open Access 1 | 35060 | Benicia Capitol State Historic Park | 1431 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=475 | Solano 26 | 0.863 | Benicia Capitol SHP | 1951 | State Historic or Cultural Area 132 | 4 |
10546 | 10546 | 10545 | {"type": "Polygon", "coordinates": [[[-122.16146, 38.08789], [-122.16142, 38.08812], [-122.16113, 38.08875], [-122.16075, 38.08914], [-122.15994, 38.08931], [-122.15902, 38.08918], [-122.15851, 38.08897], [-122.15817, 38.08892], [-122.15769, 38.08893], [-122.15708, 38.08888], [-122.15659, 38.0884], [-122.1563, 38.08783], [-122.15735, 38.08635], [-122.15778, 38.08578], [-122.15762, 38.08522], [-122.15727, 38.08473], [-122.15865, 38.08398], [-122.15903, 38.08432], [-122.15847, 38.08498], [-122.15814, 38.08529], [-122.15817, 38.08585], [-122.1587, 38.08649], [-122.1594, 38.08674], [-122.1605, 38.08671], [-122.16132, 38.08696], [-122.1611, 38.0872], [-122.16126, 38.08762], [-122.16146, 38.08789]]]} | Open Access 1 | 18760 | Benicia Community Park | 16010 | 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 | 31.661 | Benicia Community Park | 2000 | Local Park 2 | 4 | |
1207 | 1207 | 1206 | {"type": "Polygon", "coordinates": [[[-122.70189, 38.33494], [-122.70176, 38.3354], [-122.70189, 38.33561], [-122.70048, 38.33619], [-122.7005, 38.33624], [-122.69917, 38.33674], [-122.69927, 38.33693], [-122.69936, 38.3369], [-122.69964, 38.33736], [-122.69877, 38.33769], [-122.69843, 38.33712], [-122.69844, 38.33707], [-122.69859, 38.33701], [-122.69875, 38.33689], [-122.69884, 38.3368], [-122.69893, 38.33661], [-122.69894, 38.33646], [-122.69891, 38.33637], [-122.69885, 38.33625], [-122.69866, 38.33595], [-122.70127, 38.33495], [-122.70152, 38.33476], [-122.70176, 38.3349], [-122.70189, 38.33494]]]} | Open Access 1 | 8446 | Benicia Park | 16012 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 8.436 | Benicia Park | 1962 | Local Park 2 | 4 | |
16659 | 16659 | 16658 | {"type": "Polygon", "coordinates": [[[-122.2051, 38.06835], [-122.20509, 38.06835], [-122.20506, 38.06798], [-122.20496, 38.06762], [-122.20478, 38.06728], [-122.20454, 38.06696], [-122.20423, 38.06669], [-122.20256, 38.06554], [-122.20241, 38.06545], [-122.20216, 38.06536], [-122.20222, 38.06523], [-122.20207, 38.06518], [-122.20198, 38.06533], [-122.20173, 38.06532], [-122.20103, 38.06536], [-122.20083, 38.06535], [-122.20063, 38.06532], [-122.20046, 38.06527], [-122.19975, 38.06496], [-122.19949, 38.06491], [-122.19931, 38.06491], [-122.19905, 38.06496], [-122.19881, 38.06507], [-122.19868, 38.06517], [-122.19837, 38.06549], [-122.19826, 38.0653], [-122.1971, 38.06557], [-122.1973, 38.06518], [-122.19636, 38.06487], [-122.19528, 38.06688], [-122.19535, 38.06691], [-122.19642, 38.07069], [-122.19953, 38.07633], [-122.19954, 38.07746], [-122.19953, 38.08275], [-122.1992, 38.08341], [-122.19785, 38.08291], [-122.19761, 38.08264], [-122.19624, 38.08225], [-122.19583, 38.08204], [-122.19532, 38.08174], [-122.19463, 38.08131], [-122.19407, 38.08094], [-122.19331, 38.08036], [-122.19279, 38.07989], [-122.19349, 38.07896], [-122.19365, 38.0788], [-122.19363, 38.07868], [-122.1936, 38.07863], [-122.19351, 38.07852], [-122.19339, 38.07841], [-122.1925, 38.07951], [-122.19245, 38.07959], [-122.19184, 38.07899], [-122.19146, 38.07857], [-122.19122, 38.07827], [-122.19188, 38.07756], [-122.19095, 38.07732], [-122.19073, 38.07723], [-122.19053, 38.07711], [-122.19035, 38.07698], [-122.19019, 38.07683], [-122.18975, 38.07637], [-122.18936, 38.07589], [-122.18926, 38.07587], [-122.1854, 38.07119], [-122.18489, 38.06964], [-122.18486, 38.06961], [-122.1847, 38.0698], [-122.18413, 38.06925], [-122.18359, 38.06866], [-122.18334, 38.06843], [-122.18313, 38.0678], [-122.18328, 38.06813], [-122.18341, 38.06838], [-122.18384, 38.0678], [-122.18561, 38.0686], [-122.1866, 38.06731], [-122.18914, 38.06872], [-122.18993, 38.0674], [-122.19034, 38.06692], [-122.19093, 38.06682], [-122.19118, 38.06644], [-122.19119, 38.06639], [-122.1918, 38.06559], [-122.19194, 38.06466], [-122.19236, 38.06408], [-122.19239, 38.06333], [-122.19228, 38.06204], [-122.19361, 38.06026], [-122.19408, 38.05999], [-122.19424, 38.05993], [-122.1944, 38.05996], [-122.19486, 38.06042], [-122.19502, 38.06052], [-122.19516, 38.06059], [-122.19551, 38.0607], [-122.19587, 38.06077], [-122.19609, 38.06067], [-122.19627, 38.06056], [-122.19657, 38.06057], [-122.19692, 38.06052], [-122.19723, 38.06058], [-122.19755, 38.06079], [-122.19789, 38.06093], [-122.19823, 38.06091], [-122.1984, 38.06079], [-122.19852, 38.06084], [-122.19895, 38.0609], [-122.19947, 38.06108], [-122.19975, 38.06107], [-122.19986, 38.0611], [-122.20001, 38.06125], [-122.20032, 38.06145], [-122.20055, 38.06153], [-122.20071, 38.0619], [-122.20079, 38.06191], [-122.20082, 38.06201], [-122.20099, 38.06221], [-122.20105, 38.06235], [-122.20116, 38.06247], [-122.20123, 38.06259], [-122.20113, 38.0628], [-122.20116, 38.063], [-122.2012, 38.0631], [-122.20118, 38.06333], [-122.20122, 38.06344], [-122.20118, 38.06396], [-122.20118, 38.06409], [-122.20116, 38.06421], [-122.20107, 38.06429], [-122.20107, 38.0644], [-122.20135, 38.06461], [-122.20164, 38.0646], [-122.20192, 38.0645], [-122.20212, 38.06427], [-122.20224, 38.06426], [-122.20238, 38.06432], [-122.20259, 38.06429], [-122.20282, 38.06419], [-122.20308, 38.0639], [-122.20319, 38.0639], [-122.20324, 38.06403], [-122.20328, 38.06484], [-122.20318, 38.06503], [-122.20328, 38.06524], [-122.20342, 38.06537], [-122.20372, 38.06547], [-122.20407, 38.06569], [-122.2041, 38.06609], [-122.20468, 38.0666], [-122.20487, 38.06665], [-122.20499, 38.06686], [-122.2051, 38.06699], [-122.2051, 38.06835]]]} | Open Access 1 | 18815 | Benicia State Recreation Area | 1433 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=476 | Solano 26 | 456.027 | Benicia SRA | 1957 | State Recreation Area 39 | 4 |
13647 | 13647 | 13646 | {"type": "Polygon", "coordinates": [[[-122.15828, 38.05398], [-122.15776, 38.05473], [-122.1558, 38.05383], [-122.1562, 38.05302], [-122.15828, 38.05398]]]} | Open Access 1 | 36331 | Benicia holding 1 | 16011 | 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 | 4.824 | Benicia holding 1 | 0 | Local Other or Unknown 14 | 4 | |
3961 | 3961 | 3960 | {"type": "Polygon", "coordinates": [[[-118.20423, 33.99242], [-118.20344, 33.99243], [-118.20343, 33.99226], [-118.20423, 33.99225], [-118.20423, 33.99242]]]} | Open Access 1 | 46467 | Benito Juarez Park | 29739 | 1200 | Maywood, City of 260 | City 2 | City Agency 2 | http://www.cityofmaywood.com/index.php?option=com_content&view=article&id=162&Itemid=69 | City 2 | 1200 | Maywood, City of 256 | City 2 | City Agency 2 | Los Angeles 6 | 0.339 | Benito Juarez Park | 0 | Local Park 2 | 4 | |
3470 | 3470 | 3469 | {"type": "Polygon", "coordinates": [[[-120.50555, 37.29161], [-120.50555, 37.29165], [-120.50529, 37.29156], [-120.50523, 37.29164], [-120.50399, 37.29119], [-120.50379, 37.29152], [-120.50367, 37.29147], [-120.50412, 37.29068], [-120.50444, 37.29079], [-120.50425, 37.29113], [-120.50468, 37.29129], [-120.50468, 37.29131], [-120.5049, 37.29138], [-120.50492, 37.29138], [-120.50555, 37.29161]]]} | Open Access 1 | 25454 | Benjamin Banneker Memorial Park | 16013 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.968 | Benjamin Banneker Memorial Park | 0 | Local Park 2 | 4 | |
13174 | 13174 | 13173 | {"type": "MultiPolygon", "coordinates": [[[[-121.56754, 38.78412], [-121.56281, 38.78417], [-121.56279, 38.78305], [-121.559, 38.78306], [-121.55896, 38.78247], [-121.55883, 38.78192], [-121.55796, 38.77936], [-121.56749, 38.77925], [-121.56754, 38.78412]]], [[[-121.57688, 38.7791], [-121.57685, 38.78379], [-121.57658, 38.7838], [-121.57635, 38.78385], [-121.57612, 38.78398], [-121.57591, 38.78415], [-121.57575, 38.78438], [-121.57562, 38.78465], [-121.5756, 38.78501], [-121.57605, 38.78658], [-121.57227, 38.7866], [-121.57225, 38.78407], [-121.56773, 38.78412], [-121.56767, 38.77925], [-121.57688, 38.7791]]]]} | No Public Access 3 | 35158 | Bennett North | 16014 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 220.308 | Bennett North | None 1145 | |||
12715 | 12715 | 12714 | {"type": "Polygon", "coordinates": [[[-121.58089, 38.76428], [-121.58083, 38.77153], [-121.58085, 38.77515], [-121.58084, 38.7788], [-121.57707, 38.77889], [-121.57707, 38.77795], [-121.57912, 38.77792], [-121.57912, 38.77662], [-121.57911, 38.77661], [-121.57706, 38.77662], [-121.57704, 38.76432], [-121.58089, 38.76428]]]} | No Public Access 3 | 29729 | Bennett South | 16015 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 125.162 | Bennett South | None 1111 | |||
10343 | 10343 | 10342 | {"type": "Polygon", "coordinates": [[[-122.66467, 38.42516], [-122.66241, 38.42639], [-122.66227, 38.4263], [-122.66226, 38.42719], [-122.65949, 38.42718], [-122.65908, 38.42721], [-122.65845, 38.42668], [-122.65832, 38.42654], [-122.65644, 38.4244], [-122.65601, 38.42344], [-122.65578, 38.42204], [-122.65565, 38.42202], [-122.65546, 38.42204], [-122.65549, 38.4217], [-122.65548, 38.42103], [-122.65551, 38.41987], [-122.65565, 38.41987], [-122.65588, 38.4191], [-122.65722, 38.41788], [-122.65756, 38.41741], [-122.6573, 38.4169], [-122.65799, 38.41691], [-122.6584, 38.41785], [-122.65968, 38.41786], [-122.65969, 38.41989], [-122.66115, 38.4199], [-122.66231, 38.41954], [-122.66239, 38.41954], [-122.66292, 38.41936], [-122.66368, 38.41889], [-122.66412, 38.4193], [-122.6643, 38.41953], [-122.66441, 38.4197], [-122.66452, 38.41991], [-122.66463, 38.42017], [-122.66468, 38.42039], [-122.66472, 38.42062], [-122.66473, 38.42089], [-122.66471, 38.42112], [-122.6646, 38.42152], [-122.66438, 38.42201], [-122.66428, 38.42228], [-122.66368, 38.42219], [-122.66363, 38.42242], [-122.6636, 38.42265], [-122.66358, 38.42288], [-122.6636, 38.42317], [-122.66364, 38.42345], [-122.66372, 38.42373], [-122.66392, 38.42421], [-122.66406, 38.42445], [-122.66427, 38.42473], [-122.66467, 38.42516]]]} | Restricted Access 2 | 29799 | Bennett Valley Municipal Golf Course | 33093 | 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 | 150.922 | Bennett Valley Municipal GC | 0 | Local Recreation Area 3 | 4 | |
1589 | 1589 | 1588 | {"type": "MultiPolygon", "coordinates": [[[[-118.31877, 34.03539], [-118.31816, 34.03539], [-118.31816, 34.03498], [-118.31877, 34.03497], [-118.31877, 34.03539]]], [[[-118.31995, 34.03511], [-118.31898, 34.03511], [-118.31897, 34.03445], [-118.31994, 34.03445], [-118.31995, 34.03511]]]]} | Open Access 1 | 12149 | Benny H. Potter West Adams Avenues Memorial Park | 16017 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 2.259 | Benny H. Potter West Adams Avenues Memorial 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]);