units_with_maps

Table actions

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

4 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 443

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

DES_TP 1

  • Local Recreation Area · 4 ✖

ACCESS_TYP 1

  • Open Access · 4 ✖
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
3526 3526 3525 {"type": "Polygon", "coordinates": [[[-118.11099, 33.9097], [-118.1104, 33.90972], [-118.10973, 33.90773], [-118.11031, 33.90763], [-118.11099, 33.9097]]]} Open Access 1 20596 H. Byrum Zinn Community Park and Trail 29571 6073 Southern California Edison 655 Private 7 Utility 21 https://www.sce.com Private 14 1024 Bellflower, City of 443 City 2 City Agency 2   Los Angeles 6 3.096 H. Byrum Zinn Community Park and Trail 0 Local Recreation Area 3 4
8956 8956 8955 {"type": "Polygon", "coordinates": [[[-118.12797, 33.90613], [-118.12547, 33.90613], [-118.12545, 33.90302], [-118.12551, 33.90298], [-118.12584, 33.90303], [-118.12612, 33.90308], [-118.12612, 33.90449], [-118.12796, 33.90449], [-118.12797, 33.90613]]]} Open Access 1 14742 T. Mayne Thompson Park and Bellflower Aquatic Center 29597 1024 Bellflower, City of 449 City 2 City Agency 2 https://www.bellflower.org/home/index.asp?page=132 City 2 1024 Bellflower, City of 443 City 2 City Agency 2   Los Angeles 6 12.878 T. Mayne Thompson Park and Bellflower Aquatic Ctr. 0 Local Recreation Area 3 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
15250 15250 15249 {"type": "Polygon", "coordinates": [[[-118.10916, 33.88013], [-118.10866, 33.88013], [-118.10864, 33.87975], [-118.10856, 33.87932], [-118.10854, 33.87735], [-118.10858, 33.87736], [-118.10899, 33.87907], [-118.10911, 33.8796], [-118.10916, 33.88013]]]} Open Access 1 46307 Bellflower Skate Park 29599 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 1024 Bellflower, City of 443 City 2 City Agency 2   Los Angeles 6 2.328 Bellflower Skate Park 0 Local Recreation Area 3 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]);