superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 2, MNG_AGENCY = 532 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 1 ✖

MNG_AGENCY 1

  • Marysville, City of · 1 ✖

ACCESS_TYP 1

  • Restricted 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
6242 6242 6241 {"type": "Polygon", "coordinates": [[[-121.56958, 39.03559], [-121.56956, 39.03807], [-121.56484, 39.03808], [-121.56147, 39.03807], [-121.56144, 39.03703], [-121.55744, 39.03706], [-121.55825, 39.03559], [-121.55756, 39.03342], [-121.55676, 39.03345], [-121.55675, 39.03133], [-121.55864, 39.03128], [-121.56017, 39.03043], [-121.56157, 39.02994], [-121.56159, 39.03305], [-121.56013, 39.03307], [-121.56015, 39.03314], [-121.56158, 39.03314], [-121.56158, 39.03364], [-121.56149, 39.03366], [-121.56148, 39.03427], [-121.56921, 39.03426], [-121.56923, 39.0353], [-121.56958, 39.03559]]]} Restricted Access 2 Plumas Lake Golf Course   33071 1199 Marysville, City of 532 City 2 City Agency 2 http://www.marysville.ca.us/index.php/city-services/parks-facilities City 2 132.734 Plumas Lake GC  

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