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_AG_TYP >30
- City Agency 8,556
- State Agency 1,055
- Recreation/Parks District 1,046
- County Agency 1,037
- Non Profit - Land Trust 543
- Federal Agency 463
- Open Space District 395
- Water District 224
- County Agency - Parks 215
- Community Services District 191
- Home Owners Association 187
- Non Profit - Conservation 140
- Flood District 98
- Non Profit - Other 43
- Irrigation District 39
- School District 37
- Cemetery District 34
- County Agency - Other 28
- Port/Harbor District 28
- Special District - Other 15
- Commercial 14
- Sanitation District 7
- Joint Powers Authority 7
- 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 457
- California Department of Fish and Wildlife 408
- Los Angeles, City of 389
- California Department of Parks and Recreation 355
- Mountains Recreation and Conservation Authority 321
- Sacramento, City of 220
- San Jose, City of 196
- San Francisco, City and County of 165
- East Bay Regional Park District 162
- Los Angeles, County of 139
- Ventura, City of 134
- Roseville, City of 130
- Long Beach, City of 126
- United States Bureau of Land Management 112
- Oakland, City of 102
- San Diego, County of 102
- Santa Barbara, County of 98
- United States Forest Service 98
- Consumnes Community Services District 94
- California State Lands Commission 81
- Orange, County of 81
- Napa, City of 80
- United States Fish and Wildlife Service 78
- United States National Park Service 74
- Irvine, City of 74
- Modesto, City of 74
- Hayward Area Recreation and Park District 69
- Tracy, City of 65
- Valley-Wide Recreation and Park District 64
- Davis, City of 64
- …
DES_TP >30
- Local Park 7,465
- Local Recreation Area 1,791
- Local Other or Unknown 1,156
- Private Conservation 569
- Local Conservation Area 431
- State Conservation Area 357
- Private Recreation or Education 247
- State Park 194
- State Resource Management Area 147
- State Recreation Area 132
- National Forest 85
- Local Historic or Cultural Area 74
- National Wildlife Refuge 71
- National Public Lands 68
- State Other or Unknown 67
- State Historic or Cultural Area 61
- Recreation Management Area 52
- Private Other or Unknown 51
- National Monument or Landmark 38
- National Recreation Area 35
- Resource Management Area 23
- Federal Other or Unknown 23
- National Park 22
- Local Resource Management Area 21
- Conservation Area 12
- Private Agricultural 12
- Area of Critical Environmental Concern 7
- Wilderness Area 5
- Historic or Cultural Area 5
- Private Historic or Cultural 4
- …
ACCESS_TYP 4
- Open Access 12,080
- Restricted Access 1,103
- No Public Access 883
- Unknown Access 369
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2634 | 2634 | 2633 | {"type": "Polygon", "coordinates": [[[-119.66697, 36.81099], [-119.66697, 36.81158], [-119.66646, 36.81159], [-119.66647, 36.81091], [-119.66697, 36.81099]]]} | Open Access 1 | 18063 | Silverton II Park | 25500 | 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 | Fresno 9 | 0.783 | Silverton II Park | 0 | Local Park 2 | 4 | |
2635 | 2635 | 2634 | {"type": "Polygon", "coordinates": [[[-121.19149, 38.80011], [-121.1911, 38.80088], [-121.1908, 38.80122], [-121.18981, 38.80258], [-121.18969, 38.80269], [-121.18665, 38.80518], [-121.18527, 38.80442], [-121.18256, 38.80439], [-121.18249, 38.80331], [-121.18259, 38.79922], [-121.18607, 38.79906], [-121.18761, 38.79897], [-121.18885, 38.79896], [-121.18883, 38.80012], [-121.19149, 38.80011]]]} | Open Access 1 | 20824 | Indian Creek County Club | 20199 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | Placer 35 | 92.67 | Indian Creek County Club | 0 | Local Recreation Area 3 | 4 | |
2636 | 2636 | 2635 | {"type": "MultiPolygon", "coordinates": [[[[-121.61831, 36.69338], [-121.61761, 36.69403], [-121.61403, 36.69597], [-121.61392, 36.6958], [-121.61391, 36.69579], [-121.61567, 36.69485], [-121.6171, 36.69406], [-121.6173, 36.69392], [-121.61811, 36.69316], [-121.61831, 36.69338]]], [[[-121.61389, 36.69605], [-121.61398, 36.69617], [-121.61399, 36.69622], [-121.6138, 36.69664], [-121.61366, 36.69682], [-121.61354, 36.69691], [-121.61224, 36.69769], [-121.61221, 36.69772], [-121.61219, 36.69777], [-121.6122, 36.69782], [-121.61223, 36.69787], [-121.6123, 36.69794], [-121.61244, 36.69854], [-121.61242, 36.6986], [-121.61238, 36.69862], [-121.61191, 36.69877], [-121.61152, 36.69893], [-121.61115, 36.69912], [-121.6108, 36.69933], [-121.61052, 36.69953], [-121.61022, 36.69979], [-121.60994, 36.70006], [-121.60963, 36.70042], [-121.60958, 36.70045], [-121.60951, 36.70044], [-121.60933, 36.70036], [-121.60903, 36.70017], [-121.60877, 36.69998], [-121.6085, 36.69974], [-121.60807, 36.69925], [-121.60768, 36.69886], [-121.60741, 36.69864], [-121.60712, 36.69844], [-121.60678, 36.69815], [-121.60676, 36.69812], [-121.60678, 36.69805], [-121.60722, 36.69768], [-121.60742, 36.69757], [-121.60766, 36.69747], [-121.60782, 36.69743], [-121.60803, 36.69741], [-121.60909, 36.69738], [-121.60932, 36.69736], [-121.60954, 36.69732], [-121.6099, 36.69718], [-121.61026, 36.69698], [-121.61088, 36.69651], [-121.61103, 36.69634], [-121.61118, 36.69609], [-121.61144, 36.69619], [-121.61159, 36.69618], [-121.61213, 36.69674], [-121.61376, 36.69587], [-121.61389, 36.69605]]], [[[-121.60852, 36.70026], [-121.60793, 36.70025], [-121.60751, 36.70054], [-121.60689, 36.70069], [-121.6058, 36.70021], [-121.60548, 36.70024], [-121.60414, 36.70136], [-121.60335, 36.70226], [-121.60245, 36.70255], [-121.60136, 36.70126], [-121.60147, 36.70119], [-121.60192, 36.70118], [-121.60222, 36.70114], [-121.60278, 36.70129], [-121.60373, 36.70075], [-121.60391, 36.70048], [-121.60433, 36.70024], [-121.60516, 36.69869], [-121.60542, 36.69875], [-121.60555, 36.69875], [-121.60568, 36.69872], [-121.60581, 36.69868], [-121.60638, 36.69836], [-121.60646, 36.69837], [-121.60651, 36.69839], [-121.6068, 36.69865], [-121.60737, 36.69907], [-121.60763, 36.69932], [-121.60822, 36.7], [-121.60852, 36.70026]]]]} | Open Access 1 | 18074 | Natividad Creek Park | 22663 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 59.11 | Natividad Creek Park | 0 | Local Park 2 | 4 | |
2637 | 2637 | 2636 | {"type": "Polygon", "coordinates": [[[-122.93426, 38.43681], [-122.93107, 38.43684], [-122.92903, 38.43689], [-122.92899, 38.4368], [-122.92897, 38.4367], [-122.92903, 38.43623], [-122.92908, 38.43609], [-122.92928, 38.43568], [-122.92964, 38.43476], [-122.92971, 38.43446], [-122.92971, 38.43416], [-122.92954, 38.43343], [-122.92954, 38.43324], [-122.93106, 38.43321], [-122.93269, 38.43323], [-122.93271, 38.43595], [-122.93425, 38.43597], [-122.93426, 38.43681]]]} | Restricted Access 2 | 3289 | Harrison Grade Ecological Reserve | 19698 | 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 | Sonoma 16 | 31.802 | Harrison Grade ER | 0 | State Conservation Area 8 | 2 | |
2638 | 2638 | 2637 | {"type": "Polygon", "coordinates": [[[-122.06068, 36.95436], [-122.06068, 36.9544], [-122.06006, 36.95439], [-122.05945, 36.95444], [-122.05875, 36.95451], [-122.05874, 36.95447], [-122.0599, 36.95436], [-122.06068, 36.95436]]]} | Open Access 1 | 18084 | Natural Bridges State Beach | 22670 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.parks.ca.gov/?page_id=541 | Santa Cruz 5 | 0.17 | Natural Bridges SB | 1933 | None 216 | |
2639 | 2639 | 2638 | {"type": "Polygon", "coordinates": [[[-118.83534, 34.17548], [-118.83489, 34.17589], [-118.83416, 34.17534], [-118.83469, 34.17485], [-118.8349, 34.17502], [-118.83506, 34.17527], [-118.83534, 34.17548]]]} | Open Access 1 | 18131 | North Ranch - Hillcrest Subarea | 22850 | 1347 | Thousand Oaks, City of 428 | City 2 | City Agency 2 | http://www.ci.thousand-oaks.ca.us/ | City 2 | 1347 | Thousand Oaks, City of 422 | City 2 | City Agency 2 | Ventura 8 | 1.497 | North Ranch - Hillcrest Subarea | None 217 | |||
2640 | 2640 | 2639 | {"type": "Polygon", "coordinates": [[[-121.33746, 38.80162], [-121.33738, 38.8016], [-121.33727, 38.80178], [-121.33701, 38.80169], [-121.33682, 38.80167], [-121.33667, 38.8017], [-121.33646, 38.80179], [-121.33611, 38.80189], [-121.33569, 38.80158], [-121.33557, 38.80162], [-121.33532, 38.80198], [-121.33521, 38.8022], [-121.33504, 38.80276], [-121.33491, 38.80291], [-121.33476, 38.80304], [-121.3346, 38.80308], [-121.3345, 38.80316], [-121.33439, 38.80316], [-121.33403, 38.80308], [-121.33371, 38.8032], [-121.33356, 38.80327], [-121.3333, 38.8033], [-121.33319, 38.80335], [-121.33319, 38.80336], [-121.33327, 38.8034], [-121.33342, 38.80353], [-121.33327, 38.80373], [-121.33341, 38.80391], [-121.33373, 38.80471], [-121.33429, 38.80553], [-121.33418, 38.80554], [-121.33364, 38.80475], [-121.33336, 38.8042], [-121.33317, 38.80392], [-121.33319, 38.80381], [-121.33317, 38.80369], [-121.333, 38.80339], [-121.333, 38.80329], [-121.33291, 38.80317], [-121.33277, 38.80312], [-121.33252, 38.8032], [-121.3322, 38.8032], [-121.33214, 38.80307], [-121.33211, 38.80285], [-121.33204, 38.80268], [-121.33186, 38.80262], [-121.3318, 38.80252], [-121.33154, 38.80243], [-121.33135, 38.80239], [-121.33112, 38.80246], [-121.3307, 38.80269], [-121.3306, 38.80269], [-121.33038, 38.80264], [-121.33002, 38.80262], [-121.32972, 38.80215], [-121.33008, 38.80202], [-121.33031, 38.80215], [-121.33057, 38.80222], [-121.33078, 38.80224], [-121.33111, 38.8022], [-121.33128, 38.8022], [-121.33193, 38.8023], [-121.33194, 38.80232], [-121.33213, 38.80231], [-121.33239, 38.80227], [-121.33265, 38.80219], [-121.33299, 38.80201], [-121.33313, 38.80191], [-121.33326, 38.80175], [-121.33334, 38.80158], [-121.33336, 38.80138], [-121.33332, 38.80121], [-121.33325, 38.80108], [-121.33315, 38.80096], [-121.33271, 38.80058], [-121.33251, 38.80045], [-121.33298, 38.80021], [-121.3329, 38.79994], [-121.33309, 38.79935], [-121.33297, 38.79919], [-121.33319, 38.79911], [-121.33374, 38.79925], [-121.3338, 38.79908], [-121.33396, 38.79895], [-121.33426, 38.79902], [-121.33435, 38.7988], [-121.33426, 38.79856], [-121.33422, 38.79829], [-121.33428, 38.798], [-121.33453, 38.79801], [-121.33476, 38.79804], [-121.33495, 38.79809], [-121.33516, 38.79817], [-121.33688, 38.79907], [-121.3371, 38.79922], [-121.33729, 38.7994], [-121.33738, 38.79952], [-121.33747, 38.79968], [-121.33754, 38.79988], [-121.33757, 38.80005], [-121.33759, 38.80119], [-121.33755, 38.80141], [-121.33746, 38.80162]]]} | Open Access 1 | 20852 | William "Bill" Hughes Park | 27535 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 44.252 | William "Bill" Hughes Park | 0 | Local Park 2 | 4 | |
2641 | 2641 | 2640 | {"type": "Polygon", "coordinates": [[[-121.3441, 38.77738], [-121.34408, 38.77766], [-121.34393, 38.77766], [-121.34396, 38.77738], [-121.3441, 38.77738]]]} | Open Access 1 | 20860 | Diamond Oaks | 18143 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.102 | Diamond Oaks | None 218 | |||
2642 | 2642 | 2641 | {"type": "Polygon", "coordinates": [[[-121.77036, 36.91276], [-121.76966, 36.91462], [-121.76892, 36.91543], [-121.7689, 36.91534], [-121.76866, 36.91515], [-121.76852, 36.91508], [-121.76829, 36.91459], [-121.76808, 36.91466], [-121.76782, 36.91477], [-121.76745, 36.91502], [-121.7671, 36.91554], [-121.7647, 36.91517], [-121.76472, 36.91506], [-121.765, 36.91488], [-121.76512, 36.91478], [-121.76522, 36.91467], [-121.76527, 36.91454], [-121.76553, 36.91449], [-121.76587, 36.91445], [-121.766, 36.91442], [-121.766, 36.9144], [-121.76584, 36.91429], [-121.766, 36.91417], [-121.76598, 36.91414], [-121.76635, 36.9138], [-121.76642, 36.91384], [-121.7669, 36.91348], [-121.76923, 36.91496], [-121.76958, 36.91459], [-121.76852, 36.91389], [-121.76951, 36.91258], [-121.77036, 36.91276]]]} | Open Access 1 | 18092 | Neary Lagoon Park | 22681 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 15.376 | Neary Lagoon Park | 0 | Local Park 2 | 4 | |
2643 | 2643 | 2642 | {"type": "Polygon", "coordinates": [[[-121.07603, 37.39301], [-121.07567, 37.39319], [-121.07512, 37.39252], [-121.07553, 37.39229], [-121.07603, 37.39291], [-121.07603, 37.39301]]]} | Open Access 1 | 18132 | Bonita Park | 16261 | 329 | Stanislaus, County of 505 | County 3 | County Agency 3 | http://www.stancounty.com/er/parks/ | County 3 | 329 | Stanislaus, County of 497 | County 3 | County Agency 3 | Stanislaus 2 | 0.972 | Bonita Park | 0 | Local Park 2 | 4 | |
2644 | 2644 | 2643 | {"type": "Polygon", "coordinates": [[[-120.43985, 34.98228], [-120.43978, 34.98591], [-120.43553, 34.98588], [-120.43551, 34.98453], [-120.43552, 34.98379], [-120.43542, 34.98223], [-120.43985, 34.98228]]]} | Open Access 1 | 18812 | Preisker Park | 23981 | 1322 | Santa Maria, City of 36 | City 2 | City Agency 2 | http://www.cityofsantamaria.org/209.shtml | City 2 | 1322 | Santa Maria, City of 35 | City 2 | City Agency 2 | Santa Barbara 7 | 39.341 | Preisker Park | 0 | Local Park 2 | 4 | |
2645 | 2645 | 2644 | {"type": "Polygon", "coordinates": [[[-121.27306, 38.75203], [-121.27181, 38.75204], [-121.27181, 38.75184], [-121.27082, 38.75101], [-121.27076, 38.75092], [-121.27152, 38.75045], [-121.2716, 38.75057], [-121.27169, 38.75052], [-121.27177, 38.75059], [-121.27186, 38.75064], [-121.27206, 38.75069], [-121.27228, 38.75067], [-121.27264, 38.75054], [-121.27306, 38.75203]]]} | Open Access 1 | 20901 | Lincoln Estates Park | 21248 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 5.411 | Lincoln Estates Park | 0 | Local Park 2 | 4 | |
2646 | 2646 | 2645 | {"type": "Polygon", "coordinates": [[[-119.68973, 36.84654], [-119.68973, 36.84842], [-119.68867, 36.84844], [-119.68868, 36.84677], [-119.68875, 36.84667], [-119.68892, 36.84656], [-119.68973, 36.84654]]]} | Open Access 1 | 18107 | Stanford El Paso Park | 25786 | 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 | Fresno 9 | 4.823 | Stanford El Paso Park | 0 | Local Park 2 | 4 | |
2647 | 2647 | 2646 | {"type": "Polygon", "coordinates": [[[-118.03613, 34.06478], [-118.03686, 34.06474], [-118.03691, 34.06477], [-118.0369, 34.06637], [-118.03687, 34.06641], [-118.03654, 34.06638], [-118.03614, 34.06638], [-118.0361, 34.06635], [-118.0361, 34.0657], [-118.03603, 34.065], [-118.03613, 34.06478]]]} | Open Access 1 | 18108 | Arceo Park | 15573 | 1095 | El Monte, City of 240 | City 2 | City Agency 2 | http://ci.el-monte.ca.us/Government/ParksandRecreation/ParksRecreation.aspx | City 2 | 1095 | El Monte, City of 236 | City 2 | City Agency 2 | Los Angeles 6 | 3.374 | Arceo Park | 0 | Local Park 2 | 4 | |
2648 | 2648 | 2647 | {"type": "Polygon", "coordinates": [[[-121.81111, 37.35649], [-121.81043, 37.35693], [-121.80987, 37.35643], [-121.80971, 37.35632], [-121.80935, 37.35613], [-121.80918, 37.35601], [-121.80884, 37.35569], [-121.80881, 37.35562], [-121.80877, 37.35558], [-121.80867, 37.35554], [-121.80857, 37.35557], [-121.80837, 37.35537], [-121.80922, 37.35479], [-121.81111, 37.35649]]]} | Open Access 1 | 18109 | Mt. Pleasant | 22581 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 5.353 | Mt. Pleasant | 1983 | None 219 | ||
2649 | 2649 | 2648 | {"type": "Polygon", "coordinates": [[[-118.92828, 34.17927], [-118.92827, 34.17981], [-118.9281, 34.18001], [-118.92782, 34.18015], [-118.92755, 34.18041], [-118.92724, 34.18051], [-118.92703, 34.18066], [-118.92722, 34.18095], [-118.92737, 34.18092], [-118.92746, 34.18099], [-118.9274, 34.18111], [-118.92771, 34.18141], [-118.92733, 34.18174], [-118.92674, 34.18145], [-118.92554, 34.18141], [-118.9251, 34.18136], [-118.92529, 34.1803], [-118.92553, 34.1803], [-118.92596, 34.18017], [-118.92604, 34.17943], [-118.92614, 34.17943], [-118.9264, 34.17961], [-118.9263, 34.17969], [-118.92648, 34.18011], [-118.9265, 34.18031], [-118.92672, 34.18048], [-118.92732, 34.18029], [-118.92767, 34.17993], [-118.92792, 34.17939], [-118.92804, 34.17906], [-118.92828, 34.17927]]]} | Open Access 1 | 18114 | Newbury Gateway Park | 22716 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 8.503 | Newbury Gateway Park | 0 | Local Park 2 | 4 | |
2650 | 2650 | 2649 | {"type": "Polygon", "coordinates": [[[-121.95042, 36.97668], [-121.95007, 36.97711], [-121.94999, 36.97716], [-121.94991, 36.97733], [-121.94972, 36.97786], [-121.94988, 36.97832], [-121.94997, 36.97847], [-121.94934, 36.97817], [-121.94948, 36.97798], [-121.9492, 36.97784], [-121.95014, 36.97662], [-121.9502, 36.97659], [-121.95027, 36.97659], [-121.95032, 36.9766], [-121.95042, 36.97668]]]} | Open Access 1 | 18122 | Noble Gulch Park | 22777 | 1044 | Capitola, City of 112 | City 2 | City Agency 2 | http://www.cityofcapitola.org/publicworks/page/parks | City 2 | 1044 | Capitola, City of 109 | City 2 | City Agency 2 | Santa Cruz 5 | 1.556 | Noble Gulch Park | 0 | Local Park 2 | 4 | |
2651 | 2651 | 2650 | {"type": "Polygon", "coordinates": [[[-116.25716, 33.86038], [-116.25703, 33.87492], [-116.24863, 33.87494], [-116.24862, 33.87491], [-116.24427, 33.8749], [-116.24426, 33.87495], [-116.24419, 33.87496], [-116.24421, 33.88071], [-116.24243, 33.8807], [-116.23111, 33.87556], [-116.2311, 33.85639], [-116.23118, 33.8458], [-116.23109, 33.84579], [-116.23108, 33.84555], [-116.24326, 33.84564], [-116.24409, 33.84607], [-116.24407, 33.84751], [-116.24625, 33.84748], [-116.24626, 33.84744], [-116.24643, 33.84744], [-116.24644, 33.8473], [-116.24851, 33.84838], [-116.24842, 33.86043], [-116.25716, 33.86038]]]} | Open Access 1 | 4472 | Sky Valley Ecological Reserve | 32310 | 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 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Sky-Valley-ER | Riverside 10 | 1703.065 | Sky Valley ER | 2007 | State Conservation Area 8 | 2 |
2652 | 2652 | 2651 | {"type": "Polygon", "coordinates": [[[-117.57659, 33.88504], [-117.57659, 33.88504], [-117.57652, 33.88547], [-117.57638, 33.88542], [-117.57645, 33.88499], [-117.57659, 33.88504]]]} | Open Access 1 | 18124 | Contreras Park | 17609 | 1068 | Corona, City of 65 | City 2 | City Agency 2 | http://www.coronadwp.com/parkmaint/index.shtml | City 2 | 1068 | Corona, City of 63 | City 2 | City Agency 2 | Riverside 10 | 0.162 | Contreras Park | 0 | Local Park 2 | 4 | |
2653 | 2653 | 2652 | {"type": "Polygon", "coordinates": [[[-120.1819, 34.5326], [-120.18188, 34.5355], [-120.18164, 34.53547], [-120.17751, 34.53436], [-120.17561, 34.53522], [-120.1757, 34.53333], [-120.1755, 34.53184], [-120.17499, 34.53056], [-120.17342, 34.52986], [-120.17345, 34.52719], [-120.17782, 34.5272], [-120.17762, 34.53254], [-120.1819, 34.5326]]]} | Open Access 1 | 18125 | Nojoqui Falls County Park | 22783 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 83.478 | Nojoqui Falls County 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]);