units_with_maps

Table actions

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

2 rows where COUNTY = 30, DES_TP = 39 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 2 ✖

DES_TP 1

  • State Recreation Area · 2 ✖

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
11239 11239 11238 {"type": "Polygon", "coordinates": [[[-120.22739, 39.32315], [-120.22725, 39.32342], [-120.22684, 39.32341], [-120.22659, 39.32344], [-120.22637, 39.32349], [-120.22597, 39.32363], [-120.22562, 39.32382], [-120.22154, 39.32332], [-120.2212, 39.32323], [-120.21896, 39.32296], [-120.21834, 39.323], [-120.21841, 39.32218], [-120.2203, 39.32236], [-120.22218, 39.3226], [-120.22366, 39.32287], [-120.22397, 39.32289], [-120.22465, 39.3229], [-120.22461, 39.32306], [-120.22416, 39.32346], [-120.22528, 39.3236], [-120.22543, 39.32361], [-120.22561, 39.32358], [-120.22616, 39.32339], [-120.22657, 39.32331], [-120.22655, 39.32317], [-120.22696, 39.32313], [-120.22739, 39.32315]]]} Open Access 1 21595 Donner Creek Public Access 32150 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   Nevada 30 12.262 Donner Creek PA 0 State Recreation Area 39 4
15644 15644 15643 {"type": "Polygon", "coordinates": [[[-121.00139, 39.06934], [-120.99874, 39.069], [-120.99789, 39.06951], [-120.99788, 39.06952], [-120.999, 39.07047], [-120.99886, 39.07205], [-120.99861, 39.07295], [-120.99796, 39.0731], [-120.99607, 39.0738], [-120.99433, 39.07435], [-120.99373, 39.0745], [-120.99325, 39.07469], [-120.99326, 39.07569], [-120.99322, 39.07675], [-120.99435, 39.07741], [-120.99498, 39.07788], [-120.9959, 39.07848], [-120.99739, 39.07957], [-120.99723, 39.0813], [-120.99661, 39.08206], [-120.9963, 39.08237], [-120.99442, 39.08236], [-120.99343, 39.08238], [-120.99246, 39.0823], [-120.99231, 39.08231], [-120.99208, 39.08257], [-120.99044, 39.0847], [-120.98935, 39.08652], [-120.98869, 39.08647], [-120.98866, 39.08616], [-120.98849, 39.08586], [-120.98849, 39.08569], [-120.98866, 39.085], [-120.98892, 39.08446], [-120.98911, 39.08425], [-120.98944, 39.08399], [-120.98968, 39.08384], [-120.98982, 39.08372], [-120.98994, 39.08355], [-120.99005, 39.08328], [-120.99017, 39.08312], [-120.99036, 39.08297], [-120.99067, 39.08261], [-120.99095, 39.08213], [-120.99121, 39.08201], [-120.99145, 39.08195], [-120.99166, 39.0819], [-120.99237, 39.0818], [-120.99265, 39.08184], [-120.99293, 39.08186], [-120.99307, 39.08184], [-120.9935, 39.08168], [-120.99402, 39.08142], [-120.99418, 39.08135], [-120.9943, 39.08132], [-120.9947, 39.08125], [-120.99486, 39.08124], [-120.99505, 39.08127], [-120.99534, 39.08126], [-120.99555, 39.0812], [-120.99574, 39.08112], [-120.996, 39.08085], [-120.99607, 39.08067], [-120.99606, 39.08027], [-120.996, 39.0801], [-120.9959, 39.07985], [-120.99562, 39.07937], [-120.9955, 39.07919], [-120.99528, 39.07891], [-120.99505, 39.0787], [-120.9947, 39.07832], [-120.99434, 39.07809], [-120.99402, 39.07796], [-120.99345, 39.07782], [-120.99319, 39.07772], [-120.993, 39.07768], [-120.99251, 39.07753], [-120.99184, 39.07724], [-120.99161, 39.07702], [-120.99151, 39.07673], [-120.99147, 39.07651], [-120.99149, 39.07621], [-120.99158, 39.07602], [-120.99189, 39.07557], [-120.9925, 39.07488], [-120.99267, 39.07476], [-120.993, 39.07459], [-120.99322, 39.0745], [-120.99385, 39.07434], [-120.99409, 39.07418], [-120.99484, 39.07381], [-120.99607, 39.07334], [-120.99649, 39.07321], [-120.99713, 39.07298], [-120.99738, 39.07283], [-120.99767, 39.07269], [-120.9981, 39.07243], [-120.99838, 39.07221], [-120.99849, 39.072], [-120.99854, 39.07182], [-120.99855, 39.07157], [-120.99824, 39.07081], [-120.99812, 39.07063], [-120.99784, 39.07034], [-120.99765, 39.07025], [-120.99734, 39.07012], [-120.9971, 39.07005], [-120.99687, 39.06992], [-120.99659, 39.06968], [-120.99646, 39.06946], [-120.99637, 39.06927], [-120.99635, 39.06914], [-120.99637, 39.06886], [-120.99644, 39.06871], [-120.99652, 39.06857], [-120.99666, 39.06839], [-120.99682, 39.06823], [-120.99699, 39.06815], [-121.00137, 39.0689], [-121.00139, 39.06934]]]} Open Access 1 25248 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   Nevada 30 67.17 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]);