units_with_maps

Table actions

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

1 row where DES_TP = 624, MNG_AG_LEV = 4 and MNG_AG_TYP = 9

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Flood District · 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
7508 7508 7507 {"type": "MultiPolygon", "coordinates": [[[[-118.02016, 34.0969], [-118.0198, 34.09688], [-118.01959, 34.0969], [-118.01911, 34.09701], [-118.0189, 34.09694], [-118.01761, 34.0972], [-118.01658, 34.09718], [-118.0164, 34.09722], [-118.01612, 34.09729], [-118.01466, 34.09789], [-118.01431, 34.09815], [-118.01381, 34.09841], [-118.01362, 34.0986], [-118.01357, 34.09879], [-118.0136, 34.09887], [-118.01377, 34.09908], [-118.01382, 34.09936], [-118.01376, 34.09954], [-118.01378, 34.09965], [-118.01385, 34.0997], [-118.01389, 34.09971], [-118.01387, 34.09979], [-118.01404, 34.09992], [-118.01418, 34.10009], [-118.0142, 34.10023], [-118.01441, 34.1004], [-118.01459, 34.10065], [-118.01469, 34.10074], [-118.0146, 34.10103], [-118.01451, 34.10145], [-118.01426, 34.10188], [-118.01405, 34.10192], [-118.01382, 34.10181], [-118.01359, 34.10176], [-118.01335, 34.10167], [-118.01317, 34.10165], [-118.01293, 34.10166], [-118.01281, 34.10171], [-118.01263, 34.10171], [-118.01249, 34.1015], [-118.01245, 34.1014], [-118.01232, 34.10131], [-118.01216, 34.10128], [-118.01201, 34.1012], [-118.01193, 34.10108], [-118.01189, 34.10083], [-118.01186, 34.10077], [-118.01175, 34.10074], [-118.01157, 34.10064], [-118.01107, 34.10048], [-118.01123, 34.10014], [-118.01033, 34.09983], [-118.01043, 34.09961], [-118.01123, 34.09967], [-118.01206, 34.09925], [-118.01293, 34.0984], [-118.01387, 34.098], [-118.01443, 34.09761], [-118.01638, 34.09673], [-118.01739, 34.09682], [-118.02013, 34.09652], [-118.02016, 34.0969]]], [[[-118.02033, 34.09914], [-118.02027, 34.09935], [-118.01857, 34.10015], [-118.01711, 34.10129], [-118.01597, 34.10246], [-118.0159, 34.10259], [-118.01579, 34.10286], [-118.01576, 34.10299], [-118.01574, 34.10324], [-118.01575, 34.10339], [-118.01577, 34.10348], [-118.01575, 34.10348], [-118.01572, 34.10338], [-118.01572, 34.10318], [-118.01575, 34.10295], [-118.01581, 34.10274], [-118.01593, 34.1025], [-118.01609, 34.10228], [-118.01709, 34.10125], [-118.01848, 34.10009], [-118.02033, 34.09914]]]]} Open Access 1 7037 Peck Road Water Conservation Park 23558 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   Los Angeles 6 27.496 Peck Road Water Conservation Park   None 624  

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