units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, COUNTY = 28 and DES_TP = 80

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, DES_TP

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open 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
15730 15730 15729 {"type": "Polygon", "coordinates": [[[-121.60522, 41.69165], [-121.60511, 41.70627], [-121.60479, 41.73534], [-121.60403, 41.76443], [-121.60396, 41.77595], [-121.58813, 41.77602], [-121.58456, 41.77601], [-121.56898, 41.77609], [-121.56908, 41.81943], [-121.56907, 41.8339], [-121.5529, 41.8342], [-121.55288, 41.82887], [-121.55095, 41.82937], [-121.5496, 41.82915], [-121.54923, 41.82844], [-121.5492, 41.82643], [-121.54712, 41.82637], [-121.54423, 41.82549], [-121.54289, 41.82596], [-121.5422, 41.8257], [-121.54188, 41.82493], [-121.54181, 41.82425], [-121.54119, 41.82378], [-121.54113, 41.8233], [-121.53976, 41.82232], [-121.54001, 41.82165], [-121.53975, 41.82073], [-121.54001, 41.81962], [-121.54235, 41.81798], [-121.54205, 41.8173], [-121.54106, 41.81697], [-121.53988, 41.81779], [-121.53708, 41.81694], [-121.53554, 41.81671], [-121.53375, 41.81571], [-121.5337, 41.8157], [-121.53233, 41.81357], [-121.53151, 41.81282], [-121.53108, 41.81266], [-121.53041, 41.81284], [-121.52976, 41.81347], [-121.52954, 41.81409], [-121.52923, 41.81514], [-121.52889, 41.81605], [-121.52815, 41.81705], [-121.52781, 41.81732], [-121.52698, 41.81787], [-121.52533, 41.81882], [-121.52484, 41.81919], [-121.52419, 41.82007], [-121.52363, 41.82112], [-121.52269, 41.82413], [-121.52149, 41.8262], [-121.52111, 41.8277], [-121.52114, 41.82834], [-121.52171, 41.82914], [-121.52149, 41.82971], [-121.5206, 41.83014], [-121.51984, 41.83044], [-121.51941, 41.83078], [-121.51928, 41.83124], [-121.5197, 41.83224], [-121.51914, 41.8341], [-121.51908, 41.83442], [-121.51436, 41.83442], [-121.51433, 41.82912], [-121.51169, 41.82761], [-121.50843, 41.82826], [-121.50666, 41.82558], [-121.50332, 41.82563], [-121.50099, 41.82522], [-121.4992, 41.82829], [-121.4969, 41.82934], [-121.49793, 41.83142], [-121.49495, 41.83208], [-121.49492, 41.83409], [-121.47774, 41.83412], [-121.47657, 41.83333], [-121.47549, 41.83378], [-121.47492, 41.83413], [-121.47292, 41.83502], [-121.46271, 41.83784], [-121.45722, 41.837], [-121.45718, 41.77594], [-121.44944, 41.77596], [-121.44955, 41.74988], [-121.44964, 41.74987], [-121.44964, 41.72052], [-121.44946, 41.69158], [-121.45951, 41.69157], [-121.48824, 41.69147], [-121.5074, 41.69151], [-121.52757, 41.69143], [-121.54613, 41.69144], [-121.54676, 41.69143], [-121.54681, 41.6896], [-121.55168, 41.68957], [-121.55165, 41.6914], [-121.55166, 41.69141], [-121.56643, 41.69136], [-121.58579, 41.69163], [-121.60522, 41.69165]]]} Open Access 1 10119 Lava Beds National Monument 14250 108 United States National Park Service 102 Federal 1 Federal Agency 1 http://www.nps.gov/ National Park Service 12 108 United States National Park Service 59 Federal 1 Federal Agency 1 http://www.nps.gov/labe/index.htm Siskiyou 28 43621.479 Lava Beds NM 1925 National Monument or Landmark 80 3

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