units_with_maps

Table actions

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

1 row where AGNCY_TYP = 17, DES_TP = 14 and MNG_AGENCY = 977

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Modesto Irrigation District · 1 ✖

DES_TP 1

  • Local Other or Unknown · 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
12247 12247 12246 {"type": "MultiPolygon", "coordinates": [[[[-120.45234, 37.66491], [-120.45126, 37.66492], [-120.4513, 37.66851], [-120.44674, 37.6685], [-120.44673, 37.66851], [-120.44674, 37.67122], [-120.45132, 37.67124], [-120.45137, 37.67588], [-120.44916, 37.67588], [-120.44916, 37.674], [-120.44573, 37.674], [-120.44575, 37.67587], [-120.44458, 37.67586], [-120.44457, 37.67654], [-120.44205, 37.67462], [-120.44382, 37.67412], [-120.44455, 37.67299], [-120.44461, 37.67256], [-120.44475, 37.67257], [-120.4449, 37.67256], [-120.44505, 37.67252], [-120.44514, 37.67246], [-120.44483, 37.67199], [-120.44468, 37.67196], [-120.44507, 37.6707], [-120.44499, 37.67024], [-120.44449, 37.66942], [-120.44291, 37.66834], [-120.44239, 37.66704], [-120.44248, 37.66673], [-120.44261, 37.66672], [-120.44265, 37.66654], [-120.4428, 37.6663], [-120.44314, 37.66621], [-120.4433, 37.66615], [-120.4436, 37.66606], [-120.4438, 37.66594], [-120.44446, 37.66575], [-120.4451, 37.6655], [-120.44525, 37.66542], [-120.4455, 37.66526], [-120.44561, 37.66517], [-120.44655, 37.66479], [-120.44745, 37.66461], [-120.44802, 37.66442], [-120.4486, 37.66415], [-120.4489, 37.66403], [-120.44896, 37.66403], [-120.44897, 37.66546], [-120.44841, 37.66516], [-120.446, 37.66557], [-120.4447, 37.6664], [-120.44362, 37.66685], [-120.4434, 37.66746], [-120.44475, 37.66857], [-120.44489, 37.6691], [-120.44555, 37.66955], [-120.44602, 37.67113], [-120.44528, 37.67163], [-120.44515, 37.67243], [-120.44517, 37.67244], [-120.4453, 37.67229], [-120.44557, 37.6718], [-120.4461, 37.67146], [-120.44637, 37.67123], [-120.44639, 37.67116], [-120.44594, 37.66953], [-120.44588, 37.66942], [-120.4452, 37.66891], [-120.44506, 37.66845], [-120.44381, 37.66745], [-120.44378, 37.66737], [-120.44391, 37.66706], [-120.44474, 37.66674], [-120.44475, 37.66672], [-120.44619, 37.66585], [-120.44834, 37.66548], [-120.44899, 37.66585], [-120.44902, 37.66671], [-120.44904, 37.66672], [-120.44902, 37.66585], [-120.44936, 37.66604], [-120.45033, 37.66568], [-120.45153, 37.66468], [-120.45209, 37.66468], [-120.45234, 37.66491]]], [[[-120.45863, 37.66709], [-120.45837, 37.66745], [-120.45807, 37.66728], [-120.45701, 37.66699], [-120.45657, 37.66648], [-120.45591, 37.66655], [-120.45586, 37.66493], [-120.45287, 37.66491], [-120.4523, 37.66438], [-120.45142, 37.66437], [-120.45017, 37.66539], [-120.44941, 37.66567], [-120.449, 37.66546], [-120.44899, 37.66389], [-120.45094, 37.66331], [-120.45214, 37.6633], [-120.45292, 37.66353], [-120.45469, 37.6645], [-120.45597, 37.66483], [-120.45707, 37.66528], [-120.45808, 37.66542], [-120.45807, 37.66685], [-120.45863, 37.66709]]], [[[-120.4581, 37.66852], [-120.45593, 37.66852], [-120.45592, 37.66685], [-120.45642, 37.6668], [-120.45679, 37.66726], [-120.45787, 37.66754], [-120.45809, 37.66767], [-120.4581, 37.66852]]], [[[-120.46353, 37.67073], [-120.46336, 37.67081], [-120.46178, 37.67083], [-120.46161, 37.67074], [-120.46152, 37.67035], [-120.46215, 37.67035], [-120.46214, 37.67076], [-120.46273, 37.67071], [-120.46274, 37.67073], [-120.46353, 37.67073]]], [[[-120.46732, 37.67226], [-120.46714, 37.6722], [-120.46709, 37.67244], [-120.4668, 37.67265], [-120.46662, 37.67282], [-120.46272, 37.67278], [-120.46272, 37.67151], [-120.46155, 37.67149], [-120.46156, 37.67114], [-120.46174, 37.67122], [-120.46355, 37.67119], [-120.46422, 37.67085], [-120.4647, 37.67087], [-120.46593, 37.67124], [-120.46653, 37.67153], [-120.46679, 37.67169], [-120.46732, 37.67226]]], [[[-120.47223, 37.67317], [-120.4708, 37.6731], [-120.47028, 37.6729], [-120.47027, 37.67258], [-120.47085, 37.67281], [-120.47222, 37.6729], [-120.47223, 37.67317]]], [[[-120.47225, 37.67253], [-120.47103, 37.67244], [-120.4703, 37.67214], [-120.47223, 37.67225], [-120.47225, 37.67253]]], [[[-120.48912, 37.6657], [-120.4889, 37.66599], [-120.48853, 37.66657], [-120.48791, 37.6663], [-120.48855, 37.6654], [-120.48912, 37.6657]]], [[[-120.48983, 37.66609], [-120.48929, 37.66695], [-120.48896, 37.66679], [-120.48931, 37.66621], [-120.48953, 37.66592], [-120.48983, 37.66609]]]]} Open Access 1 25750 Modesto Irrigation District 22339 2081 Modesto Irrigation District 1015 Special District 4 Irrigation District 17 http://www.mid.org/ Special District 4 2081 Modesto Irrigation District 977 Special District 4 Irrigation District 16   Stanislaus 2 199.046 Modesto Irrigation District 0 Local Other or Unknown 14 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]);