units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

2 rows where ACCESS_TYP = 2, LAYER = 10 and MNG_AGENCY = 50

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Save the Redwoods League · 2 ✖

ACCESS_TYP 1

  • Restricted Access · 2 ✖
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
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
7793 7793 7792 {"type": "Polygon", "coordinates": [[[-118.63454, 36.18601], [-118.63435, 36.1915], [-118.63306, 36.1915], [-118.63218, 36.19218], [-118.63212, 36.19397], [-118.61609, 36.19398], [-118.61722, 36.17918], [-118.62989, 36.17918], [-118.63, 36.17971], [-118.62954, 36.17985], [-118.62973, 36.18036], [-118.62976, 36.1805], [-118.62995, 36.18078], [-118.63014, 36.18062], [-118.63022, 36.18061], [-118.63043, 36.18061], [-118.63077, 36.18048], [-118.63076, 36.18084], [-118.63059, 36.18085], [-118.63054, 36.18116], [-118.6307, 36.18159], [-118.63091, 36.1819], [-118.63132, 36.18238], [-118.63152, 36.18281], [-118.63151, 36.18308], [-118.6315, 36.18327], [-118.63127, 36.18345], [-118.63102, 36.18383], [-118.63106, 36.18424], [-118.63119, 36.18421], [-118.63133, 36.18459], [-118.63075, 36.18481], [-118.6304, 36.18522], [-118.6304, 36.18523], [-118.63054, 36.18528], [-118.63041, 36.18553], [-118.63056, 36.18557], [-118.62994, 36.187], [-118.62974, 36.18759], [-118.63016, 36.18773], [-118.63014, 36.18778], [-118.63045, 36.18785], [-118.63081, 36.18831], [-118.63058, 36.18848], [-118.6308, 36.18866], [-118.63041, 36.18937], [-118.63012, 36.18952], [-118.62921, 36.18951], [-118.62926, 36.18984], [-118.62817, 36.18997], [-118.62813, 36.19023], [-118.62824, 36.19042], [-118.6285, 36.19056], [-118.62877, 36.1906], [-118.62878, 36.1914], [-118.63008, 36.19135], [-118.63049, 36.19144], [-118.63124, 36.19144], [-118.63216, 36.19071], [-118.63241, 36.19046], [-118.63191, 36.19015], [-118.63205, 36.18967], [-118.63246, 36.18949], [-118.6326, 36.18949], [-118.63287, 36.18938], [-118.63304, 36.18902], [-118.6332, 36.18884], [-118.63374, 36.18683], [-118.6339, 36.18645], [-118.63436, 36.186], [-118.63454, 36.18601]]]} Restricted Access 2 48976 Alder Creek 33673 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 https://www.savetheredwoods.org/project/alder-creek/ Tulare 29 530.017 Alder Creek 2019 Private Conservation 16 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);