superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
169 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: PARK_URL, YR_EST
MNG_AGENCY >30
- The Nature Conservancy 26
- Peninsula Open Space Trust 24
- American River Conservancy 13
- Save Mount Diablo 13
- Sonoma Land Trust 11
- Center for Natural Lands Management 7
- Elkhorn Slough Foundation 6
- Wilderness Land Trust 6
- Land Trust of Santa Cruz County 5
- The Environmental Trust 5
- Big Sur Land Trust 4
- Land Conservancy of San Luis Obispo County 4
- Pacific Forest Trust 4
- Bear Yuba Land Trust 3
- John Muir Land Trust 3
- Fallbrook Land Conservancy 3
- Placer Land Trust 3
- The Conservation Fund - California 3
- Save the Redwoods League 2
- Sequoia Riverlands Trust 2
- Land Trust of Napa County 2
- Escondido Creek Conservancy 2
- Solano Land Trust 2
- San Dieguito River Valley Land Conservancy 2
- Rivers and Lands Conservancy 2
- Ojai Valley Land Conservancy 2
- Friends of the Desert Mountains 1
- San Joaquin River Parkway and Conservation Trust 1
- Eastern Sierra Land Trust 1
- Mojave Desert Land Trust 1
- …
MNG_AG_TYP 1
- Non Profit - Land Trust · 169 ✖
ACCESS_TYP 1
- No Public Access · 169 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5782 | 5782 | 5781 | {"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 | Kraynick | 20724 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 0.091 | Kraynick | ||
13088 | 13088 | 13087 | {"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 | Balboa | 31690 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 0.426 | Balboa | ||
1910 | 1910 | 1909 | {"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.93306, 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.54427], [-121.93338, 36.54376], [-121.93361, 36.54372]]]} | No Public Access 3 | Carmel Point | 16873 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.547 | Carmel Point | ||
11627 | 11627 | 11626 | {"type": "Polygon", "coordinates": [[[-122.57517, 38.37016], [-122.57515, 38.37071], [-122.57458, 38.37071], [-122.57457, 38.37015], [-122.57517, 38.37016]]]} | No Public Access 3 | Bunnell Vernal Pool | 28171 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 0.778 | Bunnell Vernal Pool | ||
12075 | 12075 | 12074 | {"type": "Polygon", "coordinates": [[[-122.15393, 37.29035], [-122.15337, 37.2902], [-122.15234, 37.28908], [-122.15254, 37.28883], [-122.15265, 37.28907], [-122.15276, 37.28926], [-122.15289, 37.28945], [-122.15307, 37.28967], [-122.15328, 37.28988], [-122.15348, 37.29005], [-122.15393, 37.29035]]]} | No Public Access 3 | Nely Lane | 30540 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 0.797 | Nely Lane | ||
12133 | 12133 | 12132 | {"type": "Polygon", "coordinates": [[[-116.89141, 34.24771], [-116.89139, 34.24775], [-116.89092, 34.24766], [-116.89067, 34.24764], [-116.89021, 34.24767], [-116.89012, 34.24725], [-116.89068, 34.24717], [-116.89141, 34.24771]]]} | No Public Access 3 | Big Bear Eagle Point | 30588 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 1.036 | Big Bear Eagle Point | ||
5237 | 5237 | 5236 | {"type": "MultiPolygon", "coordinates": [[[[-121.08114, 35.55145], [-121.08094, 35.55155], [-121.08081, 35.55137], [-121.081, 35.55127], [-121.08114, 35.55145]]], [[[-121.08169, 35.55293], [-121.08166, 35.55296], [-121.08162, 35.55297], [-121.0814, 35.55288], [-121.08151, 35.55272], [-121.08167, 35.55289], [-121.08169, 35.55293]]], [[[-121.08169, 35.55181], [-121.0815, 35.55191], [-121.08145, 35.55186], [-121.08165, 35.55176], [-121.08169, 35.55181]]], [[[-121.08289, 35.55133], [-121.08268, 35.55142], [-121.0826, 35.55129], [-121.08281, 35.55121], [-121.08289, 35.55133]]], [[[-121.08323, 35.55368], [-121.08304, 35.55379], [-121.083, 35.55374], [-121.08318, 35.55362], [-121.08323, 35.55368]]], [[[-121.08343, 35.5522], [-121.08323, 35.55229], [-121.08305, 35.55203], [-121.08322, 35.55198], [-121.08328, 35.55199], [-121.08343, 35.5522]]], [[[-121.08398, 35.553], [-121.08385, 35.55317], [-121.08371, 35.55309], [-121.08383, 35.55293], [-121.08398, 35.553]]], [[[-121.08484, 35.55543], [-121.08475, 35.55561], [-121.08467, 35.55559], [-121.08476, 35.5554], [-121.08484, 35.55543]]], [[[-121.08514, 35.5535], [-121.08511, 35.55367], [-121.08494, 35.55365], [-121.08497, 35.55347], [-121.08514, 35.5535]]], [[[-121.08639, 35.55379], [-121.08638, 35.55383], [-121.08634, 35.55385], [-121.08599, 35.55394], [-121.08602, 35.55379], [-121.08594, 35.55376], [-121.08597, 35.5536], [-121.0862, 35.55366], [-121.08636, 35.55374], [-121.08639, 35.55379]]], [[[-121.08617, 35.55567], [-121.08611, 35.55581], [-121.08603, 35.55579], [-121.08609, 35.55564], [-121.08617, 35.55567]]], [[[-121.08866, 35.55383], [-121.08865, 35.55389], [-121.08842, 35.55387], [-121.08844, 35.5538], [-121.08866, 35.55383]]], [[[-121.08965, 35.557], [-121.08936, 35.55714], [-121.08931, 35.557], [-121.08958, 35.55687], [-121.0896, 35.55695], [-121.08965, 35.557]]]]} | No Public Access 3 | Lodge Hill parcels | 21397 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 1.127 | Lodge Hill parcels | ||
13808 | 13808 | 13807 | {"type": "Polygon", "coordinates": [[[-122.4022, 37.20214], [-122.40125, 37.20225], [-122.4012, 37.20194], [-122.40118, 37.20168], [-122.40207, 37.20156], [-122.4022, 37.20214]]]} | No Public Access 3 | Bolsa Point | 31330 | 3054 | Peninsula Open Space Trust 335 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.openspacetrust.org/ | Non Governmental Organization 10 | 1.321 | Bolsa Point | ||
2682 | 2682 | 2681 | {"type": "Polygon", "coordinates": [[[-117.27099, 33.11486], [-117.27071, 33.11529], [-117.27021, 33.11588], [-117.27021, 33.11462], [-117.27039, 33.11459], [-117.27068, 33.11463], [-117.27068, 33.11466], [-117.27084, 33.11474], [-117.27086, 33.11483], [-117.2709, 33.11482], [-117.27099, 33.11486]]]} | No Public Access 3 | Cassia Professional Offices Preserve | 16944 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 1.463 | Cassia Professional Offices Preserve | ||
5680 | 5680 | 5679 | {"type": "Polygon", "coordinates": [[[-121.85546, 37.89221], [-121.85527, 37.89229], [-121.85529, 37.89252], [-121.85529, 37.89268], [-121.85503, 37.89298], [-121.85481, 37.89305], [-121.85461, 37.89329], [-121.85368, 37.89311], [-121.854, 37.8926], [-121.8552, 37.89211], [-121.85544, 37.89196], [-121.85546, 37.89221]]]} | No Public Access 3 | Marsh Creek IV | 21890 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 2.681 | Marsh Creek IV | ||
9770 | 9770 | 9769 | {"type": "Polygon", "coordinates": [[[-122.55345, 38.40221], [-122.55342, 38.40222], [-122.55339, 38.40241], [-122.55334, 38.40261], [-122.5533, 38.4027], [-122.55328, 38.40271], [-122.55302, 38.40335], [-122.5529, 38.40379], [-122.55285, 38.40389], [-122.55273, 38.40398], [-122.55259, 38.40403], [-122.55217, 38.40408], [-122.55197, 38.40413], [-122.55139, 38.40441], [-122.55124, 38.40451], [-122.55114, 38.40465], [-122.55105, 38.40484], [-122.55103, 38.405], [-122.55083, 38.40493], [-122.55088, 38.40472], [-122.55094, 38.40461], [-122.55106, 38.40447], [-122.55121, 38.40434], [-122.55159, 38.40415], [-122.5516, 38.40413], [-122.55188, 38.40399], [-122.55214, 38.40394], [-122.55215, 38.40392], [-122.55253, 38.40387], [-122.55263, 38.40384], [-122.5527, 38.40377], [-122.55274, 38.40369], [-122.55286, 38.40326], [-122.55313, 38.40259], [-122.55315, 38.40258], [-122.55323, 38.40229], [-122.55325, 38.40214], [-122.55327, 38.40213], [-122.55327, 38.40197], [-122.55321, 38.40156], [-122.5528, 38.40071], [-122.55261, 38.40048], [-122.55248, 38.40036], [-122.55232, 38.40025], [-122.55216, 38.40016], [-122.55176, 38.39998], [-122.55175, 38.39995], [-122.55175, 38.39974], [-122.55218, 38.40001], [-122.55243, 38.40014], [-122.5526, 38.40026], [-122.55275, 38.40039], [-122.55288, 38.40054], [-122.55298, 38.4007], [-122.55313, 38.40102], [-122.55308, 38.40106], [-122.55324, 38.40139], [-122.55329, 38.40139], [-122.55336, 38.40156], [-122.55344, 38.40188], [-122.55345, 38.40221]]]} | No Public Access 3 | Sonoma Creek | 25610 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 2.818 | Sonoma Creek | ||
13288 | 13288 | 13287 | {"type": "Polygon", "coordinates": [[[-122.58261, 37.85753], [-122.58259, 37.8576], [-122.58251, 37.85765], [-122.58238, 37.85766], [-122.58222, 37.85781], [-122.58223, 37.85789], [-122.5822, 37.85802], [-122.58207, 37.85822], [-122.58182, 37.85825], [-122.58184, 37.85843], [-122.58135, 37.85849], [-122.58134, 37.85841], [-122.58127, 37.85842], [-122.58132, 37.85872], [-122.58066, 37.85877], [-122.58048, 37.85852], [-122.58056, 37.8582], [-122.58066, 37.85798], [-122.58082, 37.85776], [-122.581, 37.85765], [-122.58118, 37.85765], [-122.58129, 37.8577], [-122.58138, 37.85771], [-122.58154, 37.85766], [-122.58164, 37.85754], [-122.58173, 37.85747], [-122.5818, 37.85734], [-122.5818, 37.85728], [-122.582, 37.85714], [-122.58207, 37.85711], [-122.58216, 37.85712], [-122.58229, 37.85715], [-122.5824, 37.8572], [-122.58246, 37.85725], [-122.58247, 37.85738], [-122.5825, 37.85742], [-122.58256, 37.85746], [-122.58261, 37.85753]]]} | No Public Access 3 | Spindrift Preserve | 30615 | 3091 | The Nature Conservancy 61 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.nature.org/ | Non Governmental Organization 10 | 4.229 | Spindrift Preserve | ||
6262 | 6262 | 6261 | {"type": "Polygon", "coordinates": [[[-120.93652, 38.63111], [-120.9365, 38.63193], [-120.93417, 38.63196], [-120.93415, 38.63114], [-120.93652, 38.63111]]]} | No Public Access 3 | Lipa Waterfalls | 21329 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 4.642 | Lipa Waterfalls | ||
7363 | 7363 | 7362 | {"type": "Polygon", "coordinates": [[[-117.03443, 32.57835], [-117.03338, 32.57837], [-117.03339, 32.57655], [-117.03443, 32.57653], [-117.03443, 32.57835]]]} | No Public Access 3 | Newport 5 Preserve | 22731 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 4.918 | Newport 5 Preserve | |||
11597 | 11597 | 11596 | {"type": "Polygon", "coordinates": [[[-121.92075, 37.92393], [-121.9207, 37.92397], [-121.92039, 37.92381], [-121.9203, 37.92414], [-121.92003, 37.92424], [-121.91984, 37.92395], [-121.91964, 37.92376], [-121.91951, 37.92367], [-121.91935, 37.92359], [-121.91901, 37.9235], [-121.919, 37.92085], [-121.91954, 37.92244], [-121.91992, 37.92282], [-121.92054, 37.92333], [-121.92036, 37.92371], [-121.92075, 37.92393]]]} | No Public Access 3 | Lot 25 | 28140 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 5.016 | Lot 25 | ||
3714 | 3714 | 3713 | {"type": "Polygon", "coordinates": [[[-121.75471, 37.90136], [-121.75464, 37.90146], [-121.75417, 37.90192], [-121.75141, 37.90095], [-121.75176, 37.90033], [-121.75471, 37.90136]]]} | No Public Access 3 | Dry Creek | 18280 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 5.18 | Dry Creek | ||
11547 | 11547 | 11546 | {"type": "Polygon", "coordinates": [[[-116.32668, 33.22441], [-116.32666, 33.22675], [-116.32578, 33.22675], [-116.32579, 33.22442], [-116.32668, 33.22441]]]} | No Public Access 3 | Mesquite Bosque | 28286 | 3004 | Anza-Borrego Foundation 822 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.theabf.org/ | Non Governmental Organization 10 | 5.284 | Mesquite Bosque | ||
5682 | 5682 | 5681 | {"type": "Polygon", "coordinates": [[[-121.85413, 37.89196], [-121.8541, 37.89216], [-121.85391, 37.89258], [-121.85359, 37.89309], [-121.85291, 37.89291], [-121.853, 37.89277], [-121.85296, 37.89026], [-121.85326, 37.89012], [-121.85368, 37.89116], [-121.85406, 37.89177], [-121.85413, 37.89196]]]} | No Public Access 3 | Marsh Creek VI | 21892 | 3073 | Save Mount Diablo 622 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savemountdiablo.org/ | Non Governmental Organization 10 | 5.462 | Marsh Creek VI | ||
2110 | 2110 | 2109 | {"type": "Polygon", "coordinates": [[[-122.17793, 37.90594], [-122.17733, 37.90582], [-122.17717, 37.90575], [-122.17703, 37.90565], [-122.17594, 37.90451], [-122.1759, 37.90445], [-122.1758, 37.90422], [-122.17658, 37.90386], [-122.17688, 37.90402], [-122.17698, 37.90406], [-122.17712, 37.90407], [-122.1773, 37.90402], [-122.17734, 37.90402], [-122.1777, 37.90423], [-122.17801, 37.90516], [-122.17793, 37.90594]]]} | No Public Access 3 | Bodfish Preserve | 16221 | 3045 | John Muir Land Trust 105 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jmlt.org/ | Non Governmental Organization 10 | 6.524 | Bodfish Preserve | 2003 | |
10372 | 10372 | 10371 | {"type": "Polygon", "coordinates": [[[-120.70034, 35.19238], [-120.70034, 35.19247], [-120.69736, 35.19188], [-120.69769, 35.19026], [-120.6994, 35.19064], [-120.69895, 35.19211], [-120.70034, 35.19238]]]} | No Public Access 3 | TNC | 26376 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 7.131 | TNC |
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]);