units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 178
- San Diego, City of 175
- Los Angeles, City of 133
- Ventura, City of 117
- East Bay Regional Park District 86
- Roseville, City of 86
- California Department of Parks and Recreation 79
- California Department of Fish and Wildlife 74
- Los Angeles, County of 68
- Long Beach, City of 68
- Valley-Wide Recreation and Park District 63
- Butte, County of 53
- San Jose, City of 52
- Irvine, City of 51
- Poway, City of 50
- Yuba County Water Agency 48
- Consumnes Community Services District 47
- California State Lands Commission 45
- Lake, County of 45
- San Diego, County of 44
- Rocklin, City of 44
- Napa, City of 43
- El Dorado, County of 41
- Brentwood, City of 40
- Santa Barbara, County of 39
- San Ramon, City of 39
- Torrance, City of 39
- United States Bureau of Land Management 37
- Orange, County of 34
- Sunrise Recreation and Park District 34
- …
DES_TP >30
- Local Park 2,698
- Local Other or Unknown 1,001
- Local Recreation Area 692
- Private Conservation 370
- Local Conservation Area 187
- Private Recreation or Education 176
- State Conservation Area 68
- State Resource Management Area 60
- State Other or Unknown 54
- Private Other or Unknown 45
- State Recreation Area 41
- State Park 33
- National Wildlife Refuge 24
- National Public Lands 19
- Local Historic or Cultural Area 18
- Local Resource Management Area 18
- National Monument or Landmark 16
- Recreation Management Area 15
- State Historic or Cultural Area 11
- Private Agricultural 10
- National Recreation Area 8
- Federal Other or Unknown 8
- Resource Management Area 6
- Area of Critical Environmental Concern 4
- National Forest 2
- Conservation Area 2
- Wilderness Area 2
- Historic or Cultural Area 2
- National Park 1
- None 1
- …
MNG_AG_TYP 29
- City Agency 3,405
- County Agency 502
- Recreation/Parks District 473
- Non Profit - Land Trust 349
- State Agency 322
- Open Space District 215
- Home Owners Association 154
- Federal Agency 120
- Water District 120
- Community Services District 103
- Non Profit - Conservation 94
- County Agency - Parks 83
- Flood District 59
- School District 33
- Non Profit - Other 29
- Port/Harbor District 13
- Commercial 12
- County Agency - Other 10
- Joint Powers Authority 9
- Irrigation District 5
- Other 5
- Transportation Agency 5
- Cemetery District 4
- Special District - Other 4
- Mitigation Bank 4
- Conservation District 4
- Metropolitan Planning Organization 2
- Home Owners Associatin 1
- Non Profit - Education 1
ACCESS_TYP 4
- Open Access 4,696
- Restricted Access 683
- No Public Access 488
- Unknown Access 273
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5561 | 5561 | 5560 | {"type": "Polygon", "coordinates": [[[-117.17221, 32.6999], [-117.17211, 32.7001], [-117.17102, 32.6997], [-117.17097, 32.69967], [-117.17083, 32.69942], [-117.17076, 32.69937], [-117.17067, 32.69933], [-117.17052, 32.69934], [-117.17043, 32.69931], [-117.17024, 32.69922], [-117.17006, 32.6991], [-117.16996, 32.69911], [-117.1698, 32.69915], [-117.16962, 32.69918], [-117.16901, 32.69889], [-117.16914, 32.69885], [-117.16904, 32.69858], [-117.1698, 32.69838], [-117.17003, 32.69899], [-117.17025, 32.69908], [-117.17031, 32.69907], [-117.17053, 32.69915], [-117.17075, 32.69909], [-117.17086, 32.69913], [-117.17107, 32.69962], [-117.17145, 32.69978], [-117.17154, 32.69964], [-117.17221, 32.6999]]]} | Open Access 1 | 26054 | Coronado Landing Park | 17647 | 2133 | San Diego Unified Port District 186 | Special District 4 | Port/Harbor District 15 | http://www.portofsandiego.org/ | Special District 4 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.portofsandiego.org/coronado-landing-park.html | San Diego 4 | 2.44 | Coronado Landing Park | 0 | Local Park 2 | 4 |
3170 | 3170 | 3169 | {"type": "Polygon", "coordinates": [[[-117.10708, 32.66324], [-117.10647, 32.66342], [-117.10689, 32.66448], [-117.1065, 32.66459], [-117.10666, 32.665], [-117.10616, 32.66513], [-117.1063, 32.66549], [-117.10541, 32.66574], [-117.10527, 32.66536], [-117.10579, 32.66424], [-117.1063, 32.663], [-117.10681, 32.66258], [-117.10708, 32.66324]]]} | Open Access 1 | 26055 | Paradise Creek Educational Park | 31842 | 1219 | National City, City of 51 | City 2 | City Agency 2 | http://www.ci.national-city.ca.us/index.aspx?page=152 | City 2 | 1219 | National City, City of 49 | City 2 | City Agency 2 | http://www.nationalcityca.gov/government/community-services/facilities | San Diego 4 | 6.137 | Paradise Creek Educational Park | 0 | Local Park 2 | 4 |
3171 | 3171 | 3170 | {"type": "Polygon", "coordinates": [[[-117.07154, 32.66675], [-117.07129, 32.66682], [-117.07133, 32.66693], [-117.07096, 32.66703], [-117.07084, 32.66671], [-117.07146, 32.66654], [-117.07154, 32.66675]]]} | Open Access 1 | 26057 | Lincoln Acres Park | 21245 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 319 | San Diego, County of 101 | County 3 | County Agency 3 | http://www.sdparks.org/content/sdparks/en/park-pages/LincolnAcres.html | San Diego 4 | 0.484 | Lincoln Acres Park | 0 | Local Park 2 | 4 |
15937 | 15937 | 15936 | {"type": "MultiPolygon", "coordinates": [[[[-121.99642, 37.20062], [-121.9961, 37.20064], [-121.99603, 37.20069], [-121.9957, 37.20034], [-121.99607, 37.20027], [-121.99642, 37.20062]]], [[[-122.00833, 37.20275], [-122.004, 37.20269], [-122.004, 37.203], [-122.00303, 37.20339], [-122.00278, 37.20334], [-122.00269, 37.20316], [-122.0026, 37.20287], [-122.0024, 37.20267], [-122.00214, 37.20249], [-122.00197, 37.20223], [-122.00149, 37.2019], [-122.00117, 37.20202], [-122.00085, 37.20232], [-122.00073, 37.20239], [-122.00008, 37.2022], [-121.99943, 37.20178], [-121.99922, 37.20166], [-121.99916, 37.20145], [-121.99924, 37.20129], [-121.99981, 37.20106], [-121.99981, 37.20098], [-121.99968, 37.20096], [-121.99936, 37.20109], [-121.99923, 37.20108], [-121.99923, 37.2011], [-121.99938, 37.20114], [-121.99975, 37.20099], [-121.99974, 37.20103], [-121.99918, 37.20125], [-121.99908, 37.20145], [-121.99911, 37.20152], [-121.99828, 37.20145], [-121.99822, 37.20136], [-121.99819, 37.20122], [-121.99837, 37.20105], [-121.99849, 37.20081], [-121.9986, 37.20081], [-121.99878, 37.20097], [-121.99904, 37.20104], [-121.99903, 37.20102], [-121.99882, 37.20093], [-121.99863, 37.20075], [-121.99842, 37.20076], [-121.99836, 37.20099], [-121.99812, 37.2012], [-121.99815, 37.20137], [-121.99819, 37.20144], [-121.99778, 37.2014], [-121.99773, 37.20137], [-121.99761, 37.2012], [-121.99739, 37.20106], [-121.99713, 37.20098], [-121.99704, 37.201], [-121.99704, 37.20071], [-121.99725, 37.20063], [-121.99727, 37.20053], [-121.9968, 37.20032], [-121.99639, 37.20001], [-121.99625, 37.19949], [-121.99634, 37.19949], [-121.9964, 37.19987], [-121.99646, 37.19997], [-121.99655, 37.20004], [-121.99736, 37.2004], [-121.99747, 37.20056], [-121.99765, 37.20059], [-121.99816, 37.20046], [-121.99816, 37.20016], [-121.99827, 37.2002], [-121.99829, 37.20019], [-121.99828, 37.19951], [-122.00391, 37.19945], [-122.00393, 37.20056], [-122.00408, 37.20061], [-122.00445, 37.20089], [-122.00478, 37.20065], [-122.00501, 37.20057], [-122.00529, 37.20053], [-122.00542, 37.20049], [-122.00569, 37.20046], [-122.00593, 37.20031], [-122.00598, 37.2003], [-122.00603, 37.20031], [-122.00609, 37.20037], [-122.00607, 37.20044], [-122.00571, 37.20073], [-122.00558, 37.20074], [-122.00555, 37.20094], [-122.00616, 37.20082], [-122.00623, 37.20082], [-122.00654, 37.20099], [-122.0066, 37.20104], [-122.00677, 37.20128], [-122.00679, 37.20135], [-122.00678, 37.20144], [-122.00647, 37.20184], [-122.00663, 37.20197], [-122.00722, 37.20194], [-122.0074, 37.202], [-122.00752, 37.20214], [-122.00773, 37.20226], [-122.00786, 37.20238], [-122.00807, 37.20266], [-122.00833, 37.20275]]], [[[-121.99759, 37.20139], [-121.99675, 37.2013], [-121.99678, 37.20115], [-121.99712, 37.2011], [-121.99732, 37.20116], [-121.99751, 37.20127], [-121.99759, 37.20139]]], [[[-122.01727, 37.18803], [-122.01727, 37.18839], [-122.01651, 37.1884], [-122.01649, 37.18777], [-122.01664, 37.18779], [-122.01717, 37.18797], [-122.01727, 37.18803]]]]} | No Public Access 3 | 26058 | El Sereno Open Space Preserve | 31504 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_el_sereno.asp | Santa Clara 19 | 58.338 | El Sereno OSP | 2000 | Local Conservation Area 4 | 2 |
15926 | 15926 | 15925 | {"type": "MultiPolygon", "coordinates": [[[[-122.41419, 37.46278], [-122.41421, 37.46862], [-122.41414, 37.47512], [-122.41413, 37.47522], [-122.414, 37.47527], [-122.41401, 37.4756], [-122.41372, 37.47587], [-122.41362, 37.47586], [-122.41351, 37.47591], [-122.41342, 37.47591], [-122.41323, 37.47601], [-122.41266, 37.47621], [-122.41223, 37.47631], [-122.41183, 37.47652], [-122.41123, 37.47658], [-122.41113, 37.47681], [-122.41103, 37.47697], [-122.41098, 37.477], [-122.41091, 37.47712], [-122.41042, 37.47707], [-122.40995, 37.47728], [-122.40987, 37.47741], [-122.40971, 37.47748], [-122.40942, 37.47748], [-122.40924, 37.47742], [-122.40883, 37.47751], [-122.40866, 37.47768], [-122.40854, 37.47772], [-122.40829, 37.47772], [-122.40821, 37.47762], [-122.40808, 37.47756], [-122.40787, 37.47734], [-122.40767, 37.47725], [-122.40751, 37.47726], [-122.40728, 37.47733], [-122.40699, 37.47769], [-122.40686, 37.47796], [-122.40677, 37.4781], [-122.40663, 37.4782], [-122.40652, 37.47825], [-122.40536, 37.47805], [-122.40522, 37.47825], [-122.40562, 37.4793], [-122.40556, 37.47931], [-122.40515, 37.47828], [-122.40493, 37.47819], [-122.40448, 37.47884], [-122.40421, 37.47906], [-122.40061, 37.48061], [-122.4007, 37.47307], [-122.39635, 37.47298], [-122.3963, 37.46907], [-122.38706, 37.46904], [-122.38704, 37.47252], [-122.36958, 37.47246], [-122.36957, 37.47244], [-122.36919, 37.47246], [-122.36918, 37.47242], [-122.35679, 37.47249], [-122.35661, 37.47221], [-122.3563, 37.47141], [-122.35785, 37.47071], [-122.35738, 37.46988], [-122.35574, 37.47062], [-122.35486, 37.46992], [-122.35467, 37.46986], [-122.35145, 37.4674], [-122.35152, 37.46659], [-122.35151, 37.46509], [-122.35599, 37.46518], [-122.356, 37.46157], [-122.36904, 37.46174], [-122.36902, 37.46595], [-122.36903, 37.46596], [-122.38706, 37.46593], [-122.38709, 37.46223], [-122.39618, 37.46228], [-122.39615, 37.45869], [-122.39987, 37.45872], [-122.39987, 37.46233], [-122.40412, 37.46239], [-122.40925, 37.4625], [-122.41125, 37.46312], [-122.41145, 37.46315], [-122.41419, 37.46278]]], [[[-122.38707, 37.48329], [-122.38706, 37.49047], [-122.37846, 37.49056], [-122.37836, 37.48332], [-122.38707, 37.48329]]]]} | No Public Access 3 | 26059 | Miramontes Ridge Open Space Preserve | 30750 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | San Mateo 15 | 1618.377 | Miramontes Ridge OSP | 2000 | Local Conservation Area 4 | 2 | |
12352 | 12352 | 12351 | {"type": "MultiPolygon", "coordinates": [[[[-121.89775, 37.33349], [-121.8975, 37.33361], [-121.8974, 37.33308], [-121.89744, 37.33307], [-121.89775, 37.33349]]], [[[-121.89812, 37.33398], [-121.89762, 37.33422], [-121.89752, 37.33373], [-121.89783, 37.33359], [-121.89812, 37.33398]]], [[[-121.90026, 37.3341], [-121.89891, 37.33473], [-121.89762, 37.33298], [-121.89903, 37.33231], [-121.89928, 37.33223], [-121.90012, 37.33219], [-121.90026, 37.3341]]], [[[-121.89873, 37.33481], [-121.89853, 37.33491], [-121.89838, 37.33472], [-121.89818, 37.33481], [-121.89813, 37.33476], [-121.89775, 37.33492], [-121.89764, 37.33433], [-121.89819, 37.33408], [-121.89873, 37.33481]]]]} | Restricted Access 2 | 26060 | Arena Green | 15579 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2143 | Santa Clara Valley Water District 798 | Special District 4 | Water District 13 | Santa Clara 19 | 12.575 | Arena Green | 0 | Local Park 2 | 4 | |
12358 | 12358 | 12357 | {"type": "MultiPolygon", "coordinates": [[[[-121.84261, 37.39116], [-121.83906, 37.39173], [-121.8399, 37.39348], [-121.83764, 37.39413], [-121.83749, 37.39381], [-121.83634, 37.39411], [-121.83603, 37.39345], [-121.83535, 37.39365], [-121.83514, 37.39351], [-121.83479, 37.39284], [-121.8337, 37.3931], [-121.83358, 37.39299], [-121.83348, 37.39314], [-121.83263, 37.39373], [-121.83233, 37.3939], [-121.83214, 37.39398], [-121.8281, 37.39532], [-121.82797, 37.3957], [-121.82734, 37.39585], [-121.82685, 37.39587], [-121.82686, 37.39615], [-121.82657, 37.39644], [-121.82651, 37.39643], [-121.82639, 37.39655], [-121.82559, 37.39517], [-121.82544, 37.3951], [-121.82551, 37.39493], [-121.82557, 37.39484], [-121.82568, 37.39476], [-121.82588, 37.39468], [-121.82608, 37.39465], [-121.82667, 37.39478], [-121.8274, 37.39505], [-121.82806, 37.39512], [-121.82842, 37.39499], [-121.82857, 37.39487], [-121.8294, 37.39408], [-121.82951, 37.39402], [-121.83052, 37.39357], [-121.83173, 37.39376], [-121.83224, 37.39365], [-121.83249, 37.39357], [-121.83269, 37.39339], [-121.83297, 37.39307], [-121.83327, 37.39283], [-121.83361, 37.3927], [-121.8347, 37.3924], [-121.83525, 37.392], [-121.83651, 37.39168], [-121.8373, 37.39157], [-121.83838, 37.39145], [-121.83978, 37.39108], [-121.84077, 37.39065], [-121.84249, 37.3909], [-121.84261, 37.39116]]], [[[-121.85015, 37.3894], [-121.84318, 37.39074], [-121.84314, 37.39087], [-121.84315, 37.39088], [-121.8461, 37.39031], [-121.84647, 37.39083], [-121.84326, 37.39189], [-121.84258, 37.39055], [-121.84259, 37.39049], [-121.84262, 37.39045], [-121.84295, 37.39028], [-121.84316, 37.39012], [-121.84333, 37.39004], [-121.8438, 37.38991], [-121.84439, 37.38981], [-121.84481, 37.38972], [-121.84507, 37.38962], [-121.84617, 37.38915], [-121.8462, 37.38915], [-121.84623, 37.38919], [-121.84731, 37.38887], [-121.84738, 37.38895], [-121.84895, 37.38884], [-121.84896, 37.38883], [-121.84892, 37.38877], [-121.849, 37.38872], [-121.84936, 37.3887], [-121.84959, 37.38864], [-121.85015, 37.3894]]], [[[-121.85173, 37.39157], [-121.85015, 37.39234], [-121.84982, 37.39254], [-121.84831, 37.39325], [-121.84618, 37.3903], [-121.84925, 37.38971], [-121.84935, 37.39009], [-121.84947, 37.39038], [-121.84955, 37.39054], [-121.84975, 37.39083], [-121.85002, 37.39132], [-121.85054, 37.39119], [-121.85122, 37.39088], [-121.85173, 37.39157]]], [[[-121.85562, 37.38231], [-121.85637, 37.38296], [-121.8564, 37.38301], [-121.85638, 37.38306], [-121.85412, 37.38465], [-121.854, 37.38475], [-121.85397, 37.38489], [-121.85326, 37.38521], [-121.85323, 37.38518], [-121.853, 37.38533], [-121.85277, 37.3856], [-121.8527, 37.38569], [-121.85248, 37.38617], [-121.8524, 37.38627], [-121.85226, 37.38638], [-121.85171, 37.38635], [-121.85151, 37.38647], [-121.85025, 37.38465], [-121.85053, 37.38453], [-121.85054, 37.38443], [-121.8507, 37.38439], [-121.85126, 37.38416], [-121.85131, 37.38412], [-121.85134, 37.38407], [-121.85134, 37.38401], [-121.85115, 37.38372], [-121.85117, 37.38369], [-121.85102, 37.38347], [-121.85101, 37.38342], [-121.85196, 37.38279], [-121.852, 37.38275], [-121.85203, 37.38267], [-121.8522, 37.3827], [-121.85188, 37.38292], [-121.85302, 37.38403], [-121.85382, 37.38486], [-121.85406, 37.38454], [-121.85425, 37.38376], [-121.85477, 37.38309], [-121.85562, 37.38231]]], [[[-121.85848, 37.38104], [-121.85638, 37.38252], [-121.85608, 37.38226], [-121.8567, 37.38173], [-121.85848, 37.38104]]], [[[-121.86152, 37.37246], [-121.86152, 37.37246], [-121.86128, 37.37648], [-121.85963, 37.37483], [-121.85908, 37.37422], [-121.85905, 37.37411], [-121.85907, 37.37405], [-121.85909, 37.37402], [-121.86147, 37.37241], [-121.86152, 37.37246]]], [[[-121.8694, 37.37001], [-121.8693, 37.37008], [-121.8692, 37.37008], [-121.86908, 37.37003], [-121.86895, 37.36995], [-121.86876, 37.36991], [-121.86851, 37.36982], [-121.8694, 37.37001]]]]} | Open Access 1 | 26061 | Penitencia Creek Park | 23582 | 326 | Santa Clara County Parks and Recreation Dept., County of 472 | County 3 | County Agency - Parks 7 | http://www.sccgov.org/sites/parks/Pages/Welcome-to-Santa-Clara-County-Parks.aspx | County 3 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 123.727 | Penitencia Creek Park | 1872 | Local Park 2 | 4 | |
12366 | 12366 | 12365 | {"type": "MultiPolygon", "coordinates": [[[[-121.85024, 37.38952], [-121.84925, 37.38971], [-121.84314, 37.39088], [-121.84318, 37.39074], [-121.85015, 37.3894], [-121.85024, 37.38952]]], [[[-121.849, 37.38872], [-121.84893, 37.38877], [-121.84897, 37.38884], [-121.84737, 37.38895], [-121.8473, 37.38887], [-121.84623, 37.38919], [-121.8462, 37.38915], [-121.847, 37.38884], [-121.84745, 37.38873], [-121.84784, 37.38869], [-121.84857, 37.38873], [-121.849, 37.38872]]], [[[-121.84942, 37.3875], [-121.8495, 37.38752], [-121.84953, 37.38759], [-121.84953, 37.38769], [-121.8495, 37.38778], [-121.84928, 37.38818], [-121.84922, 37.38848], [-121.84897, 37.38856], [-121.84868, 37.38858], [-121.84862, 37.38858], [-121.84859, 37.38856], [-121.84858, 37.38853], [-121.84862, 37.38848], [-121.84864, 37.38844], [-121.84863, 37.3884], [-121.84859, 37.38835], [-121.8486, 37.38826], [-121.84865, 37.38811], [-121.84876, 37.38795], [-121.84886, 37.38784], [-121.84898, 37.38775], [-121.84942, 37.3875]]], [[[-121.85151, 37.38647], [-121.8512, 37.38685], [-121.85081, 37.38712], [-121.85023, 37.38779], [-121.85011, 37.38763], [-121.84988, 37.38782], [-121.84988, 37.38784], [-121.85007, 37.38797], [-121.85006, 37.38798], [-121.84944, 37.38838], [-121.84943, 37.3883], [-121.84945, 37.38821], [-121.84964, 37.38787], [-121.8497, 37.38771], [-121.8497, 37.3876], [-121.84968, 37.38751], [-121.84962, 37.3874], [-121.84965, 37.38734], [-121.84963, 37.38732], [-121.84986, 37.38716], [-121.85123, 37.38607], [-121.85151, 37.38647]]], [[[-121.85914, 37.38164], [-121.85847, 37.38104], [-121.8567, 37.38173], [-121.85602, 37.38231], [-121.85588, 37.38217], [-121.85594, 37.3821], [-121.85582, 37.38199], [-121.85602, 37.38185], [-121.85629, 37.38155], [-121.85716, 37.38084], [-121.85739, 37.38069], [-121.85741, 37.38023], [-121.85771, 37.38002], [-121.85791, 37.38022], [-121.85855, 37.38093], [-121.85914, 37.38164]]], [[[-121.86118, 37.37735], [-121.86087, 37.37798], [-121.86079, 37.37825], [-121.8603, 37.37901], [-121.86009, 37.3791], [-121.86029, 37.37934], [-121.85926, 37.38006], [-121.85875, 37.37954], [-121.85873, 37.3795], [-121.8589, 37.37942], [-121.85891, 37.3794], [-121.85856, 37.37933], [-121.85953, 37.37905], [-121.85997, 37.37879], [-121.86029, 37.37845], [-121.86039, 37.3783], [-121.86075, 37.37722], [-121.86082, 37.37676], [-121.86085, 37.37671], [-121.86091, 37.37667], [-121.86097, 37.37666], [-121.86101, 37.37667], [-121.86117, 37.37684], [-121.8611, 37.37703], [-121.86118, 37.37735]]], [[[-121.86471, 37.37031], [-121.86175, 37.3723], [-121.86171, 37.37224], [-121.86323, 37.3712], [-121.8645, 37.37036], [-121.86471, 37.37031]]], [[[-121.86796, 37.36965], [-121.8679, 37.36974], [-121.86781, 37.3697], [-121.86615, 37.36954], [-121.86606, 37.3695], [-121.86599, 37.36949], [-121.86589, 37.36949], [-121.86575, 37.36952], [-121.86589, 37.36933], [-121.86603, 37.36942], [-121.86625, 37.36947], [-121.86796, 37.36965]]], [[[-121.87178, 37.37067], [-121.87149, 37.37068], [-121.87129, 37.37065], [-121.87106, 37.37058], [-121.87087, 37.37048], [-121.87041, 37.37061], [-121.86986, 37.37067], [-121.87064, 37.37051], [-121.87095, 37.37043], [-121.87117, 37.37057], [-121.8717, 37.37057], [-121.87178, 37.37067]]], [[[-121.87108, 37.36983], [-121.87029, 37.37016], [-121.87003, 37.36983], [-121.87015, 37.36984], [-121.87026, 37.36988], [-121.87092, 37.3696], [-121.87108, 37.36983]]]]} | Open Access 1 | 26062 | Penitencia Creek Park | 23582 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 326 | Santa Clara County Parks and Recreation Dept., County of 465 | County 3 | County Agency - Parks 7 | Santa Clara 19 | 19.403 | Penitencia Creek Park | 1872 | Local Park 2 | 4 | |
12367 | 12367 | 12366 | {"type": "Polygon", "coordinates": [[[-122.95526, 38.63545], [-122.95523, 38.63778], [-122.95525, 38.64238], [-122.94602, 38.64273], [-122.9416, 38.64274], [-122.93779, 38.64261], [-122.93244, 38.64257], [-122.93265, 38.63515], [-122.9465, 38.63525], [-122.95526, 38.63545]]]} | Restricted Access 2 | 26069 | Riddell Preserve | 24346 | 3117 | LandPaths 206 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landpaths.org/ | Non Governmental Organization 10 | 3117 | LandPaths 202 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 399.164 | Riddell Preserve | 0 | Private Conservation 16 | 2 | |
12368 | 12368 | 12367 | {"type": "Polygon", "coordinates": [[[-122.81825, 38.40854], [-122.81815, 38.40879], [-122.81802, 38.40903], [-122.81771, 38.40944], [-122.81761, 38.40955], [-122.81723, 38.40989], [-122.81689, 38.41011], [-122.81676, 38.41022], [-122.81642, 38.41022], [-122.8171, 38.40934], [-122.81709, 38.40932], [-122.81257, 38.40934], [-122.81258, 38.40564], [-122.81277, 38.40543], [-122.81323, 38.40525], [-122.81293, 38.4047], [-122.81573, 38.4037], [-122.81636, 38.40354], [-122.81639, 38.40358], [-122.81665, 38.40373], [-122.8168, 38.40416], [-122.81718, 38.40598], [-122.81793, 38.40805], [-122.81792, 38.40819], [-122.81763, 38.40819], [-122.81772, 38.40847], [-122.81769, 38.40854], [-122.81825, 38.40854]]]} | Open Access 1 | 26070 | Laguna de Santa Rosa Wetlands Preserve | 20853 | 1331 | Sebastopol, City of 605 | City 2 | City Agency 2 | http://ci.sebastopol.ca.us/page/city-parks | City 2 | 1331 | Sebastopol, City of 594 | City 2 | City Agency 2 | Sonoma 16 | 61.2 | Laguna de Santa Rosa Wetlands Preserve | 0 | Local Conservation Area 4 | 2 | |
12369 | 12369 | 12368 | {"type": "Polygon", "coordinates": [[[-122.8295, 38.42575], [-122.82842, 38.4255], [-122.82654, 38.42518], [-122.82585, 38.42504], [-122.82581, 38.4245], [-122.82568, 38.4232], [-122.82723, 38.42319], [-122.82787, 38.42348], [-122.82792, 38.42344], [-122.82827, 38.42365], [-122.82852, 38.42382], [-122.82874, 38.42402], [-122.82893, 38.42424], [-122.82918, 38.42458], [-122.82935, 38.42495], [-122.82946, 38.42528], [-122.82949, 38.42548], [-122.8295, 38.42575]]]} | No Public Access 3 | 26071 | Occidental Road Wetlands | 31262 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 15.729 | Occidental Road Wetlands | 2008 | Local Conservation Area 4 | 2 | |
3508 | 3508 | 3507 | {"type": "Polygon", "coordinates": [[[-123.14011, 38.61069], [-123.13538, 38.61068], [-123.13529, 38.6071], [-123.14003, 38.60711], [-123.14011, 38.61069]]]} | Restricted Access 2 | 26072 | Cedars Gateway | 30373 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 40.534 | Cedars Gateway | 0 | Private Conservation 16 | 2 | |
12370 | 12370 | 12369 | {"type": "MultiPolygon", "coordinates": [[[[-122.99606, 38.50153], [-122.99573, 38.50173], [-122.99551, 38.50189], [-122.99444, 38.50252], [-122.99426, 38.50269], [-122.99358, 38.50215], [-122.99512, 38.50083], [-122.99561, 38.50114], [-122.99561, 38.50132], [-122.99606, 38.50153]]], [[[-122.99562, 38.5004], [-122.99561, 38.50099], [-122.99561, 38.50099], [-122.99523, 38.50073], [-122.99562, 38.5004]]]]} | No Public Access 3 | 26073 | Riverkeeper Park | 24442 | 3132 | Russian Riverkeeper 1021 | Non Profit 6 | Non Profit - Conservation 12 | http://www.russianriverkeeper.org/ | Non Governmental Organization 10 | 3132 | Russian Riverkeeper 983 | Non Profit 6 | Non Profit - Conservation 12 | Sonoma 16 | 5.046 | Riverkeeper Park | 0 | Private Recreation or Education 65 | 4 | |
12371 | 12371 | 12370 | {"type": "Polygon", "coordinates": [[[-122.99311, 38.5006], [-122.99286, 38.50079], [-122.99268, 38.50065], [-122.9924, 38.50083], [-122.99204, 38.50049], [-122.99203, 38.50047], [-122.99249, 38.50009], [-122.99311, 38.5006]]]} | Open Access 1 | 26074 | JK Wright Park | 20415 | 2254 | Russian River Recreation and Park District 1020 | Special District 4 | Recreation/Parks District 4 | http://russianriverrecpark.org/ | Special District 4 | 2254 | Russian River Recreation and Park District 982 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 0.976 | JK Wright Park | 0 | Local Park 2 | 4 | |
12372 | 12372 | 12371 | {"type": "MultiPolygon", "coordinates": [[[[-123.00562, 38.49576], [-123.00549, 38.4958], [-123.00539, 38.49588], [-123.00523, 38.49614], [-123.00511, 38.49626], [-123.00473, 38.49647], [-123.00462, 38.49624], [-123.00463, 38.49606], [-123.00471, 38.49603], [-123.00478, 38.49593], [-123.00465, 38.49589], [-123.00465, 38.49582], [-123.00486, 38.49542], [-123.00559, 38.49564], [-123.00562, 38.49576]]], [[[-123.00577, 38.49584], [-123.0058, 38.49618], [-123.00578, 38.49638], [-123.0057, 38.49666], [-123.00565, 38.49676], [-123.00561, 38.49687], [-123.00556, 38.49718], [-123.0048, 38.49713], [-123.00487, 38.49676], [-123.00479, 38.49659], [-123.00517, 38.49638], [-123.00527, 38.49631], [-123.00534, 38.49623], [-123.00549, 38.49596], [-123.00554, 38.49591], [-123.00563, 38.49586], [-123.00577, 38.49584]]], [[[-123.01021, 38.49468], [-123.01021, 38.49468], [-123.00936, 38.49495], [-123.00973, 38.49473], [-123.01012, 38.49453], [-123.01021, 38.49468]]]]} | Open Access 1 | 26075 | Angelo Boles Park | 15495 | 2254 | Russian River Recreation and Park District 1020 | Special District 4 | Recreation/Parks District 4 | http://russianriverrecpark.org/ | Special District 4 | 2254 | Russian River Recreation and Park District 982 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 3.535 | Angelo Boles Park | 0 | Local Park 2 | 4 | |
12373 | 12373 | 12372 | {"type": "Polygon", "coordinates": [[[-123.0084, 38.49662], [-123.0082, 38.49655], [-123.00809, 38.49669], [-123.00782, 38.49662], [-123.00758, 38.4965], [-123.00797, 38.49611], [-123.00815, 38.49619], [-123.00833, 38.49619], [-123.0084, 38.49626], [-123.0084, 38.4963], [-123.0083, 38.49644], [-123.00828, 38.4965], [-123.00832, 38.49657], [-123.0084, 38.49662]]]} | Open Access 1 | 26076 | Pacheco Park | 23292 | 2254 | Russian River Recreation and Park District 1020 | Special District 4 | Recreation/Parks District 4 | http://russianriverrecpark.org/ | Special District 4 | 2254 | Russian River Recreation and Park District 982 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 0.666 | Pacheco Park | 0 | Local Park 2 | 4 | |
12353 | 12353 | 12352 | {"type": "MultiPolygon", "coordinates": [[[[-123.01059, 38.48345], [-123.01015, 38.48391], [-123.00931, 38.48364], [-123.00931, 38.48303], [-123.01059, 38.48345]]], [[[-123.01075, 38.48424], [-123.01068, 38.48437], [-123.01059, 38.48435], [-123.01053, 38.48446], [-123.01034, 38.4843], [-123.01049, 38.48402], [-123.01075, 38.48424]]], [[[-123.01166, 38.4834], [-123.01106, 38.48346], [-123.01091, 38.48354], [-123.01092, 38.48356], [-123.01119, 38.48364], [-123.01093, 38.48417], [-123.01056, 38.48386], [-123.01054, 38.48387], [-123.01049, 38.48383], [-123.01078, 38.48354], [-123.01103, 38.48341], [-123.01165, 38.48335], [-123.01166, 38.4834]]]]} | Open Access 1 | 26077 | Vacation Beach Playground | 26752 | 2254 | Russian River Recreation and Park District 1020 | Special District 4 | Recreation/Parks District 4 | http://russianriverrecpark.org/ | Special District 4 | 2254 | Russian River Recreation and Park District 982 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 2.431 | Vacation Beach Playground | 0 | Local Recreation Area 3 | 4 | |
12354 | 12354 | 12353 | {"type": "Polygon", "coordinates": [[[-121.96963, 38.04103], [-121.96963, 38.04434], [-121.96849, 38.0443], [-121.96622, 38.04318], [-121.96629, 38.04287], [-121.96269, 38.04202], [-121.96268, 38.03926], [-121.96963, 38.04103]]]} | Restricted Access 2 | 26080 | Bay Point Regional Shoreline | 31519 | 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 | Contra Costa 12 | 50.558 | Bay Point Reg. Shoreline | 1996 | Local Park 2 | 4 | |
12355 | 12355 | 12354 | {"type": "Polygon", "coordinates": [[[-115.59187, 32.84588], [-115.59017, 32.84588], [-115.59015, 32.84586], [-115.59015, 32.84522], [-115.59186, 32.84521], [-115.59187, 32.84588]]]} | Open Access 1 | 26500 | Savanna Ranch Park | 25174 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 2.951 | Savanna Ranch Park | 0 | Local Park 2 | 4 | |
12356 | 12356 | 12355 | {"type": "MultiPolygon", "coordinates": [[[[-115.55495, 32.83018], [-115.55491, 32.83021], [-115.55301, 32.8302], [-115.55298, 32.83018], [-115.55298, 32.82921], [-115.55396, 32.82921], [-115.55396, 32.82834], [-115.55488, 32.82834], [-115.55494, 32.8284], [-115.55495, 32.83018]]], [[[-115.55626, 32.83021], [-115.55518, 32.83021], [-115.55514, 32.83018], [-115.55514, 32.82921], [-115.55625, 32.82921], [-115.55626, 32.83021]]]]} | Open Access 1 | 26501 | Paseo del Sol Park | 23496 | 1450 | Imperial, City of 35 | City 2 | City Agency 2 | http://www.cityofimperial.org/dept.php?id=33 | City 2 | 1450 | Imperial, City of 34 | City 2 | City Agency 2 | Imperial 20 | 10.093 | Paseo del Sol 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]);