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)
MNG_AGENCY >30
- The Nature Conservancy 50
- National Audubon Society 29
- Rivers and Lands Conservancy 28
- Peninsula Open Space Trust 26
- Center for Natural Lands Management 25
- The Wildlands Conservancy 24
- Sonoma Land Trust 24
- Truckee Donner Land Trust 24
- Mountains Restoration Trust 23
- The Environmental Trust 21
- American River Conservancy 20
- Big Sur Land Trust 19
- Land Trust of Napa County 18
- Sempervirens Fund 18
- Save the Redwoods League 17
- Save Mount Diablo 17
- Endangered Habitats Conservancy 14
- Fallbrook Land Conservancy 14
- Wilderness Land Trust 14
- Land Trust of Santa Cruz County 13
- 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
- Ojai Valley Land Conservancy 8
- …
DES_TP 15
- Private Conservation 601
- Private Recreation or Education 67
- 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
ACCESS_TYP 4
- Open Access 276
- No Public Access 260
- Restricted Access 165
- 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
12491 | 12491 | 12490 | {"type": "Polygon", "coordinates": [[[-118.59323, 34.10829], [-118.59283, 34.10826], [-118.59281, 34.10794], [-118.59295, 34.10796], [-118.59321, 34.10791], [-118.59323, 34.10829]]]} | No Public Access 3 | 12687 | Topanga Open Space | 29663 | 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.339 | Topanga OS | 0 | 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 | |
16954 | 16954 | 16953 | {"type": "Polygon", "coordinates": [[[-118.77802, 34.04594], [-118.77704, 34.04594], [-118.77695, 34.0458], [-118.77801, 34.0458], [-118.77802, 34.04594]]]} | No Public Access 3 | 12522 | 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.35 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
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 | |
4158 | 4158 | 4157 | {"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 | 45111 | WAYS Reading and Fitness Park | 28122 | 3352 | Heal the Bay 726 | Non Profit 6 | Non Profit - Other 22 | http://www.healthebay.org/ | Non Governmental Organization 10 | 3352 | Heal the Bay 711 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 0.387 | WAYS Reading and Fitness Park | 0 | Private Recreation or Education 65 | 4 | |
10608 | 10608 | 10607 | {"type": "Polygon", "coordinates": [[[-121.91003, 37.06168], [-121.90971, 37.06155], [-121.90985, 37.0612], [-121.9102, 37.06125], [-121.91025, 37.06129], [-121.91025, 37.06133], [-121.91003, 37.06168]]]} | Open Access 1 | 48632 | The Forest of Nisene Marks State Park | 1767 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | https://www.parks.ca.gov/nisene | Santa Cruz 5 | 0.399 | The Forest of Nisene Marks SP | 1963 | State Park 15 | 4 |
4230 | 4230 | 4229 | {"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 | 45071 | Patton Street Park | 28079 | 3094 | Trust for Public Land 734 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | https://www.tpl.org/our-work/parks-for-people/patton-street-park | Los Angeles 6 | 0.4 | Patton Street Park | 0 | Private Recreation or Education 65 | 4 |
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 | |
14706 | 14706 | 14705 | {"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.30822, 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 | 45061 | Western Gage Park | 32566 | 3269 | Los Angeles Neighborhood Land Trust 564 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 3368 | Los Angeles Neighborhood Initiative 1074 | Non Profit 6 | Non Profit - Other 20 | Los Angeles 6 | 0.428 | Western Gage Park | 0 | Private Recreation or Education 65 | 4 | |
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 | |
14687 | 14687 | 14686 | {"type": "Polygon", "coordinates": [[[-122.37606, 37.71341], [-122.37566, 37.71386], [-122.37538, 37.7137], [-122.37578, 37.71325], [-122.37606, 37.71341]]]} | No Public Access 3 | 45009 | San Francisco Bay Tidelands | 30614 | 3091 | The Nature Conservancy 63 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | San Francisco 13 | 0.46 | San Francisco Bay Tidelands | 0 | Private Conservation 16 | 2 | |
2577 | 2577 | 2576 | {"type": "Polygon", "coordinates": [[[-118.61509, 34.08307], [-118.61508, 34.08325], [-118.61399, 34.08325], [-118.61398, 34.08307], [-118.61509, 34.08307]]]} | No Public Access 3 | 12513 | 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.501 | Mtns. Restoration Trust Parkland | 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 |
5406 | 5406 | 5405 | {"type": "Polygon", "coordinates": [[[-118.77959, 34.0458], [-118.7791, 34.0458], [-118.7791, 34.04539], [-118.77959, 34.04539], [-118.77959, 34.0458]]]} | No Public Access 3 | 12498 | 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.514 | Mtns. Restoration Trust Parkland | 0 | Private Recreation or Education 65 | 4 | |
6413 | 6413 | 6412 | {"type": "Polygon", "coordinates": [[[-121.93361, 36.54372], [-121.93342, 36.54391], [-121.9333, 36.54419], [-121.93338, 36.54444], [-121.93337, 36.54452], [-121.93334, 36.54453], [-121.93305, 36.54443], [-121.93288, 36.54441], [-121.93264, 36.54448], [-121.9325, 36.54447], [-121.93239, 36.54448], [-121.93237, 36.54438], [-121.93252, 36.54434], [-121.93284, 36.54436], [-121.93292, 36.54428], [-121.9331, 36.54428], [-121.93338, 36.54376], [-121.93361, 36.54372]]]} | No Public Access 3 | 3340 | Carmel Point | 16873 | 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.545 | Carmel Point | 0 | Private Conservation 16 | 2 | |
14713 | 14713 | 14712 | {"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 | 45052 | Madison Avenue Park | 28044 | 3094 | Trust for Public Land 734 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/ | Non Governmental Organization 10 | 3094 | Trust for Public Land 718 | Non Profit 6 | Non Profit - Conservation 12 | http://www.tpl.org/our-work/parks-for-people/madison-ave-park | Los Angeles 6 | 0.559 | Madison Avenue Park | 0 | Private Recreation or Education 65 | 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]);