units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
139 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 10 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, YR_EST
MNG_AGENCY >30
- Sempervirens Fund 16
- The Nature Conservancy 14
- Land Trust of Napa County 14
- Big Sur Land Trust 14
- Sonoma Land Trust 9
- Center for Natural Lands Management 5
- Solano Land Trust 5
- Truckee Donner Land Trust 5
- Rivers and Lands Conservancy 5
- Sequoia Riverlands Trust 4
- Land Trust of Santa Cruz County 4
- Save Mount Diablo 4
- The Wildlands Conservancy 3
- Peninsula Open Space Trust 3
- The Conservation Fund - California 3
- Save the Redwoods League 2
- Santa Lucia Conservancy 2
- Bear Yuba Land Trust 2
- LandPaths 2
- Land Trust for Santa Barbara County 2
- Fallbrook Land Conservancy 2
- Santa Catalina Island Conservancy 2
- Los Angeles Neighborhood Land Trust 2
- Lake County Land Trust 2
- American River Conservancy 2
- John Muir Land Trust 1
- Friends of the Desert Mountains 1
- Arroyos and Foothills Conservancy 1
- Mendocino Land Trust 1
- Tuleyome 1
- …
DES_TP 6
MNG_AG_TYP 1
- Non Profit - Land Trust · 139 ✖
ACCESS_TYP 1
- Restricted Access · 139 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
442 | 442 | 441 | {"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 | 1381 | Tor House | 26411 | 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.129 | Tor House | 0 | Private Conservation 16 | 2 | |
4444 | 4444 | 4443 | {"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 | 46513 | Erika J. Glazer Community Garden | 29800 | 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.165 | Erika J. Glazer Community Garden | 0 | Private Conservation 16 | 2 | |
10215 | 10215 | 10214 | {"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 | 17874 | Mission Trails/Probasco | 22315 | 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.256 | Mission Trails/Probasco | 0 | Private Conservation 16 | 2 | |
2296 | 2296 | 2295 | {"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.93849, 36.50138], [-121.93848, 36.50133], [-121.93865, 36.50129]]]} | Restricted Access 2 | 16894 | Highlands Inn turnout | 19940 | 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.373 | Highlands Inn turnout | 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 |
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 | |
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 | |
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 | |
4063 | 4063 | 4062 | {"type": "Polygon", "coordinates": [[[-122.00321, 37.0735], [-122.00314, 37.07355], [-122.00311, 37.07363], [-122.00284, 37.07352], [-122.00255, 37.07347], [-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 | 47063 | Glenwood | 30716 | 3036 | Land Trust of Santa Cruz County 121 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landtrustsantacruz.org/ | Non Governmental Organization 10 | 3036 | Land Trust of Santa Cruz County 118 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 1.506 | Glenwood | 0 | Private Conservation 16 | 2 | |
4594 | 4594 | 4593 | {"type": "Polygon", "coordinates": [[[-117.34544, 33.91468], [-117.34509, 33.91482], [-117.34481, 33.91495], [-117.34443, 33.91447], [-117.3444, 33.91406], [-117.34438, 33.91401], [-117.34438, 33.91173], [-117.34444, 33.9118], [-117.34479, 33.91339], [-117.34492, 33.91372], [-117.34544, 33.91468]]]} | Restricted Access 2 | 35501 | Unnamed site - Riverside Land Conservancy | 28657 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 3.461 | 0 | Private Other or Unknown 399 | 4 | ||
9956 | 9956 | 9955 | {"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.86366], [-121.43173, 35.86367], [-121.43193, 35.86378], [-121.43198, 35.86385], [-121.43202, 35.86496]]]} | Restricted Access 2 | 17132 | Kopp | 20717 | 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 | 5.005 | Kopp | 0 | Private Conservation 16 | 2 | |
12735 | 12735 | 12734 | {"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 | 29766 | Gee | 19247 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 5.342 | Gee | 0 | Private Conservation 16 | 2 | |
3450 | 3450 | 3449 | {"type": "Polygon", "coordinates": [[[-122.19466, 37.15793], [-122.19268, 37.15833], [-122.19133, 37.15817], [-122.1914, 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 | 25308 | Griffith | 19515 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 6.861 | Griffith | 0 | Private Conservation 16 | 2 | |
11275 | 11275 | 11274 | {"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.66879], [-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.46423, 38.6678], [-121.46516, 38.66788], [-121.46575, 38.66796], [-121.46584, 38.6679], [-121.46596, 38.66791]]]} | Restricted Access 2 | 21781 | Dry Creek Watershed | 18286 | 3061 | Sacramento Valley Conservancy 972 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sacramentovalleyconservancy.org/ | Non Governmental Organization 10 | 3061 | Sacramento Valley Conservancy 937 | Non Profit 6 | Non Profit - Land Trust 10 | Sacramento 41 | 8.226 | Dry Creek Watershed | 0 | Private Conservation 16 | 2 | |
4595 | 4595 | 4594 | {"type": "Polygon", "coordinates": [[[-117.34438, 33.91173], [-117.34438, 33.91401], [-117.3442, 33.91372], [-117.34412, 33.91332], [-117.34414, 33.91296], [-117.34378, 33.91232], [-117.3426, 33.91104], [-117.34229, 33.91079], [-117.34089, 33.91024], [-117.34062, 33.9102], [-117.34003, 33.91028], [-117.34003, 33.9097], [-117.3405, 33.90992], [-117.34147, 33.90992], [-117.34322, 33.91072], [-117.34323, 33.91092], [-117.34382, 33.91091], [-117.34438, 33.91173]]]} | Restricted Access 2 | 35502 | Unnamed site - Riverside Land Conservancy | 28657 | 3059 | Rivers and Lands Conservancy 773 | Non Profit 6 | Non Profit - Land Trust 10 | https://riversandlands.org/ | Non Governmental Organization 10 | 3059 | Rivers and Lands Conservancy 754 | Non Profit 6 | Non Profit - Land Trust 10 | Riverside 10 | 8.55 | 0 | Private Other or Unknown 399 | 4 | ||
9721 | 9721 | 9720 | {"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 | 16469 | Gelbart | 19249 | 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 | 8.735 | Gelbart | 0 | Private Conservation 16 | 2 | |
3409 | 3409 | 3408 | {"type": "Polygon", "coordinates": [[[-122.14677, 37.21609], [-122.14492, 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 | 24954 | Butler | 16547 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 9.721 | Butler | 0 | Private Conservation 16 | 2 | |
3075 | 3075 | 3074 | {"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.14292, 37.21504], [-122.14326, 37.21515], [-122.14366, 37.21515], [-122.14367, 37.21657]]]} | Restricted Access 2 | 24955 | Ahlgren | 15297 | 3110 | Sempervirens Fund 579 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.sempervirens.org/ | Non Governmental Organization 10 | 3110 | Sempervirens Fund 571 | Non Profit 6 | Non Profit - Land Trust 10 | Santa Cruz 5 | 9.806 | Ahlgren | 0 | Private Conservation 16 | 2 | |
8602 | 8602 | 8601 | {"type": "Polygon", "coordinates": [[[-122.32356, 38.29943], [-122.32365, 38.29978], [-122.32398, 38.30085], [-122.32422, 38.30177], [-122.32406, 38.30237], [-122.32395, 38.3027], [-122.32387, 38.30282], [-122.3233, 38.30341], [-122.32321, 38.3036], [-122.32318, 38.30361], [-122.32314, 38.30365], [-122.32186, 38.30366], [-122.32193, 38.30225], [-122.32264, 38.30224], [-122.32356, 38.29943]]]} | Restricted Access 2 | 13687 | Connolly Ranch | 17594 | 3035 | Land Trust of Napa County 140 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.napalandtrust.org/ | Non Governmental Organization 10 | 3035 | Land Trust of Napa County 137 | Non Profit 6 | Non Profit - Land Trust 10 | Napa 11 | 11.751 | Connolly Ranch | 1991 | Private Conservation 16 | 2 | |
1553 | 1553 | 1552 | {"type": "Polygon", "coordinates": [[[-121.90672, 36.50825], [-121.90222, 36.5082], [-121.90221, 36.50639], [-121.90672, 36.50645], [-121.90672, 36.50825]]]} | Restricted Access 2 | 11595 | Curtis | 17864 | 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 | 19.995 | Curtis | 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]);