superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, LABEL_NAME = "Valley View Park" and MNG_AGENCY = 253

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 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
13996 13996 13995 {"type": "Polygon", "coordinates": [[[-122.10017, 37.70619], [-122.09896, 37.70702], [-122.09936, 37.70782], [-122.09996, 37.70839], [-122.09963, 37.70842], [-122.0991, 37.70793], [-122.09862, 37.70791], [-122.09776, 37.70819], [-122.09757, 37.70803], [-122.09663, 37.70834], [-122.09654, 37.70826], [-122.09747, 37.70794], [-122.09748, 37.7079], [-122.09732, 37.70767], [-122.09679, 37.70718], [-122.09576, 37.70752], [-122.09571, 37.70748], [-122.09673, 37.70713], [-122.09579, 37.70625], [-122.09476, 37.70659], [-122.09461, 37.70645], [-122.09578, 37.70606], [-122.09484, 37.70517], [-122.09579, 37.70486], [-122.09592, 37.70495], [-122.09601, 37.70489], [-122.09606, 37.70451], [-122.09619, 37.7045], [-122.0963, 37.70448], [-122.09642, 37.70443], [-122.09652, 37.70436], [-122.09684, 37.70466], [-122.09724, 37.70491], [-122.09756, 37.70522], [-122.09777, 37.7051], [-122.09866, 37.70591], [-122.09925, 37.70555], [-122.09962, 37.70589], [-122.09971, 37.70584], [-122.10017, 37.70619]]]} Open Access 1 Valley View Park http://www.haywardrec.org/605/Valley-View-Park---Former-EBMUD-Property 31456 2045 Hayward Area Recreation and Park District 253 Special District 4 Recreation/Parks District 4 http://www.haywardrec.org/ Special District 4 24.175 Valley View Park  

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