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/default.asp?page_id=541"

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
187 187 186 {"type": "Polygon", "coordinates": [[[-122.06078, 36.95219], [-122.06068, 36.95436], [-122.06017, 36.95435], [-122.05967, 36.95438], [-122.0552, 36.95484], [-122.05516, 36.95484], [-122.05512, 36.9548], [-122.055, 36.9541], [-122.05493, 36.9538], [-122.05485, 36.95363], [-122.05466, 36.9533], [-122.05454, 36.95301], [-122.05449, 36.95276], [-122.05441, 36.95227], [-122.05607, 36.94958], [-122.05617, 36.94958], [-122.05616, 36.94934], [-122.05687, 36.94901], [-122.05684, 36.94913], [-122.057, 36.94924], [-122.05727, 36.9493], [-122.05739, 36.94928], [-122.05752, 36.94923], [-122.05761, 36.94915], [-122.05764, 36.94902], [-122.0577, 36.94899], [-122.05776, 36.94902], [-122.05784, 36.94913], [-122.05784, 36.94918], [-122.05783, 36.94922], [-122.05781, 36.94925], [-122.05772, 36.94929], [-122.05762, 36.94939], [-122.05746, 36.94944], [-122.05745, 36.94947], [-122.05749, 36.94951], [-122.05761, 36.94955], [-122.05785, 36.94957], [-122.05834, 36.94968], [-122.05902, 36.94974], [-122.05939, 36.94984], [-122.05907, 36.9502], [-122.05917, 36.9506], [-122.05968, 36.95146], [-122.0598, 36.95224], [-122.06078, 36.95219]]]} Open Access 1 Natural Bridges State Beach http://www.parks.ca.gov/default.asp?page_id=541 1655 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 62.319 Natural Bridges SB 1933

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