units_with_maps

Table actions

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

1 row where ACCESS_TYP = 3, LABEL_NAME = "Los Angeles County Flood Control District OS" and MNG_AGENCY = 284

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Los Angeles County Flood Control District · 1 ✖

ACCESS_TYP 1

  • No Public 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
16176 16176 16175 {"type": "Polygon", "coordinates": [[[-118.02569, 34.09575], [-118.02561, 34.09631], [-118.0254, 34.0964], [-118.02208, 34.09808], [-118.02179, 34.09823], [-118.0218, 34.09825], [-118.02158, 34.09831], [-118.02096, 34.09882], [-118.02033, 34.0991], [-118.01846, 34.10006], [-118.01705, 34.10123], [-118.01607, 34.10226], [-118.01593, 34.10244], [-118.01581, 34.10265], [-118.01572, 34.10293], [-118.01569, 34.1031], [-118.01568, 34.1033], [-118.01569, 34.10344], [-118.01573, 34.10351], [-118.01587, 34.10418], [-118.01498, 34.10449], [-118.01309, 34.10512], [-118.01166, 34.10633], [-118.00712, 34.10626], [-118.00748, 34.10553], [-118.00754, 34.10551], [-118.00771, 34.10517], [-118.009, 34.10473], [-118.01107, 34.10048], [-118.01157, 34.10064], [-118.01175, 34.10074], [-118.01186, 34.10077], [-118.01189, 34.10083], [-118.01193, 34.10108], [-118.01201, 34.1012], [-118.01216, 34.10128], [-118.01232, 34.10131], [-118.01245, 34.1014], [-118.01249, 34.1015], [-118.01263, 34.10171], [-118.01281, 34.10171], [-118.01293, 34.10166], [-118.01317, 34.10165], [-118.01335, 34.10167], [-118.01359, 34.10176], [-118.01382, 34.10181], [-118.01404, 34.10192], [-118.01426, 34.10188], [-118.01451, 34.10145], [-118.0146, 34.10103], [-118.01469, 34.10074], [-118.01459, 34.10065], [-118.01441, 34.1004], [-118.0142, 34.10023], [-118.01418, 34.10009], [-118.01404, 34.09992], [-118.01387, 34.09979], [-118.01388, 34.09971], [-118.01385, 34.0997], [-118.01378, 34.09965], [-118.01376, 34.09954], [-118.01382, 34.09936], [-118.01377, 34.09909], [-118.0136, 34.09887], [-118.01357, 34.09879], [-118.01362, 34.0986], [-118.01381, 34.09841], [-118.01431, 34.09815], [-118.01466, 34.09789], [-118.01612, 34.09729], [-118.01658, 34.09718], [-118.01761, 34.0972], [-118.01891, 34.09694], [-118.01911, 34.09701], [-118.01959, 34.0969], [-118.0198, 34.09688], [-118.02015, 34.09689], [-118.02013, 34.09658], [-118.02021, 34.09675], [-118.02082, 34.09668], [-118.02534, 34.09589], [-118.02569, 34.09575]]]} No Public Access 3 48171 Los Angeles County Flood Control District Open Space 32704 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 143.431 Los Angeles County Flood Control District OS 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]);