units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17,068 rows sorted by YR_EST
This data as json, copyable, CSV (advanced)
MNG_AG_TYP >30
- City Agency 10,524
- County Agency 1,219
- Recreation/Parks District 1,162
- State Agency 1,141
- Non Profit - Land Trust 601
- Federal Agency 517
- Open Space District 428
- Water District 238
- County Agency - Parks 236
- Home Owners Association 203
- Community Services District 198
- Non Profit - Conservation 148
- Flood District 108
- Cemetery District 62
- Irrigation District 50
- Non Profit - Other 45
- School District 38
- County Agency - Other 35
- Port/Harbor District 33
- Commercial 15
- Special District - Other 15
- Sanitation District 9
- Joint Powers Authority 9
- Other 6
- Non Profit - Cemetery District 5
- Conservation District 5
- Transportation Agency 5
- Mitigation Bank 4
- Non Profit - Education 3
- Metropolitan Planning Organization 2
- …
MNG_AGENCY >30
- San Diego, City of 533
- Los Angeles, City of 491
- California Department of Fish and Wildlife 443
- California Department of Parks and Recreation 380
- Mountains Recreation and Conservation Authority 351
- San Jose, City of 253
- San Francisco, City and County of 240
- Sacramento, City of 220
- Los Angeles, County of 175
- East Bay Regional Park District 167
- Ventura, City of 151
- Long Beach, City of 148
- Roseville, City of 130
- San Diego, County of 123
- Oakland, City of 122
- United States Bureau of Land Management 121
- Santa Barbara, County of 119
- United States Forest Service 111
- Irvine, City of 101
- Fresno, City of 95
- Orange, County of 95
- Consumnes Community Services District 94
- United States National Park Service 89
- California State Lands Commission 86
- Modesto, City of 85
- Hayward Area Recreation and Park District 84
- Santa Rosa, City of 83
- United States Fish and Wildlife Service 82
- Stockton, City of 81
- Napa, City of 81
- …
DES_TP >30
- Local Park 9,376
- Local Recreation Area 1,989
- Local Other or Unknown 1,190
- Private Conservation 629
- Local Conservation Area 485
- State Conservation Area 381
- Private Recreation or Education 268
- State Park 208
- State Resource Management Area 159
- State Recreation Area 145
- Local Historic or Cultural Area 116
- National Forest 99
- National Public Lands 75
- National Wildlife Refuge 75
- State Other or Unknown 70
- State Historic or Cultural Area 63
- Recreation Management Area 61
- Private Other or Unknown 51
- National Recreation Area 40
- National Monument or Landmark 39
- National Park 26
- Resource Management Area 26
- Local Resource Management Area 24
- Federal Other or Unknown 24
- Conservation Area 14
- Private Agricultural 12
- Wilderness Area 7
- Area of Critical Environmental Concern 7
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
LAYER 14 ✖
- City 10,394
- Special District 2,391
- County 1,454
- Non Governmental Organization 781
- Other State 444
- California Department of Fish and Wildlife 399
- California Department of Parks and Recreation 355
- Private 266
- Other Federal 144
- US Bureau of Land Management 142
- US Forest Service 115
- National Park Service 93
- US Fish and Wildlife Service 79
- US Military/Defense 11
MNG_AG_LEV 8 ✖
- City 10,524
- Special District 2,357
- County 1,490
- State 1,141
- Non Profit 802
- Federal 517
- Private 230
- Joint 7
AGNCY_LEV 8 ✖
- City 10,394
- Special District 2,383
- County 1,454
- State 1,198
- Non Profit 781
- Federal 584
- Private 266
- Joint 8
ACCESS_TYP 4
- Open Access 14,510
- Restricted Access 1,203
- No Public Access 969
- Unknown Access 386
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 12 | 11 | {"type": "Polygon", "coordinates": [[[-120.70087, 35.73565], [-120.70026, 35.73762], [-120.70033, 35.73765], [-120.69995, 35.73853], [-120.69975, 35.73891], [-120.69913, 35.73992], [-120.6988, 35.73992], [-120.70087, 35.73565]]]} | Open Access 1 | 48 | Rios Caledonia Adobe | 24392 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | http://www.slocountyparks.com/ | County 3 | 323 | San Luis Obispo, County of 8 | County 3 | County Agency 3 | San Luis Obispo 1 | 3.26 | Rios Caledonia Adobe | None 5 | |||
25 | 25 | 24 | {"type": "Polygon", "coordinates": [[[-122.27747, 38.29885], [-122.27706, 38.29891], [-122.27702, 38.29871], [-122.27743, 38.29865], [-122.27747, 38.29885]]]} | No Public Access 3 | 64 | Real Estate Services Division | 24211 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | Napa 11 | 0.203 | Real Estate Services Division | None 6 | |||
40 | 40 | 39 | {"type": "Polygon", "coordinates": [[[-120.6535, 35.26278], [-120.65337, 35.26287], [-120.65316, 35.26262], [-120.6533, 35.26255], [-120.6535, 35.26278]]]} | Open Access 1 | 127 | Rockview Right-of-Way | 24536 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.123 | Rockview Right-of-Way | None 7 | |||
72 | 72 | 71 | {"type": "Polygon", "coordinates": [[[-120.63097, 35.24673], [-120.63073, 35.24675], [-120.63063, 35.24673], [-120.63043, 35.24674], [-120.6303, 35.24677], [-120.63025, 35.24681], [-120.63016, 35.24683], [-120.63008, 35.24682], [-120.62998, 35.24677], [-120.62994, 35.2467], [-120.62993, 35.24662], [-120.63, 35.24651], [-120.63004, 35.24648], [-120.63007, 35.24644], [-120.63012, 35.24628], [-120.6301, 35.24623], [-120.63011, 35.24615], [-120.63017, 35.2461], [-120.63019, 35.24606], [-120.63018, 35.24601], [-120.63013, 35.24596], [-120.63051, 35.24609], [-120.63065, 35.24616], [-120.63074, 35.24623], [-120.63083, 35.24633], [-120.63089, 35.24643], [-120.63095, 35.2466], [-120.63097, 35.24673]]]} | Open Access 1 | 167 | Rodriguez Adobe | 24553 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.39 | Rodriguez Adobe | None 10 | |||
104 | 104 | 103 | {"type": "MultiPolygon", "coordinates": [[[[-117.28007, 33.05439], [-117.27998, 33.05619], [-117.27973, 33.05623], [-117.27961, 33.05627], [-117.27947, 33.05637], [-117.27933, 33.05643], [-117.27924, 33.05645], [-117.27918, 33.05644], [-117.27916, 33.05641], [-117.27907, 33.05602], [-117.279, 33.05546], [-117.279, 33.05499], [-117.27903, 33.05437], [-117.28007, 33.05439]]], [[[-117.28063, 33.05635], [-117.28056, 33.05752], [-117.28062, 33.05796], [-117.27972, 33.05795], [-117.27929, 33.05682], [-117.27923, 33.05664], [-117.27929, 33.0566], [-117.27948, 33.05654], [-117.27971, 33.0564], [-117.27986, 33.05635], [-117.28063, 33.05635]]]]} | Open Access 1 | 288 | Encinitas Ranch Community Use Site | 18665 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 9.497 | Encinitas Ranch Community Use Site | None 12 | |||
125 | 125 | 124 | {"type": "Polygon", "coordinates": [[[-122.16054, 37.91443], [-122.15949, 37.91447], [-122.15824, 37.91493], [-122.15833, 37.91517], [-122.15835, 37.9154], [-122.15843, 37.91558], [-122.15855, 37.91562], [-122.1591, 37.91596], [-122.15923, 37.916], [-122.15932, 37.91606], [-122.15944, 37.9161], [-122.15978, 37.91678], [-122.15987, 37.91706], [-122.15989, 37.91733], [-122.15981, 37.91743], [-122.15968, 37.9175], [-122.15952, 37.91752], [-122.1583, 37.91752], [-122.15781, 37.91755], [-122.15781, 37.9177], [-122.15682, 37.91818], [-122.15556, 37.91921], [-122.15437, 37.92001], [-122.15249, 37.92204], [-122.15111, 37.92218], [-122.14987, 37.92221], [-122.14886, 37.92159], [-122.14828, 37.92145], [-122.14816, 37.92139], [-122.14803, 37.92129], [-122.14763, 37.92077], [-122.14752, 37.92071], [-122.14689, 37.92039], [-122.14573, 37.91988], [-122.14487, 37.91881], [-122.14368, 37.91819], [-122.14285, 37.91769], [-122.14266, 37.9176], [-122.14226, 37.91738], [-122.14209, 37.91701], [-122.14195, 37.91666], [-122.14182, 37.91621], [-122.14211, 37.9161], [-122.14325, 37.91561], [-122.14391, 37.91541], [-122.14487, 37.91524], [-122.14541, 37.91512], [-122.14599, 37.91505], [-122.14652, 37.91488], [-122.14719, 37.91472], [-122.14806, 37.91437], [-122.14828, 37.91418], [-122.14845, 37.91387], [-122.14876, 37.91372], [-122.14919, 37.91365], [-122.14961, 37.91369], [-122.14986, 37.91367], [-122.15009, 37.91362], [-122.15051, 37.91345], [-122.15067, 37.91336], [-122.1508, 37.91331], [-122.15093, 37.9132], [-122.15112, 37.91294], [-122.15129, 37.91276], [-122.15141, 37.91268], [-122.15173, 37.91256], [-122.15298, 37.91254], [-122.15334, 37.91257], [-122.15363, 37.91257], [-122.15418, 37.9127], [-122.15462, 37.91292], [-122.15559, 37.91319], [-122.15586, 37.91333], [-122.15636, 37.91343], [-122.15653, 37.91344], [-122.15685, 37.9134], [-122.15756, 37.9135], [-122.15813, 37.9136], [-122.15841, 37.91372], [-122.15882, 37.91396], [-122.15901, 37.91397], [-122.15914, 37.91394], [-122.1593, 37.91388], [-122.15958, 37.91383], [-122.15976, 37.91392], [-122.1601, 37.91419], [-122.16054, 37.91443]]]} | Restricted Access 2 | 315 | Russell Research Station (UC) | 24744 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Contra Costa 12 | 247.32 | Russell Research Station (UC) | None 17 | |||
190 | 190 | 189 | {"type": "Polygon", "coordinates": [[[-119.54817, 34.40521], [-119.54802, 34.4054], [-119.54792, 34.40532], [-119.54714, 34.40436], [-119.54706, 34.40429], [-119.54684, 34.40419], [-119.54661, 34.40416], [-119.54636, 34.40425], [-119.54631, 34.40432], [-119.54628, 34.40444], [-119.5462, 34.40436], [-119.54604, 34.40426], [-119.54606, 34.40336], [-119.54817, 34.40521]]]} | Open Access 1 | 524 | Santa Claus Lane Beach | 25061 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 209 | California State Lands Commission 73 | State 5 | State Agency 5 | Santa Barbara 7 | 1.665 | Santa Claus Lane Beach | None 20 | |||
192 | 192 | 191 | {"type": "Polygon", "coordinates": [[[-117.25358, 33.2577], [-117.25022, 33.25616], [-117.25015, 33.25611], [-117.25356, 33.2561], [-117.25358, 33.2577]]]} | Open Access 1 | 527 | San Luis Rey River | 24941 | 1230 | Oceanside, City of 77 | City 2 | City Agency 2 | http://www.ci.oceanside.ca.us/ | City 2 | 1230 | Oceanside, City of 75 | City 2 | City Agency 2 | San Diego 4 | 7.039 | San Luis Rey River | None 21 | |||
199 | 199 | 198 | {"type": "Polygon", "coordinates": [[[-120.16151, 34.59253], [-120.16137, 34.59261], [-120.16006, 34.59216], [-120.15908, 34.5915], [-120.15736, 34.59022], [-120.15748, 34.58949], [-120.15913, 34.59074], [-120.15995, 34.59087], [-120.16151, 34.59253]]]} | Open Access 1 | 629 | Santa Ynez River | 25146 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 8.216 | Santa Ynez River | None 22 | |||
219 | 219 | 218 | {"type": "Polygon", "coordinates": [[[-117.29114, 33.03378], [-117.29094, 33.03383], [-117.29088, 33.0337], [-117.29105, 33.03363], [-117.29114, 33.03378]]]} | Open Access 1 | 708 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.079 | Swami's Bluff Parcels | None 23 | ||
227 | 227 | 226 | {"type": "MultiPolygon", "coordinates": [[[[-119.78248, 37.95765], [-119.78191, 37.95774], [-119.78114, 37.95783], [-119.78088, 37.95784], [-119.78032, 37.95783], [-119.7788, 37.95773], [-119.77779, 37.95769], [-119.77739, 37.95773], [-119.77684, 37.95775], [-119.77654, 37.95778], [-119.77451, 37.95853], [-119.77303, 37.95905], [-119.77224, 37.95938], [-119.77154, 37.95973], [-119.77095, 37.9601], [-119.77031, 37.9606], [-119.76965, 37.96095], [-119.76909, 37.96116], [-119.76827, 37.96156], [-119.76719, 37.96184], [-119.7603, 37.9612], [-119.76012, 37.96098], [-119.75864, 37.96028], [-119.75808, 37.95992], [-119.75757, 37.95963], [-119.75713, 37.95931], [-119.75672, 37.95906], [-119.75653, 37.95869], [-119.75582, 37.9585], [-119.75505, 37.95834], [-119.75446, 37.95813], [-119.75295, 37.95779], [-119.75197, 37.9575], [-119.75103, 37.95729], [-119.75009, 37.95703], [-119.74941, 37.95675], [-119.74898, 37.95664], [-119.74817, 37.95632], [-119.74784, 37.95604], [-119.74696, 37.95583], [-119.74646, 37.95572], [-119.74605, 37.95559], [-119.74406, 37.95515], [-119.74327, 37.95488], [-119.74253, 37.95468], [-119.74158, 37.95439], [-119.741, 37.95434], [-119.74041, 37.95435], [-119.73979, 37.95428], [-119.73889, 37.95439], [-119.73595, 37.95427], [-119.73595, 37.95391], [-119.74675, 37.95382], [-119.75448, 37.95395], [-119.75458, 37.9576], [-119.7592, 37.9576], [-119.75913, 37.95395], [-119.77308, 37.95392], [-119.77303, 37.95029], [-119.77768, 37.95032], [-119.77759, 37.94668], [-119.78225, 37.94672], [-119.78248, 37.95765]]], [[[-119.81885, 37.92147], [-119.81426, 37.92147], [-119.81426, 37.91421], [-119.81878, 37.91418], [-119.81885, 37.92147]]], [[[-119.84421, 37.96202], [-119.83931, 37.96193], [-119.83906, 37.95843], [-119.83448, 37.95825], [-119.83392, 37.95451], [-119.8388, 37.9546], [-119.83854, 37.95078], [-119.84372, 37.95079], [-119.84421, 37.96202]]], [[[-119.86036, 37.88501], [-119.84605, 37.88385], [-119.84611, 37.88774], [-119.84145, 37.8879], [-119.8413, 37.88039], [-119.84594, 37.88019], [-119.84585, 37.87654], [-119.8589, 37.87761], [-119.86025, 37.87771], [-119.86036, 37.88501]]], [[[-119.87668, 37.9827], [-119.8765, 37.98991], [-119.86682, 37.9901], [-119.86222, 37.99016], [-119.86254, 37.98852], [-119.86222, 37.98852], [-119.86315, 37.98805], [-119.86371, 37.98559], [-119.8637, 37.98558], [-119.86245, 37.98563], [-119.86245, 37.98296], [-119.86269, 37.97934], [-119.87214, 37.97921], [-119.87188, 37.98279], [-119.87668, 37.9827]]], [[[-120.12683, 37.81255], [-120.12681, 37.81333], [-120.1246, 37.81356], [-120.12358, 37.81349], [-120.11945, 37.81378], [-120.11816, 37.81402], [-120.11734, 37.8142], [-120.11595, 37.81463], [-120.11594, 37.81464], [-120.11624, 37.81517], [-120.11584, 37.81586], [-120.11552, 37.81623], [-120.11491, 37.81666], [-120.11067, 37.81676], [-120.11065, 37.81743], [-120.11024, 37.81743], [-120.10924, 37.81763], [-120.10873, 37.8177], [-120.10829, 37.8179], [-120.10831, 37.81866], [-120.10829, 37.8197], [-120.10723, 37.82005], [-120.1037, 37.82007], [-120.10369, 37.81959], [-120.10472, 37.81846], [-120.10506, 37.81819], [-120.1054, 37.81807], [-120.10557, 37.81803], [-120.10586, 37.81803], [-120.1062, 37.81811], [-120.10644, 37.81813], [-120.10674, 37.81812], [-120.10696, 37.81798], [-120.10817, 37.81751], [-120.10876, 37.81735], [-120.10895, 37.81728], [-120.10901, 37.8174], [-120.10927, 37.81734], [-120.11024, 37.81679], [-120.11052, 37.81661], [-120.11262, 37.81588], [-120.11356, 37.81545], [-120.11529, 37.81429], [-120.11538, 37.81417], [-120.11563, 37.814], [-120.11601, 37.81388], [-120.11636, 37.81372], [-120.11735, 37.81337], [-120.11953, 37.81312], [-120.11978, 37.81308], [-120.12037, 37.81291], [-120.12111, 37.81278], [-120.12197, 37.81273], [-120.12525, 37.81259], [-120.12683, 37.81255]]], [[[-120.15014, 37.82682], [-120.14782, 37.8271], [-120.1454, 37.82736], [-120.14411, 37.82748], [-120.14069, 37.82782], [-120.14069, 37.8275], [-120.14087, 37.82751], [-120.14154, 37.82747], [-120.14256, 37.82735], [-120.14749, 37.82689], [-120.15012, 37.8266], [-120.15014, 37.82682]]], [[[-120.17722, 37.83941], [-120.17684, 37.83942], [-120.17605, 37.83901], [-120.17507, 37.83868], [-120.17411, 37.83848], [-120.1733, 37.838], [-120.17323, 37.83688], [-120.17309, 37.83604], [-120.17225, 37.83522], [-120.17193, 37.83439], [-120.17183, 37.83408], [-120.17074, 37.83358], [-120.16942, 37.83328], [-120.16895, 37.83314], [-120.16896, 37.83286], [-120.16925, 37.83291], [-120.1695, 37.83301], [-120.17039, 37.8333], [-120.17157, 37.83356], [-120.17167, 37.83361], [-120.17194, 37.83378], [-120.17211, 37.83399], [-120.17217, 37.83412], [-120.17232, 37.83485], [-120.17239, 37.83502], [-120.17254, 37.83522], [-120.17265, 37.8353], [-120.17336, 37.83597], [-120.17353, 37.83621], [-120.17361, 37.83641], [-120.17364, 37.83654], [-120.17364, 37.83669], [-120.17363, 37.83682], [-120.1736, 37.83691], [-120.17348, 37.83711], [-120.17344, 37.83721], [-120.17342, 37.83728], [-120.17342, 37.83748], [-120.17347, 37.83769], [-120.17355, 37.83783], [-120.17365, 37.83795], [-120.17383, 37.83808], [-120.174, 37.83817], [-120.17484, 37.83834], [-120.17573, 37.83867], [-120.17664, 37.83898], [-120.17692, 37.83914], [-120.17702, 37.83922], [-120.17714, 37.83932], [-120.17722, 37.83941]]], [[[-120.21037, 37.81981], [-120.21034, 37.82012], [-120.20255, 37.82157], [-120.19985, 37.82195], [-120.20219, 37.82485], [-120.20173, 37.82485], [-120.19999, 37.82285], [-120.19998, 37.82287], [-120.20014, 37.82339], [-120.19922, 37.82363], [-120.19953, 37.82399], [-120.19979, 37.82441], [-120.19949, 37.82455], [-120.19901, 37.82447], [-120.1989, 37.82469], [-120.19872, 37.82419], [-120.19882, 37.82368], [-120.19704, 37.82292], [-120.19707, 37.82238], [-120.19657, 37.82229], [-120.19657, 37.82204], [-120.19702, 37.822], [-120.19706, 37.82181], [-120.19861, 37.82166], [-120.19862, 37.82143], [-120.19929, 37.82133], [-120.19937, 37.82165], [-120.20096, 37.82146], [-120.20257, 37.82125], [-120.21037, 37.81981]]], [[[-120.23699, 37.83811], [-120.23636, 37.83847], [-120.23608, 37.8386], [-120.23537, 37.83888], [-120.23469, 37.83909], [-120.23434, 37.83922], [-120.23383, 37.83927], [-120.23374, 37.83925], [-120.23328, 37.83907], [-120.23304, 37.83907], [-120.23286, 37.83912], [-120.23268, 37.83924], [-120.23261, 37.83941], [-120.23255, 37.83967], [-120.23246, 37.83986], [-120.23224, 37.84007], [-120.23213, 37.84013], [-120.23194, 37.84021], [-120.23166, 37.84027], [-120.23156, 37.84027], [-120.23105, 37.84017], [-120.23096, 37.84017], [-120.22998, 37.84046], [-120.22998, 37.84048], [-120.23026, 37.84045], [-120.23022, 37.84099], [-120.22955, 37.84118], [-120.22949, 37.84054], [-120.22896, 37.8407], [-120.22882, 37.84046], [-120.23099, 37.83988], [-120.2312, 37.8399], [-120.23165, 37.83998], [-120.23177, 37.83997], [-120.23195, 37.83991], [-120.23209, 37.83981], [-120.23222, 37.83965], [-120.23224, 37.83945], [-120.23229, 37.83927], [-120.23234, 37.83917], [-120.23247, 37.83901], [-120.23267, 37.83887], [-120.23287, 37.8388], [-120.23299, 37.83877], [-120.23322, 37.83877], [-120.23339, 37.8388], [-120.23347, 37.83882], [-120.23368, 37.83889], [-120.23389, 37.83899], [-120.23397, 37.83901], [-120.234, 37.83907], [-120.23407, 37.83908], [-120.23421, 37.83906], [-120.23433, 37.83903], [-120.23489, 37.83882], [-120.23488, 37.83876], [-120.23597, 37.83833], [-120.23649, 37.83806], [-120.23698, 37.83775], [-120.23699, 37.83811]]], [[[-120.25749, 37.82776], [-120.25721, 37.82808], [-120.25681, 37.82809], [-120.25739, 37.8276], [-120.25749, 37.82776]]], [[[-120.25981, 37.82614], [-120.25924, 37.82696], [-120.25895, 37.82759], [-120.25751, 37.8276], [-120.25747, 37.82751], [-120.25777, 37.82709], [-120.25796, 37.82686], [-120.25825, 37.82645], [-120.25831, 37.8264], [-120.2584, 37.8264], [-120.25848, 37.82636], [-120.2586, 37.82624], [-120.25895, 37.82598], [-120.25981, 37.82614]]], [[[-120.27489, 37.80614], [-120.27406, 37.80726], [-120.27256, 37.80864], [-120.27257, 37.80912], [-120.27216, 37.80916], [-120.2715, 37.81021], [-120.27171, 37.81044], [-120.27472, 37.81163], [-120.27473, 37.81233], [-120.27386, 37.81281], [-120.27232, 37.81374], [-120.2716, 37.81391], [-120.27119, 37.81346], [-120.27105, 37.81333], [-120.27042, 37.81346], [-120.27022, 37.81348], [-120.26932, 37.81365], [-120.26926, 37.81112], [-120.26928, 37.81], [-120.26467, 37.80999], [-120.26435, 37.80997], [-120.26431, 37.80629], [-120.25979, 37.80623], [-120.25979, 37.80548], [-120.25939, 37.80563], [-120.2594, 37.80488], [-120.25964, 37.80477], [-120.25985, 37.8047], [-120.26049, 37.80443], [-120.25943, 37.8026], [-120.26025, 37.80172], [-120.26005, 37.80147], [-120.25993, 37.80124], [-120.25972, 37.80109], [-120.25927, 37.80096], [-120.25927, 37.80071], [-120.25986, 37.80084], [-120.26014, 37.80102], [-120.26031, 37.80124], [-120.26036, 37.8014], [-120.26047, 37.80152], [-120.26189, 37.80062], [-120.26363, 37.7995], [-120.26411, 37.79928], [-120.2642, 37.79922], [-120.26428, 37.80258], [-120.26921, 37.8027], [-120.26922, 37.80246], [-120.26917, 37.79958], [-120.26919, 37.79941], [-120.26982, 37.79945], [-120.26988, 37.80024], [-120.2715, 37.80102], [-120.27278, 37.80276], [-120.27408, 37.80432], [-120.27439, 37.80542], [-120.27489, 37.80614]], [[-120.25998, 37.8061], [-120.26, 37.8061], [-120.26034, 37.80525], [-120.25998, 37.8054], [-120.25998, 37.8061]]], [[[-120.26282, 37.8227], [-120.26236, 37.82261], [-120.26216, 37.82238], [-120.26206, 37.82225], [-120.2619, 37.8221], [-120.26175, 37.82193], [-120.26165, 37.82169], [-120.26165, 37.82162], [-120.26165, 37.82151], [-120.26181, 37.82087], [-120.26215, 37.82087], [-120.26198, 37.82158], [-120.26197, 37.82165], [-120.26198, 37.8217], [-120.26202, 37.8218], [-120.26209, 37.82189], [-120.26227, 37.82206], [-120.26282, 37.8227]]], [[[-120.31147, 37.8132], [-120.31114, 37.81342], [-120.30983, 37.8125], [-120.30943, 37.81245], [-120.30958, 37.81274], [-120.30982, 37.81308], [-120.31022, 37.81349], [-120.31047, 37.81372], [-120.31049, 37.81378], [-120.30985, 37.81322], [-120.30863, 37.81205], [-120.30854, 37.8119], [-120.30841, 37.81145], [-120.30776, 37.81102], [-120.30699, 37.8104], [-120.30573, 37.81221], [-120.30627, 37.8124], [-120.30678, 37.81266], [-120.3072, 37.81318], [-120.30727, 37.81353], [-120.30655, 37.81343], [-120.30653, 37.81291], [-120.30142, 37.81283], [-120.29999, 37.81283], [-120.29887, 37.81286], [-120.29624, 37.8129], [-120.29586, 37.8126], [-120.2954, 37.81227], [-120.29312, 37.81041], [-120.29215, 37.80964], [-120.29207, 37.8097], [-120.29201, 37.80912], [-120.28667, 37.80904], [-120.28715, 37.81262], [-120.27683, 37.81248], [-120.27681, 37.80891], [-120.28132, 37.80898], [-120.28171, 37.80897], [-120.28172, 37.80895], [-120.28146, 37.80542], [-120.27675, 37.80535], [-120.27671, 37.80178], [-120.27701, 37.8018], [-120.28035, 37.80181], [-120.28129, 37.80185], [-120.28129, 37.801], [-120.28142, 37.80089], [-120.28156, 37.80081], [-120.28134, 37.80051], [-120.28269, 37.80025], [-120.2831, 37.80016], [-120.28244, 37.79947], [-120.28142, 37.79968], [-120.28114, 37.79831], [-120.28522, 37.79834], [-120.29614, 37.79847], [-120.29652, 37.79846], [-120.297, 37.79848], [-120.29725, 37.80562], [-120.30179, 37.80569], [-120.30176, 37.8074], [-120.30751, 37.80732], [-120.30856, 37.80739], [-120.30862, 37.8106], [-120.30975, 37.81069], [-120.31111, 37.81148], [-120.31147, 37.8132]], [[-120.29232, 37.80261], [-120.2914, 37.80229], [-120.29121, 37.80238], [-120.29098, 37.80252], [-120.29194, 37.80319], [-120.29254, 37.80279], [-120.29232, 37.80261]]], [[[-120.32796, 37.80551], [-120.3276, 37.80556], [-120.32758, 37.80528], [-120.32794, 37.80525], [-120.32796, 37.80551]]], [[[-120.4079, 37.79822], [-120.40753, 37.79825], [-120.40687, 37.79827], [-120.40677, 37.79754], [-120.40774, 37.79766], [-120.40778, 37.79759], [-120.40783, 37.79723], [-120.40781, 37.79697], [-120.40774, 37.79667], [-120.40756, 37.79638], [-120.40741, 37.7962], [-120.40723, 37.79605], [-120.40707, 37.79593], [-120.40743, 37.7959], [-120.40755, 37.79597], [-120.40772, 37.79613], [-120.40792, 37.79639], [-120.40803, 37.7966], [-120.40808, 37.79666], [-120.40816, 37.79688], [-120.40819, 37.79704], [-120.40821, 37.79736], [-120.40821, 37.79744], [-120.40817, 37.79766], [-120.4081, 37.79787], [-120.4079, 37.79822]]], [[[-120.5453, 37.8063], [-120.54393, 37.8097], [-120.54171, 37.80978], [-120.54178, 37.80813], [-120.53933, 37.80807], [-120.53929, 37.80704], [-120.5418, 37.80706], [-120.54182, 37.80634], [-120.5453, 37.8063]]], [[[-120.60815, 37.79881], [-120.60113, 37.80196], [-120.60157, 37.8032], [-120.59639, 37.8047], [-120.59213, 37.80472], [-120.59216, 37.80257], [-120.60009, 37.79989], [-120.60088, 37.80139], [-120.60752, 37.79831], [-120.60815, 37.79881]]]]} | Restricted Access 2 | 616 | Hetch Hetchy Water and Power | 19888 | 321 | San Francisco - Public Utilities Commission, City and County of 31 | County 3 | County Agency - Other 9 | http://sfwater.org/ | County 3 | 321 | San Francisco - Public Utilities Commission, City and County of 30 | County 3 | County Agency - Other 8 | Tuolumne 21 | 2706.955 | Hetch Hetchy Water and Power | None 25 | |||
228 | 228 | 227 | {"type": "Polygon", "coordinates": [[[-122.33028, 41.31414], [-122.32908, 41.31415], [-122.32909, 41.31022], [-122.32966, 41.31067], [-122.33018, 41.31094], [-122.33021, 41.31196], [-122.33028, 41.31197], [-122.33028, 41.31414]]]} | No Public Access 3 | 621 | Elsa Rupp Natural Area | 32160 | 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 | Siskiyou 28 | 9.475 | Elsa Rupp Natural Area | None 26 | |||
255 | 255 | 254 | {"type": "Polygon", "coordinates": [[[-117.29084, 33.0333], [-117.2907, 33.03336], [-117.29031, 33.03261], [-117.29033, 33.03255], [-117.29053, 33.03288], [-117.29071, 33.03315], [-117.29084, 33.0333]]]} | Open Access 1 | 709 | Swami's Bluff Parcels | 26094 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | http://www.encinitasca.gov/Resident/Parks-Beaches-Trails/Beaches | San Diego 4 | 0.184 | Swami's Bluff Parcels | None 27 | ||
260 | 260 | 259 | {"type": "MultiPolygon", "coordinates": [[[[-122.03147, 37.05364], [-122.03119, 37.05372], [-122.03074, 37.05397], [-122.03059, 37.05423], [-122.0306, 37.05358], [-122.03147, 37.05364]]], [[[-122.03519, 37.05382], [-122.03465, 37.05395], [-122.03443, 37.05404], [-122.03426, 37.05419], [-122.03406, 37.05445], [-122.03093, 37.05448], [-122.03136, 37.05427], [-122.0318, 37.05403], [-122.03213, 37.05418], [-122.03226, 37.05404], [-122.03245, 37.05415], [-122.03292, 37.05367], [-122.03343, 37.05332], [-122.03375, 37.05305], [-122.03394, 37.05284], [-122.03411, 37.05261], [-122.03426, 37.05236], [-122.03449, 37.05243], [-122.03454, 37.05232], [-122.03473, 37.05251], [-122.03519, 37.05382]]]]} | Open Access 1 | 876 | Skypark | 25545 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 9.029 | Skypark | None 28 | |||
272 | 272 | 271 | {"type": "Polygon", "coordinates": [[[-119.30083, 34.27437], [-119.30048, 34.27445], [-119.29837, 34.27477], [-119.29821, 34.27482], [-119.29805, 34.27491], [-119.2979, 34.27501], [-119.29779, 34.27512], [-119.29779, 34.27435], [-119.29933, 34.27392], [-119.30016, 34.27382], [-119.30083, 34.27383], [-119.30083, 34.27437]]]} | Open Access 1 | 742 | Surfer's Point | 30395 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 4.99 | Surfer's Point | None 29 | |||
280 | 280 | 279 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | 956 | South Monterey Dunes | 25664 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.07 | South Monterey Dunes | None 30 | |||
284 | 284 | 283 | {"type": "Polygon", "coordinates": [[[-116.4753, 32.60867], [-116.47487, 32.60888], [-116.47435, 32.60914], [-116.47431, 32.60887], [-116.47465, 32.60861], [-116.47505, 32.60838], [-116.4753, 32.60867]]]} | Open Access 1 | 766 | Campo Stone Store | 29229 | 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://ohp.parks.ca.gov/ListedResources/Detail/411 | San Diego 4 | 0.82 | Campo Stone Store | None 31 | ||
309 | 309 | 308 | {"type": "MultiPolygon", "coordinates": [[[[-118.61084, 34.27479], [-118.61063, 34.27477], [-118.6103, 34.2747], [-118.61002, 34.27455], [-118.60985, 34.27432], [-118.60969, 34.27388], [-118.60882, 34.27411], [-118.60768, 34.27363], [-118.60854, 34.27246], [-118.61002, 34.27238], [-118.61055, 34.2723], [-118.61121, 34.27215], [-118.61124, 34.27217], [-118.6114, 34.27269], [-118.61141, 34.27284], [-118.6114, 34.27299], [-118.61132, 34.2732], [-118.61092, 34.27389], [-118.61081, 34.27412], [-118.61077, 34.27429], [-118.61077, 34.27446], [-118.61079, 34.27463], [-118.61084, 34.27479]]], [[[-118.61416, 34.27267], [-118.61344, 34.27333], [-118.61346, 34.27364], [-118.61289, 34.27408], [-118.61233, 34.27387], [-118.61196, 34.27395], [-118.61208, 34.27432], [-118.61183, 34.27461], [-118.61168, 34.27461], [-118.61157, 34.2747], [-118.61155, 34.27488], [-118.61138, 34.27494], [-118.61124, 34.27489], [-118.61114, 34.27493], [-118.61105, 34.27475], [-118.611, 34.27459], [-118.61098, 34.27435], [-118.61101, 34.27419], [-118.61111, 34.27396], [-118.61152, 34.27327], [-118.61158, 34.2731], [-118.61162, 34.27293], [-118.61161, 34.27269], [-118.61144, 34.27212], [-118.61146, 34.27209], [-118.61246, 34.27186], [-118.61282, 34.27184], [-118.61306, 34.27186], [-118.61321, 34.27194], [-118.61333, 34.27204], [-118.61343, 34.27216], [-118.61358, 34.27242], [-118.61368, 34.27252], [-118.61379, 34.27259], [-118.61393, 34.27264], [-118.61416, 34.27267]]]]} | Open Access 1 | 826 | Garden of the Gods | 29624 | 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 | 27.234 | Garden of the Gods | None 32 | |||
325 | 325 | 324 | {"type": "Polygon", "coordinates": [[[-122.0502, 36.9496], [-122.04978, 36.94953], [-122.04949, 36.94929], [-122.04942, 36.94927], [-122.04942, 36.94924], [-122.04951, 36.94925], [-122.04961, 36.94935], [-122.04967, 36.94936], [-122.04979, 36.94944], [-122.04993, 36.94948], [-122.05019, 36.9495], [-122.0502, 36.9496]]]} | Open Access 1 | 1106 | Stockton Avenue Beach | 25857 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Santa Cruz 5 | 0.139 | Stockton Avenue Beach | None 33 | ||||
343 | 343 | 342 | {"type": "Polygon", "coordinates": [[[-119.06923, 36.07235], [-119.06918, 36.07236], [-119.06918, 36.07248], [-119.06778, 36.07246], [-119.06781, 36.07093], [-119.06922, 36.07094], [-119.06923, 36.07235]]]} | Open Access 1 | 1167 | Burton Ballfields | 16529 | 1260 | Porterville, City of 139 | City 2 | City Agency 2 | http://www.ci.porterville.ca.us/ | City 2 | 1260 | Porterville, City of 136 | City 2 | City Agency 2 | Tulare 29 | 5.41 | Burton Ballfields | None 34 |
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]);