units_with_maps

Table actions

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

1 row where AGNCY_TYP = 12, AGNCY_WEB = "http://www.rc-lc.org/" and DES_TP = 16

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Private Conservation · 1 ✖

ACCESS_TYP 1

Link rowid ▼ id map ACCESS_TYP UNIT_ID UNIT_NAME SUID_NMA AGNCY_ID AGNCY_NAME AGNCY_LEV AGNCY_TYP AGNCY_WEB LAYER MNG_AG_ID MNG_AGENCY MNG_AG_LEV MNG_AG_TYP PARK_URL COUNTY ACRES LABEL_NAME YR_EST DES_TP GAP_STS
9139 9139 9138 {"type": "Polygon", "coordinates": [[[-123.64935, 38.84992], [-123.64931, 38.84997], [-123.64904, 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.8509], [-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 48998 Hearn Gulch 33693 3303 Redwood Coast Land Conservancy 904 Non Profit 6 Non Profit - Conservation 12 http://www.rc-lc.org/ Non Governmental Organization 10 3303 Redwood Coast Land Conservancy 879 Non Profit 6 Non Profit - Conservation 12 https://www.rclc.org/hearn-gulch/ Mendocino 24 6.409 Hearn Gulch 2008 Private Conservation 16 2

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE units_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  UNIT_ID INT,
  UNIT_NAME TEXT,
  SUID_NMA INT,
  AGNCY_ID INT,
  AGNCY_NAME INT,
  AGNCY_LEV INT,
  AGNCY_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  PARK_URL TEXT,
  COUNTY INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
  DES_TP INT,
  GAP_STS TEXT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]),
   FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]),
   FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]),
   FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]),
   FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]),
   FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id])
);
CREATE INDEX [idx_units_with_maps_DES_TP]
    ON [units_with_maps] ([DES_TP]);
CREATE INDEX [idx_units_with_maps_COUNTY]
    ON [units_with_maps] ([COUNTY]);
CREATE INDEX [idx_units_with_maps_MNG_AG_TYP]
    ON [units_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_units_with_maps_MNG_AG_LEV]
    ON [units_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_units_with_maps_MNG_AGENCY]
    ON [units_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_units_with_maps_LAYER]
    ON [units_with_maps] ([LAYER]);
CREATE INDEX [idx_units_with_maps_AGNCY_TYP]
    ON [units_with_maps] ([AGNCY_TYP]);
CREATE INDEX [idx_units_with_maps_AGNCY_LEV]
    ON [units_with_maps] ([AGNCY_LEV]);
CREATE INDEX [idx_units_with_maps_AGNCY_NAME]
    ON [units_with_maps] ([AGNCY_NAME]);
CREATE INDEX [idx_units_with_maps_ACCESS_TYP]
    ON [units_with_maps] ([ACCESS_TYP]);