units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
781 rows where LAYER = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, GAP_STS
MNG_AGENCY >30
- The Nature Conservancy 50
- Mountains Restoration Trust 29
- National Audubon Society 29
- 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
- Endangered Habitats Conservancy 14
- Fallbrook Land Conservancy 14
- Wilderness Land Trust 14
- Bear Yuba Land Trust 10
- Friends of the Desert Mountains 10
- Del Monte Forest Foundation 10
- Mojave Desert Land Trust 10
- Marin Audubon Society 9
- Elkhorn Slough Foundation 9
- The Conservation Fund - California 9
- John Muir Land Trust 8
- Solano Land Trust 8
- Los Angeles Neighborhood Land Trust 8
- …
DES_TP 15
- Private Conservation 613
- Private Recreation or Education 75
- Private Other or Unknown 51
- Private Agricultural 12
- Local Park 5
- National Monument or Landmark 5
- Local Recreation Area 4
- State Conservation Area 4
- Private Historic or Cultural 4
- State Park 3
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 12
MNG_AG_LEV 6 ✖
- Non Profit 759
- State 8
- Special District 7
- County 4
- City 2
- Federal 1
ACCESS_TYP 4
- Open Access 286
- No Public Access 267
- Restricted Access 168
- Unknown Access 60
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2539 | 2539 | 2538 | {"type": "Polygon", "coordinates": [[[-118.6218, 34.10061], [-118.62167, 34.10067], [-118.6216, 34.10059], [-118.62174, 34.10053], [-118.6218, 34.10061]]]} | No Public Access 3 | 12510 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.038 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
2800 | 2800 | 2799 | {"type": "Polygon", "coordinates": [[[-118.62165, 34.10163], [-118.62148, 34.10166], [-118.62143, 34.10159], [-118.62157, 34.10153], [-118.62165, 34.10163]]]} | No Public Access 3 | 12515 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.042 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
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 | |
16958 | 16958 | 16957 | {"type": "Polygon", "coordinates": [[[-118.62162, 34.10069], [-118.62138, 34.1008], [-118.62131, 34.10072], [-118.62156, 34.10061], [-118.62162, 34.10069]]]} | No Public Access 3 | 12507 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.069 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
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 | |
16970 | 16970 | 16969 | {"type": "Polygon", "coordinates": [[[-118.62222, 34.10346], [-118.62187, 34.10346], [-118.62175, 34.10335], [-118.62193, 34.10321], [-118.62222, 34.10346]]]} | No Public Access 3 | 12502 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.156 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
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 |
16957 | 16957 | 16956 | {"type": "Polygon", "coordinates": [[[-118.77416, 34.04757], [-118.77403, 34.04762], [-118.77363, 34.04741], [-118.7737, 34.04729], [-118.77414, 34.04746], [-118.77416, 34.04757]]]} | No Public Access 3 | 12504 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.213 | Mtns. Restoration Trust Parkland | 0 | 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 | |
2004 | 2004 | 2003 | {"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 | 16907 | Audubon Overlook | 15703 | 3043 | Morro Coast Audubon Society 468 | Non Profit 6 | Non Profit - Conservation 12 | http://www.morrocoastaudubon.org/ | Non Governmental Organization 10 | 3043 | Morro Coast Audubon Society 461 | Non Profit 6 | Non Profit - Conservation 12 | San Luis Obispo 1 | 0.256 | Audubon Overlook | 0 | Private Conservation 16 | 2 | |
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 | |
15805 | 15805 | 15804 | {"type": "Polygon", "coordinates": [[[-118.77383, 34.04565], [-118.77371, 34.04579], [-118.77369, 34.04597], [-118.77341, 34.04599], [-118.77339, 34.04567], [-118.77383, 34.04565]]]} | No Public Access 3 | 12523 | Mountains Restoration Trust Parkland | 29660 | 3044 | Mountains Restoration Trust 533 | Non Profit 6 | Non Profit - Conservation 12 | http://www.mountainstrust.org/ | Non Governmental Organization 10 | 3044 | Mountains Restoration Trust 526 | Non Profit 6 | Non Profit - Conservation 12 | Los Angeles 6 | 0.266 | Mtns. Restoration Trust Parkland | 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 |
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]);