superunits_with_maps

Table actions

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

2 rows where LAYER = 5, MNG_AGENCY = 166 and MNG_AG_TYP = 5

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 2 ✖

MNG_AGENCY 1

  • California Department of Veterans Affairs · 2 ✖

ACCESS_TYP 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
310 310 309 {"type": "Polygon", "coordinates": [[[-122.3521, 38.44442], [-122.34572, 38.4492], [-122.34564, 38.44615], [-122.3358, 38.44548], [-122.33141, 38.44558], [-122.33138, 38.4492], [-122.3184, 38.44966], [-122.29917, 38.448], [-122.29908, 38.44438], [-122.3182, 38.44584], [-122.31804, 38.44201], [-122.33143, 38.44193], [-122.33145, 38.43832], [-122.32239, 38.43823], [-122.32229, 38.43447], [-122.33607, 38.43482], [-122.34065, 38.43479], [-122.34065, 38.43521], [-122.34066, 38.43522], [-122.3429, 38.43515], [-122.34817, 38.43528], [-122.34848, 38.43602], [-122.34809, 38.44201], [-122.3521, 38.44442]]]} Open Access 1 Silverado Trail Rector Dam Watershed   1818 206 California Department of Veterans Affairs 166 State 5 State Agency 5 http://www.cdva.ca.gov/ Other State 5 959.891 Silverado Trail Rector Dam Watershed  
385 385 384 {"type": "Polygon", "coordinates": [[[-122.38699, 38.39466], [-122.37714, 38.39469], [-122.37938, 38.38742], [-122.3798, 38.38598], [-122.37717, 38.39444], [-122.37409, 38.39566], [-122.37334, 38.39398], [-122.37121, 38.39263], [-122.3693, 38.39221], [-122.36874, 38.39053], [-122.36846, 38.38913], [-122.36754, 38.38821], [-122.366, 38.38782], [-122.37008, 38.38595], [-122.37392, 38.39097], [-122.37515, 38.39047], [-122.37727, 38.38728], [-122.37763, 38.38706], [-122.37758, 38.38599], [-122.37775, 38.3841], [-122.37721, 38.38217], [-122.37717, 38.38217], [-122.37531, 38.38163], [-122.37518, 38.38087], [-122.37591, 38.37813], [-122.3817, 38.37932], [-122.38186, 38.37922], [-122.38154, 38.38026], [-122.38184, 38.38028], [-122.38222, 38.39105], [-122.38683, 38.39105], [-122.38699, 38.39466]]]} Open Access 1 Veterans Home Open Space   1819 206 California Department of Veterans Affairs 166 State 5 State Agency 5 http://www.cdva.ca.gov/ Other State 5 347.869 Veterans Home OS  

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