units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
601 rows where MNG_AG_TYP = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- The Nature Conservancy 51
- Rivers and Lands Conservancy 28
- Center for Natural Lands Management 25
- Sonoma Land Trust 25
- Peninsula Open Space Trust 25
- The Wildlands Conservancy 24
- Truckee Donner Land Trust 24
- American River Conservancy 20
- The Environmental Trust 19
- Save the Redwoods League 18
- Land Trust of Napa County 18
- Big Sur Land Trust 18
- Sempervirens Fund 18
- Save Mount Diablo 17
- Fallbrook Land Conservancy 15
- Land Trust of Santa Cruz County 14
- Wilderness Land Trust 14
- San Joaquin River Parkway and Conservation Trust 12
- Bear Yuba Land Trust 10
- Friends of the Desert Mountains 10
- Mojave Desert Land Trust 10
- Elkhorn Slough Foundation 9
- The Conservation Fund - California 9
- John Muir Land Trust 8
- Solano Land Trust 8
- Ojai Valley Land Conservancy 8
- Sequoia Riverlands Trust 7
- Sierra Foothill Conservancy 7
- Mendocino Land Trust 6
- Tuleyome 6
- …
DES_TP 18
ACCESS_TYP 4
- No Public Access 213
- Open Access 193
- Restricted Access 135
- Unknown Access 40
MNG_AG_TYP 1
- Non Profit - Land Trust · 581 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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 | |
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 |
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 | ||
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 | |
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 | |
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 |
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 | |
7188 | 7188 | 7187 | {"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.47246], [-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 | 6341 | Offshore Island | 23072 | 3070 | Santa Catalina Island Conservancy 382 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.catalinaconservancy.org/ | Non Governmental Organization 10 | 3070 | Santa Catalina Island Conservancy 377 | Non Profit 6 | Non Profit - Land Trust 10 | Los Angeles 6 | 1.431 | Offshore Island | 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 | ||
3278 | 3278 | 3277 | {"type": "Polygon", "coordinates": [[[-121.03318, 39.14691], [-121.03318, 39.14723], [-121.03271, 39.14793], [-121.03234, 39.1476], [-121.0324, 39.14717], [-121.03268, 39.14678], [-121.03318, 39.14691]]]} | Open Access 1 | 23175 | Mathis Pond Preserve | 31039 | 3223 | Bear Yuba Land Trust 100 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/ | Non Governmental Organization 10 | 3223 | Bear Yuba Land Trust 98 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.bylt.org/land/mathis-pond-preserve/ | Nevada 30 | 1.459 | Mathis Pond Preserve | 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]);