superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
155 rows where ACCESS_TYP = 2 and LAYER = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AGENCY >30
- Sempervirens Fund 16
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- The Nature Conservancy 13
- Sonoma Land Trust 8
- Center for Natural Lands Management 5
- Solano Land Trust 5
- Sequoia Riverlands Trust 4
- Save Mount Diablo 4
- Truckee Donner Land Trust 4
- San Diego River Park Foundation 4
- Land Trust of Santa Cruz County 3
- The Wildlands Conservancy 3
- Peninsula Open Space Trust 3
- The Conservation Fund - California 3
- Save the Redwoods League 2
- Bear Yuba Land Trust 2
- LandPaths 2
- Land Trust for Santa Barbara County 2
- Fallbrook Land Conservancy 2
- Santa Catalina Island Conservancy 2
- Mountains Restoration Trust 2
- Los Angeles Neighborhood Land Trust 2
- Lake County Land Trust 2
- National Audubon Society 2
- Rivers and Lands Conservancy 2
- Santa Lucia Conservancy 1
- John Muir Land Trust 1
- Friends of the Desert Mountains 1
- Arroyos and Foothills Conservancy 1
- …
MNG_AG_TYP 4
ACCESS_TYP 1
- Restricted Access · 155 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10396 | 10396 | 10395 | {"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 | Tor House | 26411 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.129 | Tor House | ||
12666 | 12666 | 12665 | {"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 | Erika J. Glazer Community Garden | 29800 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.165 | Erika J. Glazer Community Garden | ||
7063 | 7063 | 7062 | {"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 | Mission Trails/Probasco | 22315 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.255 | Mission Trails/Probasco | ||
5091 | 5091 | 5090 | {"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.93848, 36.50138], [-121.93848, 36.50133], [-121.93865, 36.50129]]]} | Restricted Access 2 | Highlands Inn turnout | 19940 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.373 | Highlands Inn turnout | ||
12632 | 12632 | 12631 | {"type": "Polygon", "coordinates": [[[-118.30015, 33.94065], [-118.30015, 33.94116], [-118.29968, 33.94116], [-118.29969, 33.94065], [-118.30015, 33.94065]]]} | Restricted Access 2 | West Athens Victory Garden | http://littlegreenfingersla.org/garden/west-athens-victory-garden/ | 29801 | 3269 | Los Angeles Neighborhood Land Trust 556 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.lanlt.org/ | Non Governmental Organization 10 | 0.591 | West Athens Victory Garden | 2013 |
5037 | 5037 | 5036 | {"type": "Polygon", "coordinates": [[[-121.75445, 36.22079], [-121.75378, 36.22097], [-121.75356, 36.22094], [-121.7535, 36.2208], [-121.75377, 36.22063], [-121.75412, 36.22022], [-121.7541, 36.22039], [-121.75416, 36.22056], [-121.75428, 36.2207], [-121.75445, 36.22079]]]} | Restricted Access 2 | Henry Miller Library | 19825 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 0.707 | Henry Miller Library | ||
8109 | 8109 | 8108 | {"type": "MultiPolygon", "coordinates": [[[[-122.50461, 38.11713], [-122.50461, 38.11714], [-122.50399, 38.11757], [-122.50451, 38.11703], [-122.50461, 38.11713]]], [[[-122.50863, 38.1256], [-122.50826, 38.12589], [-122.5074, 38.1264], [-122.5073, 38.12632], [-122.5077, 38.12596], [-122.50808, 38.12568], [-122.50863, 38.1256]]]]} | Restricted Access 2 | Petaluma River Marsh | 23624 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 0.799 | Petaluma River Marsh | ||
7637 | 7637 | 7636 | {"type": "MultiPolygon", "coordinates": [[[[-118.38426, 33.41378], [-118.3842, 33.41383], [-118.38414, 33.41394], [-118.38401, 33.41383], [-118.384, 33.41378], [-118.38413, 33.41372], [-118.38426, 33.41372], [-118.38426, 33.41378]]], [[[-118.38964, 33.41779], [-118.38964, 33.41785], [-118.38958, 33.41785], [-118.38951, 33.41779], [-118.38951, 33.41769], [-118.38957, 33.41769], [-118.38964, 33.41779]]], [[[-118.40478, 33.42155], [-118.4047, 33.42166], [-118.40464, 33.42166], [-118.40457, 33.42161], [-118.40457, 33.42155], [-118.40464, 33.42149], [-118.4047, 33.42155], [-118.40478, 33.42155]]], [[[-118.40497, 33.42045], [-118.40496, 33.42056], [-118.4049, 33.42056], [-118.40477, 33.42051], [-118.40484, 33.42045], [-118.40497, 33.42045]]], [[[-118.47979, 33.38818], [-118.47972, 33.38823], [-118.47959, 33.38823], [-118.47959, 33.38818], [-118.47946, 33.38806], [-118.47946, 33.38796], [-118.47952, 33.38796], [-118.47959, 33.38802], [-118.47972, 33.38807], [-118.47979, 33.38818]]], [[[-118.4811, 33.38065], [-118.48097, 33.38071], [-118.48091, 33.38065], [-118.4809, 33.38059], [-118.4811, 33.3806], [-118.4811, 33.38065]]], [[[-118.48156, 33.37878], [-118.4815, 33.37889], [-118.48142, 33.37894], [-118.4813, 33.37889], [-118.48129, 33.37878], [-118.48133, 33.37875], [-118.48139, 33.37878], [-118.48144, 33.37879], [-118.48152, 33.37875], [-118.48156, 33.37878]]], [[[-118.4815, 33.37944], [-118.48149, 33.37954], [-118.48142, 33.37955], [-118.48136, 33.37949], [-118.48143, 33.37944], [-118.4815, 33.37944]]], [[[-118.48404, 33.39928], [-118.48397, 33.39934], [-118.48391, 33.39934], [-118.48391, 33.39926], [-118.48396, 33.39927], [-118.48401, 33.39924], [-118.48404, 33.39928]]], [[[-118.48436, 33.39945], [-118.48417, 33.39945], [-118.48417, 33.3994], [-118.48423, 33.39934], [-118.4843, 33.39934], [-118.48436, 33.39945]]], [[[-118.48607, 33.39978], [-118.48594, 33.39984], [-118.48588, 33.39978], [-118.48587, 33.39969], [-118.48595, 33.39971], [-118.48601, 33.39968], [-118.48607, 33.39978]]], [[[-118.52159, 33.4659], [-118.52152, 33.46601], [-118.52146, 33.46606], [-118.52132, 33.46612], [-118.52126, 33.46616], [-118.52119, 33.46606], [-118.5212, 33.46595], [-118.52126, 33.46589], [-118.52133, 33.46589], [-118.52146, 33.46584], [-118.52158, 33.46584], [-118.52159, 33.4659]]], [[[-118.52702, 33.46803], [-118.5269, 33.46799], [-118.52682, 33.468], [-118.52666, 33.46817], [-118.52666, 33.46821], [-118.52663, 33.46821], [-118.52656, 33.46816], [-118.52656, 33.4681], [-118.5267, 33.46799], [-118.52683, 33.46794], [-118.52696, 33.46799], [-118.52702, 33.46799], [-118.52702, 33.46803]]], [[[-118.56014, 33.43285], [-118.56001, 33.43285], [-118.55987, 33.4328], [-118.55988, 33.43274], [-118.55994, 33.43269], [-118.56007, 33.43274], [-118.56014, 33.43279], [-118.56014, 33.43285]]], [[[-118.58083, 33.4493], [-118.58077, 33.44936], [-118.58064, 33.44941], [-118.58051, 33.44931], [-118.58051, 33.44914], [-118.58057, 33.44908], [-118.5807, 33.44909], [-118.58083, 33.4492], [-118.58083, 33.4493]]], [[[-118.60553, 33.47252], [-118.60547, 33.47263], [-118.60527, 33.47264], [-118.60527, 33.47247], [-118.6052, 33.47236], [-118.6052, 33.47225], [-118.60533, 33.47225], [-118.60547, 33.4723], [-118.60553, 33.47242], [-118.60553, 33.47252]]]]} | Restricted Access 2 | Offshore Island | 23072 | 3070 | Santa Catalina Island Conservancy 377 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.catalinaconservancy.org/ | Non Governmental Organization 10 | 1.431 | Offshore Island | ||
12269 | 12269 | 12268 | {"type": "Polygon", "coordinates": [[[-122.00321, 37.0735], [-122.00314, 37.07355], [-122.00311, 37.07363], [-122.00284, 37.07352], [-122.00255, 37.07348], [-122.00256, 37.07375], [-122.00202, 37.07388], [-122.00183, 37.07412], [-122.00138, 37.0739], [-122.00159, 37.07363], [-122.00172, 37.07352], [-122.0019, 37.07342], [-122.00216, 37.07336], [-122.00242, 37.07332], [-122.00269, 37.07334], [-122.00297, 37.0734], [-122.00321, 37.0735]]]} | Restricted Access 2 | Glenwood | 30716 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 1.509 | Glenwood | ||
13278 | 13278 | 13277 | {"type": "Polygon", "coordinates": [[[-121.81078, 39.71922], [-121.81078, 39.71922], [-121.8073, 39.71927], [-121.80736, 39.71921], [-121.80878, 39.71918], [-121.80878, 39.71845], [-121.81077, 39.71844], [-121.81078, 39.71922]]]} | Restricted Access 2 | Silver Dollar BMX | https://www.usabmx.com/tracks/1344/about | 33416 | 3395 | Silver Dollar BMX 929 | Non Profit 6 | Non Profit - Other 20 | https://www.usabmx.com/tracks/1344/about | Non Governmental Organization 10 | 3.943 | Silver Dollar BMX | |
55 | 55 | 54 | {"type": "Polygon", "coordinates": [[[-117.77532, 34.12952], [-117.77504, 34.12945], [-117.77433, 34.1294], [-117.77405, 34.12932], [-117.77412, 34.12916], [-117.77405, 34.12898], [-117.77414, 34.12894], [-117.77434, 34.12867], [-117.77432, 34.1286], [-117.7742, 34.12857], [-117.77402, 34.12834], [-117.77396, 34.12824], [-117.77394, 34.12812], [-117.77421, 34.12798], [-117.77383, 34.12742], [-117.774, 34.1274], [-117.77418, 34.12741], [-117.77492, 34.12751], [-117.77483, 34.12784], [-117.77483, 34.12796], [-117.77491, 34.12831], [-117.77504, 34.12874], [-117.77512, 34.12876], [-117.77516, 34.12873], [-117.77532, 34.12952]]]} | Restricted Access 2 | La Verne Heritage Foundation | 31773 | 3382 | La Verne Heritage Foundation 888 | Non Profit 6 | Non Profit - Other 20 | https://www.laverneheritage.org/ | Non Governmental Organization 10 | 4.636 | La Verne Heritage Foundation | ||
572 | 572 | 571 | {"type": "Polygon", "coordinates": [[[-119.54118, 36.51798], [-119.54116, 36.52003], [-119.54018, 36.52002], [-119.54021, 36.51798], [-119.54118, 36.51798]]]} | Restricted Access 2 | Kingsburg Historical Park | http://kingsburghistoricalpark.org/ | 32675 | 3138 | Kingsburg Historical Society 795 | Non Profit 6 | Non Profit - Other 20 | http://www.kingsburghistoricalpark.org/ | Non Governmental Organization 10 | 4.887 | Kingsburg Historical Park | |
5774 | 5774 | 5773 | {"type": "Polygon", "coordinates": [[[-121.43202, 35.86496], [-121.43153, 35.86465], [-121.42979, 35.86366], [-121.42952, 35.86346], [-121.42931, 35.86325], [-121.4306, 35.86327], [-121.43074, 35.86332], [-121.43083, 35.86332], [-121.43092, 35.86336], [-121.43109, 35.8634], [-121.43128, 35.8635], [-121.43137, 35.86353], [-121.43147, 35.86354], [-121.43164, 35.86365], [-121.43173, 35.86367], [-121.43193, 35.86378], [-121.43198, 35.86385], [-121.43202, 35.86496]]]} | Restricted Access 2 | Kopp | 20717 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 5.005 | Kopp | ||
4530 | 4530 | 4529 | {"type": "Polygon", "coordinates": [[[-122.14589, 37.21808], [-122.14582, 37.21821], [-122.14578, 37.21847], [-122.14559, 37.21887], [-122.14558, 37.21907], [-122.14553, 37.21919], [-122.14372, 37.2192], [-122.1437, 37.2181], [-122.14589, 37.21808]]]} | Restricted Access 2 | Gee | 19247 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 5.342 | Gee | ||
4758 | 4758 | 4757 | {"type": "Polygon", "coordinates": [[[-122.19466, 37.15793], [-122.19268, 37.15833], [-122.19133, 37.15817], [-122.19141, 37.15754], [-122.19169, 37.15748], [-122.19213, 37.15729], [-122.19248, 37.15727], [-122.19291, 37.15713], [-122.19325, 37.15713], [-122.19388, 37.15727], [-122.19424, 37.15748], [-122.19448, 37.15752], [-122.19466, 37.15793]]]} | Restricted Access 2 | Griffith | 19515 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 6.86 | Griffith | ||
3720 | 3720 | 3719 | {"type": "Polygon", "coordinates": [[[-121.46596, 38.66791], [-121.46595, 38.66872], [-121.46583, 38.66866], [-121.46595, 38.66841], [-121.46579, 38.66833], [-121.46512, 38.6682], [-121.46418, 38.66813], [-121.46331, 38.66809], [-121.463, 38.66824], [-121.46235, 38.66836], [-121.46193, 38.66838], [-121.46111, 38.66833], [-121.46048, 38.66832], [-121.45968, 38.66858], [-121.45913, 38.66878], [-121.45875, 38.66888], [-121.45845, 38.66893], [-121.45814, 38.66895], [-121.4572, 38.66894], [-121.45713, 38.66904], [-121.45712, 38.66929], [-121.4569, 38.66927], [-121.4569, 38.66844], [-121.45715, 38.66844], [-121.4573, 38.66859], [-121.45804, 38.6686], [-121.45838, 38.66858], [-121.45884, 38.66849], [-121.45949, 38.66826], [-121.46, 38.66809], [-121.4603, 38.66801], [-121.46073, 38.66797], [-121.46113, 38.66797], [-121.46194, 38.66802], [-121.46228, 38.66801], [-121.46282, 38.6679], [-121.46319, 38.66773], [-121.46422, 38.66777], [-121.46424, 38.6678], [-121.46516, 38.66788], [-121.46574, 38.66796], [-121.46584, 38.6679], [-121.46596, 38.66791]]]} | Restricted Access 2 | Dry Creek Watershed | 18286 | 3061 | Sacramento Valley Conservancy 937 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sacramentovalleyconservancy.org/ | Non Governmental Organization 10 | 8.231 | Dry Creek Watershed | ||
440 | 440 | 439 | {"type": "Polygon", "coordinates": [[[-117.18941, 33.5381], [-117.18772, 33.53937], [-117.1867, 33.53844], [-117.18884, 33.53681], [-117.1892, 33.53738], [-117.18941, 33.5381]]]} | Restricted Access 2 | Murrieta Valley Pony Baseball | https://www.mvpb.org/ | 33498 | 3397 | Murrieta Valley PONY Baseball, Inc 992 | Non Profit 6 | Non Profit - Other 20 | https://www.mvpb.org/ | Non Governmental Organization 10 | 8.518 | Murrieta Valley Pony Baseball | |
4532 | 4532 | 4531 | {"type": "Polygon", "coordinates": [[[-121.7533, 36.23116], [-121.75183, 36.23133], [-121.75128, 36.23163], [-121.75085, 36.23034], [-121.75086, 36.22979], [-121.7533, 36.22983], [-121.7533, 36.23116]]]} | Restricted Access 2 | Gelbart | 19249 | 3008 | Big Sur Land Trust 169 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bigsurlandtrust.org | Non Governmental Organization 10 | 8.734 | Gelbart | ||
2392 | 2392 | 2391 | {"type": "Polygon", "coordinates": [[[-122.14677, 37.21609], [-122.14493, 37.21731], [-122.14513, 37.21749], [-122.14534, 37.21764], [-122.14562, 37.21778], [-122.14593, 37.21799], [-122.14589, 37.21808], [-122.1437, 37.2181], [-122.14367, 37.21611], [-122.14677, 37.21609]]]} | Restricted Access 2 | Butler | 16547 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 9.727 | Butler | ||
1417 | 1417 | 1416 | {"type": "Polygon", "coordinates": [[[-122.14367, 37.21657], [-122.14354, 37.21652], [-122.14303, 37.21586], [-122.14234, 37.21568], [-122.14172, 37.21539], [-122.14133, 37.21517], [-122.14115, 37.21505], [-122.14088, 37.21485], [-122.14062, 37.21462], [-122.14067, 37.21449], [-122.14068, 37.2144], [-122.14075, 37.21431], [-122.14105, 37.21399], [-122.14107, 37.21389], [-122.14322, 37.2139], [-122.14323, 37.21392], [-122.14268, 37.21489], [-122.14293, 37.21504], [-122.14326, 37.21515], [-122.14366, 37.21515], [-122.14367, 37.21657]]]} | Restricted Access 2 | Ahlgren | 15297 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 9.812 | Ahlgren |
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]);