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 = 6 and MNG_AG_TYP = 9

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Flood District · 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
4692 4692 4691 {"type": "Polygon", "coordinates": [[[-118.35865, 34.26614], [-118.35827, 34.26807], [-118.35695, 34.26791], [-118.35657, 34.2683], [-118.35593, 34.26829], [-118.35637, 34.26785], [-118.35636, 34.26783], [-118.35538, 34.26771], [-118.35584, 34.26829], [-118.35539, 34.26829], [-118.35538, 34.2683], [-118.3577, 34.27107], [-118.35758, 34.2717], [-118.35674, 34.27179], [-118.3562, 34.272], [-118.35591, 34.27203], [-118.35491, 34.27184], [-118.35328, 34.27158], [-118.35331, 34.27145], [-118.35321, 34.27142], [-118.35327, 34.27106], [-118.35311, 34.27121], [-118.35307, 34.27142], [-118.35297, 34.27141], [-118.35294, 34.27154], [-118.35225, 34.27148], [-118.3521, 34.27136], [-118.35132, 34.27105], [-118.35025, 34.27136], [-118.35001, 34.27136], [-118.34913, 34.27125], [-118.34883, 34.27106], [-118.34638, 34.27079], [-118.3461, 34.27079], [-118.34579, 34.27083], [-118.34487, 34.27088], [-118.34383, 34.27067], [-118.34275, 34.27038], [-118.34297, 34.2702], [-118.34461, 34.26985], [-118.34448, 34.26941], [-118.34405, 34.26957], [-118.34268, 34.26987], [-118.34194, 34.26956], [-118.34228, 34.26782], [-118.33932, 34.26743], [-118.33933, 34.26732], [-118.33824, 34.26717], [-118.33809, 34.26706], [-118.33774, 34.26708], [-118.33774, 34.2671], [-118.33771, 34.26708], [-118.33752, 34.26709], [-118.33678, 34.26627], [-118.33684, 34.26622], [-118.33636, 34.26564], [-118.33801, 34.26554], [-118.33802, 34.26556], [-118.33921, 34.26572], [-118.3404, 34.26577], [-118.34054, 34.26507], [-118.34096, 34.26513], [-118.34096, 34.26515], [-118.34167, 34.26525], [-118.34171, 34.26509], [-118.34256, 34.26511], [-118.34257, 34.26507], [-118.34282, 34.26507], [-118.34299, 34.26424], [-118.34363, 34.26427], [-118.34414, 34.26432], [-118.34481, 34.26442], [-118.34531, 34.26452], [-118.34609, 34.26472], [-118.3483, 34.26542], [-118.34897, 34.26558], [-118.34944, 34.26565], [-118.35413, 34.26605], [-118.35603, 34.26619], [-118.35857, 34.26622], [-118.35865, 34.26614]]]} Restricted Access 2 45521 Unnamed - Los Angeles County Flood Control District 30959 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9 http://dpw.lacounty.gov/wrd/Projects/BTWMA/index.cfm Los Angeles 6 242.496   0 Local Other or Unknown 14 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]);