units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
205 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_AG_TYP, DES_TP
MNG_AGENCY >30
- The Wildlands Conservancy 20
- Truckee Donner Land Trust 19
- Center for Natural Lands Management 11
- Fallbrook Land Conservancy 10
- Friends of the Desert Mountains 8
- Coastside Land Trust 8
- Land Trust of Santa Cruz County 7
- Mojave Desert Land Trust 7
- Los Angeles Neighborhood Land Trust 6
- Ojai Valley Land Conservancy 6
- The Nature Conservancy 5
- Bear Yuba Land Trust 5
- Sonoma Land Trust 5
- Tuleyome 5
- Trinidad Coastal Land Trust 5
- Save the Redwoods League 4
- John Muir Land Trust 4
- Sierra Foothill Conservancy 4
- Arroyos and Foothills Conservancy 4
- Mendocino Land Trust 4
- Wilderness Land Trust 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
- Eastern Sierra Land Trust 3
- Land Trust of Napa County 2
- Back Country Land Trust 2
- …
ACCESS_TYP 1
- Open Access · 205 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13028 | 13028 | 13027 | {"type": "Polygon", "coordinates": [[[-122.47784, 37.51093], [-122.47784, 37.51093], [-122.4775, 37.51077], [-122.4778, 37.51075], [-122.47784, 37.51093]]]} | Open Access 1 | 34870 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.069 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
296 | 296 | 295 | {"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 | 795 | Shinglemill Creek | 28175 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 0.071 | Shinglemill Creek | 0 | Private Conservation 16 | 2 | |
13027 | 13027 | 13026 | {"type": "Polygon", "coordinates": [[[-122.47788, 37.51058], [-122.47771, 37.51062], [-122.47766, 37.51034], [-122.47781, 37.51035], [-122.47788, 37.51058]]]} | Open Access 1 | 34869 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.104 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
3751 | 3751 | 3750 | {"type": "Polygon", "coordinates": [[[-122.43183, 37.44426], [-122.43175, 37.44427], [-122.43168, 37.44373], [-122.43176, 37.44372], [-122.43183, 37.44426]]]} | Open Access 1 | 34834 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.114 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
9788 | 9788 | 9787 | {"type": "Polygon", "coordinates": [[[-121.94606, 36.98814], [-121.94612, 36.98821], [-121.94625, 36.9883], [-121.94626, 36.98834], [-121.94624, 36.98837], [-121.94619, 36.98839], [-121.94597, 36.9884], [-121.94596, 36.98815], [-121.94606, 36.98814]]]} | Open Access 1 | 16684 | Greenspace Gardens | 30453 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 0.128 | Greenspace Gardens | 0 | Private Conservation 16 | 2 | |
2966 | 2966 | 2965 | {"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 | 48647 | Golden Age Park | 33393 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.lanlt.org/projectupdates | Los Angeles 6 | 0.172 | Golden Age Park | 2019 | Private Recreation or Education 65 | 4 |
4022 | 4022 | 4021 | {"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 | 46884 | Vermont Miracle Park | 32598 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 0.23 | Vermont Miracle Park | 0 | Private Recreation or Education 65 | 4 | |
14625 | 14625 | 14624 | {"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 | 44860 | San Dieguito Lagoon | 24865 | 3066 | San Dieguito River Valley Land Conservancy 378 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sdrvc.org/ | Non Governmental Organization 10 | 3066 | San Dieguito River Valley Land Conservancy 373 | Non Profit 6 | Non Profit - Land Trust 10 | http://sandieguitorivervalleyconservancy.org/sdrvc1_projects_acquisitions1.html | San Diego 4 | 0.286 | San Dieguito Lagoon | 0 | Private Conservation 16 | 2 |
13025 | 13025 | 13024 | {"type": "MultiPolygon", "coordinates": [[[[-122.44722, 37.47993], [-122.44714, 37.47996], [-122.44695, 37.47974], [-122.44702, 37.4797], [-122.44722, 37.47993]]], [[[-122.44891, 37.47986], [-122.44862, 37.48002], [-122.44843, 37.47979], [-122.44871, 37.47964], [-122.44891, 37.47986]]]]} | Open Access 1 | 34864 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.287 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
5701 | 5701 | 5700 | {"type": "Polygon", "coordinates": [[[-118.46593, 34.21588], [-118.46567, 34.21583], [-118.46558, 34.21553], [-118.46555, 34.21552], [-118.46554, 34.21541], [-118.46585, 34.21547], [-118.46593, 34.21588]]]} | Open Access 1 | 45758 | Marson Park | 28763 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/parks-and-gardens.php#marson | Los Angeles 6 | 0.288 | Marson Park | 0 | Private Recreation or Education 65 | 4 |
15335 | 15335 | 15334 | {"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 | 46514 | Estrella Park | 29799 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/parks-and-gardens.php | Los Angeles 6 | 0.309 | Estrella Park | 1982 | Private Recreation or Education 65 | 4 |
13026 | 13026 | 13025 | {"type": "MultiPolygon", "coordinates": [[[[-122.44993, 37.48751], [-122.4495, 37.48768], [-122.44944, 37.4876], [-122.44975, 37.48747], [-122.44965, 37.4873], [-122.44975, 37.48725], [-122.44993, 37.48751]]], [[[-122.45031, 37.48826], [-122.44999, 37.48839], [-122.44987, 37.48822], [-122.45019, 37.48809], [-122.45031, 37.48826]]]]} | Open Access 1 | 34867 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.34 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
14655 | 14655 | 14654 | {"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 | 45042 | Faith and Hope Veterans Park | 28005 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 0.453 | Faith and Hope Veterans Park | 0 | Private Recreation or Education 65 | 4 | |
8068 | 8068 | 8067 | {"type": "Polygon", "coordinates": [[[-120.1983, 39.31826], [-120.19732, 39.31893], [-120.19724, 39.31898], [-120.19794, 39.3181], [-120.1983, 39.31826]]]} | Open Access 1 | 48988 | Hoseit | 33682 | 3104 | Truckee Donner Land Trust 673 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tdlandtrust.org/ | Non Governmental Organization 10 | 3104 | Truckee Donner Land Trust 663 | Non Profit 6 | Non Profit - Land Trust 10 | https://www.truckeedonnerlandtrust.org/ | Nevada 30 | 0.508 | Hoseit | 0 | Private Conservation 16 | 2 |
222 | 222 | 221 | {"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.95037], [-121.8671, 36.95041], [-121.86715, 36.95031], [-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 | 732 | Seascape Uplands Preserve | 25249 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 0.859 | Seascape Uplands Preserve | 0 | Private Conservation 16 | 2 | |
1282 | 1282 | 1281 | {"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 | 7247 | Palomares House | 23367 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/palomares-house-and-park.html | San Diego 4 | 1.248 | Palomares House | 0 | Private Conservation 16 | 2 |
3278 | 3278 | 3277 | {"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 | 23175 | Mathis Pond Preserve | 31039 | 3223 | Bear Yuba Land Trust 100 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/ | Non Governmental Organization 10 | 3223 | Bear Yuba Land Trust 98 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/land/mathis-pond-preserve/ | Nevada 30 | 1.459 | Mathis Pond Preserve | 0 | Private Conservation 16 | 2 |
15232 | 15232 | 15231 | {"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 | 46186 | Chaney Trail Open Space | 29490 | 3000 | Arroyos and Foothills Conservancy 375 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arroyosfoothills.org/ | Non Governmental Organization 10 | 3000 | Arroyos and Foothills Conservancy 370 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 1.539 | Chaney Trail OS | 0 | Private Recreation or Education 65 | 4 | |
13024 | 13024 | 13023 | {"type": "MultiPolygon", "coordinates": [[[[-122.44521, 37.47132], [-122.44505, 37.47233], [-122.44454, 37.47219], [-122.44468, 37.47127], [-122.44521, 37.47132]]], [[[-122.44527, 37.47091], [-122.44525, 37.47104], [-122.44472, 37.47099], [-122.44474, 37.47086], [-122.44527, 37.47091]]], [[[-122.44533, 37.4705], [-122.44529, 37.47077], [-122.44476, 37.47072], [-122.4448, 37.47045], [-122.44533, 37.4705]]], [[[-122.44524, 37.47005], [-122.445, 37.47003], [-122.44508, 37.46956], [-122.44524, 37.47005], [-122.44524, 37.47005]]]]} | Open Access 1 | 34859 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 1.932 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
4553 | 4553 | 4552 | {"type": "Polygon", "coordinates": [[[-121.86524, 36.95323], [-121.8652, 36.95327], [-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 | 28280 | Unnamed site - Center for Natural Lands Management | 28630 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 2.082 | 0 | Private Other or Unknown 399 | 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]);