superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 1 and ACRES = "1.812"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 2 ✖
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
2323 2323 2322 {"type": "MultiPolygon", "coordinates": [[[[-122.42838, 37.77801], [-122.42815, 37.77804], [-122.42806, 37.77759], [-122.42829, 37.77756], [-122.42838, 37.77801]]], [[[-122.42857, 37.77894], [-122.42834, 37.77897], [-122.42819, 37.77823], [-122.42842, 37.7782], [-122.42857, 37.77894]]], [[[-122.42876, 37.77987], [-122.42853, 37.7799], [-122.42838, 37.77916], [-122.42861, 37.77913], [-122.42876, 37.77987]]], [[[-122.42895, 37.78081], [-122.42872, 37.78084], [-122.42857, 37.78009], [-122.4288, 37.78006], [-122.42895, 37.78081]]], [[[-122.42907, 37.78141], [-122.42884, 37.78144], [-122.42875, 37.78102], [-122.42899, 37.78099], [-122.42907, 37.78141]]]]} Open Access 1 Buchanan Street Mall   16470 1300 San Francisco, City and County of 21 City 2 City Agency 2 http://sfrecpark.org/ City 2 1.812 Buchanan Street Mall  
11585 11585 11584 {"type": "Polygon", "coordinates": [[[-121.87966, 37.30969], [-121.87878, 37.3098], [-121.87879, 37.30936], [-121.87874, 37.30887], [-121.87949, 37.30878], [-121.87966, 37.30969]]]} Open Access 1 Roberto Antonio Balermino Park   28091 1303 San Jose, City of 32 City 2 City Agency 2 http://www.sanjoseca.gov/index.aspx?NID=204 City 2 1.812 Roberto Antonio Balermino 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]);