units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 2, COUNTY = 16 and MNG_AG_TYP = 10
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID
MNG_AGENCY 4
MNG_AG_TYP 1
- Non Profit - Land Trust · 12 ✖
DES_TP 1
ACCESS_TYP 1
- Restricted Access · 12 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2442 | 2442 | 2441 | {"type": "Polygon", "coordinates": [[[-122.4923, 38.11974], [-122.49219, 38.12381], [-122.48094, 38.13068], [-122.47815, 38.13213], [-122.47787, 38.13223], [-122.47757, 38.13227], [-122.47646, 38.13226], [-122.47621, 38.13224], [-122.47598, 38.13216], [-122.47578, 38.13203], [-122.47568, 38.13193], [-122.47541, 38.13154], [-122.47473, 38.13141], [-122.47237, 38.12844], [-122.48847, 38.12189], [-122.48949, 38.12141], [-122.49045, 38.1209], [-122.4914, 38.12034], [-122.4923, 38.11974]]]} | Restricted Access 2 | 17347 | Leonard Ranch | 21175 | 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 | 219.848 | Leonard Ranch | 0 | Private Conservation 16 | 2 | |
| 3322 | 3322 | 3321 | {"type": "MultiPolygon", "coordinates": [[[[-123.40494, 38.66202], [-123.38247, 38.66233], [-123.37486, 38.66239], [-123.37498, 38.66124], [-123.37497, 38.66112], [-123.3749, 38.66086], [-123.37469, 38.66067], [-123.37443, 38.66055], [-123.37421, 38.66051], [-123.37361, 38.66023], [-123.37309, 38.66003], [-123.37248, 38.65998], [-123.37203, 38.6598], [-123.37186, 38.65959], [-123.3717, 38.65932], [-123.37174, 38.65907], [-123.37171, 38.65886], [-123.37178, 38.65853], [-123.37193, 38.6582], [-123.37202, 38.6579], [-123.37191, 38.6576], [-123.37169, 38.65733], [-123.37137, 38.6571], [-123.37129, 38.65694], [-123.37131, 38.65671], [-123.37166, 38.65611], [-123.37178, 38.65599], [-123.37199, 38.65599], [-123.37217, 38.6559], [-123.37245, 38.65567], [-123.3725, 38.65543], [-123.37247, 38.65529], [-123.37244, 38.65519], [-123.37237, 38.65505], [-123.37228, 38.65492], [-123.37205, 38.65477], [-123.37164, 38.65466], [-123.37124, 38.6547], [-123.37108, 38.65478], [-123.37075, 38.65482], [-123.37008, 38.65497], [-123.36932, 38.65521], [-123.369, 38.65529], [-123.36857, 38.65552], [-123.36836, 38.65558], [-123.36789, 38.6557], [-123.36757, 38.65573], [-123.36734, 38.65573], [-123.36731, 38.65572], [-123.36723, 38.65574], [-123.36718, 38.65568], [-123.36712, 38.65568], [-123.36654, 38.65525], [-123.36657, 38.65521], [-123.36656, 38.65499], [-123.36658, 38.65495], [-123.36657, 38.6549], [-123.36663, 38.65484], [-123.36665, 38.65477], [-123.36666, 38.65462], [-123.36668, 38.6546], [-123.36669, 38.65455], [-123.36667, 38.65452], [-123.36669, 38.65449], [-123.36667, 38.65442], [-123.36671, 38.65438], [-123.36675, 38.65415], [-123.36682, 38.65401], [-123.36682, 38.6539], [-123.36702, 38.65373], [-123.36729, 38.65372], [-123.36736, 38.65376], [-123.3676, 38.65378], [-123.36765, 38.65381], [-123.3677, 38.65381], [-123.36785, 38.65393], [-123.3679, 38.65393], [-123.36802, 38.65402], [-123.36804, 38.65407], [-123.36808, 38.6541], [-123.36816, 38.65414], [-123.36854, 38.65414], [-123.36862, 38.6541], [-123.36868, 38.65412], [-123.36893, 38.6541], [-123.36955, 38.6541], [-123.3696, 38.65408], [-123.36975, 38.65396], [-123.36978, 38.65396], [-123.36991, 38.6539], [-123.37004, 38.65379], [-123.37006, 38.65376], [-123.37006, 38.65366], [-123.36994, 38.65355], [-123.36984, 38.65351], [-123.36976, 38.65343], [-123.3697, 38.65341], [-123.36958, 38.65325], [-123.36917, 38.65295], [-123.36881, 38.65278], [-123.36878, 38.65275], [-123.36878, 38.65272], [-123.36814, 38.65225], [-123.36814, 38.65216], [-123.36806, 38.65206], [-123.36806, 38.65201], [-123.36798, 38.65195], [-123.36798, 38.65159], [-123.36802, 38.65155], [-123.36813, 38.65151], [-123.36839, 38.6513], [-123.3684, 38.65123], [-123.36843, 38.65119], [-123.36843, 38.65114], [-123.36846, 38.65111], [-123.36845, 38.65076], [-123.36843, 38.65074], [-123.36841, 38.65065], [-123.36838, 38.65062], [-123.36837, 38.65046], [-123.36835, 38.6504], [-123.36826, 38.65033], [-123.36825, 38.65029], [-123.36815, 38.65021], [-123.36813, 38.65017], [-123.36806, 38.65019], [-123.36784, 38.65005], [-123.36767, 38.65001], [-123.3676, 38.64998], [-123.36734, 38.64997], [-123.36725, 38.65003], [-123.36704, 38.6501], [-123.36694, 38.65017], [-123.36683, 38.6502], [-123.36673, 38.65026], [-123.36663, 38.65027], [-123.3664, 38.6504], [-123.36621, 38.65047], [-123.36617, 38.6505], [-123.36616, 38.65055], [-123.36597, 38.65071], [-123.36588, 38.65072], [-123.36578, 38.65077], [-123.36577, 38.65079], [-123.36572, 38.6508], [-123.36564, 38.65088], [-123.36563, 38.65091], [-123.36545, 38.65106], [-123.36538, 38.65109], [-123.3653, 38.65115], [-123.36514, 38.65116], [-123.36505, 38.65124], [-123.36486, 38.65132], [-123.36486, 38.65136], [-123.36477, 38.65142], [-123.36476, 38.65148], [-123.36477, 38.65149], [-123.36472, 38.65153], [-123.36471, 38.65158], [-123.36464, 38.65161], [-123.36464, 38.65167], [-123.36462, 38.65156], [-123.36463, 38.65144], [-123.36465, 38.6514], [-123.36493, 38.6511], [-123.3651, 38.65089], [-123.36515, 38.65046], [-123.36526, 38.65026], [-123.36583, 38.64966], [-123.36597, 38.6494], [-123.36595, 38.649], [-123.3659, 38.64855], [-123.36584, 38.6483], [-123.3659, 38.6482], [-123.36601, 38.64817], [-123.36615, 38.64816], [-123.36634, 38.64818], [-123.36657, 38.64813], [-123.36702, 38.64793], [-123.36757, 38.64777], [-123.36797, 38.64773], [-123.36816, 38.64762], [-123.36834, 38.64759], [-123.3685, 38.6476], [-123.36872, 38.64765], [-123.36904, 38.64769], [-123.36933, 38.64783], [-123.37015, 38.64844], [-123.37058, 38.6486], [-123.37084, 38.64878], [-123.37111, 38.64904], [-123.37118, 38.64917], [-123.37123, 38.6492], [-123.37168, 38.64936], [-123.3718, 38.64936], [-123.37185, 38.64934], [-123.3721, 38.649], [-123.37216, 38.64899], [-123.37247, 38.64922], [-123.37272, 38.64939], [-123.37311, 38.64951], [-123.37351, 38.64966], [-123.37374, 38.64994], [-123.3742, 38.65023], [-123.37445, 38.65026], [-123.37494, 38.65029], [-123.37519, 38.65028], [-123.37585, 38.64991], [-123.37604, 38.64986], [-123.37624, 38.64985], [-123.37643, 38.64986], [-123.37683, 38.64995], [-123.37761, 38.65026], [-123.37798, 38.65045], [-123.37857, 38.65085], [-123.37886, 38.6511], [-123.37971, 38.65178], [-123.38039, 38.65198], [-123.38104, 38.65226], [-123.38129, 38.65232], [-123.38134, 38.65234], [-123.38157, 38.6525], [-123.38209, 38.65282], [-123.38235, 38.65302], [-123.38266, 38.65321], [-123.38301, 38.6534], [-123.38332, 38.65361], [-123.38364, 38.65382], [-123.38389, 38.65402], [-123.38404, 38.6541], [-123.38454, 38.65443], [-123.38474, 38.6546], [-123.38503, 38.65479], [-123.38517, 38.65488], [-123.38546, 38.65501], [-123.38565, 38.65515], [-123.38595, 38.65532], [-123.38615, 38.65545], [-123.38639, 38.65553], [-123.38653, 38.65553], [-123.38706, 38.65542], [-123.38745, 38.65536], [-123.38762, 38.65535], [-123.3879, 38.65538], [-123.38858, 38.65532], [-123.38913, 38.65531], [-123.38937, 38.65528], [-123.38994, 38.65517], [-123.39025, 38.65513], [-123.39136, 38.6551], [-123.39163, 38.65508], [-123.39222, 38.65498], [-123.39311, 38.65478], [-123.39327, 38.65475], [-123.3935, 38.65474], [-123.39389, 38.65477], [-123.39418, 38.65475], [-123.39438, 38.65464], [-123.39466, 38.65439], [-123.39488, 38.65424], [-123.3955, 38.65399], [-123.3959, 38.65381], [-123.39645, 38.65349], [-123.3968, 38.65323], [-123.39775, 38.65275], [-123.39838, 38.65311], [-123.39866, 38.65311], [-123.39891, 38.65304], [-123.39909, 38.65281], [-123.3992, 38.65259], [-123.39953, 38.65248], [-123.39962, 38.65247], [-123.39972, 38.65249], [-123.39988, 38.65261], [-123.40005, 38.65249], [-123.40031, 38.65274], [-123.40044, 38.65296], [-123.40066, 38.6535], [-123.40072, 38.65367], [-123.40074, 38.6538], [-123.40077, 38.65426], [-123.40081, 38.65443], [-123.40129, 38.65541], [-123.4014, 38.65555], [-123.40231, 38.65657], [-123.40276, 38.65715], [-123.40316, 38.65775], [-123.40351, 38.65837], [-123.40371, 38.65875], [-123.40379, 38.65888], [-123.4039, 38.659], [-123.40403, 38.65911], [-123.40459, 38.65943], [-123.40466, 38.65949], [-123.40471, 38.65956], [-123.40474, 38.6597], [-123.4046, 38.66065], [-123.40459, 38.66091], [-123.4046, 38.66108], [-123.40464, 38.66134], [-123.40472, 38.66159], [-123.40483, 38.66183], [-123.40494, 38.66202]]], [[[-123.40851, 38.65496], [-123.40848, 38.65498], [-123.40835, 38.65494], [-123.40828, 38.65496], [-123.4082, 38.65492], [-123.40818, 38.65488], [-123.4082, 38.65479], [-123.40818, 38.65465], [-123.40816, 38.65459], [-123.40811, 38.65456], [-123.40805, 38.65455], [-123.40796, 38.65456], [-123.40791, 38.65461], [-123.40791, 38.65466], [-123.40798, 38.65477], [-123.40799, 38.65488], [-123.40796, 38.655], [-123.40788, 38.65508], [-123.4078, 38.6551], [-123.40777, 38.65509], [-123.40775, 38.65496], [-123.40773, 38.65494], [-123.40756, 38.65491], [-123.40743, 38.65486], [-123.4073, 38.65491], [-123.40717, 38.65502], [-123.40707, 38.6552], [-123.40705, 38.65529], [-123.40706, 38.65544], [-123.4071, 38.65551], [-123.40709, 38.65565], [-123.40695, 38.65585], [-123.4069, 38.65586], [-123.40671, 38.6558], [-123.40652, 38.65588], [-123.40642, 38.65587], [-123.4062, 38.65591], [-123.40602, 38.65589], [-123.40597, 38.65592], [-123.4059, 38.65601], [-123.40575, 38.65605], [-123.4057, 38.65611], [-123.40556, 38.65636], [-123.40551, 38.65649], [-123.40551, 38.65655], [-123.40554, 38.65665], [-123.40557, 38.65674], [-123.40567, 38.65688], [-123.40578, 38.65697], [-123.40595, 38.65698], [-123.40611, 38.65704], [-123.4062, 38.65711], [-123.40626, 38.6572], [-123.40637, 38.65721], [-123.40639, 38.65731], [-123.40643, 38.65736], [-123.40653, 38.65741], [-123.40667, 38.65743], [-123.40676, 38.65748], [-123.40688, 38.65762], [-123.40697, 38.6578], [-123.40701, 38.65785], [-123.40713, 38.65789], [-123.40714, 38.65782], [-123.40718, 38.65781], [-123.40726, 38.65779], [-123.40735, 38.65782], [-123.40741, 38.65777], [-123.40744, 38.65777], [-123.40747, 38.65779], [-123.40748, 38.65784], [-123.4075, 38.65786], [-123.40762, 38.65786], [-123.40779, 38.65796], [-123.40781, 38.658], [-123.40772, 38.65803], [-123.40738, 38.65801], [-123.40728, 38.65803], [-123.40732, 38.65811], [-123.40747, 38.65814], [-123.40767, 38.65824], [-123.40768, 38.65826], [-123.40766, 38.65829], [-123.40772, 38.65834], [-123.40774, 38.65843], [-123.40785, 38.65851], [-123.40787, 38.65861], [-123.40791, 38.65866], [-123.40793, 38.6587], [-123.4081, 38.65879], [-123.40812, 38.65882], [-123.40788, 38.65881], [-123.40577, 38.65928], [-123.40591, 38.65967], [-123.40489, 38.65989], [-123.40491, 38.65964], [-123.40488, 38.65953], [-123.40482, 38.65944], [-123.40468, 38.65931], [-123.40418, 38.65903], [-123.40396, 38.65884], [-123.40387, 38.6587], [-123.40368, 38.65832], [-123.40332, 38.65769], [-123.40291, 38.65708], [-123.40246, 38.6565], [-123.40154, 38.65547], [-123.40143, 38.65531], [-123.40097, 38.6544], [-123.40095, 38.6543], [-123.40092, 38.65379], [-123.40088, 38.6536], [-123.40061, 38.65292], [-123.40051, 38.65274], [-123.40076, 38.65265], [-123.40383, 38.65095], [-123.40392, 38.651], [-123.40409, 38.65101], [-123.40427, 38.65107], [-123.4045, 38.65111], [-123.40464, 38.65117], [-123.40467, 38.65121], [-123.40466, 38.65124], [-123.40449, 38.65136], [-123.40442, 38.65145], [-123.40434, 38.65151], [-123.40406, 38.65168], [-123.40404, 38.65172], [-123.40406, 38.65179], [-123.40416, 38.65197], [-123.40427, 38.65214], [-123.40431, 38.65217], [-123.40447, 38.6522], [-123.40454, 38.65223], [-123.40471, 38.65216], [-123.40476, 38.65216], [-123.40477, 38.6522], [-123.4047, 38.65227], [-123.40471, 38.65231], [-123.40476, 38.65233], [-123.40486, 38.65231], [-123.40492, 38.65232], [-123.40497, 38.65237], [-123.40499, 38.65244], [-123.40518, 38.65237], [-123.40532, 38.65234], [-123.40537, 38.65235], [-123.40538, 38.6524], [-123.40527, 38.65253], [-123.40522, 38.65263], [-123.4052, 38.65276], [-123.40524, 38.65282], [-123.40532, 38.65284], [-123.40539, 38.65283], [-123.40548, 38.65278], [-123.40552, 38.65279], [-123.40552, 38.65283], [-123.40549, 38.6529], [-123.40538, 38.65306], [-123.40538, 38.6531], [-123.4054, 38.65312], [-123.40545, 38.65312], [-123.40548, 38.65311], [-123.40564, 38.65295], [-123.40568, 38.65295], [-123.40571, 38.65297], [-123.40572, 38.65302], [-123.40567, 38.65318], [-123.40557, 38.65337], [-123.40558, 38.65342], [-123.40567, 38.65345], [-123.40572, 38.65343], [-123.40584, 38.65324], [-123.4059, 38.65321], [-123.40596, 38.65321], [-123.40601, 38.65318], [-123.40605, 38.65319], [-123.40606, 38.65309], [-123.40611, 38.65305], [-123.40616, 38.65306], [-123.40618, 38.65308], [-123.40617, 38.65319], [-123.40618, 38.65322], [-123.40627, 38.65317], [-123.40631, 38.65317], [-123.40622, 38.65332], [-123.40624, 38.65333], [-123.40631, 38.65332], [-123.40629, 38.65338], [-123.4063, 38.65341], [-123.40649, 38.65346], [-123.40654, 38.65346], [-123.40658, 38.65344], [-123.40659, 38.65334], [-123.40662, 38.65328], [-123.40675, 38.65324], [-123.40678, 38.65325], [-123.4068, 38.65333], [-123.40684, 38.65336], [-123.40704, 38.65344], [-123.40716, 38.65342], [-123.40718, 38.65338], [-123.40713, 38.65327], [-123.40713, 38.65323], [-123.40721, 38.65314], [-123.40726, 38.65311], [-123.4074, 38.65315], [-123.40752, 38.65325], [-123.40756, 38.65326], [-123.40757, 38.6533], [-123.40749, 38.65342], [-123.4074, 38.65351], [-123.40733, 38.65361], [-123.40725, 38.65364], [-123.40715, 38.65361], [-123.40712, 38.65365], [-123.40708, 38.65377], [-123.40716, 38.65392], [-123.40715, 38.65408], [-123.40723, 38.65412], [-123.40736, 38.65413], [-123.40744, 38.65402], [-123.40747, 38.6539], [-123.40749, 38.65389], [-123.40758, 38.65403], [-123.40763, 38.65404], [-123.40769, 38.654], [-123.40774, 38.65406], [-123.40778, 38.65406], [-123.40788, 38.65411], [-123.40787, 38.65415], [-123.40791, 38.65418], [-123.40801, 38.65439], [-123.40803, 38.65442], [-123.40811, 38.65444], [-123.40822, 38.65445], [-123.4083, 38.65444], [-123.40838, 38.6544], [-123.4084, 38.65446], [-123.40838, 38.65457], [-123.40843, 38.65472], [-123.40852, 38.65486], [-123.40851, 38.65496]]]]} | Restricted Access 2 | 29685 | Stewarts Point Ranch | 31787 | 3074 | Save the Redwoods League 52 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.savetheredwoods.org | Non Governmental Organization 10 | 3074 | Save the Redwoods League 50 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 827.936 | Stewarts Point Ranch | 0 | Private Conservation 16 | 2 | |
| 3508 | 3508 | 3507 | {"type": "Polygon", "coordinates": [[[-123.14011, 38.61069], [-123.13538, 38.61068], [-123.13529, 38.6071], [-123.14003, 38.60711], [-123.14011, 38.61069]]]} | Restricted Access 2 | 26072 | Cedars Gateway | 30373 | 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 | 40.534 | Cedars Gateway | 0 | Private Conservation 16 | 2 | |
| 4210 | 4210 | 4209 | {"type": "Polygon", "coordinates": [[[-122.47197, 38.1283], [-122.4645, 38.13105], [-122.44704, 38.13795], [-122.44644, 38.13823], [-122.44615, 38.13839], [-122.44568, 38.13872], [-122.44545, 38.13897], [-122.44525, 38.1392], [-122.44504, 38.13949], [-122.44486, 38.13977], [-122.44471, 38.14006], [-122.44458, 38.14035], [-122.44446, 38.14067], [-122.44437, 38.141], [-122.44428, 38.14149], [-122.44372, 38.14707], [-122.44374, 38.14738], [-122.44379, 38.14769], [-122.44391, 38.14814], [-122.444, 38.14835], [-122.44409, 38.14851], [-122.44427, 38.14876], [-122.44452, 38.14903], [-122.44526, 38.14959], [-122.44458, 38.14983], [-122.44386, 38.14899], [-122.44332, 38.14857], [-122.44119, 38.1476], [-122.43736, 38.14574], [-122.43544, 38.14477], [-122.43452, 38.14398], [-122.43428, 38.14347], [-122.43428, 38.14324], [-122.43463, 38.14305], [-122.43581, 38.14269], [-122.43858, 38.14212], [-122.44008, 38.14139], [-122.44194, 38.13975], [-122.44273, 38.13902], [-122.44346, 38.1384], [-122.44341, 38.13799], [-122.44356, 38.13762], [-122.44369, 38.13768], [-122.4437, 38.13766], [-122.44276, 38.13578], [-122.44175, 38.13459], [-122.44837, 38.12832], [-122.44877, 38.12827], [-122.44917, 38.12819], [-122.44956, 38.1281], [-122.44994, 38.12799], [-122.4503, 38.12785], [-122.45066, 38.1277], [-122.45101, 38.12753], [-122.45134, 38.12733], [-122.45165, 38.12713], [-122.45195, 38.1269], [-122.45222, 38.12666], [-122.45248, 38.12641], [-122.45278, 38.12614], [-122.45307, 38.12587], [-122.45333, 38.12558], [-122.45358, 38.12529], [-122.45381, 38.12498], [-122.45402, 38.12467], [-122.45455, 38.12282], [-122.45528, 38.12149], [-122.45577, 38.1208], [-122.45771, 38.11917], [-122.45865, 38.11863], [-122.45944, 38.1183], [-122.46431, 38.11785], [-122.46604, 38.11802], [-122.46687, 38.1184], [-122.46755, 38.11832], [-122.46856, 38.11787], [-122.46924, 38.1173], [-122.47014, 38.11694], [-122.47078, 38.11682], [-122.47175, 38.11735], [-122.47439, 38.11866], [-122.4745, 38.11878], [-122.47456, 38.11893], [-122.47451, 38.11926], [-122.47326, 38.12358], [-122.47206, 38.12591], [-122.47068, 38.12757], [-122.47164, 38.12826], [-122.47197, 38.1283]]]} | Restricted Access 2 | 44951 | Sears Point Tidal Marsh Restoration | 25247 | 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 | 945.166 | Sears Point Tidal Marsh Restoration | 0 | Private Conservation 16 | 2 | |
| 6646 | 6646 | 6645 | {"type": "MultiPolygon", "coordinates": [[[[-122.51527, 38.37001], [-122.51519, 38.37008], [-122.51534, 38.3703], [-122.51546, 38.37054], [-122.51559, 38.37091], [-122.51563, 38.37129], [-122.51562, 38.37155], [-122.51553, 38.37193], [-122.51537, 38.37229], [-122.5153, 38.37241], [-122.51491, 38.37287], [-122.51118, 38.37404], [-122.51013, 38.37434], [-122.51015, 38.37307], [-122.50548, 38.37304], [-122.50521, 38.37843], [-122.50043, 38.37993], [-122.49924, 38.37749], [-122.49835, 38.37301], [-122.50062, 38.37298], [-122.50067, 38.3693], [-122.50109, 38.36935], [-122.50814, 38.36943], [-122.51383, 38.36841], [-122.51527, 38.37001]]], [[[-122.51662, 38.37234], [-122.51662, 38.37234], [-122.51535, 38.37273], [-122.51611, 38.3718], [-122.51628, 38.37168], [-122.51662, 38.37234]]]]} | Restricted Access 2 | 4664 | Glen Oaks Ranch | 30371 | 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 | 237.145 | Glen Oaks Ranch | 0 | Private Conservation 16 | 2 | |
| 7069 | 7069 | 7068 | {"type": "Polygon", "coordinates": [[[-123.01386, 38.31434], [-123.01002, 38.3143], [-123.00814, 38.31429], [-123.00245, 38.31411], [-123.0023, 38.31424], [-123.0022, 38.3144], [-123.00205, 38.31453], [-123.00187, 38.31464], [-122.99666, 38.30504], [-122.99501, 38.30525], [-122.99554, 38.30466], [-122.99486, 38.30372], [-122.99439, 38.30005], [-122.99478, 38.29961], [-122.99675, 38.29965], [-122.99733, 38.29973], [-122.99963, 38.29915], [-122.99977, 38.2988], [-123.00043, 38.29842], [-123.00176, 38.29807], [-123.00219, 38.29769], [-123.00325, 38.29684], [-123.00604, 38.29753], [-123.00633, 38.29757], [-123.00696, 38.29822], [-123.00801, 38.29894], [-123.01009, 38.30083], [-123.01048, 38.30104], [-123.01147, 38.30205], [-123.01274, 38.30297], [-123.01309, 38.30341], [-123.01267, 38.30378], [-123.01248, 38.30387], [-123.0122, 38.30391], [-123.0122, 38.30408], [-123.01231, 38.30426], [-123.01018, 38.30693], [-123.00978, 38.30732], [-123.00968, 38.30746], [-123.00962, 38.30758], [-123.00923, 38.30803], [-123.01266, 38.31021], [-123.01302, 38.3108], [-123.01386, 38.31434]]]} | Restricted Access 2 | 47579 | Estero Americano Coast Preserve | 31306 | 3092 | The Wildlands Conservancy 228 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/ | Non Governmental Organization 10 | 3092 | The Wildlands Conservancy 224 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.wildlandsconservancy.org/preserve_estero.html | Sonoma 16 | 534.989 | Estero Americano Coast Preserve | 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 | |
| 12367 | 12367 | 12366 | {"type": "Polygon", "coordinates": [[[-122.95526, 38.63545], [-122.95523, 38.63778], [-122.95525, 38.64238], [-122.94602, 38.64273], [-122.9416, 38.64274], [-122.93779, 38.64261], [-122.93244, 38.64257], [-122.93265, 38.63515], [-122.9465, 38.63525], [-122.95526, 38.63545]]]} | Restricted Access 2 | 26069 | Riddell Preserve | 24346 | 3117 | LandPaths 206 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landpaths.org/ | Non Governmental Organization 10 | 3117 | LandPaths 202 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 399.164 | Riddell Preserve | 0 | Private Conservation 16 | 2 | |
| 12739 | 12739 | 12738 | {"type": "Polygon", "coordinates": [[[-123.00187, 38.31464], [-123.00168, 38.31468], [-123.00149, 38.31469], [-123.0013, 38.31467], [-123.00099, 38.31458], [-123.00054, 38.31452], [-122.9992, 38.31445], [-122.99866, 38.3144], [-122.99823, 38.31441], [-122.99803, 38.31444], [-122.99761, 38.31456], [-122.99668, 38.31508], [-122.99383, 38.31148], [-122.99215, 38.31077], [-122.99203, 38.3109], [-122.99179, 38.31125], [-122.99172, 38.31155], [-122.99169, 38.31176], [-122.98597, 38.31107], [-122.98577, 38.31048], [-122.98517, 38.30994], [-122.98578, 38.3092], [-122.98644, 38.30902], [-122.98804, 38.30885], [-122.98863, 38.30853], [-122.98887, 38.30813], [-122.98961, 38.30746], [-122.99089, 38.30638], [-122.99155, 38.30658], [-122.99309, 38.3076], [-122.99409, 38.30712], [-122.99553, 38.31018], [-123.00095, 38.31294], [-123.00187, 38.31464]]]} | Restricted Access 2 | 29771 | Estero Americano Preserve | 18725 | 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 | 126.098 | Estero Americano Preserve | 0 | Private Conservation 16 | 2 | |
| 12752 | 12752 | 12751 | {"type": "Polygon", "coordinates": [[[-122.65077, 38.61356], [-122.64992, 38.61454], [-122.63987, 38.62487], [-122.63944, 38.62453], [-122.63742, 38.62319], [-122.63268, 38.6202], [-122.6332, 38.61993], [-122.6331, 38.61632], [-122.63334, 38.61617], [-122.63377, 38.61611], [-122.63408, 38.61584], [-122.63451, 38.61471], [-122.63559, 38.6144], [-122.63622, 38.61393], [-122.63644, 38.61346], [-122.63665, 38.61321], [-122.63708, 38.61305], [-122.63741, 38.61285], [-122.63794, 38.61266], [-122.63885, 38.61242], [-122.6392, 38.61208], [-122.63977, 38.61055], [-122.63934, 38.61024], [-122.63883, 38.60973], [-122.63892, 38.60957], [-122.63896, 38.60946], [-122.63896, 38.60939], [-122.63889, 38.6093], [-122.63908, 38.60927], [-122.63908, 38.60915], [-122.63931, 38.60891], [-122.63973, 38.60812], [-122.64021, 38.60798], [-122.64038, 38.60761], [-122.64114, 38.60679], [-122.6417, 38.60607], [-122.64476, 38.60766], [-122.64556, 38.60874], [-122.64611, 38.60904], [-122.64892, 38.60685], [-122.64974, 38.60729], [-122.65027, 38.60754], [-122.64673, 38.61137], [-122.65077, 38.61356]]]} | Restricted Access 2 | 29784 | Live Oaks Ranch | 21378 | 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 | 423.5 | Live Oaks Ranch | 0 | Private Conservation 16 | 2 | |
| 14658 | 14658 | 14657 | {"type": "Polygon", "coordinates": [[[-122.41076, 38.30586], [-122.4105, 38.30586], [-122.41012, 38.30647], [-122.40815, 38.31238], [-122.40664, 38.31183], [-122.40681, 38.31136], [-122.4072, 38.31105], [-122.40728, 38.31092], [-122.40729, 38.31082], [-122.40727, 38.31073], [-122.40725, 38.31069], [-122.40711, 38.31053], [-122.40702, 38.31037], [-122.40702, 38.31023], [-122.4071, 38.31006], [-122.40718, 38.30992], [-122.40732, 38.30976], [-122.40754, 38.30964], [-122.40801, 38.3095], [-122.40842, 38.3088], [-122.40859, 38.30835], [-122.4086, 38.30803], [-122.40874, 38.30778], [-122.40884, 38.30736], [-122.40873, 38.30665], [-122.40876, 38.30618], [-122.4087, 38.30548], [-122.40881, 38.30532], [-122.40968, 38.30578], [-122.4104, 38.30572], [-122.41076, 38.30586]]]} | Restricted Access 2 | 44920 | John Holden | 28164 | 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 | http://www.sonomalandtrust.org/explore/interactive_map/map.php | Sonoma 16 | 20.987 | John Holden | 0 | Private Conservation 16 | 2 |
| 15641 | 15641 | 15640 | {"type": "Polygon", "coordinates": [[[-122.9909, 38.45117], [-122.99089, 38.45304], [-122.9819, 38.45306], [-122.98189, 38.45486], [-122.97297, 38.45495], [-122.97294, 38.45853], [-122.95472, 38.45866], [-122.95449, 38.45151], [-122.96373, 38.45139], [-122.96376, 38.45585], [-122.96898, 38.4551], [-122.97121, 38.4514], [-122.97193, 38.45139], [-122.972, 38.45122], [-122.97256, 38.45114], [-122.97315, 38.45133], [-122.97373, 38.45061], [-122.97378, 38.45005], [-122.97438, 38.44935], [-122.97382, 38.44864], [-122.97289, 38.4453], [-122.97252, 38.44412], [-122.97114, 38.43987], [-122.97136, 38.43953], [-122.97142, 38.43948], [-122.97176, 38.43934], [-122.97187, 38.43927], [-122.97198, 38.43918], [-122.9721, 38.43904], [-122.97216, 38.43899], [-122.97266, 38.43888], [-122.9728, 38.43886], [-122.97308, 38.4388], [-122.9732, 38.43874], [-122.97423, 38.43809], [-122.97446, 38.43846], [-122.97407, 38.43836], [-122.97391, 38.43853], [-122.97358, 38.43857], [-122.97339, 38.43874], [-122.9731, 38.43891], [-122.97545, 38.44272], [-122.97561, 38.44268], [-122.97572, 38.44292], [-122.9759, 38.44312], [-122.97601, 38.44321], [-122.97613, 38.44329], [-122.97696, 38.44369], [-122.97706, 38.44361], [-122.9784, 38.44416], [-122.97943, 38.4446], [-122.97956, 38.44468], [-122.97979, 38.44487], [-122.97991, 38.44503], [-122.98, 38.44521], [-122.98014, 38.44558], [-122.9802, 38.44568], [-122.98029, 38.44578], [-122.98039, 38.44587], [-122.98058, 38.44598], [-122.98091, 38.44608], [-122.98094, 38.44877], [-122.9819, 38.44878], [-122.9819, 38.45122], [-122.9909, 38.45117]]]} | Restricted Access 2 | 35146 | Bohemia Ecological Preserve | 16232 | 3117 | LandPaths 206 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.landpaths.org/ | Non Governmental Organization 10 | 3117 | LandPaths 202 | Non Profit 6 | Non Profit - Land Trust 10 | Sonoma 16 | 540.325 | Bohemia EP | 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]);