units_with_maps

Table actions

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

1 row where COUNTY = 41 and DES_TP = 986

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

DES_TP 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
11274 11274 11273 {"type": "MultiPolygon", "coordinates": [[[[-121.56274, 38.64215], [-121.55175, 38.64219], [-121.55177, 38.63957], [-121.56212, 38.63953], [-121.56243, 38.64112], [-121.56256, 38.64159], [-121.56274, 38.64215]]], [[[-121.56974, 38.6564], [-121.5697, 38.66347], [-121.5552, 38.66347], [-121.55514, 38.66338], [-121.55569, 38.66199], [-121.55597, 38.6616], [-121.55662, 38.66106], [-121.55701, 38.66063], [-121.55734, 38.66024], [-121.55755, 38.65989], [-121.55802, 38.65871], [-121.55839, 38.65818], [-121.55884, 38.65793], [-121.55993, 38.65762], [-121.56053, 38.65731], [-121.56097, 38.65689], [-121.56108, 38.65639], [-121.56974, 38.6564]]], [[[-121.56061, 38.631], [-121.55811, 38.631], [-121.55878, 38.63463], [-121.55707, 38.63464], [-121.55706, 38.63442], [-121.55574, 38.62732], [-121.55758, 38.62732], [-121.55858, 38.62737], [-121.56002, 38.62737], [-121.56004, 38.62778], [-121.5601, 38.62831], [-121.56061, 38.631]]], [[[-121.56747, 38.64782], [-121.56742, 38.65624], [-121.56279, 38.65624], [-121.56281, 38.65341], [-121.55849, 38.65339], [-121.5583, 38.65285], [-121.55758, 38.65156], [-121.55699, 38.65089], [-121.55642, 38.64912], [-121.56515, 38.6491], [-121.56711, 38.64756], [-121.56747, 38.64782]]]]} No Public Access 3 21780 Fisherman's Lake 18921 2092 Natomas Basin Conservancy 634 Special District 4 Flood District 8 http://www.natomasbasin.org/ Special District 4 2092 Natomas Basin Conservancy 623 Special District 4 Flood District 9   Sacramento 41 461.997 Fisherman's Lake   None 986  

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