units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
211 rows where ACCESS_TYP = 3 and DES_TP = 16 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_LEV, AGNCY_TYP, MNG_AG_LEV, YR_EST
MNG_AGENCY >30
- The Nature Conservancy 30
- Peninsula Open Space Trust 22
- The Environmental Trust 21
- Endangered Habitats Conservancy 14
- American River Conservancy 13
- Save Mount Diablo 13
- Sonoma Land Trust 10
- Center for Natural Lands Management 8
- Elkhorn Slough Foundation 8
- Marin Audubon Society 7
- Wilderness Land Trust 5
- Land Trust of Santa Cruz County 4
- Big Sur Land Trust 4
- Land Conservancy of San Luis Obispo County 4
- Pacific Forest Trust 4
- The Conservation Fund - California 4
- Bear Yuba Land Trust 3
- John Muir Land Trust 3
- Fallbrook Land Conservancy 3
- Placer Land Trust 3
- Save the Redwoods League 2
- Land Trust of Napa County 2
- Escondido Creek Conservancy 2
- Solano Land Trust 2
- National Audubon Society 2
- Audubon Canyon Ranch 2
- Ojai Valley Land Conservancy 2
- Sequoia Riverlands Trust 1
- Friends of the Desert Mountains 1
- California Biological Field Studies Association 1
- …
MNG_AG_TYP 4
DES_TP 1
- Private Conservation · 211 ✖
ACCESS_TYP 1
- No Public Access · 211 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
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 | ||
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 | |
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 | |
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 | |
8178 | 8178 | 8177 | {"type": "Polygon", "coordinates": [[[-117.14201, 32.97455], [-117.14188, 32.97462], [-117.14104, 32.97463], [-117.14104, 32.97435], [-117.14107, 32.97432], [-117.14158, 32.97431], [-117.14176, 32.97445], [-117.14201, 32.97446], [-117.14201, 32.97455]]]} | No Public Access 3 | 12383 | 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.632 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
8181 | 8181 | 8180 | {"type": "Polygon", "coordinates": [[[-117.30491, 33.0932], [-117.30453, 33.09207], [-117.30484, 33.09153], [-117.30491, 33.09304], [-117.30491, 33.0932]]]} | No Public Access 3 | 12389 | 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.747 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
11905 | 11905 | 11904 | {"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 | 24493 | Bunnell Vernal Pool | 28171 | 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 | Sonoma 16 | 0.779 | Bunnell Vernal Pool | 0 | Private Conservation 16 | 2 | |
12683 | 12683 | 12682 | {"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 | 46923 | Nely Lane | 30540 | 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 | Santa Clara 19 | 0.798 | Nely Lane | 0 | Private Conservation 16 | 2 | |
8179 | 8179 | 8178 | {"type": "Polygon", "coordinates": [[[-117.28623, 33.14129], [-117.28623, 33.14129], [-117.28489, 33.14169], [-117.28558, 33.1409], [-117.28623, 33.14129]]]} | No Public Access 3 | 12385 | 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 | 1.011 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
5623 | 5623 | 5622 | {"type": "Polygon", "coordinates": [[[-116.89141, 34.24771], [-116.89139, 34.24775], [-116.89093, 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 | 45308 | Big Bear Eagle Point | 30588 | 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 Bernardino 22 | 1.036 | Big Bear Eagle Point | 0 | Private Conservation 16 | 2 | |
3739 | 3739 | 3738 | {"type": "Polygon", "coordinates": [[[-122.53527, 38.06893], [-122.5352, 38.06916], [-122.53501, 38.06911], [-122.53442, 38.06923], [-122.53406, 38.06927], [-122.53308, 38.06944], [-122.53252, 38.06952], [-122.53229, 38.06957], [-122.53239, 38.06949], [-122.53251, 38.06943], [-122.5325, 38.06937], [-122.53297, 38.06927], [-122.53439, 38.06908], [-122.53527, 38.06893]]]} | No Public Access 3 | 31028 | Marin Audubon Society | 21815 | 3039 | Marin Audubon Society 261 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinaudubon.org | Non Governmental Organization 10 | 3039 | Marin Audubon Society 257 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 1.098 | Marin Audubon Society | 0 | Private Conservation 16 | 2 | |
10046 | 10046 | 10045 | {"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.55378], [-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 | 17393 | Lodge Hill parcels | 21397 | 3032 | Land Conservancy of San Luis Obispo County 506 | Non Profit 6 | Non Profit - Land Trust 10 | http://lcslo.org/ | Non Governmental Organization 10 | 3032 | Land Conservancy of San Luis Obispo County 498 | Non Profit 6 | Non Profit - Land Trust 10 | San Luis Obispo 1 | 1.127 | Lodge Hill parcels | 0 | Private Conservation 16 | 2 | |
7385 | 7385 | 7384 | {"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 | 47598 | Bolsa Point | 31330 | 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 | 1.321 | Bolsa Point | 0 | Private Conservation 16 | 2 | |
15293 | 15293 | 15292 | {"type": "Polygon", "coordinates": [[[-118.42222, 33.91688], [-118.4218, 33.91688], [-118.42178, 33.91679], [-118.42102, 33.91679], [-118.42102, 33.91638], [-118.42222, 33.91637], [-118.42222, 33.91688]]]} | No Public Access 3 | 46424 | El Segundo Blue Butterfly Preserve | 29696 | 6107 | Chevron Corporation 1149 | Private 7 | Commercial 20 | http://www.chevron.com/ | Private 14 | 6107 | Chevron Corporation 1096 | Private 7 | Commercial 18 | Los Angeles 6 | 1.358 | El Segundo Blue Butterfly Preserve | 0 | Private Conservation 16 | 2 | |
8180 | 8180 | 8179 | {"type": "Polygon", "coordinates": [[[-117.14409, 32.97117], [-117.14395, 32.97109], [-117.14349, 32.97116], [-117.14334, 32.9712], [-117.14311, 32.97129], [-117.14298, 32.97143], [-117.14283, 32.97134], [-117.14262, 32.97134], [-117.14241, 32.97126], [-117.14226, 32.97152], [-117.14221, 32.97148], [-117.14212, 32.97145], [-117.142, 32.97148], [-117.14191, 32.97142], [-117.14158, 32.97142], [-117.14184, 32.97106], [-117.14409, 32.97105], [-117.14409, 32.97117]]]} | No Public Access 3 | 12386 | 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 | 1.452 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 2 | ||
14622 | 14622 | 14621 | {"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.27085, 33.11484], [-117.2709, 33.11482], [-117.27099, 33.11486]]]} | No Public Access 3 | 44873 | Cassia Professional Offices Preserve | 16944 | 3014 | Center for Natural Lands Management 91 | Non Profit 6 | Non Profit - Land Trust 10 | http://cnlm.org/ | Non Governmental Organization 10 | 3014 | Center for Natural Lands Management 89 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 1.462 | Cassia Professional Offices Preserve | 0 | Private Conservation 16 | 2 | |
12992 | 12992 | 12991 | {"type": "Polygon", "coordinates": [[[-122.52978, 37.8954], [-122.52954, 37.89543], [-122.52847, 37.89519], [-122.52798, 37.89489], [-122.5279, 37.89438], [-122.52814, 37.89335], [-122.52828, 37.89337], [-122.52811, 37.89431], [-122.52822, 37.89474], [-122.52855, 37.89493], [-122.52945, 37.89515], [-122.52977, 37.89515], [-122.52978, 37.8954]]]} | No Public Access 3 | 31029 | Marin Audubon Society | 21815 | 3039 | Marin Audubon Society 261 | Non Profit 6 | Non Profit - Conservation 12 | http://www.marinaudubon.org | Non Governmental Organization 10 | 3039 | Marin Audubon Society 257 | Non Profit 6 | Non Profit - Conservation 12 | Marin 23 | 1.819 | Marin Audubon Society | 0 | Private Conservation 16 | 2 | |
11546 | 11546 | 11545 | {"type": "Polygon", "coordinates": [[[-116.89021, 32.80935], [-116.89021, 32.80935], [-116.88892, 32.80921], [-116.88944, 32.80854], [-116.89012, 32.80849], [-116.89021, 32.80935]]]} | No Public Access 3 | 46824 | Guyot/La Cresta Property | 30292 | 3208 | Endangered Habitats Conservancy 79 | Non Profit 6 | Non Profit - Conservation 12 | http://www.ehleague.org/EndangeredHabitatsConservancy.html | Non Governmental Organization 10 | 3208 | Endangered Habitats Conservancy 77 | Non Profit 6 | Non Profit - Conservation 12 | San Diego 4 | 1.954 | Guyot/La Cresta Property | 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]);