units_with_maps

Table actions

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

1 row where COUNTY = 35, DES_TP = 39 and MNG_AGENCY = 25

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • California Department of Fish and Wildlife · 1 ✖

DES_TP 1

  • State Recreation Area · 1 ✖

ACCESS_TYP 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
15643 15643 15642 {"type": "Polygon", "coordinates": [[[-120.99671, 39.06834], [-120.99652, 39.06857], [-120.99644, 39.06871], [-120.99637, 39.06886], [-120.99635, 39.06914], [-120.99637, 39.06927], [-120.99646, 39.06946], [-120.99659, 39.06968], [-120.99687, 39.06992], [-120.9971, 39.07005], [-120.99734, 39.07012], [-120.99765, 39.07025], [-120.99784, 39.07034], [-120.99812, 39.07063], [-120.99824, 39.07081], [-120.99855, 39.07157], [-120.99854, 39.07182], [-120.99849, 39.072], [-120.99838, 39.07221], [-120.9981, 39.07243], [-120.99767, 39.07269], [-120.99738, 39.07283], [-120.99713, 39.07298], [-120.99649, 39.07321], [-120.99607, 39.07334], [-120.99484, 39.07381], [-120.99409, 39.07418], [-120.99385, 39.07434], [-120.99322, 39.0745], [-120.993, 39.07459], [-120.99267, 39.07476], [-120.9925, 39.07488], [-120.99189, 39.07557], [-120.99158, 39.07602], [-120.99149, 39.07621], [-120.99147, 39.07651], [-120.99151, 39.07673], [-120.99161, 39.07702], [-120.99184, 39.07724], [-120.99251, 39.07753], [-120.993, 39.07768], [-120.99319, 39.07772], [-120.99345, 39.07782], [-120.99402, 39.07796], [-120.99434, 39.07809], [-120.9947, 39.07832], [-120.99505, 39.0787], [-120.99528, 39.07891], [-120.99562, 39.07937], [-120.9959, 39.07985], [-120.996, 39.0801], [-120.99606, 39.08027], [-120.99607, 39.08067], [-120.996, 39.08085], [-120.99574, 39.08112], [-120.99555, 39.0812], [-120.99534, 39.08126], [-120.99505, 39.08127], [-120.99486, 39.08124], [-120.9947, 39.08125], [-120.9943, 39.08132], [-120.99418, 39.08135], [-120.99402, 39.08142], [-120.9935, 39.08168], [-120.99307, 39.08184], [-120.99293, 39.08186], [-120.99265, 39.08184], [-120.99237, 39.0818], [-120.99166, 39.0819], [-120.99145, 39.08195], [-120.99121, 39.08201], [-120.99095, 39.08213], [-120.99067, 39.08261], [-120.99036, 39.08297], [-120.99017, 39.08312], [-120.99005, 39.08328], [-120.98994, 39.08355], [-120.98982, 39.08372], [-120.98968, 39.08384], [-120.98944, 39.08399], [-120.98911, 39.08425], [-120.98892, 39.08446], [-120.98866, 39.085], [-120.98849, 39.08569], [-120.98849, 39.08586], [-120.98866, 39.08616], [-120.98869, 39.08655], [-120.98862, 39.08703], [-120.98855, 39.0873], [-120.98845, 39.08793], [-120.98843, 39.08826], [-120.9885, 39.08873], [-120.9885, 39.08893], [-120.98842, 39.08946], [-120.98829, 39.08984], [-120.98807, 39.09034], [-120.98777, 39.09082], [-120.98758, 39.09124], [-120.98746, 39.0917], [-120.98744, 39.09194], [-120.98753, 39.09229], [-120.98763, 39.09261], [-120.98767, 39.09305], [-120.98764, 39.09386], [-120.98765, 39.09424], [-120.9877, 39.09478], [-120.98769, 39.09523], [-120.9875, 39.09581], [-120.98734, 39.09612], [-120.98718, 39.09657], [-120.98701, 39.09686], [-120.98693, 39.09713], [-120.98595, 39.09711], [-120.98599, 39.09674], [-120.98612, 39.09664], [-120.98632, 39.09614], [-120.98629, 39.09545], [-120.98596, 39.09498], [-120.98503, 39.0942], [-120.98558, 39.09368], [-120.98546, 39.09235], [-120.98657, 39.09107], [-120.98674, 39.09083], [-120.9867, 39.09033], [-120.98696, 39.08997], [-120.98691, 39.08986], [-120.9866, 39.08927], [-120.98671, 39.08913], [-120.98676, 39.08867], [-120.98713, 39.08755], [-120.98727, 39.08678], [-120.98727, 39.08652], [-120.98507, 39.08644], [-120.9851, 39.08641], [-120.98519, 39.0857], [-120.98792, 39.08572], [-120.98804, 39.0846], [-120.98534, 39.08446], [-120.98552, 39.08418], [-120.98554, 39.08391], [-120.98553, 39.08389], [-120.98595, 39.08391], [-120.98618, 39.08365], [-120.98626, 39.08324], [-120.98589, 39.08303], [-120.98525, 39.08302], [-120.98405, 39.08281], [-120.98364, 39.08242], [-120.98361, 39.08227], [-120.98482, 39.0823], [-120.98631, 39.08198], [-120.98669, 39.08217], [-120.98741, 39.0821], [-120.98798, 39.08208], [-120.98812, 39.08203], [-120.98858, 39.08163], [-120.9892, 39.08157], [-120.99035, 39.08116], [-120.99165, 39.08076], [-120.99174, 39.08067], [-120.99174, 39.08048], [-120.99121, 39.08021], [-120.99107, 39.0799], [-120.99046, 39.07976], [-120.99046, 39.07954], [-120.99108, 39.07911], [-120.99089, 39.07826], [-120.99068, 39.07809], [-120.99046, 39.07809], [-120.99002, 39.07837], [-120.98978, 39.07857], [-120.98899, 39.07846], [-120.98851, 39.078], [-120.98798, 39.07804], [-120.98799, 39.07753], [-120.98813, 39.0775], [-120.98861, 39.07731], [-120.98907, 39.07721], [-120.98929, 39.07706], [-120.98955, 39.07697], [-120.98991, 39.0767], [-120.99015, 39.07635], [-120.99047, 39.07543], [-120.99047, 39.07502], [-120.99045, 39.0749], [-120.99083, 39.07446], [-120.99109, 39.07398], [-120.99131, 39.0739], [-120.9926, 39.07315], [-120.99373, 39.07267], [-120.99362, 39.07229], [-120.99347, 39.07218], [-120.99296, 39.0721], [-120.99253, 39.07211], [-120.9922, 39.07202], [-120.99207, 39.07186], [-120.99213, 39.07158], [-120.99196, 39.07135], [-120.99185, 39.07089], [-120.99161, 39.07074], [-120.99178, 39.07028], [-120.99209, 39.07027], [-120.99237, 39.07012], [-120.99289, 39.07067], [-120.99332, 39.07063], [-120.99403, 39.07028], [-120.99413, 39.07005], [-120.99342, 39.06931], [-120.99361, 39.06918], [-120.99384, 39.06887], [-120.99374, 39.0683], [-120.99662, 39.06833], [-120.99663, 39.06835], [-120.99671, 39.06834]]]} Open Access 1 17849 Bear River Fishing Access 32044 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   Placer 35 202.774 Bear River FA 0 State Recreation Area 39 4

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