superunits_with_maps

Table actions

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

2 rows where ACCESS_TYP = 3, MNG_AGENCY = 397 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 2 ✖

MNG_AGENCY 1

  • Redding, City of · 2 ✖

ACCESS_TYP 1

  • No Public 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
1086 1086 1085 {"type": "Polygon", "coordinates": [[[-122.36691, 40.54302], [-122.36592, 40.5431], [-122.36353, 40.54312], [-122.36021, 40.54062], [-122.35827, 40.53887], [-122.35869, 40.53865], [-122.35994, 40.53985], [-122.36268, 40.54141], [-122.36314, 40.54118], [-122.36361, 40.54142], [-122.36399, 40.54141], [-122.36435, 40.5415], [-122.36455, 40.54173], [-122.3645, 40.54212], [-122.36612, 40.54211], [-122.36613, 40.5421], [-122.366, 40.54166], [-122.36662, 40.54149], [-122.36663, 40.54153], [-122.36607, 40.54171], [-122.36613, 40.54189], [-122.36673, 40.54208], [-122.36691, 40.54302]]]} No Public Access 3 John F. Reginato River Access   32846 1268 Redding, City of 397 City 2 City Agency 2 http://reddingrecreation.org/ City 2 19.462 John F. Reginato River Access  
7313 7313 7312 {"type": "Polygon", "coordinates": [[[-122.36272, 40.53922], [-122.3624, 40.53935], [-122.36222, 40.53907], [-122.36209, 40.53893], [-122.36194, 40.53846], [-122.36158, 40.53834], [-122.36236, 40.53775], [-122.36265, 40.53834], [-122.36232, 40.53846], [-122.36264, 40.53909], [-122.36272, 40.53922]]]} No Public Access 3 Native American Burial Site   22661 1268 Redding, City of 397 City 2 City Agency 2 http://reddingrecreation.org/ City 2 1.762 Native American Burial Site  

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