units_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, AGNCY_WEB = "http://www.cityofpaloalto.org/", DES_TP = 2 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

DES_TP 1

  • Local Park · 1 ✖

ACCESS_TYP 1

  • Restricted 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
9733 9733 9732 {"type": "Polygon", "coordinates": [[[-122.20028, 37.35643], [-122.20024, 37.35647], [-122.19706, 37.35796], [-122.1956, 37.35913], [-122.19551, 37.35915], [-122.19283, 37.36128], [-122.19343, 37.364], [-122.19163, 37.36491], [-122.19121, 37.36486], [-122.18979, 37.36548], [-122.18785, 37.36605], [-122.18758, 37.36631], [-122.18746, 37.3668], [-122.18581, 37.36661], [-122.18362, 37.36568], [-122.1833, 37.36619], [-122.18307, 37.36647], [-122.18209, 37.36668], [-122.18172, 37.36693], [-122.18155, 37.3674], [-122.18133, 37.36761], [-122.18086, 37.36775], [-122.18039, 37.36775], [-122.17994, 37.36759], [-122.17931, 37.36763], [-122.17847, 37.36744], [-122.17787, 37.36834], [-122.17612, 37.3684], [-122.17396, 37.37054], [-122.17031, 37.37008], [-122.17135, 37.36699], [-122.17198, 37.36518], [-122.17335, 37.36092], [-122.17368, 37.36063], [-122.1744, 37.36062], [-122.17451, 37.36045], [-122.17473, 37.36023], [-122.17521, 37.35985], [-122.17572, 37.35871], [-122.17541, 37.35837], [-122.17478, 37.35829], [-122.1746, 37.35829], [-122.17433, 37.35832], [-122.17417, 37.35828], [-122.17865, 37.34535], [-122.18261, 37.33356], [-122.18261, 37.33335], [-122.18272, 37.333], [-122.18278, 37.33298], [-122.18293, 37.33313], [-122.18307, 37.33336], [-122.18316, 37.3336], [-122.18354, 37.33423], [-122.18396, 37.33471], [-122.18422, 37.33493], [-122.18425, 37.33503], [-122.18425, 37.33511], [-122.18433, 37.33527], [-122.18455, 37.33559], [-122.18472, 37.33589], [-122.18511, 37.33643], [-122.18569, 37.33745], [-122.18575, 37.33774], [-122.18573, 37.33808], [-122.18575, 37.33829], [-122.1858, 37.33847], [-122.18587, 37.33862], [-122.18598, 37.33872], [-122.18642, 37.33897], [-122.18674, 37.33917], [-122.18701, 37.33938], [-122.18755, 37.33983], [-122.18816, 37.34023], [-122.18896, 37.34079], [-122.18981, 37.34152], [-122.19022, 37.34193], [-122.19054, 37.34227], [-122.19063, 37.34234], [-122.19078, 37.34256], [-122.19104, 37.34304], [-122.19123, 37.34331], [-122.19132, 37.3434], [-122.19172, 37.34369], [-122.19225, 37.34397], [-122.19245, 37.34411], [-122.19334, 37.34485], [-122.19415, 37.34572], [-122.19477, 37.34656], [-122.19495, 37.34674], [-122.19507, 37.3469], [-122.19527, 37.34727], [-122.19537, 37.34737], [-122.19573, 37.34791], [-122.19587, 37.34819], [-122.19587, 37.34861], [-122.19583, 37.3488], [-122.19585, 37.34915], [-122.19597, 37.3496], [-122.19595, 37.34979], [-122.19585, 37.34997], [-122.19578, 37.35027], [-122.19576, 37.35063], [-122.19589, 37.35103], [-122.19597, 37.35123], [-122.19616, 37.35138], [-122.19628, 37.35152], [-122.19681, 37.35201], [-122.19698, 37.35212], [-122.19724, 37.35244], [-122.19734, 37.35259], [-122.19748, 37.35297], [-122.19769, 37.35325], [-122.19788, 37.35361], [-122.19802, 37.35406], [-122.19823, 37.35432], [-122.19849, 37.35445], [-122.19866, 37.35465], [-122.19887, 37.35483], [-122.1992, 37.35517], [-122.19939, 37.35529], [-122.19955, 37.35533], [-122.19972, 37.35545], [-122.19997, 37.35579], [-122.20002, 37.35596], [-122.20014, 37.35615], [-122.20028, 37.35643]]]} Restricted Access 2 16498 Foothills Park 18984 1243 Palo Alto, City of 161 City 2 City Agency 2 http://www.cityofpaloalto.org/ City 2 1243 Palo Alto, City of 157 City 2 City Agency 2   Santa Clara 19 1303.372 Foothills Park 2000 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]);