units_with_maps

Table actions

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

5 rows where ACCESS_TYP = 2, COUNTY = 24 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, LAYER, MNG_AG_ID

MNG_AG_TYP 1

  • State Agency · 5 ✖

ACCESS_TYP 1

  • Restricted Access · 5 ✖
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
5846 5846 5845 {"type": "Polygon", "coordinates": [[[-123.25549, 38.89635], [-123.24599, 38.90389], [-123.24056, 38.90437], [-123.24061, 38.90254], [-123.2406, 38.89715], [-123.24069, 38.8935], [-123.24608, 38.89273], [-123.24609, 38.89637], [-123.25549, 38.89635]]]} Restricted Access 2 21623 Yorkville Ecological Reserve 27781 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Mendocino 24 226.535 Yorkville ER 0 State Conservation Area 8 2
8345 8345 8344 {"type": "Polygon", "coordinates": [[[-123.76615, 39.28535], [-123.76613, 39.28619], [-123.76623, 39.28837], [-123.76622, 39.29088], [-123.76353, 39.28996], [-123.76354, 39.28536], [-123.76125, 39.28534], [-123.76132, 39.28339], [-123.76129, 39.28146], [-123.7637, 39.2815], [-123.76605, 39.28153], [-123.76615, 39.28535]]]} Restricted Access 2 48474 Hans Jenny Pygmy Forest Reserve 33185 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5 https://ucnrs.org/reserves/hans-jenny-pygmy-forest-reserve/ Mendocino 24 75.697 Hans Jenny Pygmy Forest Reserve 0 State Conservation Area 8 2
13035 13035 13034 {"type": "MultiPolygon", "coordinates": [[[[-123.64441, 39.75598], [-123.63975, 39.75602], [-123.63972, 39.75235], [-123.64438, 39.75234], [-123.64441, 39.75598]]], [[[-123.65347, 39.71672], [-123.65341, 39.72014], [-123.64901, 39.72013], [-123.64896, 39.72745], [-123.65836, 39.72733], [-123.65832, 39.7344], [-123.65803, 39.73441], [-123.65809, 39.73793], [-123.65344, 39.7379], [-123.65346, 39.7415], [-123.65813, 39.74151], [-123.65816, 39.74512], [-123.66276, 39.74514], [-123.66279, 39.74876], [-123.64434, 39.74871], [-123.6443, 39.74686], [-123.64423, 39.74153], [-123.63961, 39.74155], [-123.63968, 39.74852], [-123.62908, 39.74855], [-123.62916, 39.75428], [-123.62928, 39.75953], [-123.62941, 39.7631], [-123.61982, 39.76303], [-123.61972, 39.7572], [-123.61974, 39.75216], [-123.60664, 39.75215], [-123.60665, 39.74865], [-123.60708, 39.74862], [-123.60699, 39.74532], [-123.60243, 39.74535], [-123.60217, 39.73476], [-123.60203, 39.73072], [-123.60697, 39.73081], [-123.60683, 39.73467], [-123.60685, 39.73806], [-123.60686, 39.73807], [-123.62089, 39.73787], [-123.62563, 39.73784], [-123.62573, 39.73448], [-123.62573, 39.73082], [-123.62095, 39.73081], [-123.61612, 39.73078], [-123.61613, 39.72352], [-123.60199, 39.72364], [-123.60199, 39.71979], [-123.60191, 39.71269], [-123.61144, 39.71261], [-123.61113, 39.70554], [-123.61535, 39.70557], [-123.6194, 39.70756], [-123.62071, 39.70814], [-123.62079, 39.70548], [-123.62344, 39.70778], [-123.62259, 39.7091], [-123.62098, 39.70833], [-123.62096, 39.70834], [-123.62098, 39.71253], [-123.63005, 39.71275], [-123.63459, 39.71283], [-123.63944, 39.71302], [-123.63944, 39.71669], [-123.64419, 39.71672], [-123.64426, 39.7201], [-123.649, 39.72013], [-123.64904, 39.71674], [-123.64901, 39.71511], [-123.65345, 39.7151], [-123.65347, 39.71672]], [[-123.63945, 39.7201], [-123.63472, 39.72005], [-123.6348, 39.7235], [-123.63947, 39.72353], [-123.63945, 39.7201]]]]} Restricted Access 2 31209 Angelo Coast Range Reserve 15496 217 University of California 53 State 5 State Agency 5 http://nrs.ucop.edu/ Other State 5 217 University of California 51 State 5 State Agency 5 http://angelo.berkeley.edu/ Mendocino 24 4263.8 Angelo Coast Range Reserve 0 State Conservation Area 8 2
15588 15588 15587 {"type": "Polygon", "coordinates": [[[-123.6721, 39.95973], [-123.67226, 39.96331], [-123.67206, 39.97058], [-123.66728, 39.97068], [-123.66757, 39.97778], [-123.66307, 39.9778], [-123.663, 39.97427], [-123.65839, 39.97425], [-123.65822, 39.97069], [-123.6582, 39.96352], [-123.66285, 39.96333], [-123.66745, 39.96334], [-123.66745, 39.95984], [-123.6721, 39.95973]]]} Restricted Access 2 21599 Little Butte Ecological Reserve 21334 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Mendocino 24 391.018 Little Butte ER 0 State Conservation Area 8 2
16926 16926 16925 {"type": "Polygon", "coordinates": [[[-123.67585, 39.86241], [-123.67556, 39.87486], [-123.67546, 39.87608], [-123.66682, 39.87604], [-123.65783, 39.87597], [-123.65713, 39.87595], [-123.64776, 39.87607], [-123.64804, 39.87287], [-123.64796, 39.86931], [-123.65257, 39.86915], [-123.65252, 39.86823], [-123.65018, 39.8683], [-123.6502, 39.8676], [-123.64794, 39.86771], [-123.6478, 39.86589], [-123.64302, 39.86603], [-123.64322, 39.8728], [-123.64298, 39.8761], [-123.64382, 39.8761], [-123.64373, 39.8869], [-123.63912, 39.88694], [-123.63453, 39.88701], [-123.63448, 39.89067], [-123.63451, 39.89445], [-123.6299, 39.89439], [-123.62987, 39.89068], [-123.63001, 39.88714], [-123.6205, 39.88727], [-123.62047, 39.88367], [-123.61607, 39.88359], [-123.61609, 39.87995], [-123.61591, 39.87629], [-123.62046, 39.87631], [-123.62508, 39.87627], [-123.62501, 39.8729], [-123.62042, 39.87286], [-123.62037, 39.86924], [-123.61593, 39.86919], [-123.61593, 39.86211], [-123.61588, 39.85855], [-123.61596, 39.85496], [-123.61593, 39.85382], [-123.61593, 39.85146], [-123.62052, 39.85156], [-123.6206, 39.84809], [-123.6254, 39.84806], [-123.62975, 39.84811], [-123.63882, 39.84816], [-123.6388, 39.84454], [-123.64339, 39.84452], [-123.64332, 39.84811], [-123.64321, 39.85176], [-123.64302, 39.86259], [-123.6478, 39.86253], [-123.64782, 39.86589], [-123.65242, 39.86566], [-123.65235, 39.86245], [-123.65734, 39.86238], [-123.67167, 39.86238], [-123.67585, 39.86241]], [[-123.6339, 39.85532], [-123.63389, 39.85531], [-123.62946, 39.85529], [-123.62043, 39.85511], [-123.62028, 39.86222], [-123.62034, 39.86565], [-123.62453, 39.86567], [-123.62946, 39.8659], [-123.62953, 39.86679], [-123.6339, 39.86677], [-123.63381, 39.86255], [-123.6339, 39.85532]], [[-123.63372, 39.87352], [-123.63371, 39.87351], [-123.62953, 39.87358], [-123.62941, 39.87616], [-123.63373, 39.87614], [-123.63372, 39.87352]]]} Restricted Access 2 21600 Little Red Mountain Ecological Reserve 21355 201 California Department of Fish and Wildlife 25 State 5 State Agency 5 https://www.wildlife.ca.gov/ California Department of Fish and Wildlife 6 201 California Department of Fish and Wildlife 25 State 5 State Agency 5   Mendocino 24 2942.053 Little Red Mtn. ER 0 State Conservation Area 8 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]);