units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
629 rows where DES_TP = 16 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- The Nature Conservancy 47
- National Audubon Society 27
- Sonoma Land Trust 24
- Center for Natural Lands Management 23
- The Wildlands Conservancy 23
- Peninsula Open Space Trust 21
- Truckee Donner Land Trust 21
- The Environmental Trust 19
- Land Trust of Napa County 18
- Sempervirens Fund 18
- American River Conservancy 18
- Big Sur Land Trust 17
- Save Mount Diablo 17
- Endangered Habitats Conservancy 14
- Fallbrook Land Conservancy 14
- Wilderness Land Trust 13
- Land Trust of Santa Cruz County 12
- Save the Redwoods League 10
- Bear Yuba Land Trust 10
- Marin Audubon Society 9
- Elkhorn Slough Foundation 9
- The Conservation Fund - California 9
- Mojave Desert Land Trust 8
- Ojai Valley Land Conservancy 8
- Friends of the Desert Mountains 7
- Sierra Foothill Conservancy 7
- Solano Land Trust 7
- San Diego River Park Foundation 7
- John Muir Land Trust 6
- Sequoia Riverlands Trust 6
- …
MNG_AG_TYP 7
ACCESS_TYP 4
- No Public Access 205
- Open Access 202
- Restricted Access 150
- Unknown Access 52
LAYER 2 ✖
DES_TP 1
- Private Conservation · 609 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11226 | 11226 | 11225 | {"type": "Polygon", "coordinates": [[[-121.20019, 38.71522], [-121.20005, 38.71565], [-121.19981, 38.71561], [-121.19954, 38.7156], [-121.19959, 38.71518], [-121.20019, 38.71522]]]} | Open Access 1 | 21564 | Elsami | 18603 | 3056 | Placer Legacy 969 | Non Profit 6 | Non Profit - Conservation 12 | http://www.placer.ca.gov/departments/communitydevelopment/planning/placerlegacy | Non Governmental Organization 10 | 3056 | Placer Legacy 935 | Non Profit 6 | Non Profit - Conservation 12 | Placer 35 | 0.573 | Elsami | 0 | Private Conservation 16 | 2 | |
15336 | 15336 | 15335 | {"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 | 46515 | West Athens Victory Garden | 29801 | 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://littlegreenfingersla.org/garden/west-athens-victory-garden/ | Los Angeles 6 | 0.591 | West Athens Victory Garden | 2013 | Private Conservation 16 | 2 |
13959 | 13959 | 13958 | {"type": "Polygon", "coordinates": [[[-117.79032, 33.68059], [-117.78996, 33.68096], [-117.78968, 33.68077], [-117.78973, 33.68055], [-117.78979, 33.68042], [-117.7899, 33.68029], [-117.79032, 33.68059]]]} | Restricted Access 2 | 36667 | Woodspring Pool | 32225 | 6034 | Woodbridge Village Association 244 | Private 7 | Home Owners Association 16 | http://www.wva.org/ | Private 14 | 6034 | Woodbridge Village Association 240 | Private 7 | Home Owners Association 15 | Orange 3 | 0.596 | Woodspring Pool | 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 | ||
14783 | 14783 | 14782 | {"type": "Polygon", "coordinates": [[[-116.98285, 32.63543], [-116.98278, 32.63553], [-116.98274, 32.63564], [-116.98277, 32.63571], [-116.98272, 32.63579], [-116.98265, 32.63578], [-116.98257, 32.63579], [-116.9824, 32.63586], [-116.98222, 32.63538], [-116.98267, 32.63521], [-116.98278, 32.63525], [-116.98285, 32.63543]]]} | Restricted Access 2 | 45170 | The Breezeway | 33355 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.674 | The Breezeway | 0 | Private Conservation 16 | 2 | ||
9846 | 9846 | 9845 | {"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 | 16833 | Henry Miller Library | 19825 | 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.706 | Henry Miller Library | 0 | Private Conservation 16 | 2 | |
14157 | 14157 | 14156 | {"type": "Polygon", "coordinates": [[[-117.67909, 33.649], [-117.67893, 33.64913], [-117.67899, 33.64929], [-117.67864, 33.64938], [-117.67843, 33.64889], [-117.67844, 33.64887], [-117.67849, 33.64885], [-117.67865, 33.6488], [-117.67888, 33.64875], [-117.67905, 33.64874], [-117.67909, 33.64874], [-117.67911, 33.64877], [-117.67904, 33.64889], [-117.67905, 33.64895], [-117.67909, 33.649]]]} | Restricted Access 2 | 43052 | Sterling Heights park | 32391 | 6044 | Lake Forest Drive Association 1088 | Private 7 | Home Owners Association 16 | http://lakeforestdrivehoa.org/ | Private 14 | 6044 | Lake Forest Drive Association 1044 | Private 7 | Home Owners Association 15 | Orange 3 | 0.718 | Sterling Heights park | 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 | |
10499 | 10499 | 10498 | {"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 | 18650 | Petaluma River Marsh | 23624 | 3082 | Sonoma Land Trust 245 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sonomalandtrust.org/ | Non Governmental Organization 10 | 3082 | Sonoma Land Trust 241 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 0.8 | Petaluma River Marsh | 0 | Private Conservation 16 | 2 | |
222 | 222 | 221 | {"type": "MultiPolygon", "coordinates": [[[[-121.8673, 36.95006], [-121.86712, 36.95048], [-121.86682, 36.95042], [-121.86651, 36.95041], [-121.8673, 36.95006]], [[-121.86709, 36.95029], [-121.86695, 36.95026], [-121.86691, 36.95037], [-121.8671, 36.95041], [-121.86715, 36.95031], [-121.86709, 36.95029]]], [[[-121.86797, 36.95053], [-121.8677, 36.95077], [-121.86751, 36.95064], [-121.86733, 36.95055], [-121.86756, 36.95019], [-121.86775, 36.95036], [-121.86797, 36.95053]]], [[[-121.86937, 36.95145], [-121.86934, 36.95153], [-121.86929, 36.95158], [-121.86921, 36.95159], [-121.86891, 36.95152], [-121.86896, 36.95137], [-121.86937, 36.95145]]]]} | Open Access 1 | 732 | Seascape Uplands Preserve | 25249 | 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 | Santa Cruz 5 | 0.859 | Seascape Uplands Preserve | 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 | |
11427 | 11427 | 11426 | {"type": "Polygon", "coordinates": [[[-123.35819, 39.40016], [-123.35815, 39.40029], [-123.35808, 39.40029], [-123.35808, 39.40035], [-123.35769, 39.40035], [-123.35769, 39.40074], [-123.35748, 39.40075], [-123.35748, 39.40086], [-123.35711, 39.40086], [-123.35709, 39.40016], [-123.35819, 39.40016]]]} | Open Access 1 | 48094 | Willits Kids Club Discovery Park and Playground | 32597 | 3383 | Willits Kids Club 977 | Non Profit 6 | Non Profit - Other 22 | http://www.willitskidsclub.org/about | Non Governmental Organization 10 | 3383 | Willits Kids Club 941 | Non Profit 6 | Non Profit - Other 20 | Mendocino 24 | 1.119 | Willits Kids Club Discovery Park and Playground | 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 | |
1282 | 1282 | 1281 | {"type": "Polygon", "coordinates": [[[-117.23197, 33.35767], [-117.23195, 33.35817], [-117.23163, 33.35818], [-117.2314, 33.35817], [-117.23119, 33.35811], [-117.23111, 33.35808], [-117.23108, 33.35804], [-117.2311, 33.358], [-117.23133, 33.35781], [-117.23146, 33.35767], [-117.2318, 33.35723], [-117.2319, 33.35729], [-117.23197, 33.35767]]]} | Open Access 1 | 7247 | Palomares House | 23367 | 3022 | Fallbrook Land Conservancy 339 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/ | Non Governmental Organization 10 | 3022 | Fallbrook Land Conservancy 336 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.fallbrooklandconservancy.org/palomares-house-and-park.html | San Diego 4 | 1.248 | Palomares House | 0 | Private Conservation 16 | 2 |
13192 | 13192 | 13191 | {"type": "Polygon", "coordinates": [[[-121.97264, 36.58026], [-121.97194, 36.58041], [-121.97168, 36.58018], [-121.97156, 36.57995], [-121.97243, 36.57965], [-121.97257, 36.57999], [-121.97264, 36.58026]]]} | Open Access 1 | 35189 | S.F.B. Morse Memorial Lot | 28537 | 3016 | Del Monte Forest Foundation 559 | Non Profit 6 | Non Profit - Conservation 12 | http://www.delmonteforestfoundation.org/ | Non Governmental Organization 10 | 3016 | Del Monte Forest Foundation 552 | Non Profit 6 | Non Profit - Conservation 12 | Monterey 14 | 1.252 | S.F.B. Morse Memorial Lot | 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 |
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]);