units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, COUNTY = 45 and DES_TP = 105

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • National Wildlife Refuge · 1 ✖

ACCESS_TYP 1

  • Restricted 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
15850 15850 15849 {"type": "MultiPolygon", "coordinates": [[[[-124.16059, 40.87217], [-124.15935, 40.87441], [-124.1591, 40.87482], [-124.15841, 40.8758], [-124.15802, 40.87677], [-124.15793, 40.87692], [-124.15746, 40.8779], [-124.15736, 40.87804], [-124.15705, 40.87896], [-124.15707, 40.87975], [-124.15684, 40.88046], [-124.15643, 40.88132], [-124.1557, 40.88248], [-124.15463, 40.884], [-124.15341, 40.88618], [-124.1531, 40.88736], [-124.15228, 40.88842], [-124.15171, 40.88947], [-124.15081, 40.89237], [-124.14956, 40.89484], [-124.14901, 40.89714], [-124.14853, 40.8981], [-124.14798, 40.89904], [-124.14745, 40.90015], [-124.14717, 40.90077], [-124.14702, 40.90141], [-124.13758, 40.90143], [-124.13747, 40.8996], [-124.13857, 40.90032], [-124.13875, 40.90031], [-124.13832, 40.89956], [-124.1387, 40.89925], [-124.13869, 40.89655], [-124.13937, 40.89642], [-124.13968, 40.896], [-124.14294, 40.89593], [-124.14282, 40.89253], [-124.14069, 40.89256], [-124.14045, 40.89212], [-124.14002, 40.8921], [-124.14009, 40.89181], [-124.14043, 40.8918], [-124.14046, 40.89145], [-124.14131, 40.89143], [-124.14123, 40.89108], [-124.14161, 40.89089], [-124.14199, 40.89065], [-124.14188, 40.88971], [-124.14163, 40.88901], [-124.14138, 40.88848], [-124.14151, 40.88777], [-124.1413, 40.88692], [-124.13952, 40.88691], [-124.13952, 40.88663], [-124.13772, 40.8859], [-124.13786, 40.88519], [-124.13851, 40.88394], [-124.1395, 40.88337], [-124.13944, 40.87877], [-124.14934, 40.87533], [-124.15014, 40.87485], [-124.15078, 40.87451], [-124.15139, 40.87417], [-124.15184, 40.87381], [-124.15229, 40.87315], [-124.15289, 40.87208], [-124.15909, 40.87208], [-124.16059, 40.87217]]], [[[-124.15266, 40.87208], [-124.15216, 40.87294], [-124.15169, 40.8737], [-124.15123, 40.87407], [-124.14996, 40.87485], [-124.14922, 40.87527], [-124.14826, 40.87558], [-124.13943, 40.87863], [-124.13941, 40.87686], [-124.14005, 40.877], [-124.14048, 40.87722], [-124.14068, 40.87736], [-124.14092, 40.87725], [-124.14114, 40.877], [-124.14119, 40.87664], [-124.1414, 40.87629], [-124.14178, 40.87609], [-124.14228, 40.87601], [-124.14287, 40.87601], [-124.14336, 40.87594], [-124.1437, 40.87576], [-124.14384, 40.87549], [-124.1438, 40.87521], [-124.14359, 40.87486], [-124.14354, 40.87454], [-124.14353, 40.87433], [-124.1436, 40.87415], [-124.14359, 40.87401], [-124.1438, 40.87379], [-124.14391, 40.87365], [-124.14399, 40.87357], [-124.1441, 40.8735], [-124.14483, 40.87324], [-124.14558, 40.87319], [-124.14582, 40.87316], [-124.14666, 40.87311], [-124.1468, 40.87307], [-124.14695, 40.87296], [-124.14743, 40.87284], [-124.14768, 40.87267], [-124.14772, 40.87256], [-124.14772, 40.87249], [-124.14739, 40.87235], [-124.14716, 40.87219], [-124.14709, 40.87211], [-124.15266, 40.87208]]], [[[-124.14222, 40.91262], [-124.1418, 40.91338], [-124.14125, 40.91495], [-124.14071, 40.91627], [-124.13945, 40.91626], [-124.13942, 40.91259], [-124.14222, 40.91262]]]]} Restricted Access 2 29383 Humboldt Bay National Wildlife Refuge 20143 106 United States Fish and Wildlife Service 45 Federal 1 Federal Agency 1 http://www.fws.gov/ US Fish and Wildlife Service 8 106 United States Fish and Wildlife Service 44 Federal 1 Federal Agency 1 https://www.fws.gov/refuge/humboldt_bay/ Humboldt 45 880.169 Humboldt Bay NWR 1971 National Wildlife Refuge 105 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]);