superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
682 rows where MNG_AG_LEV = 6 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- The Nature Conservancy 43
- National Audubon Society 29
- Peninsula Open Space Trust 27
- Center for Natural Lands Management 24
- Sonoma Land Trust 24
- Truckee Donner Land Trust 22
- Big Sur Land Trust 21
- The Wildlands Conservancy 19
- American River Conservancy 19
- Land Trust of Napa County 18
- Sempervirens Fund 18
- Save Mount Diablo 17
- Land Trust of Santa Cruz County 15
- Fallbrook Land Conservancy 15
- Endangered Habitats Conservancy 14
- Save the Redwoods League 13
- San Joaquin River Parkway and Conservation Trust 12
- Mountains Restoration Trust 10
- Bear Yuba Land Trust 9
- John Muir Land Trust 8
- Friends of the Desert Mountains 8
- Solano Land Trust 8
- Los Angeles Neighborhood Land Trust 8
- Wilderness Land Trust 8
- The Conservation Fund - California 8
- Ojai Valley Land Conservancy 8
- Sequoia Riverlands Trust 7
- Marin Audubon Society 7
- Sierra Foothill Conservancy 7
- Elkhorn Slough Foundation 7
- …
MNG_AG_TYP 5
ACCESS_TYP 4
- Open Access 270
- No Public Access 202
- Restricted Access 155
- Unknown Access 55
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11582 | 11582 | 11581 | {"type": "Polygon", "coordinates": [[[-122.08006, 37.03997], [-122.08006, 37.04024], [-122.07996, 37.04025], [-122.07993, 37.04002], [-122.08006, 37.03997]]]} | Open Access 1 | Shinglemill Creek | 28175 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 0.071 | Shinglemill Creek | ||
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 | ||
11863 | 11863 | 11862 | {"type": "Polygon", "coordinates": [[[-121.94626, 36.98834], [-121.94624, 36.98837], [-121.94619, 36.98839], [-121.94597, 36.9884], [-121.94596, 36.98815], [-121.94606, 36.98814], [-121.94612, 36.98821], [-121.94625, 36.9883], [-121.94626, 36.98834]]]} | Open Access 1 | Greenspace Gardens | 30453 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 0.128 | Greenspace Gardens | ||
10396 | 10396 | 10395 | {"type": "Polygon", "coordinates": [[[-121.93363, 36.54329], [-121.93317, 36.54325], [-121.93307, 36.54313], [-121.93323, 36.54306], [-121.93329, 36.54312], [-121.93337, 36.54317], [-121.93363, 36.54329]]]} | Restricted Access 2 | Tor House | 26411 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.129 | Tor House | ||
12666 | 12666 | 12665 | {"type": "Polygon", "coordinates": [[[-118.29797, 34.03179], [-118.29758, 34.03179], [-118.29757, 34.03163], [-118.29797, 34.03162], [-118.29797, 34.03179]]]} | Restricted Access 2 | Erika J. Glazer Community Garden | 29800 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.165 | Erika J. Glazer Community Garden | ||
13187 | 13187 | 13186 | {"type": "Polygon", "coordinates": [[[-118.28333, 34.05806], [-118.28325, 34.05818], [-118.28282, 34.05798], [-118.2829, 34.05786], [-118.28333, 34.05806]]]} | Open Access 1 | Golden Age Park | https://www.lanlt.org/projectupdates | 33393 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.172 | Golden Age Park | 2019 |
14029 | 14029 | 14028 | {"type": "Polygon", "coordinates": [[[-118.29141, 33.96539], [-118.29091, 33.96539], [-118.29091, 33.96521], [-118.29141, 33.96521], [-118.29141, 33.96539]]]} | Open Access 1 | Vermont Miracle Park | 32598 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.229 | Vermont Miracle Park | ||
7063 | 7063 | 7062 | {"type": "Polygon", "coordinates": [[[-121.91841, 36.54792], [-121.91818, 36.54805], [-121.91774, 36.54778], [-121.91774, 36.54777], [-121.9183, 36.54778], [-121.91841, 36.54792]]]} | Restricted Access 2 | Mission Trails/Probasco | 22315 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.255 | Mission Trails/Probasco | ||
1676 | 1676 | 1675 | {"type": "Polygon", "coordinates": [[[-120.83864, 35.3316], [-120.83864, 35.33176], [-120.83843, 35.33176], [-120.83823, 35.33167], [-120.83823, 35.33139], [-120.83864, 35.3316]]]} | Open Access 1 | Audubon Overlook | 15703 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 0.256 | Audubon Overlook | ||
11588 | 11588 | 11587 | {"type": "Polygon", "coordinates": [[[-118.33306, 33.97936], [-118.33306, 33.97952], [-118.33244, 33.97953], [-118.33244, 33.97936], [-118.33306, 33.97936]]]} | Open Access 1 | South Victoria Avenue Park | http://www.tpl.org/our-work/parks-for-people/fitness-zones/south-victoria-avenue-park | 28103 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 0.26 | South Victoria Avenue Park | 2019 |
789 | 789 | 788 | {"type": "Polygon", "coordinates": [[[-122.39104, 37.75772], [-122.39035, 37.75777], [-122.39033, 37.7576], [-122.39101, 37.75756], [-122.39104, 37.75772]]]} | Open Access 1 | Woods Yard | https://www.sfparksalliance.org/our-parks/parks/woods-yard | 33552 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.275 | Woods Yard | |
7714 | 7714 | 7713 | {"type": "Polygon", "coordinates": [[[-117.26035, 32.96792], [-117.26005, 32.96812], [-117.25973, 32.9678], [-117.2599, 32.96778], [-117.2601, 32.96779], [-117.26023, 32.96784], [-117.26035, 32.96792]]]} | Open Access 1 | San Dieguito Lagoon | http://sandieguitorivervalleyconservancy.org/sdrvc1_projects_acquisitions1.html | 24865 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 0.286 | San Dieguito Lagoon | |
11948 | 11948 | 11947 | {"type": "Polygon", "coordinates": [[[-118.46593, 34.21588], [-118.46567, 34.21583], [-118.46558, 34.21554], [-118.46555, 34.21552], [-118.46554, 34.21541], [-118.46585, 34.21547], [-118.46593, 34.21588]]]} | Open Access 1 | Marson Park | http://www.lanlt.org/parks-and-gardens.php#marson | 28763 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.288 | Marson Park | |
12665 | 12665 | 12664 | {"type": "Polygon", "coordinates": [[[-118.27552, 34.03356], [-118.27521, 34.03404], [-118.27516, 34.03403], [-118.27517, 34.03372], [-118.27516, 34.0334], [-118.27552, 34.03356]]]} | Open Access 1 | Estrella Park | http://www.lanlt.org/parks-and-gardens.php | 29799 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.309 | Estrella Park | 1982 |
5091 | 5091 | 5090 | {"type": "Polygon", "coordinates": [[[-121.93865, 36.50129], [-121.93862, 36.50189], [-121.93831, 36.5019], [-121.93831, 36.50186], [-121.93839, 36.50179], [-121.93842, 36.50173], [-121.9384, 36.50165], [-121.93832, 36.5016], [-121.93831, 36.50147], [-121.93848, 36.50138], [-121.93848, 36.50133], [-121.93865, 36.50129]]]} | Restricted Access 2 | Highlands Inn turnout | 19940 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.373 | Highlands Inn turnout | ||
11593 | 11593 | 11592 | {"type": "Polygon", "coordinates": [[[-118.26097, 33.95842], [-118.26096, 33.95916], [-118.26076, 33.95916], [-118.26076, 33.95842], [-118.26097, 33.95842]]]} | Open Access 1 | WAYS Reading and Fitness Park | 28122 | 3352 | Heal the Bay 711 | Non Profit 6 | Non Profit - Other 20 | http://www.healthebay.org/ | Non Governmental Organization 10 | 0.387 | WAYS Reading and Fitness Park | ||
11573 | 11573 | 11572 | {"type": "Polygon", "coordinates": [[[-118.25946, 34.06588], [-118.25927, 34.06617], [-118.25885, 34.06598], [-118.25904, 34.06569], [-118.25946, 34.06588]]]} | Open Access 1 | Patton Street Park | https://www.tpl.org/our-work/parks-for-people/patton-street-park | 28079 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 0.4 | Patton Street Park | |
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 | ||
13982 | 13982 | 13981 | {"type": "MultiPolygon", "coordinates": [[[[-118.30836, 33.98193], [-118.30825, 33.98197], [-118.30786, 33.98212], [-118.30786, 33.98191], [-118.30833, 33.98191], [-118.30836, 33.98193]]], [[[-118.30883, 33.98208], [-118.30883, 33.98228], [-118.30824, 33.98228], [-118.3082, 33.98226], [-118.30823, 33.98223], [-118.30862, 33.98208], [-118.30883, 33.98208]]], [[[-118.30873, 33.9818], [-118.30853, 33.98187], [-118.30843, 33.98187], [-118.30843, 33.9818], [-118.30873, 33.9818]]]]} | Open Access 1 | Western Gage Park | 32566 | 3368 | Los Angeles Neighborhood Initiative 1074 | Non Profit 6 | Non Profit - Other 20 | http://lani.org/ | Non Governmental Organization 10 | 0.428 | Western Gage Park | ||
9932 | 9932 | 9931 | {"type": "Polygon", "coordinates": [[[-118.23217, 33.92468], [-118.23217, 33.9253], [-118.23188, 33.9253], [-118.23188, 33.92468], [-118.23217, 33.92468]]]} | Open Access 1 | Faith and Hope Veterans Park | 28005 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.453 | Faith and Hope Veterans 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]);