units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Parks and Recreation 225
- California Department of Fish and Wildlife 211
- San Diego, City of 137
- Los Angeles, City of 116
- Mountains Recreation and Conservation Authority 115
- East Bay Regional Park District 111
- Ventura, City of 103
- Consumnes Community Services District 86
- Roseville, City of 68
- Los Angeles, County of 65
- United States Fish and Wildlife Service 61
- California State Lands Commission 61
- Long Beach, City of 58
- Butte, County of 45
- Poway, City of 43
- United States Forest Service 41
- Tracy, City of 41
- Irvine, City of 39
- Lake, County of 39
- Orange, County of 38
- Midpeninsula Regional Open Space District 38
- Stockton, City of 37
- Folsom, City of 36
- Arcata, City of 36
- San Diego, County of 34
- San Jose, City of 33
- El Dorado, County of 33
- Southgate Recreation and Park District 33
- Sunrise Recreation and Park District 33
- San Ramon, City of 32
- …
DES_TP >30
- Local Park 2,293
- Local Recreation Area 901
- Local Other or Unknown 693
- Private Conservation 209
- Local Conservation Area 203
- State Conservation Area 198
- Private Recreation or Education 140
- State Park 133
- State Resource Management Area 81
- State Recreation Area 72
- National Wildlife Refuge 55
- National Forest 38
- State Historic or Cultural Area 38
- Recreation Management Area 21
- National Monument or Landmark 19
- State Other or Unknown 16
- National Public Lands 14
- National Recreation Area 13
- National Park 11
- Local Resource Management Area 10
- Conservation Area 9
- Private Other or Unknown 9
- Private Agricultural 8
- Local Historic or Cultural Area 7
- Federal Other or Unknown 7
- Resource Management Area 4
- Historic or Cultural Area 3
- Wilderness Area 1
- State Wilderness 1
- Area of Critical Environmental Concern 1
- …
AGNCY_NAME >30 ✖
- California Department of Parks and Recreation 203
- California Department of Fish and Wildlife 182
- San Diego, City of 133
- Los Angeles, City of 115
- Ventura, City of 103
- California State Lands Commission 100
- Consumnes Community Services District 84
- Mountains Recreation and Conservation Authority 82
- Los Angeles, County of 81
- East Bay Regional Park District 79
- Roseville, City of 68
- United States Fish and Wildlife Service 58
- Long Beach, City of 58
- Butte, County of 45
- United States Forest Service 44
- Poway, City of 43
- Irvine, City of 42
- Tracy, City of 41
- Lake, County of 39
- United States Bureau of Land Management 38
- Orange, County of 38
- Midpeninsula Regional Open Space District 37
- Stockton, City of 37
- Folsom, City of 36
- Arcata, City of 36
- United States National Park Service 35
- San Jose, City of 34
- San Diego, County of 34
- Southgate Recreation and Park District 33
- Sunrise Recreation and Park District 33
- …
MNG_AG_TYP 29
- City Agency 2,903
- State Agency 569
- Recreation/Parks District 526
- County Agency 412
- Federal Agency 189
- Non Profit - Land Trust 173
- Open Space District 160
- Community Services District 146
- Home Owners Association 111
- County Agency - Parks 92
- Water District 90
- Non Profit - Conservation 80
- Flood District 48
- Irrigation District 24
- School District 21
- Non Profit - Other 15
- Special District - Other 11
- County Agency - Other 9
- Commercial 7
- Port/Harbor District 6
- Other 5
- Transportation Agency 5
- Conservation District 4
- Cemetery District 3
- Joint Powers Authority 3
- Sanitation District 2
- Mitigation Bank 2
- Non Profit - Education 2
- Fire District 1
ACCESS_TYP 4
- Open Access 4,550
- Restricted Access 555
- No Public Access 352
- Unknown Access 162
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11450 | 11450 | 11449 | {"type": "Polygon", "coordinates": [[[-122.28821, 37.52187], [-122.28809, 37.52198], [-122.28808, 37.52195], [-122.28782, 37.52178], [-122.28799, 37.5217], [-122.28809, 37.5217], [-122.28813, 37.52177], [-122.28821, 37.52187]]]} | Open Access 1 | 29140 | Patricia Wharton Park | 23511 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 0.132 | Patricia Wharton Park | 0 | Local Park 2 | 4 | |
11451 | 11451 | 11450 | {"type": "MultiPolygon", "coordinates": [[[[-116.59234, 34.03268], [-116.5923, 34.0347], [-116.59123, 34.03474], [-116.59115, 34.03652], [-116.58466, 34.03678], [-116.58481, 34.03853], [-116.5809, 34.0386], [-116.58091, 34.04038], [-116.57644, 34.04023], [-116.57642, 34.04155], [-116.57328, 34.04159], [-116.57, 34.04162], [-116.56986, 34.04692], [-116.56352, 34.04691], [-116.56354, 34.05456], [-116.55475, 34.05448], [-116.55492, 34.05811], [-116.56122, 34.05806], [-116.56128, 34.05923], [-116.55487, 34.0591], [-116.55488, 34.0601], [-116.55259, 34.06009], [-116.55251, 34.0614], [-116.5501, 34.0614], [-116.54994, 34.06339], [-116.54835, 34.06346], [-116.54828, 34.06424], [-116.54626, 34.06421], [-116.54624, 34.06519], [-116.53262, 34.06536], [-116.53247, 34.07285], [-116.51983, 34.07282], [-116.51988, 34.06964], [-116.51517, 34.06958], [-116.51515, 34.07569], [-116.51343, 34.0757], [-116.51333, 34.07759], [-116.51126, 34.07747], [-116.51124, 34.07925], [-116.50641, 34.07913], [-116.50655, 34.08834], [-116.50548, 34.08832], [-116.50565, 34.09019], [-116.49264, 34.09016], [-116.49274, 34.09717], [-116.49033, 34.09701], [-116.4903, 34.09914], [-116.49031, 34.09915], [-116.49276, 34.09914], [-116.49281, 34.1027], [-116.49049, 34.10282], [-116.49064, 34.10459], [-116.48031, 34.1046], [-116.48035, 34.10279], [-116.48167, 34.10281], [-116.48147, 34.10097], [-116.48384, 34.10094], [-116.48374, 34.09934], [-116.48492, 34.09922], [-116.48503, 34.10082], [-116.48684, 34.10087], [-116.48689, 34.0955], [-116.48821, 34.09556], [-116.48805, 34.09156], [-116.49033, 34.09162], [-116.49023, 34.09017], [-116.49264, 34.09015], [-116.49279, 34.07579], [-116.49276, 34.07578], [-116.49276, 34.07564], [-116.47486, 34.07595], [-116.45762, 34.07597], [-116.45749, 34.04727], [-116.45702, 34.03291], [-116.47522, 34.03278], [-116.49258, 34.03289], [-116.4927, 34.03289], [-116.49271, 34.03282], [-116.50153, 34.03285], [-116.50154, 34.03287], [-116.5104, 34.03285], [-116.51135, 34.03285], [-116.51135, 34.0331], [-116.5124, 34.03294], [-116.5902, 34.03278], [-116.59234, 34.03268]], [[-116.49261, 34.06174], [-116.49262, 34.06173], [-116.49247, 34.04721], [-116.48377, 34.04722], [-116.48374, 34.06177], [-116.49261, 34.06174]]], [[[-116.52859, 34.13276], [-116.52407, 34.13273], [-116.52413, 34.13143], [-116.52327, 34.13146], [-116.52251, 34.12986], [-116.52392, 34.12954], [-116.52402, 34.12872], [-116.51927, 34.12869], [-116.51926, 34.1287], [-116.51951, 34.1302], [-116.51394, 34.13273], [-116.51117, 34.13274], [-116.51124, 34.1208], [-116.49298, 34.12073], [-116.49296, 34.11736], [-116.49486, 34.11749], [-116.49488, 34.11668], [-116.49809, 34.11667], [-116.49814, 34.11471], [-116.49949, 34.11475], [-116.4995, 34.11474], [-116.4994, 34.11285], [-116.49293, 34.11273], [-116.49285, 34.10822], [-116.49684, 34.10815], [-116.4972, 34.1046], [-116.50082, 34.10465], [-116.50082, 34.10624], [-116.50349, 34.10627], [-116.50381, 34.10466], [-116.51143, 34.10466], [-116.51113, 34.11831], [-116.51416, 34.11832], [-116.51433, 34.11849], [-116.51481, 34.11846], [-116.51518, 34.11852], [-116.51538, 34.11911], [-116.51572, 34.11928], [-116.51629, 34.11937], [-116.51724, 34.11932], [-116.51779, 34.11912], [-116.5186, 34.11946], [-116.5186, 34.11969], [-116.5188, 34.12005], [-116.51931, 34.12023], [-116.51985, 34.12026], [-116.52008, 34.12043], [-116.52049, 34.12068], [-116.52062, 34.12082], [-116.52092, 34.12108], [-116.5212, 34.12105], [-116.52187, 34.12102], [-116.52204, 34.12125], [-116.52225, 34.12142], [-116.52343, 34.12171], [-116.52377, 34.12199], [-116.52421, 34.12219], [-116.52451, 34.12242], [-116.52468, 34.12267], [-116.52475, 34.12301], [-116.52512, 34.12318], [-116.52566, 34.12324], [-116.52613, 34.12392], [-116.52681, 34.12431], [-116.52735, 34.12446], [-116.52792, 34.12446], [-116.52802, 34.12457], [-116.52858, 34.1249], [-116.52859, 34.13276]], [[-116.50294, 34.11678], [-116.50298, 34.11475], [-116.50159, 34.11474], [-116.50156, 34.11287], [-116.50032, 34.11286], [-116.50047, 34.11673], [-116.50294, 34.11678]]]]} | Open Access 1 | 23057 | Big Morongo Canyon Preserve | 16082 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Bernardino 22 | 12367.553 | Big Morongo Canyon Preserve | None 1017 | |||
11452 | 11452 | 11451 | {"type": "Polygon", "coordinates": [[[-117.32919, 34.76299], [-117.32823, 34.76319], [-117.32818, 34.76317], [-117.32818, 34.76226], [-117.32889, 34.76227], [-117.32893, 34.76248], [-117.32907, 34.76281], [-117.32919, 34.76299]]]} | Open Access 1 | 48176 | Helendale Dog Park | 32711 | 2424 | Helendale Community Services District 980 | Special District 4 | Community Services District 19 | https://www.helendalecsd.org/parks_facilities.html | Special District 4 | 2424 | Helendale Community Services District 943 | Special District 4 | Community Services District 17 | https://helendalecsd.recdesk.com/Community/Page?pageId=18185 | San Bernardino 22 | 1.769 | Helendale Dog Park | 0 | Local Park 2 | 4 |
11453 | 11453 | 11452 | {"type": "Polygon", "coordinates": [[[-119.64146, 36.86082], [-119.64061, 36.86083], [-119.64054, 36.86081], [-119.64033, 36.86071], [-119.64039, 36.86063], [-119.64038, 36.86058], [-119.64034, 36.86054], [-119.64039, 36.86048], [-119.64043, 36.86049], [-119.64051, 36.8604], [-119.64048, 36.86038], [-119.64055, 36.86031], [-119.64068, 36.86025], [-119.64076, 36.86015], [-119.64076, 36.86006], [-119.64074, 36.85999], [-119.64069, 36.85994], [-119.6406, 36.85989], [-119.64045, 36.85988], [-119.64032, 36.85992], [-119.64025, 36.86], [-119.64022, 36.8601], [-119.64016, 36.86016], [-119.64014, 36.86015], [-119.64003, 36.86026], [-119.64004, 36.86027], [-119.63998, 36.86031], [-119.63993, 36.86029], [-119.63989, 36.86028], [-119.63977, 36.86035], [-119.63963, 36.86019], [-119.63964, 36.86015], [-119.64081, 36.85949], [-119.64109, 36.85938], [-119.64137, 36.85932], [-119.64141, 36.85934], [-119.64141, 36.85936], [-119.64144, 36.85937], [-119.64146, 36.86082]]]} | Open Access 1 | 48696 | Harlan Ranch Community Park | 33431 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | https://www.visitclovis.com/clovis-parks/ | Fresno 9 | 3.576 | Harlan Ranch Community Park | 0 | Local Park 2 | 4 |
11454 | 11454 | 11453 | {"type": "MultiPolygon", "coordinates": [[[[-124.05595, 41.47223], [-124.05117, 41.47218], [-124.05105, 41.46848], [-124.0463, 41.46856], [-124.04634, 41.46465], [-124.05103, 41.46466], [-124.05582, 41.46463], [-124.05595, 41.47223]]], [[[-124.06678, 41.47217], [-124.06079, 41.47219], [-124.06072, 41.46461], [-124.06518, 41.46458], [-124.06526, 41.46505], [-124.06536, 41.46536], [-124.06539, 41.46558], [-124.06546, 41.46582], [-124.06573, 41.46632], [-124.0656, 41.4668], [-124.06555, 41.46706], [-124.06555, 41.46729], [-124.0656, 41.46758], [-124.06567, 41.46781], [-124.06579, 41.46837], [-124.06595, 41.46869], [-124.06608, 41.46892], [-124.06598, 41.46969], [-124.06597, 41.46998], [-124.06606, 41.47029], [-124.06614, 41.47063], [-124.06633, 41.47127], [-124.06663, 41.47177], [-124.06678, 41.47217]]]]} | Open Access 1 | 23081 | Prairie Creek Redwoods State Park | 1699 | 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=415 | Del Norte 50 | 213.927 | Prairie Creek Redwoods SP | 1923 | State Park 15 | 4 |
11455 | 11455 | 11454 | {"type": "MultiPolygon", "coordinates": [[[[-117.89231, 34.14567], [-117.89232, 34.14572], [-117.8923, 34.14577], [-117.89142, 34.14625], [-117.89109, 34.14638], [-117.89071, 34.14645], [-117.8907, 34.1464], [-117.89103, 34.14632], [-117.89133, 34.1462], [-117.89231, 34.14567]]], [[[-117.89398, 34.14516], [-117.89359, 34.14522], [-117.89327, 34.1453], [-117.89286, 34.14547], [-117.89251, 34.14565], [-117.89244, 34.14566], [-117.8924, 34.14562], [-117.89292, 34.14535], [-117.89329, 34.14521], [-117.89356, 34.14514], [-117.89398, 34.14508], [-117.89398, 34.14516]]], [[[-117.89576, 34.14528], [-117.89574, 34.14534], [-117.89568, 34.14536], [-117.89471, 34.14518], [-117.89471, 34.14509], [-117.89576, 34.14528]]], [[[-117.89689, 34.14547], [-117.89687, 34.14551], [-117.89683, 34.14554], [-117.89667, 34.14552], [-117.89591, 34.14538], [-117.89586, 34.14535], [-117.89585, 34.14531], [-117.89585, 34.14529], [-117.89689, 34.14547]]], [[[-117.90254, 34.14631], [-117.90253, 34.14657], [-117.9025, 34.14662], [-117.90232, 34.14665], [-117.90191, 34.14664], [-117.9005, 34.14647], [-117.90014, 34.1464], [-117.89976, 34.14628], [-117.89897, 34.14594], [-117.89854, 34.1458], [-117.89799, 34.14568], [-117.89706, 34.14557], [-117.89701, 34.14555], [-117.897, 34.1455], [-117.89703, 34.14549], [-117.89704, 34.14545], [-117.89839, 34.14551], [-117.8988, 34.1456], [-117.8993, 34.14573], [-117.89949, 34.14575], [-117.89971, 34.14575], [-117.8999, 34.14571], [-117.9001, 34.14566], [-117.90052, 34.14549], [-117.90053, 34.14551], [-117.90048, 34.14556], [-117.90024, 34.14565], [-117.90007, 34.1458], [-117.90006, 34.146], [-117.90009, 34.14604], [-117.90054, 34.14621], [-117.90061, 34.14626], [-117.90082, 34.14635], [-117.90087, 34.14629], [-117.90192, 34.14656], [-117.90237, 34.14653], [-117.90247, 34.14645], [-117.9025, 34.14635], [-117.90254, 34.14631]]], [[[-117.90512, 34.1467], [-117.90333, 34.14671], [-117.90319, 34.14669], [-117.9029, 34.14665], [-117.90281, 34.14655], [-117.90276, 34.14644], [-117.90281, 34.14643], [-117.90288, 34.14653], [-117.90298, 34.14659], [-117.90322, 34.14661], [-117.90335, 34.14655], [-117.90333, 34.14661], [-117.90334, 34.14665], [-117.90505, 34.14666], [-117.90509, 34.14664], [-117.90512, 34.1466], [-117.90512, 34.1467]]]]} | Open Access 1 | 48143 | Sierra Madre Walking Trail | 32674 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.955 | Sierra Madre Walking Trail | 0 | Local Recreation Area 3 | 4 | |
11456 | 11456 | 11455 | {"type": "Polygon", "coordinates": [[[-118.0761, 34.07395], [-118.07588, 34.07396], [-118.07583, 34.07284], [-118.07606, 34.07306], [-118.0761, 34.07395]]]} | No Public Access 3 | 48148 | Rosemead Community Garden | 32678 | 1284 | Rosemead, City of 130 | City 2 | City Agency 2 | http://www.cityofrosemead.org/index.aspx?page=74 | City 2 | 1284 | Rosemead, City of 127 | City 2 | City Agency 2 | Los Angeles 6 | 0.555 | Rosemead Community Garden | 0 | Local Park 2 | 4 | |
11457 | 11457 | 11456 | {"type": "Polygon", "coordinates": [[[-118.11356, 34.10969], [-118.11221, 34.1097], [-118.11219, 34.10843], [-118.11354, 34.10842], [-118.11356, 34.10969]]]} | Restricted Access 2 | 48149 | Coolidge School Park | 32679 | 2393 | San Gabriel Unified School District 706 | Special District 4 | School District 14 | http://www.sgusd.k12.ca.us/ | Special District 4 | 2393 | San Gabriel Unified School District 693 | Special District 4 | School District 21 | Los Angeles 6 | 4.336 | Coolidge School Park | 0 | Local Park 2 | 4 | |
11458 | 11458 | 11457 | {"type": "Polygon", "coordinates": [[[-118.34474, 33.32226], [-118.34459, 33.32254], [-118.3446, 33.32273], [-118.34452, 33.32287], [-118.3446, 33.32309], [-118.34427, 33.32358], [-118.34443, 33.32393], [-118.34426, 33.32423], [-118.3442, 33.32446], [-118.34379, 33.32439], [-118.34347, 33.32438], [-118.34308, 33.32446], [-118.34269, 33.32445], [-118.34244, 33.3245], [-118.34221, 33.3245], [-118.34188, 33.32462], [-118.34159, 33.32501], [-118.34093, 33.32616], [-118.34059, 33.32671], [-118.34044, 33.32692], [-118.3404, 33.3271], [-118.34009, 33.32721], [-118.33946, 33.32689], [-118.33948, 33.32659], [-118.33959, 33.32583], [-118.33972, 33.32552], [-118.3398, 33.32542], [-118.33979, 33.3253], [-118.33984, 33.32508], [-118.33996, 33.32488], [-118.34008, 33.32444], [-118.34, 33.3241], [-118.34057, 33.32354], [-118.3407, 33.32339], [-118.34036, 33.32293], [-118.34018, 33.32261], [-118.34014, 33.32239], [-118.34096, 33.32196], [-118.34151, 33.32158], [-118.34217, 33.32149], [-118.34226, 33.32154], [-118.34245, 33.32162], [-118.34263, 33.32167], [-118.34308, 33.32189], [-118.34323, 33.32187], [-118.34351, 33.32192], [-118.34445, 33.32198], [-118.34474, 33.32226]]]} | Open Access 1 | 48147 | Santa Catalina Island Nature Center at Avalon Canyon | 32677 | 3070 | Santa Catalina Island Conservancy 382 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.catalinaconservancy.org/ | Non Governmental Organization 10 | 3070 | Santa Catalina Island Conservancy 377 | Non Profit 6 | Non Profit - Land Trust 10 | http://parks.lacounty.gov/santa-catalina-island-nature-center-at-avalon-canyon/ | Los Angeles 6 | 37.759 | Santa Catalina Island Nature Ctr. at Avalon Canyon | 0 | Private Conservation 16 | 2 |
11459 | 11459 | 11458 | {"type": "Polygon", "coordinates": [[[-118.36519, 34.09549], [-118.36478, 34.0955], [-118.36479, 34.09569], [-118.36502, 34.09571], [-118.36502, 34.09582], [-118.36457, 34.09582], [-118.36457, 34.09538], [-118.36518, 34.09538], [-118.36519, 34.09549]]]} | Open Access 1 | 48159 | Laurel Park | 32697 | 1375 | West Hollywood, City of 334 | City 2 | City Agency 2 | http://www.weho.org/residents/recreation-services/parks-and-facilities | City 2 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | Los Angeles 6 | 0.43 | Laurel Park | 2011 | Local Park 2 | 4 | |
11460 | 11460 | 11459 | {"type": "Polygon", "coordinates": [[[-118.30636, 33.88501], [-118.306, 33.88501], [-118.306, 33.88495], [-118.30635, 33.88494], [-118.30636, 33.88501]]]} | Restricted Access 2 | 48160 | Rush Memorial Gymnasium | 32699 | 1117 | Gardena, City of 297 | City 2 | City Agency 2 | http://www.ci.gardena.ca.us/ | City 2 | 1117 | Gardena, City of 293 | City 2 | City Agency 2 | https://www.facebook.com/pages/Rush-Memorial-Gymnasium/1811050155861741 | Los Angeles 6 | 0.058 | Rush Memorial Gymnasium | 0 | Local Recreation Area 3 | 4 |
11461 | 11461 | 11460 | {"type": "Polygon", "coordinates": [[[-118.92622, 34.40137], [-118.92584, 34.40136], [-118.92572, 34.40141], [-118.92553, 34.40166], [-118.92549, 34.40178], [-118.92542, 34.40186], [-118.9253, 34.4018], [-118.92553, 34.4015], [-118.92556, 34.40139], [-118.92547, 34.40109], [-118.92613, 34.401], [-118.92622, 34.40137]]]} | Open Access 1 | 48697 | Meadowlark Park | 33432 | 1423 | Fillmore, City of 600 | City 2 | City Agency 2 | http://www.fillmoreca.com/rec-dept.htm | City 2 | 1423 | Fillmore, City of 590 | City 2 | City Agency 2 | Ventura 8 | 0.726 | Meadowlark Park | 0 | Local Park 2 | 4 | |
11462 | 11462 | 11461 | {"type": "Polygon", "coordinates": [[[-122.179, 40.39296], [-122.17893, 40.39304], [-122.17881, 40.3933], [-122.17839, 40.39374], [-122.17821, 40.39349], [-122.17821, 40.39301], [-122.17663, 40.39309], [-122.17653, 40.3925], [-122.17678, 40.39242], [-122.177, 40.39239], [-122.17736, 40.39239], [-122.1779, 40.39233], [-122.17853, 40.39231], [-122.17893, 40.39282], [-122.179, 40.39296]]]} | Open Access 1 | 29185 | Battle Creek Public Access | 32043 | 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 | Shasta 27 | 4.326 | Battle Creek PA | 0 | State Recreation Area 39 | 4 | |
11463 | 11463 | 11462 | {"type": "Polygon", "coordinates": [[[-117.67517, 34.0201], [-117.67477, 34.0201], [-117.67476, 34.0193], [-117.67517, 34.0193], [-117.67517, 34.0201]]]} | Open Access 1 | 48698 | Community Garden Pocket Park | 33797 | 1053 | Chino, City of 266 | City 2 | City Agency 2 | http://www.cityofchino.org/residents/parks | City 2 | 1053 | Chino, City of 261 | City 2 | City Agency 2 | https://www.cityofchino.org/residents/connection/programs/garden_workshops | San Bernardino 22 | 0.828 | Community Garden PP | 0 | Local Park 2 | 4 |
11464 | 11464 | 11463 | {"type": "Polygon", "coordinates": [[[-119.22071, 35.67312], [-119.22071, 35.67438], [-119.21686, 35.67441], [-119.21687, 35.67315], [-119.22071, 35.67312]]]} | Open Access 1 | 48174 | Jim White "Blanco" Park | 32709 | 1691 | McFarland, City of 981 | City 2 | City Agency 2 | http://www.mcfarlandcity.org/194/Parks-Recreation | City 2 | 1691 | McFarland, City of 944 | City 2 | City Agency 2 | https://www.mcfarlandcity.org/194/Parks-Recreation | Kern 36 | 11.997 | Jim White "Blanco" Park | 2019 | Local Park 2 | 4 |
11465 | 11465 | 11464 | {"type": "Polygon", "coordinates": [[[-117.32813, 34.76673], [-117.32803, 34.7693], [-117.32577, 34.76927], [-117.32577, 34.76773], [-117.32645, 34.76704], [-117.32646, 34.76671], [-117.32813, 34.76673]]]} | Open Access 1 | 48175 | Helendale Community Park | 32710 | 2424 | Helendale Community Services District 980 | Special District 4 | Community Services District 19 | https://www.helendalecsd.org/parks_facilities.html | Special District 4 | 2424 | Helendale Community Services District 943 | Special District 4 | Community Services District 17 | https://www.helendalecsd.org/parks_facilities.html | San Bernardino 22 | 13.717 | Helendale Community Park | 2017 | Local Park 2 | 4 |
11466 | 11466 | 11465 | {"type": "Polygon", "coordinates": [[[-122.28132, 37.9134], [-122.28121, 37.91335], [-122.28073, 37.91357], [-122.28038, 37.91363], [-122.28006, 37.91364], [-122.28059, 37.91414], [-122.28032, 37.91429], [-122.28033, 37.91433], [-122.28017, 37.91443], [-122.28013, 37.91447], [-122.28011, 37.91455], [-122.27999, 37.91464], [-122.27974, 37.91375], [-122.27977, 37.91354], [-122.27953, 37.91348], [-122.27932, 37.91337], [-122.27914, 37.9133], [-122.27894, 37.91332], [-122.27856, 37.91344], [-122.27849, 37.9134], [-122.27855, 37.91313], [-122.27855, 37.91292], [-122.28025, 37.91174], [-122.28106, 37.91239], [-122.2812, 37.91267], [-122.28074, 37.91276], [-122.28074, 37.91278], [-122.28092, 37.91335], [-122.28129, 37.91318], [-122.28132, 37.9134]]]} | Open Access 1 | 48178 | Kensington Park | 32713 | 300 | Contra Costa County Public Works Dept., County of 429 | County 3 | County Agency - Other 9 | http://www.co.contra-costa.ca.us/227/Public-Works | County 3 | 300 | Contra Costa County Public Works Dept., County of 423 | County 3 | County Agency - Other 8 | Contra Costa 12 | 8.459 | Kensington Park | 0 | Local Park 2 | 4 | |
11467 | 11467 | 11466 | {"type": "Polygon", "coordinates": [[[-122.80585, 40.71739], [-122.80501, 40.71749], [-122.80433, 40.7175], [-122.80228, 40.7173], [-122.80209, 40.71687], [-122.80259, 40.71646], [-122.80453, 40.71712], [-122.80523, 40.71718], [-122.80585, 40.71739]]]} | Open Access 1 | 29196 | Deadwood Hole Fishing Access | 32145 | 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 | Trinity 46 | 4.23 | Deadwood Hole FA | 0 | State Recreation Area 39 | 4 | |
11468 | 11468 | 11467 | {"type": "Polygon", "coordinates": [[[-121.85697, 39.8077], [-121.85694, 39.81018], [-121.85663, 39.81022], [-121.85626, 39.80996], [-121.85599, 39.80946], [-121.85582, 39.80948], [-121.85572, 39.80922], [-121.85437, 39.80942], [-121.85359, 39.80962], [-121.85359, 39.80913], [-121.85387, 39.80913], [-121.85422, 39.80927], [-121.85439, 39.8093], [-121.8557, 39.8091], [-121.85575, 39.80889], [-121.85596, 39.80883], [-121.85612, 39.80845], [-121.85624, 39.80843], [-121.85634, 39.80839], [-121.85643, 39.80834], [-121.8565, 39.80827], [-121.85674, 39.80774], [-121.85697, 39.8077]]]} | Open Access 1 | 48708 | Skycreek Park | 33437 | 1052 | Chico, City of 430 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | Butte 42 | 5.528 | Skycreek Park | 0 | Local Park 2 | 4 | |
11469 | 11469 | 11468 | {"type": "Polygon", "coordinates": [[[-121.27421, 38.90427], [-121.27413, 38.90433], [-121.27265, 38.90434], [-121.2726, 38.90431], [-121.27257, 38.90427], [-121.27256, 38.90359], [-121.27263, 38.90353], [-121.27416, 38.90352], [-121.2742, 38.90357], [-121.27421, 38.90427]]]} | Open Access 1 | 48709 | Palo Verde Park | 33438 | 1175 | Lincoln, City of 608 | City 2 | City Agency 2 | http://www.ci.lincoln.ca.us/default.aspx?Jpage=41500 | City 2 | 1175 | Lincoln, City of 597 | City 2 | City Agency 2 | Placer 35 | 3.146 | Palo Verde 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]);