superunits_with_maps

Table actions

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

1 row where PARK_URL = "http://www.parks.ca.gov/?page_id=438"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

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
15224 15224 15223 {"type": "Polygon", "coordinates": [[[-123.48833, 39.0803], [-123.48372, 39.08029], [-123.48373, 39.08107], [-123.48368, 39.0826], [-123.48432, 39.08313], [-123.48458, 39.08343], [-123.48463, 39.08384], [-123.48436, 39.08444], [-123.48525, 39.08509], [-123.48456, 39.0858], [-123.48364, 39.08558], [-123.48367, 39.0826], [-123.48077, 39.08161], [-123.48076, 39.08131], [-123.47893, 39.08028], [-123.47439, 39.08025], [-123.47436, 39.07788], [-123.4725, 39.07663], [-123.47113, 39.07659], [-123.46798, 39.0766], [-123.46492, 39.07508], [-123.46151, 39.07281], [-123.4601, 39.07284], [-123.46008, 39.07238], [-123.46007, 39.07014], [-123.46023, 39.06539], [-123.45537, 39.06534], [-123.45544, 39.06341], [-123.45545, 39.06159], [-123.45553, 39.05798], [-123.45553, 39.05708], [-123.45559, 39.05445], [-123.46023, 39.05439], [-123.46022, 39.05711], [-123.46482, 39.05712], [-123.46487, 39.05796], [-123.4658, 39.05801], [-123.46596, 39.06175], [-123.46949, 39.06165], [-123.46951, 39.06546], [-123.46948, 39.06926], [-123.4742, 39.06927], [-123.4742, 39.06549], [-123.47884, 39.06549], [-123.47901, 39.07289], [-123.47915, 39.07652], [-123.48371, 39.07663], [-123.48825, 39.07668], [-123.48833, 39.0803]]]} Open Access 1 Hendy Woods State Park http://www.parks.ca.gov/?page_id=438 1562 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 827.769 Hendy Woods SP 1958

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