units_with_maps

Table actions

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

1 row where COUNTY = 25 and MNG_AG_TYP = 16

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Irrigation District · 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
16777 16777 16776 {"type": "MultiPolygon", "coordinates": [[[[-121.32835, 39.32083], [-121.32741, 39.32099], [-121.32743, 39.32082], [-121.32742, 39.32081], [-121.32611, 39.32104], [-121.32606, 39.32077], [-121.32632, 39.32044], [-121.32753, 39.32028], [-121.32834, 39.32058], [-121.32835, 39.32083]]], [[[-121.33188, 39.34191], [-121.33189, 39.34216], [-121.33188, 39.34277], [-121.33121, 39.34476], [-121.32791, 39.34345], [-121.32665, 39.344], [-121.32726, 39.34514], [-121.32708, 39.34564], [-121.32807, 39.34709], [-121.32842, 39.34764], [-121.32772, 39.34845], [-121.3264, 39.34849], [-121.32679, 39.35054], [-121.32645, 39.35135], [-121.32611, 39.35143], [-121.32406, 39.35094], [-121.32355, 39.35201], [-121.32411, 39.3543], [-121.32393, 39.35623], [-121.32202, 39.35605], [-121.32233, 39.35703], [-121.32218, 39.35806], [-121.3208, 39.35861], [-121.32109, 39.3604], [-121.32114, 39.36108], [-121.32034, 39.36122], [-121.32035, 39.362], [-121.31996, 39.36193], [-121.31991, 39.36118], [-121.31898, 39.36126], [-121.31866, 39.36182], [-121.31683, 39.36169], [-121.31191, 39.36163], [-121.31381, 39.36072], [-121.31438, 39.35769], [-121.3151, 39.35558], [-121.3156, 39.35493], [-121.31674, 39.35424], [-121.31864, 39.35203], [-121.31711, 39.35045], [-121.31381, 39.35083], [-121.3124, 39.35023], [-121.31157, 39.34868], [-121.30954, 39.34808], [-121.30783, 39.347], [-121.3062, 39.34438], [-121.30459, 39.34319], [-121.3042, 39.34249], [-121.30412, 39.34039], [-121.30516, 39.33994], [-121.30606, 39.33992], [-121.30807, 39.33935], [-121.30808, 39.33857], [-121.3048, 39.33534], [-121.30563, 39.33302], [-121.30741, 39.33138], [-121.30729, 39.33068], [-121.3033, 39.32901], [-121.30466, 39.32782], [-121.30453, 39.32059], [-121.3106, 39.32065], [-121.31527, 39.32072], [-121.31837, 39.32456], [-121.31915, 39.32509], [-121.3195, 39.32553], [-121.32, 39.32597], [-121.32241, 39.32959], [-121.32248, 39.32994], [-121.32225, 39.3305], [-121.32237, 39.33074], [-121.32276, 39.3312], [-121.32426, 39.33264], [-121.32426, 39.33439], [-121.32584, 39.33452], [-121.32707, 39.33532], [-121.32707, 39.33704], [-121.32858, 39.33861], [-121.32912, 39.34105], [-121.33188, 39.34191]]], [[[-121.31524, 39.36175], [-121.31682, 39.36179], [-121.3186, 39.36191], [-121.31775, 39.36316], [-121.32079, 39.36518], [-121.32123, 39.36596], [-121.32097, 39.36688], [-121.31987, 39.36715], [-121.31905, 39.36651], [-121.31795, 39.36582], [-121.31713, 39.36478], [-121.31529, 39.36402], [-121.31306, 39.36412], [-121.31005, 39.36485], [-121.3087, 39.36396], [-121.30512, 39.36372], [-121.30466, 39.36234], [-121.30758, 39.36172], [-121.31033, 39.36236], [-121.31075, 39.36219], [-121.31169, 39.36174], [-121.31524, 39.36175]]]]} Open Access 1 662 Collins Lake Recreation Area 720 2010 Browns Valley Irrigation District 1174 Special District 4 Irrigation District 17 http://www.bvid.org/ Special District 4 2010 Browns Valley Irrigation District 1114 Special District 4 Irrigation District 16 http://www.collinslake.com/map Yuba 25 1598.822 Collins Lake Rec. Area 0 Local Recreation Area 3 4

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