superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 2, MNG_AGENCY = 112 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

MNG_AGENCY 1

  • Seaside, City of · 2 ✖

ACCESS_TYP 1

  • Restricted 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
6397 6397 6396 {"type": "Polygon", "coordinates": [[[-121.82991, 36.63229], [-121.82593, 36.63574], [-121.82568, 36.63592], [-121.82546, 36.63603], [-121.82507, 36.63615], [-121.82474, 36.63618], [-121.81961, 36.63594], [-121.81935, 36.63593], [-121.81911, 36.63596], [-121.81872, 36.63606], [-121.81842, 36.6362], [-121.8183, 36.63628], [-121.81716, 36.63727], [-121.81692, 36.63709], [-121.81597, 36.63671], [-121.81592, 36.6366], [-121.81575, 36.63637], [-121.81533, 36.63587], [-121.81503, 36.63572], [-121.81455, 36.63544], [-121.81353, 36.63481], [-121.8128, 36.63419], [-121.81388, 36.63201], [-121.81361, 36.63084], [-121.81575, 36.62643], [-121.81895, 36.62681], [-121.82132, 36.62198], [-121.82148, 36.62204], [-121.82208, 36.62234], [-121.82269, 36.62251], [-121.82291, 36.6226], [-121.82351, 36.62312], [-121.82384, 36.6233], [-121.82411, 36.62337], [-121.82463, 36.62366], [-121.82508, 36.62391], [-121.82592, 36.62448], [-121.82574, 36.62606], [-121.82589, 36.62664], [-121.82609, 36.62719], [-121.82662, 36.62852], [-121.82696, 36.62899], [-121.82756, 36.62939], [-121.82804, 36.62959], [-121.82889, 36.62973], [-121.82916, 36.63084], [-121.82912, 36.6309], [-121.82991, 36.63229]]]} Restricted Access 2 Bayonet Black Horse Golf Course   33056 1330 Seaside, City of 112 City 2 City Agency 2 http://www.ci.seaside.ca.us/index.aspx?page=313 City 2 373.547 Bayonet Black Horse GC  
8335 8335 8334 {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} Restricted Access 2 South Monterey Dunes   25664 1330 Seaside, City of 112 City 2 City Agency 2 http://www.ci.seaside.ca.us/index.aspx?page=313 City 2 0.069 South Monterey Dunes  

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