superunits_with_maps

Table actions

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

1 row where ACCESS_TYP = 1 and LABEL_NAME = "Hellhole Canyon Preserve"

This data as json, copyable, CSV (advanced)

These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP

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
12252 12252 12251 {"type": "MultiPolygon", "coordinates": [[[[-116.91462, 33.22682], [-116.91453, 33.23359], [-116.91037, 33.23358], [-116.91038, 33.23708], [-116.90136, 33.23707], [-116.90139, 33.22701], [-116.90169, 33.22659], [-116.91067, 33.22678], [-116.91462, 33.22682]]], [[[-116.92783, 33.19759], [-116.92778, 33.20078], [-116.92782, 33.2009], [-116.92779, 33.20311], [-116.9278, 33.20838], [-116.91504, 33.20852], [-116.91746, 33.20521], [-116.92314, 33.19761], [-116.92783, 33.19759]]], [[[-116.96695, 33.2241], [-116.96284, 33.22409], [-116.96285, 33.22763], [-116.96266, 33.23129], [-116.95379, 33.23114], [-116.95353, 33.23835], [-116.95793, 33.23848], [-116.95778, 33.2421], [-116.94485, 33.24154], [-116.92792, 33.2417], [-116.91891, 33.24172], [-116.91909, 33.2343], [-116.91916, 33.23058], [-116.92233, 33.23056], [-116.92215, 33.23127], [-116.92182, 33.2315], [-116.92221, 33.23241], [-116.92339, 33.23242], [-116.92344, 33.23055], [-116.92777, 33.2305], [-116.92787, 33.22694], [-116.93242, 33.2271], [-116.93206, 33.22005], [-116.93192, 33.2162], [-116.93201, 33.2162], [-116.93202, 33.21615], [-116.93604, 33.21632], [-116.93838, 33.21647], [-116.94032, 33.21654], [-116.9408, 33.22037], [-116.94526, 33.22053], [-116.9496, 33.22055], [-116.94958, 33.22402], [-116.95835, 33.22405], [-116.95837, 33.22057], [-116.96282, 33.22058], [-116.96695, 33.22052], [-116.96695, 33.2241]], [[-116.9453, 33.22653], [-116.94303, 33.22648], [-116.943, 33.22741], [-116.94529, 33.22745], [-116.9453, 33.22653]]]]} Open Access 1 Hellhole Canyon Preserve http://www.sdparks.org/content/sdparks/en/park-pages/HellholeCanyon.html 29239 319 San Diego, County of 101 County 3 County Agency 3 http://www.sandiegocounty.gov/parks/ County 3 2451.865 Hellhole Canyon Preserve  

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