units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 1305 and MNG_AGENCY = 24

✖
✖
✖
✖

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AG_TYP

MNG_AGENCY 1

  • Los Angeles, City of · 1 ✖

DES_TP 1

ACCESS_TYP 1

  • Open 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
15071 15071 15070 {"type": "MultiPolygon", "coordinates": [[[[-118.63255, 34.24222], [-118.62651, 34.24223], [-118.62364, 34.24155], [-118.62491, 34.24079], [-118.62536, 34.24058], [-118.62581, 34.24041], [-118.62616, 34.24031], [-118.62661, 34.24021], [-118.62851, 34.23987], [-118.62859, 34.24002], [-118.62823, 34.24014], [-118.62823, 34.24016], [-118.62911, 34.24082], [-118.6296, 34.24045], [-118.6303, 34.2401], [-118.62987, 34.23992], [-118.62968, 34.23989], [-118.62947, 34.2399], [-118.62939, 34.2397], [-118.62967, 34.23962], [-118.63003, 34.23949], [-118.63181, 34.23857], [-118.63244, 34.23857], [-118.63255, 34.24222]]], [[[-118.64773, 34.23509], [-118.64698, 34.23808], [-118.64533, 34.23797], [-118.6453, 34.23738], [-118.64525, 34.2372], [-118.64517, 34.23709], [-118.64506, 34.23701], [-118.64494, 34.23695], [-118.64477, 34.23691], [-118.64466, 34.23691], [-118.64275, 34.23709], [-118.64106, 34.23749], [-118.64076, 34.23753], [-118.63969, 34.23748], [-118.63942, 34.2375], [-118.6392, 34.23755], [-118.63613, 34.23734], [-118.63942, 34.23655], [-118.63983, 34.23643], [-118.64024, 34.23628], [-118.64062, 34.2361], [-118.64112, 34.2358], [-118.6422, 34.23503], [-118.64245, 34.23482], [-118.64272, 34.23456], [-118.64297, 34.23456], [-118.6431, 34.23455], [-118.64353, 34.23445], [-118.64377, 34.23443], [-118.64405, 34.23446], [-118.64425, 34.23446], [-118.64438, 34.23443], [-118.64451, 34.23438], [-118.64489, 34.23421], [-118.64508, 34.23408], [-118.64527, 34.23391], [-118.64596, 34.23309], [-118.64604, 34.23304], [-118.64613, 34.23301], [-118.64626, 34.23304], [-118.64632, 34.23308], [-118.64695, 34.23413], [-118.64705, 34.2343], [-118.64715, 34.23459], [-118.64718, 34.2348], [-118.64723, 34.23492], [-118.64733, 34.23502], [-118.64747, 34.23508], [-118.64764, 34.2351], [-118.64773, 34.23509]]], [[[-118.64513, 34.23795], [-118.64455, 34.23792], [-118.64101, 34.23767], [-118.64277, 34.23726], [-118.64475, 34.23708], [-118.64486, 34.2371], [-118.64496, 34.23715], [-118.64504, 34.23723], [-118.64508, 34.2373], [-118.6451, 34.23739], [-118.64513, 34.23795]]], [[[-118.64869, 34.23122], [-118.64777, 34.2349], [-118.64766, 34.23493], [-118.64756, 34.23493], [-118.64746, 34.23489], [-118.64741, 34.23485], [-118.64737, 34.23476], [-118.64736, 34.23459], [-118.64731, 34.23443], [-118.64704, 34.23391], [-118.64653, 34.23305], [-118.64641, 34.23292], [-118.64632, 34.23288], [-118.6462, 34.23285], [-118.64609, 34.23285], [-118.64598, 34.23288], [-118.64583, 34.23296], [-118.64511, 34.23381], [-118.64497, 34.23394], [-118.64469, 34.23412], [-118.6443, 34.23428], [-118.64411, 34.2343], [-118.64363, 34.23426], [-118.64302, 34.23439], [-118.64287, 34.2344], [-118.64317, 34.23401], [-118.64344, 34.23355], [-118.64356, 34.23328], [-118.64398, 34.23214], [-118.64416, 34.23177], [-118.64433, 34.23147], [-118.64456, 34.23111], [-118.64483, 34.23077], [-118.64578, 34.22973], [-118.64612, 34.2293], [-118.64629, 34.22905], [-118.64647, 34.22871], [-118.64661, 34.22836], [-118.6467, 34.22803], [-118.6467, 34.23122], [-118.64869, 34.23122]]]]} Open Access 1 45843 Chatsworth Reservoir Site 28863 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 147.742 Chatsworth Reservoir Site   None 1305  

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