superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
180 rows where ACCESS_TYP = 1 and MNG_AG_TYP = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 180 ✖
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 | ||
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 |
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 | |
9444 | 9444 | 9443 | {"type": "MultiPolygon", "coordinates": [[[[-121.8673, 36.95006], [-121.86712, 36.95048], [-121.86682, 36.95042], [-121.86651, 36.95041], [-121.8673, 36.95006]], [[-121.86709, 36.95029], [-121.86695, 36.95026], [-121.86691, 36.95036], [-121.8671, 36.95041], [-121.86714, 36.95032], [-121.86709, 36.95029]]], [[[-121.86797, 36.95053], [-121.8677, 36.95077], [-121.86751, 36.95064], [-121.86733, 36.95055], [-121.86756, 36.95019], [-121.86775, 36.95036], [-121.86797, 36.95053]]], [[[-121.86937, 36.95145], [-121.86934, 36.95153], [-121.86929, 36.95158], [-121.86921, 36.95159], [-121.86891, 36.95152], [-121.86896, 36.95137], [-121.86937, 36.95145]]]]} | Open Access 1 | Seascape Uplands Preserve | 25249 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 0.862 | Seascape Uplands Preserve | ||
7891 | 7891 | 7890 | {"type": "Polygon", "coordinates": [[[-117.23197, 33.35767], [-117.23195, 33.35817], [-117.23163, 33.35818], [-117.2314, 33.35817], [-117.23119, 33.35811], [-117.23111, 33.35808], [-117.23108, 33.35804], [-117.2311, 33.358], [-117.23133, 33.35781], [-117.23146, 33.35767], [-117.2318, 33.35723], [-117.2319, 33.35729], [-117.23197, 33.35767]]]} | Open Access 1 | Palomares House | http://www.fallbrooklandconservancy.org/palomares-house-and-park.html | 23367 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 1.247 | Palomares House | |
13584 | 13584 | 13583 | {"type": "Polygon", "coordinates": [[[-121.03318, 39.14691], [-121.03318, 39.14723], [-121.03271, 39.14793], [-121.03234, 39.1476], [-121.0324, 39.14717], [-121.03268, 39.14678], [-121.03318, 39.14691]]]} | Open Access 1 | Mathis Pond Preserve | http://www.bylt.org/land/mathis-pond-preserve/ | 31039 | 3223 | Bear Yuba Land Trust 98 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/ | Non Governmental Organization 10 | 1.459 | Mathis Pond Preserve | |
10963 | 10963 | 10962 | {"type": "Polygon", "coordinates": [[[-118.14873, 34.20755], [-118.14873, 34.20755], [-118.14745, 34.20754], [-118.14816, 34.20703], [-118.14871, 34.20655], [-118.14873, 34.20755]]]} | Open Access 1 | Chaney Trail Open Space | 29490 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 1.539 | Chaney Trail OS | ||
14271 | 14271 | 14270 | {"type": "Polygon", "coordinates": [[[-121.86524, 36.95323], [-121.8652, 36.95328], [-121.86519, 36.95407], [-121.86435, 36.9541], [-121.86433, 36.95383], [-121.86433, 36.95311], [-121.86434, 36.95307], [-121.86438, 36.95306], [-121.86444, 36.95305], [-121.86478, 36.95308], [-121.86502, 36.95314], [-121.86524, 36.95323]]]} | Open Access 1 | Unnamed site - Center for Natural Lands Management | 28630 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 2.082 | |||
7095 | 7095 | 7094 | {"type": "Polygon", "coordinates": [[[-120.29922, 39.32203], [-120.29646, 39.32199], [-120.29619, 39.32189], [-120.29604, 39.32171], [-120.29531, 39.32159], [-120.29539, 39.32128], [-120.29584, 39.32142], [-120.2959, 39.32131], [-120.29584, 39.32107], [-120.29593, 39.32107], [-120.296, 39.32135], [-120.29622, 39.32136], [-120.29622, 39.3215], [-120.2965, 39.32167], [-120.29679, 39.32181], [-120.29708, 39.32187], [-120.29719, 39.32187], [-120.29746, 39.32194], [-120.29812, 39.32159], [-120.29922, 39.32203]]]} | Open Access 1 | Creekside Woods | https://www.truckeedonnerlandtrust.org/ | 33680 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 2.301 | Creekside Woods | |
13818 | 13818 | 13817 | {"type": "Polygon", "coordinates": [[[-124.13929, 41.06003], [-124.13917, 41.06023], [-124.1392, 41.0603], [-124.1392, 41.06036], [-124.13919, 41.06045], [-124.13914, 41.06056], [-124.13914, 41.06105], [-124.139, 41.06087], [-124.13894, 41.06077], [-124.13889, 41.06064], [-124.13881, 41.06034], [-124.13872, 41.06015], [-124.13853, 41.0599], [-124.13853, 41.05847], [-124.13916, 41.05822], [-124.13886, 41.05927], [-124.13888, 41.05935], [-124.13894, 41.05944], [-124.139, 41.05949], [-124.13903, 41.0595], [-124.13912, 41.0596], [-124.13912, 41.05966], [-124.13904, 41.05969], [-124.13904, 41.05972], [-124.13918, 41.05981], [-124.13927, 41.05989], [-124.13929, 41.06003]]]} | Open Access 1 | Bruno Groth Grove | 31341 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 2.652 | Bruno Groth Grove | ||
11519 | 11519 | 11518 | {"type": "Polygon", "coordinates": [[[-124.14215, 41.06163], [-124.14216, 41.06222], [-124.14214, 41.06229], [-124.14209, 41.0624], [-124.14204, 41.06246], [-124.14198, 41.06251], [-124.14186, 41.06258], [-124.14183, 41.06248], [-124.14083, 41.06253], [-124.14052, 41.06219], [-124.14116, 41.06192], [-124.14071, 41.06151], [-124.14108, 41.06136], [-124.14118, 41.06161], [-124.14193, 41.0615], [-124.14195, 41.0613], [-124.14192, 41.06121], [-124.14212, 41.06118], [-124.14215, 41.06163]]]} | Open Access 1 | Saunders Park | http://www.trinidadcoastallandtrust.org/holdings/index.html | 27897 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3.145 | Saunders Park | |
14628 | 14628 | 14627 | {"type": "Polygon", "coordinates": [[[-119.79781, 38.30883], [-119.79777, 38.30983], [-119.79674, 38.30981], [-119.79629, 38.30945], [-119.79631, 38.30886], [-119.79781, 38.30883]]]} | Open Access 1 | Stanislaus National Forest | https://www.savetheredwoods.org/ | 33338 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3.299 | Stanislaus NF | |
11612 | 11612 | 11611 | {"type": "Polygon", "coordinates": [[[-122.52153, 38.36819], [-122.52136, 38.36832], [-122.52125, 38.36844], [-122.52062, 38.36888], [-122.52047, 38.36894], [-122.52018, 38.36901], [-122.51901, 38.36925], [-122.51878, 38.36932], [-122.51813, 38.3696], [-122.51797, 38.36971], [-122.51815, 38.36947], [-122.51862, 38.36901], [-122.51892, 38.36884], [-122.51915, 38.36873], [-122.51948, 38.36861], [-122.5215, 38.36809], [-122.52153, 38.36819]]]} | Open Access 1 | Stuart Creek Run | 28159 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3.571 | Stuart Creek Run | ||
11533 | 11533 | 11532 | {"type": "Polygon", "coordinates": [[[-124.12251, 41.04406], [-124.12176, 41.04463], [-124.12151, 41.04441], [-124.12099, 41.04406], [-124.12081, 41.04391], [-124.12065, 41.04375], [-124.12044, 41.04348], [-124.12027, 41.04316], [-124.1202, 41.04307], [-124.12117, 41.04308], [-124.12124, 41.04322], [-124.12149, 41.04344], [-124.1218, 41.0436], [-124.1221, 41.04381], [-124.12227, 41.04396], [-124.12251, 41.04406]]]} | Open Access 1 | North Luffenholtz Beach | 27913 | 3203 | Trinidad Coastal Land Trust 680 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.trinidadcoastallandtrust.org/ | Non Governmental Organization 10 | 3.699 | North Luffenholtz Beach |
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]);