superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
270 rows where ACCESS_TYP = 1 and LAYER = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Truckee Donner Land Trust 18
- The Wildlands Conservancy 15
- Center for Natural Lands Management 11
- Fallbrook Land Conservancy 10
- Land Trust of Santa Cruz County 7
- Friends of the Desert Mountains 6
- Del Monte Forest Foundation 6
- Los Angeles Neighborhood Land Trust 6
- Ojai Valley Land Conservancy 6
- Sonoma Land Trust 5
- San Francisco Parks Alliance 5
- Trinidad Coastal Land Trust 5
- Save the Redwoods League 4
- The Nature Conservancy 4
- Bear Yuba Land Trust 4
- John Muir Land Trust 4
- Sierra Foothill Conservancy 4
- Arroyos and Foothills Conservancy 4
- Mendocino Land Trust 4
- Mountains Restoration Trust 4
- Tuleyome 4
- American River Conservancy 4
- Feather River Land Trust 4
- Big Sur Land Trust 3
- Land Trust for Santa Barbara County 3
- San Dieguito River Valley Land Conservancy 3
- San Joaquin River Parkway and Conservation Trust 3
- National Audubon Society 3
- Eastern Sierra Land Trust 3
- Trust for Public Land 3
- …
MNG_AG_TYP 5
ACCESS_TYP 1
- Open Access · 270 ✖
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 | ||
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 | ||
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 | ||
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 |
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 | |
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 | ||
7239 | 7239 | 7238 | {"type": "Polygon", "coordinates": [[[-120.1983, 39.31826], [-120.19732, 39.31892], [-120.19724, 39.31898], [-120.19794, 39.3181], [-120.1983, 39.31826]]]} | Open Access 1 | Hoseit | https://www.truckeedonnerlandtrust.org/ | 33682 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 0.508 | Hoseit | |
11563 | 11563 | 11562 | {"type": "Polygon", "coordinates": [[[-118.2902, 34.09309], [-118.2894, 34.0931], [-118.2894, 34.09282], [-118.2902, 34.09282], [-118.2902, 34.09309]]]} | Open Access 1 | Madison Avenue Park | http://www.tpl.org/our-work/parks-for-people/madison-ave-park | 28044 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 0.559 | Madison Avenue Park | |
3968 | 3968 | 3967 | {"type": "Polygon", "coordinates": [[[-121.20019, 38.71522], [-121.20005, 38.71565], [-121.19981, 38.71561], [-121.19954, 38.7156], [-121.19959, 38.71518], [-121.20019, 38.71522]]]} | Open Access 1 | Elsami | 18603 | 3056 | Placer Legacy 935 | Non Profit 6 | Non Profit - Conservation 12 | http://www.placer.ca.gov/departments/communitydevelopment/planning/placerlegacy | Non Governmental Organization 10 | 0.573 | Elsami | ||
463 | 463 | 462 | {"type": "Polygon", "coordinates": [[[-122.39117, 37.78541], [-122.39071, 37.78573], [-122.39028, 37.78609], [-122.39017, 37.78649], [-122.38985, 37.78623], [-122.39103, 37.78533], [-122.39117, 37.78541]]]} | Open Access 1 | Rincon Hill Dog Park | https://www.rinconhilldogpark.org/about | 33503 | 3308 | San Francisco Parks Alliance 521 | Non Profit 6 | Non Profit - Other 20 | http://www.sfparksalliance.org/ | Non Governmental Organization 10 | 0.621 | Rincon Hill Dog Park | 2007 |
7334 | 7334 | 7333 | {"type": "Polygon", "coordinates": [[[-120.68035, 38.19748], [-120.68032, 38.19764], [-120.68019, 38.19787], [-120.68017, 38.19785], [-120.67998, 38.1978], [-120.68, 38.19774], [-120.67974, 38.19755], [-120.67986, 38.19742], [-120.6797, 38.19732], [-120.67973, 38.19727], [-120.67949, 38.1971], [-120.67965, 38.19699], [-120.67991, 38.19725], [-120.68002, 38.19734], [-120.68035, 38.19748]]]} | Open Access 1 | Neilsen Park | 22689 | 3050 | Odd Fellows Sierra Recreation Association 799 | Non Profit 6 | Non Profit - Other 20 | http://ofsraparkmgt.wix.com/home | Non Governmental Organization 10 | 0.654 | Neilsen Park | ||
14308 | 14308 | 14307 | {"type": "Polygon", "coordinates": [[[-119.72173, 34.41045], [-119.72161, 34.41166], [-119.72134, 34.41164], [-119.72147, 34.41038], [-119.72173, 34.41045]]]} | Open Access 1 | Unnamed site - Community Environmental Council | 28696 | 3015 | Community Environmental Council 500 | Non Profit 6 | Non Profit - Conservation 12 | http://www.communityenvironmentalcouncil.org/ | Non Governmental Organization 10 | 0.837 |
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]);