units_with_maps

Table actions

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

1 row where COUNTY = 40, MNG_AGENCY = 142 and MNG_AG_TYP = 1

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Federal Agency · 1 ✖

MNG_AGENCY 1

  • United States Army Corps of Engineers · 1 ✖

DES_TP 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
8001 8001 8000 {"type": "Polygon", "coordinates": [[[-122.51612, 38.78782], [-122.51607, 38.78848], [-122.51598, 38.78899], [-122.51594, 38.7894], [-122.5158, 38.78991], [-122.51562, 38.79035], [-122.51537, 38.7908], [-122.51516, 38.79114], [-122.51473, 38.79152], [-122.51393, 38.79201], [-122.51347, 38.79227], [-122.51293, 38.79235], [-122.51216, 38.79226], [-122.51186, 38.79219], [-122.51069, 38.79201], [-122.51012, 38.79196], [-122.51012, 38.79106], [-122.50107, 38.79096], [-122.49151, 38.7907], [-122.49123, 38.79432], [-122.48652, 38.7942], [-122.48671, 38.79057], [-122.48194, 38.79044], [-122.48188, 38.79214], [-122.48129, 38.79189], [-122.48107, 38.79177], [-122.48088, 38.79164], [-122.4807, 38.79145], [-122.48046, 38.79125], [-122.48022, 38.7911], [-122.48001, 38.79093], [-122.47977, 38.79071], [-122.47962, 38.79051], [-122.47943, 38.79033], [-122.47741, 38.79023], [-122.47748, 38.7866], [-122.48204, 38.78678], [-122.48216, 38.78314], [-122.49496, 38.77032], [-122.49673, 38.7718], [-122.50565, 38.77269], [-122.50628, 38.77324], [-122.51133, 38.77737], [-122.51504, 38.78693], [-122.51612, 38.78782]]]} Open Access 1 11115 Department of Defense 18095 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   Lake 40 1307.764 Department of Defense   None 668  

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