units_with_maps

Table actions

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

1 row where DES_TP = 16, MNG_AGENCY = 358, MNG_AG_TYP = 10 and UNIT_NAME = "Lynch Canyon"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Non Profit - Land Trust · 1 ✖

MNG_AGENCY 1

  • Solano Land Trust · 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
10088 10088 10087 {"type": "Polygon", "coordinates": [[[-122.21548, 38.18844], [-122.20971, 38.18989], [-122.2097, 38.1899], [-122.20972, 38.18993], [-122.20957, 38.18997], [-122.20942, 38.19007], [-122.20927, 38.19031], [-122.20939, 38.19045], [-122.20962, 38.19067], [-122.2102, 38.19107], [-122.21063, 38.19142], [-122.21102, 38.19176], [-122.21125, 38.19204], [-122.21086, 38.19191], [-122.21039, 38.1919], [-122.20803, 38.19229], [-122.2065, 38.19244], [-122.20517, 38.19253], [-122.20303, 38.195], [-122.20038, 38.19816], [-122.19827, 38.19743], [-122.18154, 38.19131], [-122.17397, 38.18864], [-122.17227, 38.18783], [-122.17294, 38.18746], [-122.17317, 38.18734], [-122.17373, 38.1871], [-122.17404, 38.187], [-122.17455, 38.18669], [-122.17517, 38.18645], [-122.17589, 38.18624], [-122.177, 38.18601], [-122.17825, 38.18569], [-122.17876, 38.18564], [-122.17926, 38.1855], [-122.18022, 38.1852], [-122.18082, 38.18493], [-122.18155, 38.18446], [-122.18212, 38.18393], [-122.18282, 38.18333], [-122.18367, 38.18248], [-122.1846, 38.18173], [-122.18525, 38.18092], [-122.18609, 38.1804], [-122.18671, 38.18021], [-122.18724, 38.17988], [-122.18769, 38.1795], [-122.18813, 38.17926], [-122.18895, 38.17876], [-122.1896, 38.17833], [-122.1904, 38.17862], [-122.19569, 38.18033], [-122.20124, 38.18226], [-122.20456, 38.18336], [-122.20852, 38.17882], [-122.20856, 38.17702], [-122.20843, 38.17334], [-122.20855, 38.17294], [-122.20885, 38.17308], [-122.20916, 38.17343], [-122.21013, 38.17418], [-122.21058, 38.17411], [-122.21097, 38.17455], [-122.211, 38.17485], [-122.21097, 38.175], [-122.21098, 38.17511], [-122.21097, 38.17545], [-122.21112, 38.17572], [-122.21146, 38.17591], [-122.21166, 38.17631], [-122.21193, 38.17662], [-122.21208, 38.17687], [-122.21289, 38.17725], [-122.21347, 38.17773], [-122.21373, 38.17806], [-122.2141, 38.17832], [-122.21444, 38.1787], [-122.21482, 38.17925], [-122.21499, 38.17946], [-122.21492, 38.17987], [-122.21465, 38.18028], [-122.21414, 38.18069], [-122.21366, 38.18093], [-122.21364, 38.18099], [-122.21359, 38.18105], [-122.21344, 38.18133], [-122.21336, 38.18173], [-122.21328, 38.18201], [-122.21335, 38.1826], [-122.21346, 38.18297], [-122.21354, 38.18331], [-122.21342, 38.18371], [-122.21326, 38.18399], [-122.21298, 38.18429], [-122.21282, 38.18454], [-122.21286, 38.18479], [-122.21325, 38.1851], [-122.21363, 38.18587], [-122.2139, 38.18631], [-122.21544, 38.18836], [-122.21548, 38.18844]]]} Restricted Access 2 17506 Lynch Canyon 29277 3081 Solano Land Trust 361 Non Profit 6 Non Profit - Land Trust 10 http://www.solanolandtrust.org/ Non Governmental Organization 10 3081 Solano Land Trust 358 Non Profit 6 Non Profit - Land Trust 10 http://www.solanolandtrust.org/LynchCanyon.aspx Solano 26 1152.887 Lynch Canyon 1994 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]);