units_with_maps

Table actions

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

3 rows where AGNCY_TYP = 32 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, YR_EST

MNG_AG_TYP 1

  • City Agency · 3 ✖

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
15228 15228 15227 {"type": "Polygon", "coordinates": [[[-118.11833, 33.88205], [-118.11787, 33.88208], [-118.11777, 33.88205], [-118.11754, 33.88194], [-118.11747, 33.88184], [-118.11747, 33.88161], [-118.11833, 33.88205]]]} Open Access 1 46284 Bellflower Bike Trail Plaza 29576 2077 Los Angeles County Metropolitan Transportation Authority 1142 Special District 4 Transportation Agency 32 http://www.metro.net Special District 4 1024 Bellflower, City of 443 City 2 City Agency 2   Los Angeles 6 0.44 Bellflower Bike Trail Plaza 0 Local Park 2 4
15245 15245 15244 {"type": "MultiPolygon", "coordinates": [[[[-118.11714, 33.88168], [-118.11705, 33.88172], [-118.11518, 33.88074], [-118.11387, 33.87997], [-118.10923, 33.87712], [-118.10987, 33.87717], [-118.11517, 33.88042], [-118.11714, 33.88145], [-118.11714, 33.88168]]], [[[-118.12513, 33.88586], [-118.11962, 33.88303], [-118.11818, 33.88229], [-118.11864, 33.88221], [-118.12292, 33.8844], [-118.12415, 33.88503], [-118.1244, 33.88538], [-118.12513, 33.88572], [-118.12513, 33.88586]]], [[[-118.13228, 33.8892], [-118.13165, 33.8892], [-118.12539, 33.88599], [-118.12539, 33.88567], [-118.13228, 33.8892]]], [[[-118.13385, 33.89032], [-118.13216, 33.88946], [-118.13216, 33.88942], [-118.1327, 33.88942], [-118.13384, 33.89], [-118.13385, 33.89032]]], [[[-118.14254, 33.89477], [-118.13411, 33.89046], [-118.13411, 33.89013], [-118.14254, 33.89445], [-118.14254, 33.89477]]]]} Open Access 1 46283 Bellflower Bike Trail 29575 2077 Los Angeles County Metropolitan Transportation Authority 1142 Special District 4 Transportation Agency 32 http://www.metro.net Special District 4 1024 Bellflower, City of 443 City 2 City Agency 2   Los Angeles 6 24.976 Bellflower Bike Trail 0 Local Recreation Area 3 4
15319 15319 15318 {"type": "Polygon", "coordinates": [[[-117.99491, 34.13454], [-117.99491, 34.13492], [-117.99485, 34.13497], [-117.99432, 34.13496], [-117.99491, 34.13454]]]} Open Access 1 46482 Evergreen Plaza Park 29759 2394 Metro Gold Line Foothill Extension Construction Authority 1152 Special District 4 Transportation Agency 32 http://www.foothillgoldline.org/about-us/construction-authority/ Special District 4 1209 Monrovia, City of 309 City 2 City Agency 2   Los Angeles 6 0.318 Evergreen Plaza Park 2015 Local Park 2 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]);