units_with_maps

Table actions

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

1 row where COUNTY = 48 and DES_TP = 82

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Resource Management 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
3129 3129 3128 {"type": "MultiPolygon", "coordinates": [[[[-120.20207, 37.13415], [-120.20207, 37.13449], [-120.20152, 37.13451], [-120.20131, 37.13451], [-120.20105, 37.13446], [-120.20079, 37.13437], [-120.19586, 37.13211], [-120.19264, 37.1301], [-120.19236, 37.12991], [-120.19219, 37.12982], [-120.19198, 37.12974], [-120.1916, 37.12964], [-120.19133, 37.12962], [-120.19109, 37.12962], [-120.18887, 37.12995], [-120.18886, 37.12996], [-120.18902, 37.13022], [-120.18406, 37.13106], [-120.18407, 37.12916], [-120.18436, 37.12914], [-120.18504, 37.12897], [-120.18623, 37.12879], [-120.18751, 37.12855], [-120.18812, 37.1284], [-120.1887, 37.12966], [-120.19099, 37.12929], [-120.19127, 37.12928], [-120.19151, 37.1293], [-120.19175, 37.12933], [-120.19202, 37.12939], [-120.19235, 37.12951], [-120.19259, 37.12963], [-120.19617, 37.13183], [-120.201, 37.13407], [-120.20111, 37.13414], [-120.20121, 37.13417], [-120.20134, 37.13418], [-120.20207, 37.13415]]], [[[-120.18786, 37.12782], [-120.18688, 37.1281], [-120.18514, 37.12848], [-120.18407, 37.12864], [-120.18407, 37.12724], [-120.18761, 37.12726], [-120.18786, 37.12782]]], [[[-120.19316, 37.12631], [-120.19316, 37.12665], [-120.1915, 37.12715], [-120.18701, 37.12712], [-120.18727, 37.12685], [-120.191, 37.1269], [-120.19192, 37.12674], [-120.19316, 37.12631]]]]} Open Access 1 25780 Berenda Reservoir 16018 100 United States Army Corps of Engineers 146 Federal 1 Federal Agency 1 http://www.usace.army.mil/ Other Federal 13 100 United States Army Corps of Engineers 142 Federal 1 Federal Agency 1   Madera 48 47.282 Berenda Reservoir 0 Resource Management Area 82 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]);