superunits_with_maps

Table actions

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

2 rows where MNG_AGENCY = 32, MNG_AG_TYP = 2 and YR_EST = 1968

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

MNG_AGENCY 1

  • San Jose, City of · 2 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP PARK_NAME PARK_URL SUID_NMA MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP AGNCY_WEB LAYER ACRES LABEL_NAME YR_EST
857 857 856 {"type": "Polygon", "coordinates": [[[-121.96948, 37.42504], [-121.96911, 37.42631], [-121.96897, 37.42625], [-121.96621, 37.4255], [-121.96617, 37.42548], [-121.96616, 37.42544], [-121.96616, 37.42534], [-121.96673, 37.42526], [-121.9667, 37.42508], [-121.96711, 37.42501], [-121.96723, 37.42536], [-121.96863, 37.42514], [-121.96837, 37.42417], [-121.96898, 37.42432], [-121.96891, 37.42472], [-121.96948, 37.42504]]]} Open Access 1 Alviso Park   15432 1303 San Jose, City of 32 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 6.598 Alviso Park 1968
5936 5936 5935 {"type": "Polygon", "coordinates": [[[-121.99104, 37.31833], [-121.99006, 37.31807], [-121.98956, 37.31796], [-121.98887, 37.31783], [-121.98886, 37.31751], [-121.9889, 37.31748], [-121.98891, 37.31744], [-121.98887, 37.3173], [-121.98888, 37.31598], [-121.9893, 37.31588], [-121.9898, 37.31567], [-121.98986, 37.31569], [-121.9901, 37.31583], [-121.99032, 37.3159], [-121.99057, 37.31593], [-121.99093, 37.31593], [-121.99095, 37.31828], [-121.99104, 37.3183], [-121.99104, 37.31833]]]} Open Access 1 Mise   22290 1303 San Jose, City of 32 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 10.989 Mise 1968

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);