units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
587 rows where AGNCY_TYP = 10 and MNG_AG_TYP = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
MNG_AGENCY >30
- The Nature Conservancy 50
- Rivers and Lands Conservancy 28
- Peninsula Open Space Trust 27
- Center for Natural Lands Management 25
- The Wildlands Conservancy 24
- Sonoma Land Trust 24
- Truckee Donner Land Trust 24
- Big Sur Land Trust 21
- The Environmental Trust 21
- American River Conservancy 20
- Land Trust of Napa County 18
- Sempervirens Fund 18
- Save the Redwoods League 17
- Save Mount Diablo 17
- Land Trust of Santa Cruz County 15
- Wilderness Land Trust 14
- Fallbrook Land Conservancy 13
- Bear Yuba Land Trust 10
- Friends of the Desert Mountains 10
- Mojave Desert Land Trust 10
- Elkhorn Slough Foundation 9
- The Conservation Fund - California 9
- John Muir Land Trust 8
- Solano Land Trust 8
- Los Angeles Neighborhood Land Trust 8
- Coastside Land Trust 8
- Ojai Valley Land Conservancy 8
- Sequoia Riverlands Trust 7
- Sierra Foothill Conservancy 7
- San Dieguito River Valley Land Conservancy 6
- …
DES_TP 5
ACCESS_TYP 4
- No Public Access 214
- Open Access 201
- Restricted Access 136
- Unknown Access 36
MNG_AG_TYP 1
- Non Profit - Land Trust · 587 ✖
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 | |
4231 | 4231 | 4230 | {"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 | 29758 | Kraynick | 20724 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.092 | Kraynick | 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 | |
442 | 442 | 441 | {"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 | 1381 | Tor House | 26411 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.129 | Tor House | 0 | Private Conservation 16 | 2 | |
4444 | 4444 | 4443 | {"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 | 46513 | Erika J. Glazer Community Garden | 29800 | 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.165 | Erika J. Glazer Community Garden | 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 | |
10215 | 10215 | 10214 | {"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 | 17874 | Mission Trails/Probasco | 22315 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.256 | Mission Trails/Probasco | 0 | Private Conservation 16 | 2 | |
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 |
8169 | 8169 | 8168 | {"type": "Polygon", "coordinates": [[[-117.01797, 32.65356], [-117.01795, 32.65355], [-117.01732, 32.65317], [-117.01775, 32.65304], [-117.01797, 32.65356]]]} | No Public Access 3 | 12372 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.332 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
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 | |
8160 | 8160 | 8159 | {"type": "Polygon", "coordinates": [[[-117.14404, 32.97655], [-117.14403, 32.97699], [-117.14363, 32.97685], [-117.14365, 32.97679], [-117.14365, 32.97656], [-117.14404, 32.97655]]]} | No Public Access 3 | 12367 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 0.366 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
2296 | 2296 | 2295 | {"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.93849, 36.50138], [-121.93848, 36.50133], [-121.93865, 36.50129]]]} | Restricted Access 2 | 16894 | Highlands Inn turnout | 19940 | 3008 | Big Sur Land Trust 173 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 0.373 | Highlands Inn turnout | 0 | Private Conservation 16 | 2 | |
8400 | 8400 | 8399 | {"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 | 47808 | Balboa | 31690 | 3054 | Peninsula Open Space Trust 338 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.426 | Balboa | 0 | Private Conservation 16 | 2 |
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]);