units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 55 and DES_TP = 11

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP

ACCESS_TYP 1

  • Open Access · 1 ✖
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
15760 15760 15759 {"type": "MultiPolygon", "coordinates": [[[[-122.93825, 39.74777], [-122.93793, 39.74988], [-122.93734, 39.75496], [-122.93771, 39.76963], [-122.93754, 39.78054], [-122.93327, 39.78047], [-122.93323, 39.78428], [-122.93311, 39.79145], [-122.93312, 39.79146], [-122.93755, 39.79151], [-122.9376, 39.79819], [-122.93753, 39.79821], [-122.91165, 39.79836], [-122.9116, 39.79936], [-122.9037, 39.79927], [-122.89331, 39.7991], [-122.86653, 39.79991], [-122.85612, 39.80016], [-122.83762, 39.80062], [-122.82963, 39.80062], [-122.81039, 39.80056], [-122.79351, 39.80052], [-122.77447, 39.80053], [-122.75609, 39.8004], [-122.75111, 39.80039], [-122.73685, 39.80031], [-122.69946, 39.80007], [-122.6808, 39.79999], [-122.66223, 39.79969], [-122.64374, 39.79965], [-122.61576, 39.79934], [-122.61603, 39.79862], [-122.61608, 39.78853], [-122.60715, 39.78842], [-122.60714, 39.78843], [-122.60729, 39.79209], [-122.61103, 39.79208], [-122.61123, 39.79928], [-122.60753, 39.79924], [-122.59777, 39.79933], [-122.59761, 39.78492], [-122.59293, 39.78491], [-122.59297, 39.7811], [-122.5976, 39.7811], [-122.5975, 39.77392], [-122.59267, 39.77395], [-122.59269, 39.77035], [-122.58811, 39.77034], [-122.58804, 39.75728], [-122.58786, 39.75022], [-122.58776, 39.74186], [-122.58736, 39.72722], [-122.60621, 39.72711], [-122.60609, 39.72356], [-122.60584, 39.7126], [-122.58989, 39.71261], [-122.58999, 39.70345], [-122.59012, 39.69564], [-122.5901, 39.68813], [-122.59006, 39.68178], [-122.58996, 39.67829], [-122.6039, 39.67842], [-122.60385, 39.67488], [-122.59459, 39.67472], [-122.59457, 39.67415], [-122.59411, 39.67417], [-122.59361, 39.67426], [-122.59265, 39.67451], [-122.59222, 39.67451], [-122.59109, 39.67464], [-122.59084, 39.67477], [-122.59063, 39.67482], [-122.59041, 39.67479], [-122.58993, 39.67481], [-122.5899, 39.67452], [-122.59078, 39.67447], [-122.59127, 39.6743], [-122.59164, 39.67437], [-122.59249, 39.67418], [-122.59311, 39.67425], [-122.59338, 39.67407], [-122.59421, 39.67386], [-122.59454, 39.67395], [-122.5945, 39.67126], [-122.58984, 39.67119], [-122.58976, 39.66765], [-122.59441, 39.66768], [-122.59422, 39.65713], [-122.59889, 39.65714], [-122.59879, 39.6536], [-122.59879, 39.6464], [-122.59874, 39.64279], [-122.60805, 39.64285], [-122.60801, 39.63894], [-122.60796, 39.63187], [-122.60781, 39.62503], [-122.61143, 39.62502], [-122.61121, 39.61731], [-122.61591, 39.61731], [-122.61578, 39.60987], [-122.6157, 39.60638], [-122.6155, 39.59551], [-122.62025, 39.59557], [-122.62026, 39.59556], [-122.6202, 39.5806], [-122.62013, 39.57254], [-122.6201, 39.56617], [-122.61559, 39.56609], [-122.61553, 39.56192], [-122.61529, 39.55145], [-122.6152, 39.54066], [-122.61522, 39.53729], [-122.61038, 39.53729], [-122.60586, 39.53731], [-122.60536, 39.5258], [-122.60968, 39.52581], [-122.6097, 39.52176], [-122.60518, 39.52169], [-122.60496, 39.507], [-122.60502, 39.49408], [-122.60328, 39.47972], [-122.60138, 39.4653], [-122.59961, 39.45096], [-122.60857, 39.45098], [-122.60858, 39.44739], [-122.59016, 39.44732], [-122.59017, 39.44378], [-122.58086, 39.44375], [-122.58095, 39.42223], [-122.58097, 39.41127], [-122.58563, 39.41121], [-122.58564, 39.4112], [-122.58549, 39.40377], [-122.58074, 39.40392], [-122.58, 39.39306], [-122.57994, 39.38565], [-122.61686, 39.38534], [-122.6261, 39.38515], [-122.62611, 39.38521], [-122.64455, 39.38491], [-122.6585, 39.38477], [-122.67361, 39.38476], [-122.6794, 39.38435], [-122.70154, 39.38298], [-122.72053, 39.38331], [-122.73913, 39.38332], [-122.73926, 39.39086], [-122.73922, 39.4065], [-122.74022, 39.4185], [-122.74167, 39.43541], [-122.73268, 39.45037], [-122.73152, 39.47984], [-122.73228, 39.49392], [-122.73233, 39.49438], [-122.73386, 39.49987], [-122.7339, 39.49988], [-122.73479, 39.50326], [-122.73622, 39.50846], [-122.7362, 39.51051], [-122.73643, 39.52219], [-122.73643, 39.52477], [-122.73612, 39.53725], [-122.73664, 39.55176], [-122.73669, 39.56624], [-122.73571, 39.58068], [-122.75111, 39.58117], [-122.75406, 39.5813], [-122.77254, 39.57942], [-122.78575, 39.57963], [-122.78576, 39.57962], [-122.78574, 39.5796], [-122.78609, 39.5796], [-122.7861, 39.57959], [-122.78627, 39.57964], [-122.7904, 39.57962], [-122.79623, 39.58005], [-122.79623, 39.58008], [-122.80212, 39.58052], [-122.80216, 39.58054], [-122.80819, 39.58089], [-122.8082, 39.58096], [-122.80944, 39.58105], [-122.80938, 39.58114], [-122.80939, 39.58115], [-122.81405, 39.58152], [-122.82848, 39.57957], [-122.84651, 39.57997], [-122.86717, 39.58065], [-122.86706, 39.58767], [-122.84672, 39.58755], [-122.84671, 39.58738], [-122.84264, 39.58771], [-122.8428, 39.59512], [-122.84684, 39.59484], [-122.85677, 39.595], [-122.85698, 39.59874], [-122.86655, 39.59889], [-122.86669, 39.59516], [-122.86693, 39.59515], [-122.86696, 39.59484], [-122.88552, 39.59498], [-122.88532, 39.60342], [-122.87972, 39.60297], [-122.87907, 39.59933], [-122.87445, 39.59931], [-122.87579, 39.60652], [-122.88043, 39.60664], [-122.88109, 39.61068], [-122.88508, 39.61105], [-122.88513, 39.61107], [-122.88513, 39.61114], [-122.88929, 39.62467], [-122.89054, 39.62467], [-122.89055, 39.62488], [-122.89047, 39.62489], [-122.89052, 39.63536], [-122.89063, 39.64028], [-122.89057, 39.64026], [-122.88585, 39.64023], [-122.88584, 39.64024], [-122.88589, 39.64372], [-122.89071, 39.64368], [-122.89079, 39.64744], [-122.88593, 39.64744], [-122.88592, 39.65114], [-122.89088, 39.65116], [-122.89123, 39.66628], [-122.89129, 39.67548], [-122.89149, 39.6818], [-122.89336, 39.70013], [-122.89409, 39.70909], [-122.91202, 39.70938], [-122.91207, 39.71126], [-122.91212, 39.72617], [-122.91213, 39.74043], [-122.91211, 39.74774], [-122.93825, 39.74777]], [[-122.59968, 39.42234], [-122.59967, 39.42192], [-122.59752, 39.42196], [-122.59747, 39.4165], [-122.59053, 39.41657], [-122.59054, 39.41476], [-122.58322, 39.41489], [-122.5834, 39.41664], [-122.58586, 39.41665], [-122.58592, 39.41841], [-122.59052, 39.41843], [-122.59058, 39.42005], [-122.59493, 39.42006], [-122.59506, 39.422], [-122.59504, 39.42583], [-122.59963, 39.42584], [-122.59968, 39.42234]], [[-122.60859, 39.45098], [-122.60858, 39.45099], [-122.60918, 39.45442], [-122.63631, 39.45479], [-122.6455, 39.45474], [-122.6454, 39.45133], [-122.63624, 39.45116], [-122.62707, 39.4511], [-122.61811, 39.45096], [-122.60859, 39.45098]], [[-122.63244, 39.42161], [-122.62718, 39.4216], [-122.6271, 39.43644], [-122.63703, 39.43634], [-122.63703, 39.43326], [-122.63167, 39.43323], [-122.63184, 39.42602], [-122.63707, 39.42601], [-122.63712, 39.41428], [-122.63235, 39.41432], [-122.63244, 39.42161]], [[-122.63647, 39.39635], [-122.63644, 39.39601], [-122.63598, 39.39679], [-122.6357, 39.39731], [-122.6357, 39.39788], [-122.63532, 39.39892], [-122.63501, 39.39935], [-122.63495, 39.39963], [-122.62756, 39.39971], [-122.62755, 39.40333], [-122.63221, 39.40329], [-122.63232, 39.40714], [-122.63713, 39.40717], [-122.63665, 39.39962], [-122.63513, 39.39962], [-122.63519, 39.39939], [-122.63542, 39.39905], [-122.63564, 39.39842], [-122.63574, 39.39807], [-122.63585, 39.39743], [-122.63647, 39.39635]], [[-122.6428, 39.53735], [-122.65224, 39.53738], [-122.65221, 39.53727], [-122.65223, 39.53358], [-122.64276, 39.53352], [-122.63806, 39.53354], [-122.63822, 39.53727], [-122.6383, 39.54085], [-122.64281, 39.54088], [-122.6428, 39.53735]], [[-122.65178, 39.55878], [-122.65179, 39.55877], [-122.65164, 39.55509], [-122.64225, 39.55489], [-122.6423, 39.55545], [-122.64275, 39.55546], [-122.64281, 39.55836], [-122.65178, 39.55878]], [[-122.65953, 39.46605], [-122.65954, 39.46604], [-122.65928, 39.45846], [-122.64553, 39.45854], [-122.64573, 39.46222], [-122.65497, 39.46215], [-122.65501, 39.46604], [-122.65953, 39.46605]], [[-122.66584, 39.55185], [-122.66583, 39.55184], [-122.6611, 39.55189], [-122.66106, 39.55542], [-122.65871, 39.55535], [-122.65872, 39.5591], [-122.65641, 39.559], [-122.65645, 39.56276], [-122.65686, 39.56279], [-122.65687, 39.56275], [-122.66136, 39.56276], [-122.66141, 39.56635], [-122.66625, 39.56632], [-122.67521, 39.56621], [-122.67527, 39.55912], [-122.66577, 39.55918], [-122.66584, 39.55185]], [[-122.65852, 39.55308], [-122.65851, 39.55307], [-122.65712, 39.55306], [-122.65696, 39.55441], [-122.65836, 39.55442], [-122.65852, 39.55308]], [[-122.65854, 39.76659], [-122.65855, 39.76658], [-122.65848, 39.76545], [-122.65777, 39.76543], [-122.65778, 39.76657], [-122.65854, 39.76659]], [[-122.67415, 39.46609], [-122.65954, 39.46605], [-122.65966, 39.46957], [-122.67465, 39.46948], [-122.67866, 39.46942], [-122.6784, 39.46606], [-122.67415, 39.46609]], [[-122.6664, 39.63893], [-122.6712, 39.63892], [-122.67132, 39.63538], [-122.6665, 39.63538], [-122.66167, 39.6354], [-122.66158, 39.63894], [-122.6664, 39.63893]], [[-122.67409, 39.44344], [-122.67889, 39.44335], [-122.67952, 39.43973], [-122.67424, 39.43966], [-122.6655, 39.43975], [-122.66508, 39.44346], [-122.66914, 39.44348], [-122.66893, 39.44705], [-122.67393, 39.44722], [-122.67409, 39.44344]], [[-122.68035, 39.58867], [-122.68484, 39.58865], [-122.68481, 39.58498], [-122.68029, 39.58497], [-122.66639, 39.58485], [-122.6664, 39.58857], [-122.68035, 39.58867]], [[-122.68572, 39.63667], [-122.68571, 39.63665], [-122.6833, 39.63665], [-122.68329, 39.63846], [-122.68564, 39.63846], [-122.68572, 39.63667]], [[-122.68981, 39.55645], [-122.68864, 39.55643], [-122.68866, 39.55734], [-122.68749, 39.55734], [-122.68754, 39.55901], [-122.68871, 39.559], [-122.68869, 39.55825], [-122.68986, 39.55825], [-122.68981, 39.55645]], [[-122.69402, 39.66967], [-122.6933, 39.66933], [-122.69297, 39.66908], [-122.69285, 39.6689], [-122.69271, 39.66848], [-122.69254, 39.66817], [-122.69147, 39.66804], [-122.69089, 39.66839], [-122.6907, 39.66877], [-122.69109, 39.6692], [-122.69149, 39.66957], [-122.69199, 39.66991], [-122.69214, 39.67047], [-122.69252, 39.67039], [-122.69269, 39.67045], [-122.69284, 39.67064], [-122.69297, 39.67074], [-122.69311, 39.67082], [-122.69327, 39.67082], [-122.69433, 39.67006], [-122.69402, 39.66967]], [[-122.71195, 39.47713], [-122.71196, 39.47712], [-122.71153, 39.47331], [-122.6928, 39.47315], [-122.69284, 39.47691], [-122.71195, 39.47713]], [[-122.7044, 39.72298], [-122.69937, 39.72304], [-122.69939, 39.72678], [-122.70447, 39.72676], [-122.7044, 39.72298]], [[-122.70509, 39.62273], [-122.70645, 39.62483], [-122.71434, 39.62488], [-122.72276, 39.6249], [-122.72312, 39.62107], [-122.72311, 39.62106], [-122.72142, 39.62125], [-122.70442, 39.62167], [-122.70509, 39.62273]], [[-122.71755, 39.67108], [-122.71754, 39.67107], [-122.70825, 39.671], [-122.70808, 39.67813], [-122.71725, 39.67821], [-122.71755, 39.67108]], [[-122.72745, 39.4624], [-122.72744, 39.46239], [-122.71148, 39.4625], [-122.71077, 39.46704], [-122.71111, 39.4699], [-122.71782, 39.46986], [-122.7179, 39.46694], [-122.72717, 39.46679], [-122.72745, 39.4624]], [[-122.77866, 39.75686], [-122.7594, 39.75594], [-122.75937, 39.75667], [-122.75921, 39.7636], [-122.77854, 39.76365], [-122.77866, 39.75686]], [[-122.80646, 39.66468], [-122.80482, 39.6647], [-122.80483, 39.66597], [-122.80649, 39.66596], [-122.80646, 39.66468]], [[-122.83851, 39.60284], [-122.83852, 39.60283], [-122.83763, 39.59583], [-122.83758, 39.59552], [-122.83602, 39.59559], [-122.83066, 39.59596], [-122.82763, 39.59601], [-122.82662, 39.59607], [-122.82686, 39.59961], [-122.83096, 39.59959], [-122.83507, 39.59934], [-122.83543, 39.603], [-122.83851, 39.60284]], [[-122.85826, 39.66984], [-122.85364, 39.66971], [-122.85356, 39.67329], [-122.84907, 39.67395], [-122.84879, 39.68061], [-122.84849, 39.68584], [-122.84335, 39.68715], [-122.84284, 39.69672], [-122.84786, 39.69633], [-122.84818, 39.69107], [-122.84934, 39.69088], [-122.84937, 39.69052], [-122.85275, 39.69056], [-122.85349, 39.67949], [-122.85351, 39.67891], [-122.85351, 39.67592], [-122.85818, 39.67616], [-122.85826, 39.66984]], [[-122.8507, 39.70846], [-122.85092, 39.70845], [-122.84955, 39.70622], [-122.84722, 39.70626], [-122.84858, 39.70845], [-122.8507, 39.70846]], [[-122.86968, 39.77896], [-122.8608, 39.77897], [-122.86087, 39.7829], [-122.86555, 39.78282], [-122.86562, 39.78953], [-122.87001, 39.78948], [-122.86978, 39.78282], [-122.86968, 39.77896]], [[-122.87898, 39.76889], [-122.87342, 39.76882], [-122.87564, 39.78279], [-122.87921, 39.78276], [-122.87898, 39.76889]], [[-122.88592, 39.64743], [-122.88593, 39.64742], [-122.88588, 39.64372], [-122.88125, 39.64367], [-122.88128, 39.64743], [-122.88592, 39.64743]], [[-122.89299, 39.76104], [-122.89298, 39.76103], [-122.88584, 39.76236], [-122.88577, 39.76679], [-122.89293, 39.76672], [-122.89303, 39.76484], [-122.89299, 39.76104]]], [[[-122.88601, 39.58023], [-122.88576, 39.58777], [-122.88116, 39.58768], [-122.88132, 39.58033], [-122.88601, 39.58023]]]]} Open Access 1 23027 Mendocino National Forest 14079 107 United States Forest Service 38 Federal 1 Federal Agency 1 http://www.fs.fed.us/ US Forest Service 7 107 United States Forest Service 37 Federal 1 Federal Agency 1 http://www.fs.usda.gov/mendocino/ Glenn 55 215067.599 Mendocino NF 1908 National Forest 11 3

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