superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
754 rows where ACCESS_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- California Department of Fish and Wildlife 75
- East Bay Regional Park District 41
- The Nature Conservancy 26
- Peninsula Open Space Trust 24
- Torrance, City of 20
- Natomas Basin Conservancy 20
- Santa Clara Valley Open Space Authority 17
- Midpeninsula Regional Open Space District 17
- Fresno Metropolitan Flood Control District 16
- California Department of Parks and Recreation 15
- San Diego, City of 14
- Endangered Habitats Conservancy 14
- San Diego, County of 14
- American River Conservancy 13
- Save Mount Diablo 13
- United States Fish and Wildlife Service 12
- Santa Clara County Parks and Recreation Dept., County of 12
- Los Angeles, City of 11
- Sonoma Land Trust 11
- Sonoma County Agricultural Preservation and Open Space District 11
- California Department of Water Resources 11
- Rocklin, City of 8
- Center for Natural Lands Management 7
- Napa County Regional Park and Open Space District 7
- Los Angeles - Department of Water and Power, City of 7
- Riverside County Habitat Conservation Agency 7
- Los Angeles County Flood Control District 6
- Elkhorn Slough Foundation 6
- Vallejo, City of 6
- Wilderness Land Trust 6
- …
MNG_AG_TYP 20
- Non Profit - Land Trust 169
- City Agency 155
- State Agency 124
- Recreation/Parks District 97
- Flood District 47
- Non Profit - Conservation 32
- Federal Agency 28
- Water District 27
- County Agency 26
- County Agency - Parks 17
- Open Space District 15
- Irrigation District 7
- County Agency - Other 3
- Home Owners Association 1
- Commercial 1
- Sanitation District 1
- Non Profit - Other 1
- Joint Powers Authority 1
- Other 1
- Mitigation Bank 1
LAYER 12 ✖
MNG_AG_LEV 8 ✖
- Non Profit 202
- Special District 194
- City 155
- State 124
- County 46
- Federal 28
- Private 4
- Joint 1
ACCESS_TYP 1
- No Public Access · 754 ✖
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13714 | 13714 | 13713 | {"type": "Polygon", "coordinates": [[[-118.518, 34.05167], [-118.51753, 34.05174], [-118.51751, 34.0517], [-118.51798, 34.05163], [-118.518, 34.05167]]]} | No Public Access 3 | Chautauqua Blvd Access to Will Rogers State Historic Preserve | 31212 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.053 | Chautauqua Blvd Access to Will Rogers SHPr | ||
5782 | 5782 | 5781 | {"type": "Polygon", "coordinates": [[[-122.31412, 37.26649], [-122.31377, 37.26649], [-122.31369, 37.26638], [-122.31401, 37.26638], [-122.31412, 37.26649]]]} | No Public Access 3 | Kraynick | 20724 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 0.091 | Kraynick | ||
12189 | 12189 | 12188 | {"type": "Polygon", "coordinates": [[[-118.36681, 33.81599], [-118.36674, 33.81603], [-118.36641, 33.81553], [-118.36652, 33.81548], [-118.36669, 33.81573], [-118.36666, 33.81576], [-118.36681, 33.81599]]]} | No Public Access 3 | Greenbelt SE Bindewald SE Calle Mayor | 29168 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.159 | Greenbelt SE Bindewald SE Calle Mayor | ||
3576 | 3576 | 3575 | {"type": "Polygon", "coordinates": [[[-122.25654, 38.2078], [-122.25633, 38.20788], [-122.2563, 38.20749], [-122.2564, 38.20753], [-122.25652, 38.20754], [-122.25654, 38.2078]]]} | No Public Access 3 | Dept Of Transportation/Paul Kenny | 18103 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.163 | Dept Of Transportation/Paul Kenny | ||
12172 | 12172 | 12171 | {"type": "Polygon", "coordinates": [[[-118.36219, 33.85184], [-118.36169, 33.85181], [-118.36169, 33.85167], [-118.36213, 33.85167], [-118.36219, 33.85184]]]} | No Public Access 3 | Entradero Swale 4 | 29148 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.181 | Entradero Swale 4 | ||
12758 | 12758 | 12757 | {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} | No Public Access 3 | Chittick Field | 29944 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 0.181 | Chittick Field | 2014 | |
8571 | 8571 | 8570 | {"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 | 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 | 0.203 | Real Estate Services Division | ||
11658 | 11658 | 11657 | {"type": "Polygon", "coordinates": [[[-118.2914, 33.95801], [-118.2914, 33.95822], [-118.29101, 33.95822], [-118.29101, 33.95801], [-118.2914, 33.95801]]]} | No Public Access 3 | Community Build Youth Center Expansion | 30356 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 0.206 | Community Build Youth Ctr. Expansion | ||
1079 | 1079 | 1078 | {"type": "Polygon", "coordinates": [[[-122.27901, 38.29895], [-122.27868, 38.299], [-122.27861, 38.29876], [-122.27894, 38.2987], [-122.27901, 38.29895]]]} | No Public Access 3 | 575 Third St | 15206 | 203 | California Department of General Services 17 | State 5 | State Agency 5 | http://www.dgs.ca.gov/default.htm | Other State 5 | 0.209 | 575 Third St | ||
9948 | 9948 | 9947 | {"type": "MultiPolygon", "coordinates": [[[[-118.22877, 34.08683], [-118.22866, 34.08675], [-118.22875, 34.08668], [-118.22875, 34.08668], [-118.22877, 34.08683]]], [[[-118.22915, 34.08683], [-118.22891, 34.08704], [-118.22889, 34.08693], [-118.22882, 34.08688], [-118.22879, 34.08664], [-118.22885, 34.08659], [-118.22915, 34.08683]]]]} | No Public Access 3 | Steelhead Park | 25823 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.219 | Steelhead Park | ||
14327 | 14327 | 14326 | {"type": "Polygon", "coordinates": [[[-118.25828, 33.88611], [-118.25795, 33.88612], [-118.25789, 33.88584], [-118.25805, 33.88581], [-118.25821, 33.88581], [-118.25828, 33.88611]]]} | No Public Access 3 | Unnamed site - Carson, City of | 29713 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 0.248 | |||
13252 | 13252 | 13251 | {"type": "Polygon", "coordinates": [[[-122.01238, 36.97053], [-122.01187, 36.97081], [-122.01185, 36.97079], [-122.01191, 36.97056], [-122.01223, 36.97036], [-122.01238, 36.97053]]]} | No Public Access 3 | South Branciforte | 32313 | 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 | 0.251 | South Branciforte | ||
13339 | 13339 | 13338 | {"type": "MultiPolygon", "coordinates": [[[[-124.08853, 40.86727], [-124.08849, 40.86738], [-124.08823, 40.86732], [-124.08827, 40.86721], [-124.08853, 40.86727]]], [[[-124.09773, 40.87241], [-124.0977, 40.87249], [-124.09755, 40.87251], [-124.09741, 40.87256], [-124.09735, 40.8727], [-124.09726, 40.87269], [-124.09716, 40.87293], [-124.09704, 40.8729], [-124.09711, 40.87263], [-124.09748, 40.87243], [-124.09773, 40.87241]]]]} | No Public Access 3 | City of Arcata Openspace | 30673 | 1432 | Arcata, City of 577 | City 2 | City Agency 2 | http://www.cityofarcata.org/rec | City 2 | 0.304 | City of Arcata Openspace | ||
12661 | 12661 | 12660 | {"type": "Polygon", "coordinates": [[[-118.22601, 34.0822], [-118.22554, 34.08201], [-118.22525, 34.08188], [-118.22546, 34.08173], [-118.22558, 34.08171], [-118.22568, 34.08174], [-118.22578, 34.08182], [-118.22601, 34.0822]]]} | No Public Access 3 | Confluence Park | 29794 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 0.392 | Confluence Park | 2003 | |
13559 | 13559 | 13558 | {"type": "Polygon", "coordinates": [[[-119.81224, 36.70995], [-119.81224, 36.71035], [-119.81186, 36.71035], [-119.81187, 36.71016], [-119.81185, 36.71008], [-119.81178, 36.70994], [-119.81224, 36.70995]]]} | No Public Access 3 | Basin TT2 | http://www.fresnofloodcontrol.org/ | 30991 | 2036 | Fresno Metropolitan Flood Control District 729 | Special District 4 | Flood District 9 | http://www.fresnofloodcontrol.org/ | Special District 4 | 0.396 | Basin TT2 | |
12119 | 12119 | 12118 | {"type": "Polygon", "coordinates": [[[-118.32429, 33.80965], [-118.32389, 33.80965], [-118.32389, 33.80924], [-118.32429, 33.80924], [-118.32429, 33.80965]]]} | No Public Access 3 | Empty Lot 237th and Vine | 29082 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.419 | Empty Lot 237th and Vine | ||
12183 | 12183 | 12182 | {"type": "Polygon", "coordinates": [[[-118.35893, 33.85167], [-118.35893, 33.85181], [-118.35772, 33.85181], [-118.35772, 33.85168], [-118.35893, 33.85167]]]} | No Public Access 3 | Entradero Swale 6 | 29163 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 0.421 | Entradero Swale 6 | ||
3570 | 3570 | 3569 | {"type": "MultiPolygon", "coordinates": [[[[-122.29969, 38.27466], [-122.29947, 38.27466], [-122.29946, 38.27356], [-122.29948, 38.27356], [-122.29969, 38.27466]]], [[[-122.46397, 38.50119], [-122.46394, 38.50121], [-122.46301, 38.50039], [-122.46304, 38.50037], [-122.46397, 38.50119]]]]} | No Public Access 3 | Department of Transportation | 18097 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 0.423 | Department of Transportation | ||
13088 | 13088 | 13087 | {"type": "Polygon", "coordinates": [[[-122.44442, 37.46814], [-122.44436, 37.46855], [-122.44394, 37.46851], [-122.444, 37.4681], [-122.44442, 37.46814]]]} | No Public Access 3 | Balboa | 31690 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 0.426 | Balboa | ||
11240 | 11240 | 11239 | {"type": "Polygon", "coordinates": [[[-118.04461, 34.0463], [-118.04438, 34.04649], [-118.04391, 34.0461], [-118.04414, 34.0459], [-118.04461, 34.0463]]]} | No Public Access 3 | Civic Center Community Park | 29845 | 1402 | South El Monte, City of 595 | City 2 | City Agency 2 | http://www.ci.south-el-monte.ca.us/CITYDEPARTMENTSSERVICES/CommunityServices/ParksandRecreationDivision.aspx | City 2 | 0.465 | Civic Ctr. Community Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);