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_AGENCY = 879 and MNG_AG_TYP = 12

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Conservation · 1 ✖

MNG_AGENCY 1

  • Redwood Coast Land Conservancy · 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
9213 9213 9212 {"type": "Polygon", "coordinates": [[[-123.64935, 38.84992], [-123.64931, 38.84997], [-123.64905, 38.85012], [-123.6491, 38.8502], [-123.64922, 38.8503], [-123.64935, 38.85043], [-123.64926, 38.85052], [-123.64925, 38.85081], [-123.64913, 38.85087], [-123.64879, 38.85091], [-123.6488, 38.85097], [-123.64889, 38.851], [-123.64926, 38.851], [-123.64932, 38.85103], [-123.64924, 38.85123], [-123.64905, 38.85129], [-123.64886, 38.85128], [-123.64865, 38.85135], [-123.64865, 38.8514], [-123.64859, 38.85151], [-123.64858, 38.8516], [-123.64874, 38.85164], [-123.64862, 38.8517], [-123.64861, 38.85178], [-123.6485, 38.85183], [-123.64834, 38.85186], [-123.64822, 38.85194], [-123.64778, 38.85177], [-123.6477, 38.85162], [-123.64757, 38.85111], [-123.64735, 38.85059], [-123.64703, 38.8501], [-123.64817, 38.84956], [-123.6482, 38.84968], [-123.64816, 38.84975], [-123.64816, 38.84981], [-123.64797, 38.84979], [-123.64779, 38.84979], [-123.64762, 38.85], [-123.64765, 38.85012], [-123.64778, 38.85034], [-123.64793, 38.85047], [-123.64806, 38.85051], [-123.64829, 38.85043], [-123.64844, 38.85027], [-123.64843, 38.85018], [-123.64865, 38.85004], [-123.64885, 38.84997], [-123.64907, 38.84994], [-123.64935, 38.84992]]]} Open Access 1 Hearn Gulch https://www.rclc.org/hearn-gulch/ 33693 3303 Redwood Coast Land Conservancy 879 Non Profit 6 Non Profit - Conservation 12 http://www.rc-lc.org/ Non Governmental Organization 10 6.419 Hearn Gulch 2008

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