superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=22628"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • State Agency · 1 ✖

ACCESS_TYP 1

  • Open 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
67 67 66 {"type": "Polygon", "coordinates": [[[-121.51495, 38.59762], [-121.51338, 38.59761], [-121.51336, 38.59756], [-121.51327, 38.59756], [-121.51307, 38.59789], [-121.513, 38.59808], [-121.51301, 38.59821], [-121.51313, 38.59845], [-121.51366, 38.59911], [-121.51385, 38.59939], [-121.51418, 38.59934], [-121.51451, 38.59934], [-121.51455, 38.59944], [-121.51467, 38.59956], [-121.5147, 38.5997], [-121.51408, 38.59996], [-121.51356, 38.60048], [-121.51325, 38.60025], [-121.51317, 38.60031], [-121.51294, 38.60017], [-121.51239, 38.59978], [-121.51196, 38.59943], [-121.51181, 38.59953], [-121.5113, 38.59905], [-121.51034, 38.59789], [-121.51021, 38.5977], [-121.50934, 38.5946], [-121.50974, 38.59464], [-121.50975, 38.59462], [-121.50966, 38.59448], [-121.5093, 38.59445], [-121.50925, 38.59427], [-121.50981, 38.5943], [-121.50978, 38.59357], [-121.51193, 38.59338], [-121.51214, 38.59405], [-121.51228, 38.59474], [-121.51242, 38.59519], [-121.51248, 38.59533], [-121.51259, 38.5955], [-121.51262, 38.5955], [-121.51279, 38.59579], [-121.5128, 38.59579], [-121.51281, 38.59575], [-121.51329, 38.59552], [-121.51374, 38.59521], [-121.5138, 38.59521], [-121.51411, 38.59532], [-121.51458, 38.59545], [-121.51459, 38.59549], [-121.51455, 38.59588], [-121.51458, 38.59618], [-121.51466, 38.59649], [-121.51484, 38.59691], [-121.51491, 38.59713], [-121.51495, 38.59734], [-121.51495, 38.59762]]]} Open Access 1 California Indian Heritage Center http://www.parks.ca.gov/?page_id=22628 1456 204 California Department of Parks and Recreation 47 State 5 State Agency 5 http://www.parks.ca.gov/ California Department of Parks and Recreation 9 51.979 California Indian Heritage Ctr. 2011

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