units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
18 rows where GAP_STS = 2 and MNG_AGENCY = 593
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, COUNTY, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3247 | 3247 | 3246 | {"type": "Polygon", "coordinates": [[[-120.82265, 38.76759], [-120.82261, 38.77004], [-120.82166, 38.77002], [-120.8217, 38.76791], [-120.8204, 38.7679], [-120.8206, 38.76763], [-120.82087, 38.76723], [-120.82106, 38.7671], [-120.82135, 38.76686], [-120.82133, 38.76734], [-120.82168, 38.76727], [-120.82168, 38.76705], [-120.82179, 38.76716], [-120.82201, 38.76729], [-120.82256, 38.76752], [-120.82265, 38.76759]]]} | No Public Access 3 | 23317 | Chili Bar | 17200 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 7.888 | Chili Bar | 0 | Private Conservation 16 | 2 | |
3260 | 3260 | 3259 | {"type": "MultiPolygon", "coordinates": [[[[-120.7965, 38.61535], [-120.79633, 38.62279], [-120.79567, 38.62277], [-120.79185, 38.62276], [-120.7919, 38.61618], [-120.79189, 38.6153], [-120.7965, 38.61535]]], [[[-120.90694, 38.79848], [-120.90679, 38.79843], [-120.90681, 38.79852], [-120.90607, 38.79953], [-120.90651, 38.79973], [-120.90656, 38.80019], [-120.90546, 38.80173], [-120.90364, 38.80302], [-120.90349, 38.80296], [-120.9027, 38.79998], [-120.89999, 38.79985], [-120.90024, 38.79404], [-120.90136, 38.79491], [-120.90499, 38.79766], [-120.9066, 38.79767], [-120.90691, 38.79838], [-120.90694, 38.79848]]]]} | No Public Access 3 | 23332 | Van Noord | 26829 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 154.278 | Van Noord | 0 | Private Conservation 16 | 2 | |
3279 | 3279 | 3278 | {"type": "Polygon", "coordinates": [[[-120.9889, 38.82713], [-120.98787, 38.82714], [-120.98483, 38.82713], [-120.98489, 38.82712], [-120.98485, 38.82698], [-120.98311, 38.8197], [-120.9866, 38.81975], [-120.98651, 38.82011], [-120.98625, 38.82065], [-120.98624, 38.82099], [-120.98631, 38.82126], [-120.9863, 38.8213], [-120.9865, 38.82179], [-120.98694, 38.82251], [-120.98712, 38.82289], [-120.9872, 38.823], [-120.98759, 38.82338], [-120.98777, 38.82376], [-120.98792, 38.82394], [-120.98822, 38.82421], [-120.98854, 38.82472], [-120.98858, 38.82499], [-120.98872, 38.82552], [-120.989, 38.82633], [-120.98901, 38.8266], [-120.98898, 38.82699], [-120.9889, 38.82713]]]} | No Public Access 3 | 23318 | Cronan Ranch | 17831 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 63.637 | Cronan Ranch | 0 | Private Conservation 16 | 2 | |
3280 | 3280 | 3279 | {"type": "Polygon", "coordinates": [[[-120.93652, 38.63111], [-120.9365, 38.63193], [-120.93417, 38.63196], [-120.93415, 38.63114], [-120.93652, 38.63111]]]} | No Public Access 3 | 23322 | Lipa Waterfalls | 21329 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 4.642 | Lipa Waterfalls | 0 | Private Conservation 16 | 2 | |
3281 | 3281 | 3280 | {"type": "Polygon", "coordinates": [[[-121.04125, 38.76909], [-121.03825, 38.76914], [-121.03819, 38.76642], [-121.04048, 38.76638], [-121.04117, 38.76638], [-121.04125, 38.76909]]]} | No Public Access 3 | 23324 | Nash | 22635 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 19.438 | Nash | 0 | Private Conservation 16 | 2 | |
3282 | 3282 | 3281 | {"type": "Polygon", "coordinates": [[[-121.04117, 38.76638], [-121.04048, 38.76638], [-121.03502, 38.76647], [-121.03499, 38.76554], [-121.04021, 38.76549], [-121.04023, 38.76594], [-121.04115, 38.76594], [-121.04117, 38.76638]]]} | No Public Access 3 | 23325 | Pearson | 23548 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 12.35 | Pearson | 0 | Private Conservation 16 | 2 | |
3283 | 3283 | 3282 | {"type": "Polygon", "coordinates": [[[-120.73962, 38.6495], [-120.73921, 38.64993], [-120.7388, 38.65022], [-120.73853, 38.65033], [-120.73807, 38.65074], [-120.73779, 38.65096], [-120.73712, 38.65128], [-120.73623, 38.65135], [-120.73528, 38.64942], [-120.73449, 38.64788], [-120.73405, 38.6479], [-120.73339, 38.64639], [-120.73504, 38.64557], [-120.73852, 38.64548], [-120.73911, 38.64587], [-120.73675, 38.6478], [-120.73664, 38.64821], [-120.73757, 38.64914], [-120.73805, 38.64939], [-120.73962, 38.6495]]]} | No Public Access 3 | 23327 | Pollock | 23873 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 43.967 | Pollock | 0 | Private Conservation 16 | 2 | |
3903 | 3903 | 3902 | {"type": "Polygon", "coordinates": [[[-121.03542, 38.78141], [-121.03507, 38.78183], [-121.0346, 38.78212], [-121.03407, 38.78232], [-121.03329, 38.78251], [-121.03294, 38.78277], [-121.03281, 38.78309], [-121.03251, 38.78343], [-121.03212, 38.78352], [-121.03173, 38.78352], [-121.03122, 38.78337], [-121.0308, 38.78336], [-121.03049, 38.78342], [-121.03022, 38.78367], [-121.02605, 38.7837], [-121.02584, 38.77615], [-121.02577, 38.77476], [-121.02639, 38.77374], [-121.02717, 38.77352], [-121.03037, 38.77412], [-121.0309, 38.77359], [-121.03129, 38.77362], [-121.03139, 38.7737], [-121.03083, 38.77451], [-121.03091, 38.77531], [-121.03245, 38.77575], [-121.03465, 38.7743], [-121.03466, 38.77614], [-121.02705, 38.77614], [-121.02704, 38.77615], [-121.03315, 38.77619], [-121.03315, 38.77636], [-121.03329, 38.77676], [-121.03362, 38.77707], [-121.03421, 38.77714], [-121.03468, 38.77725], [-121.03503, 38.77769], [-121.03515, 38.77801], [-121.03498, 38.77838], [-121.03517, 38.77907], [-121.03541, 38.77968], [-121.03542, 38.78141]]]} | No Public Access 3 | 36005 | Brush Creek Ranch | 16454 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 188.734 | Brush Creek Ranch | 0 | Private Conservation 16 | 2 | |
4416 | 4416 | 4415 | {"type": "MultiPolygon", "coordinates": [[[[-120.90814, 38.57014], [-120.88983, 38.57064], [-120.88467, 38.57039], [-120.87584, 38.57006], [-120.87151, 38.56993], [-120.8715, 38.56994], [-120.86697, 38.56993], [-120.86692, 38.56986], [-120.8621, 38.56961], [-120.86253, 38.55815], [-120.85319, 38.55806], [-120.85317, 38.56585], [-120.84869, 38.5658], [-120.84867, 38.56178], [-120.84703, 38.56175], [-120.84722, 38.56109], [-120.84747, 38.56052], [-120.84786, 38.55986], [-120.84785, 38.55864], [-120.84776, 38.55795], [-120.84741, 38.55706], [-120.84716, 38.55637], [-120.84716, 38.55602], [-120.84747, 38.55538], [-120.8479, 38.55469], [-120.84815, 38.55447], [-120.85319, 38.55445], [-120.85298, 38.55034], [-120.85383, 38.55007], [-120.85469, 38.54965], [-120.8556, 38.54902], [-120.85593, 38.54876], [-120.85622, 38.54844], [-120.85654, 38.54799], [-120.85673, 38.54759], [-120.85682, 38.54727], [-120.86255, 38.54729], [-120.86253, 38.54355], [-120.86193, 38.54352], [-120.8622, 38.54343], [-120.8624, 38.54325], [-120.86258, 38.54305], [-120.86265, 38.54278], [-120.86275, 38.54246], [-120.86278, 38.54217], [-120.86285, 38.54182], [-120.86295, 38.54149], [-120.86296, 38.54115], [-120.86303, 38.54057], [-120.86312, 38.54032], [-120.8632, 38.54004], [-120.8632, 38.53983], [-120.86315, 38.53957], [-120.86318, 38.53931], [-120.86318, 38.53903], [-120.86315, 38.53865], [-120.86303, 38.53826], [-120.86299, 38.53795], [-120.86305, 38.53755], [-120.86304, 38.53735], [-120.86308, 38.53705], [-120.86308, 38.53681], [-120.86312, 38.53663], [-120.87136, 38.53664], [-120.87142, 38.54103], [-120.87181, 38.55451], [-120.88584, 38.55578], [-120.88549, 38.55967], [-120.89525, 38.55995], [-120.89521, 38.56332], [-120.8996, 38.56317], [-120.9078, 38.56279], [-120.90814, 38.57014]]], [[[-120.86073, 38.54359], [-120.85581, 38.5436], [-120.85581, 38.5436], [-120.85591, 38.5434], [-120.85607, 38.54316], [-120.85627, 38.54297], [-120.8565, 38.54279], [-120.85668, 38.54269], [-120.85716, 38.54254], [-120.8574, 38.54244], [-120.85763, 38.54239], [-120.85782, 38.54241], [-120.85828, 38.54248], [-120.85862, 38.54256], [-120.85924, 38.54276], [-120.85942, 38.54276], [-120.85951, 38.5429], [-120.85966, 38.543], [-120.85987, 38.5431], [-120.86022, 38.5432], [-120.86038, 38.54328], [-120.86073, 38.54359]]]]} | Restricted Access 2 | 47296 | El Dorado Ranch | 31004 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 2066.338 | El Dorado Ranch | 0 | Private Conservation 16 | 2 | |
5907 | 5907 | 5906 | {"type": "Polygon", "coordinates": [[[-121.06313, 38.76897], [-121.063, 38.78367], [-121.04442, 38.78347], [-121.03528, 38.78363], [-121.03172, 38.78365], [-121.03101, 38.78349], [-121.03062, 38.78361], [-121.03056, 38.78366], [-121.03018, 38.78366], [-121.03031, 38.78355], [-121.03046, 38.78347], [-121.03063, 38.78341], [-121.03081, 38.78338], [-121.03105, 38.78339], [-121.03198, 38.78357], [-121.03218, 38.78356], [-121.03238, 38.78351], [-121.03253, 38.78342], [-121.03264, 38.78332], [-121.0327, 38.78321], [-121.03277, 38.78301], [-121.03282, 38.7829], [-121.03291, 38.78279], [-121.03303, 38.78269], [-121.03326, 38.78258], [-121.03436, 38.78226], [-121.03471, 38.78212], [-121.03494, 38.78197], [-121.03512, 38.7818], [-121.03527, 38.78162], [-121.03538, 38.7814], [-121.03545, 38.78114], [-121.03546, 38.78089], [-121.03537, 38.78001], [-121.03533, 38.77972], [-121.03524, 38.77934], [-121.03506, 38.77878], [-121.03503, 38.77865], [-121.03503, 38.77844], [-121.0351, 38.778], [-121.03509, 38.77787], [-121.03505, 38.77773], [-121.03497, 38.7776], [-121.03487, 38.77748], [-121.03475, 38.77737], [-121.03459, 38.77728], [-121.03432, 38.77719], [-121.03365, 38.77709], [-121.0335, 38.77703], [-121.03337, 38.77695], [-121.03326, 38.77681], [-121.03319, 38.77666], [-121.03318, 38.77655], [-121.03321, 38.77623], [-121.0443, 38.77626], [-121.04433, 38.77443], [-121.04566, 38.77464], [-121.04634, 38.77454], [-121.04646, 38.77509], [-121.04578, 38.77583], [-121.0456, 38.77662], [-121.04612, 38.77759], [-121.04686, 38.77789], [-121.04769, 38.77781], [-121.04823, 38.77663], [-121.04941, 38.77578], [-121.04986, 38.77431], [-121.05193, 38.77346], [-121.05274, 38.77289], [-121.05339, 38.77455], [-121.05382, 38.77492], [-121.05405, 38.77539], [-121.0549, 38.77568], [-121.05579, 38.7753], [-121.05608, 38.77364], [-121.05591, 38.77206], [-121.05759, 38.77248], [-121.05837, 38.7723], [-121.05906, 38.77063], [-121.05972, 38.77035], [-121.06003, 38.76924], [-121.06079, 38.76894], [-121.06313, 38.76897]]]} | Open Access 1 | 47298 | Salmon Falls Ranch | 31005 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 622.913 | Salmon Falls Ranch | 0 | Private Conservation 16 | 2 | |
6350 | 6350 | 6349 | {"type": "Polygon", "coordinates": [[[-120.69679, 38.57498], [-120.69649, 38.5788], [-120.68726, 38.57844], [-120.68746, 38.57462], [-120.69186, 38.57497], [-120.69679, 38.57498]]]} | No Public Access 3 | 47503 | Horan | 31218 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 82.976 | Horan | 0 | Private Conservation 16 | 2 | |
11473 | 11473 | 11472 | {"type": "Polygon", "coordinates": [[[-120.99733, 38.78125], [-120.99384, 38.77961], [-120.99126, 38.77775], [-120.99111, 38.77741], [-120.99213, 38.77714], [-120.99327, 38.77628], [-120.99328, 38.77611], [-120.99356, 38.77581], [-120.99483, 38.77689], [-120.99715, 38.77875], [-120.99733, 38.77874], [-120.99733, 38.78125]]]} | No Public Access 3 | 23333 | Weiner | 27332 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 36.591 | Weiner | 0 | Private Conservation 16 | 2 | |
11491 | 11491 | 11490 | {"type": "Polygon", "coordinates": [[[-120.77806, 38.63768], [-120.77462, 38.63758], [-120.77107, 38.63752], [-120.77102, 38.64128], [-120.76872, 38.64124], [-120.76429, 38.64111], [-120.76022, 38.64107], [-120.7573, 38.64112], [-120.75802, 38.64063], [-120.75802, 38.64061], [-120.75717, 38.64113], [-120.7498, 38.64127], [-120.7499, 38.63796], [-120.74989, 38.63739], [-120.74996, 38.63668], [-120.74997, 38.6353], [-120.75, 38.6339], [-120.75449, 38.63396], [-120.75835, 38.63414], [-120.75949, 38.63422], [-120.76853, 38.63428], [-120.76861, 38.63259], [-120.76878, 38.63261], [-120.7694, 38.63258], [-120.76978, 38.63253], [-120.76997, 38.63226], [-120.77073, 38.63165], [-120.77203, 38.63101], [-120.77281, 38.63056], [-120.77334, 38.63035], [-120.77402, 38.63023], [-120.77471, 38.63031], [-120.77577, 38.6302], [-120.7762, 38.63021], [-120.77666, 38.63042], [-120.77691, 38.63036], [-120.77704, 38.63021], [-120.77707, 38.62996], [-120.77798, 38.62996], [-120.77804, 38.63242], [-120.77806, 38.63388], [-120.77806, 38.63768]], [[-120.7581, 38.63436], [-120.75809, 38.63434], [-120.75745, 38.63465], [-120.75712, 38.63501], [-120.75757, 38.63474], [-120.75777, 38.63457], [-120.7581, 38.63436]], [[-120.75869, 38.64016], [-120.7587, 38.64017], [-120.75904, 38.63994], [-120.75941, 38.63957], [-120.75945, 38.63935], [-120.75944, 38.63935], [-120.75926, 38.63961], [-120.75869, 38.64016]], [[-120.75958, 38.63877], [-120.75915, 38.63838], [-120.75911, 38.63837], [-120.75911, 38.63839], [-120.75954, 38.63877], [-120.75952, 38.63915], [-120.75949, 38.63923], [-120.7595, 38.63924], [-120.75959, 38.63913], [-120.75958, 38.63877]]]} | No Public Access 3 | 23320 | Ladies Valley | 20825 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 485.277 | Ladies Valley | 0 | Private Conservation 16 | 2 | |
11492 | 11492 | 11491 | {"type": "Polygon", "coordinates": [[[-120.97547, 38.67216], [-120.97547, 38.67475], [-120.96631, 38.67478], [-120.96624, 38.67115], [-120.97194, 38.67113], [-120.97229, 38.67133], [-120.97256, 38.67157], [-120.97292, 38.67184], [-120.97378, 38.67217], [-120.97547, 38.67216]]]} | No Public Access 3 | 23329 | Smith and Gabb2 | 25567 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 72.885 | Smith and Gabb2 | 0 | Private Conservation 16 | 2 | |
11493 | 11493 | 11492 | {"type": "Polygon", "coordinates": [[[-120.9753, 38.72624], [-120.97528, 38.7292], [-120.97223, 38.72922], [-120.97223, 38.72627], [-120.97243, 38.72625], [-120.97326, 38.72601], [-120.9753, 38.72624]]]} | No Public Access 3 | 23330 | Thomas | 26305 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 22.424 | Thomas | 0 | Private Conservation 16 | 2 | |
13640 | 13640 | 13639 | {"type": "Polygon", "coordinates": [[[-121.01127, 38.77623], [-121.01126, 38.77986], [-121.01124, 38.77991], [-121.01121, 38.77993], [-121.00677, 38.77985], [-121.00661, 38.77987], [-121.00662, 38.77616], [-121.01127, 38.77623]]]} | Unknown Access 4 | 36003 | Boulder Glen | 16295 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | El Dorado 34 | 40.914 | Boulder Glen | 0 | Private Conservation 16 | 2 | |
15148 | 15148 | 15147 | {"type": "MultiPolygon", "coordinates": [[[[-120.41957, 39.20187], [-120.4169, 39.21534], [-120.4075, 39.2155], [-120.39824, 39.21551], [-120.40113, 39.22913], [-120.38195, 39.22954], [-120.37973, 39.21554], [-120.36287, 39.21575], [-120.36267, 39.22994], [-120.3575, 39.22992], [-120.34426, 39.22975], [-120.34426, 39.22825], [-120.34441, 39.21377], [-120.32839, 39.21429], [-120.32899, 39.20107], [-120.34482, 39.20103], [-120.34478, 39.20247], [-120.35234, 39.20247], [-120.35053, 39.18017], [-120.35009, 39.17281], [-120.34973, 39.16545], [-120.34941, 39.15824], [-120.34919, 39.15288], [-120.349, 39.14735], [-120.34886, 39.14376], [-120.36876, 39.14361], [-120.36801, 39.1291], [-120.35794, 39.12885], [-120.34815, 39.12868], [-120.34857, 39.13618], [-120.34878, 39.14199], [-120.33091, 39.14182], [-120.33022, 39.12723], [-120.34808, 39.12751], [-120.34775, 39.12113], [-120.34739, 39.1135], [-120.36773, 39.11396], [-120.36793, 39.10676], [-120.3676, 39.09886], [-120.38773, 39.09918], [-120.38759, 39.11378], [-120.37751, 39.11395], [-120.36774, 39.11397], [-120.36773, 39.11398], [-120.3679, 39.12173], [-120.36801, 39.12909], [-120.37794, 39.12928], [-120.38774, 39.12921], [-120.38806, 39.13639], [-120.38842, 39.14358], [-120.36876, 39.14362], [-120.36957, 39.15815], [-120.35927, 39.15824], [-120.35956, 39.16914], [-120.37014, 39.16917], [-120.37033, 39.17276], [-120.37065, 39.18017], [-120.3719, 39.20244], [-120.37657, 39.20243], [-120.37625, 39.19484], [-120.38104, 39.19484], [-120.38084, 39.18746], [-120.38574, 39.18741], [-120.3857, 39.18373], [-120.39066, 39.18369], [-120.39065, 39.18737], [-120.39989, 39.18729], [-120.40931, 39.18725], [-120.40928, 39.20208], [-120.41957, 39.20187]], [[-120.40087, 39.2021], [-120.40086, 39.20209], [-120.39789, 39.20215], [-120.3906, 39.20226], [-120.39063, 39.19106], [-120.38579, 39.1911], [-120.38583, 39.19479], [-120.38104, 39.19485], [-120.38125, 39.20242], [-120.38208, 39.20242], [-120.38091, 39.20906], [-120.37974, 39.21554], [-120.38901, 39.21574], [-120.39823, 39.2155], [-120.40087, 39.2021]]], [[[-120.45621, 39.20083], [-120.45598, 39.21519], [-120.44679, 39.21526], [-120.44217, 39.21531], [-120.43751, 39.21546], [-120.43762, 39.20166], [-120.44631, 39.20136], [-120.45621, 39.20083]]]]} | Open Access 1 | 45990 | American River Headwaters | 29161 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | http://northernsierrapartnership.org/american-river-headwaters/ | Placer 35 | 10210.918 | American River Headwaters | 0 | Private Conservation 16 | 2 |
15281 | 15281 | 15280 | {"type": "MultiPolygon", "coordinates": [[[[-120.86261, 38.53701], [-120.86257, 38.53794], [-120.86264, 38.5384], [-120.86251, 38.53943], [-120.86255, 38.53979], [-120.86253, 38.54056], [-120.86247, 38.54133], [-120.86227, 38.54212], [-120.86232, 38.54264], [-120.86183, 38.54323], [-120.86116, 38.54345], [-120.86029, 38.54304], [-120.85959, 38.54261], [-120.8578, 38.54218], [-120.85666, 38.54224], [-120.85572, 38.54279], [-120.8553, 38.54346], [-120.8552, 38.54393], [-120.85244, 38.54392], [-120.8524, 38.54218], [-120.85217, 38.54078], [-120.86208, 38.54056], [-120.86202, 38.53698], [-120.86261, 38.53701]]], [[[-120.85667, 38.54735], [-120.85662, 38.54767], [-120.85595, 38.54814], [-120.85555, 38.54854], [-120.8547, 38.54903], [-120.8538, 38.54953], [-120.85255, 38.55006], [-120.8525, 38.54733], [-120.85667, 38.54735]]]]} | Restricted Access 2 | 47297 | El Dorado Ranch | 31004 | 3003 | American River Conservancy 604 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.arconservancy.org/ | Non Governmental Organization 10 | 3003 | American River Conservancy 593 | Non Profit 6 | Non Profit - Land Trust 10 | Amador 52 | 78.399 | El Dorado Ranch | 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]);