units_with_maps

Table actions

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

1 row where COUNTY = 53, DES_TP = 280 and MNG_AG_TYP = 13

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Water District · 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
3393 3393 3392 {"type": "MultiPolygon", "coordinates": [[[[-120.88206, 38.22962], [-120.88189, 38.22982], [-120.88159, 38.23048], [-120.88159, 38.23065], [-120.88161, 38.23075], [-120.88169, 38.23091], [-120.88173, 38.23116], [-120.8817, 38.23131], [-120.88166, 38.23143], [-120.88152, 38.2317], [-120.88139, 38.23188], [-120.88135, 38.23191], [-120.88132, 38.23191], [-120.88121, 38.23184], [-120.88112, 38.23181], [-120.88099, 38.2318], [-120.88089, 38.23185], [-120.88088, 38.23187], [-120.88089, 38.23197], [-120.88095, 38.232], [-120.88106, 38.23199], [-120.88113, 38.23201], [-120.88115, 38.23205], [-120.88115, 38.23208], [-120.88108, 38.23215], [-120.88066, 38.23229], [-120.88046, 38.23239], [-120.88038, 38.2325], [-120.88038, 38.23276], [-120.88036, 38.23281], [-120.88032, 38.23287], [-120.88015, 38.23306], [-120.88013, 38.23322], [-120.88003, 38.23342], [-120.88007, 38.23367], [-120.88013, 38.23382], [-120.88032, 38.23409], [-120.88035, 38.23419], [-120.88033, 38.2345], [-120.88028, 38.2347], [-120.88019, 38.23483], [-120.87992, 38.23514], [-120.87985, 38.23528], [-120.87983, 38.23543], [-120.87972, 38.23557], [-120.87969, 38.23566], [-120.8797, 38.23574], [-120.87973, 38.2358], [-120.87982, 38.23588], [-120.87992, 38.23616], [-120.87995, 38.23634], [-120.88001, 38.23643], [-120.88003, 38.23667], [-120.88015, 38.23674], [-120.88024, 38.2369], [-120.88025, 38.23697], [-120.87983, 38.23695], [-120.87977, 38.23661], [-120.87962, 38.23641], [-120.87951, 38.23616], [-120.87941, 38.23589], [-120.87939, 38.2356], [-120.8795, 38.23533], [-120.87978, 38.23483], [-120.87985, 38.23449], [-120.87982, 38.23416], [-120.87983, 38.23386], [-120.87975, 38.23364], [-120.87958, 38.2334], [-120.87903, 38.23321], [-120.87825, 38.23309], [-120.87706, 38.23294], [-120.87671, 38.23265], [-120.87842, 38.23189], [-120.87843, 38.23187], [-120.87341, 38.22535], [-120.87204, 38.22503], [-120.87203, 38.22504], [-120.87195, 38.22581], [-120.87185, 38.22579], [-120.86743, 38.2259], [-120.86741, 38.2291], [-120.86743, 38.22969], [-120.86627, 38.22967], [-120.86558, 38.22968], [-120.8603, 38.2333], [-120.85937, 38.2333], [-120.86518, 38.22927], [-120.86511, 38.22496], [-120.86509, 38.22495], [-120.86027, 38.22871], [-120.85803, 38.23052], [-120.85065, 38.23681], [-120.84976, 38.2368], [-120.858, 38.22975], [-120.85967, 38.22835], [-120.86401, 38.22497], [-120.86521, 38.22393], [-120.8652, 38.22214], [-120.86748, 38.22214], [-120.87285, 38.22217], [-120.87216, 38.22368], [-120.87396, 38.22439], [-120.87577, 38.22762], [-120.87615, 38.22832], [-120.87628, 38.22852], [-120.8766, 38.22888], [-120.87679, 38.22907], [-120.87704, 38.2292], [-120.87729, 38.22928], [-120.8778, 38.22939], [-120.87823, 38.22945], [-120.88003, 38.22959], [-120.88206, 38.22962]]], [[[-120.85787, 38.23417], [-120.85785, 38.23462], [-120.85433, 38.23687], [-120.85366, 38.23686], [-120.85787, 38.23417]]], [[[-120.91315, 38.21032], [-120.91298, 38.21043], [-120.91128, 38.21116], [-120.90986, 38.21173], [-120.908, 38.21251], [-120.90585, 38.21345], [-120.90347, 38.21452], [-120.90325, 38.21464], [-120.90253, 38.21465], [-120.90408, 38.21398], [-120.90642, 38.21293], [-120.9077, 38.21238], [-120.9082, 38.21214], [-120.91193, 38.21058], [-120.91275, 38.21022], [-120.91315, 38.20991], [-120.91315, 38.21032]]], [[[-120.93525, 38.19678], [-120.93371, 38.19753], [-120.93183, 38.19851], [-120.93183, 38.19816], [-120.93487, 38.19669], [-120.93525, 38.19678]]], [[[-120.9649, 38.18209], [-120.96374, 38.18268], [-120.95624, 38.18595], [-120.94558, 38.19119], [-120.94558, 38.19252], [-120.94527, 38.19255], [-120.94301, 38.19248], [-120.93813, 38.19519], [-120.93656, 38.196], [-120.93552, 38.19663], [-120.93514, 38.19654], [-120.93624, 38.19583], [-120.93847, 38.19465], [-120.93948, 38.19405], [-120.94079, 38.19333], [-120.94193, 38.19268], [-120.94543, 38.19079], [-120.95544, 38.18586], [-120.96448, 38.18193], [-120.9649, 38.18209]]], [[[-120.97586, 38.17794], [-120.96785, 38.18071], [-120.9655, 38.18181], [-120.96533, 38.18196], [-120.96523, 38.18197], [-120.9648, 38.1818], [-120.96512, 38.18165], [-120.96673, 38.18082], [-120.96792, 38.18037], [-120.96917, 38.17985], [-120.97185, 38.17901], [-120.97553, 38.17762], [-120.97552, 38.17761], [-120.9746, 38.1776], [-120.97333, 38.17764], [-120.97544, 38.17692], [-120.97586, 38.17794]]]]} No Public Access 3 35086 EBMUD 18417 2031 East Bay Municipal Utility District 433 Special District 4 Water District 13 http://www.ebmud.com/ Special District 4 2031 East Bay Municipal Utility District 427 Special District 4 Water District 13   Calaveras 53 231.042 EBMUD   None 280  

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