units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 2, COUNTY = 24 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 3 ✖

ACCESS_TYP 1

  • Restricted Access · 3 ✖
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
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]);