units_with_maps

Table actions

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

1 row where AGNCY_WEB = "http://www.eid.org/", DES_TP = 1047 and MNG_AGENCY = 965

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • El Dorado Irrigation 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
11894 11894 11893 {"type": "Polygon", "coordinates": [[[-120.12824, 38.64367], [-120.12745, 38.64502], [-120.12745, 38.64534], [-120.12754, 38.64544], [-120.12754, 38.64592], [-120.12698, 38.64679], [-120.12687, 38.64752], [-120.12602, 38.64905], [-120.12536, 38.64986], [-120.12533, 38.65022], [-120.12477, 38.65066], [-120.12428, 38.65143], [-120.12428, 38.65184], [-120.1244, 38.652], [-120.12469, 38.65274], [-120.12469, 38.65299], [-120.12431, 38.65329], [-120.12408, 38.65434], [-120.12408, 38.65528], [-120.12378, 38.65628], [-120.12355, 38.6566], [-120.12346, 38.65717], [-120.1232, 38.658], [-120.12283, 38.65868], [-120.12326, 38.65908], [-120.1232, 38.65942], [-120.12256, 38.65988], [-120.12233, 38.66033], [-120.12224, 38.66088], [-120.1223, 38.66154], [-120.12277, 38.662], [-120.12312, 38.66212], [-120.12376, 38.6622], [-120.12411, 38.66248], [-120.12513, 38.66278], [-120.12522, 38.66294], [-120.12467, 38.66328], [-120.12353, 38.66442], [-120.12347, 38.66461], [-120.12268, 38.66502], [-120.12184, 38.66626], [-120.12134, 38.66635], [-120.12123, 38.66683], [-120.12169, 38.6671], [-120.12166, 38.66751], [-120.12152, 38.66815], [-120.12073, 38.66866], [-120.11986, 38.6688], [-120.11983, 38.66866], [-120.12044, 38.66824], [-120.12046, 38.66806], [-120.12006, 38.668], [-120.11901, 38.66841], [-120.11857, 38.66877], [-120.11816, 38.66898], [-120.1179, 38.66898], [-120.11746, 38.66875], [-120.11685, 38.66854], [-120.11636, 38.66854], [-120.11617, 38.66864], [-120.11608, 38.66863], [-120.11572, 38.66887], [-120.11496, 38.66925], [-120.11473, 38.66954], [-120.11466, 38.66958], [-120.11437, 38.66997], [-120.11388, 38.67037], [-120.11329, 38.67047], [-120.11325, 38.67044], [-120.1131, 38.66996], [-120.11305, 38.66991], [-120.11335, 38.66935], [-120.11335, 38.66914], [-120.11262, 38.66884], [-120.11213, 38.66853], [-120.11183, 38.668], [-120.11168, 38.66783], [-120.1116, 38.66732], [-120.11127, 38.66715], [-120.11122, 38.66699], [-120.11045, 38.66634], [-120.11029, 38.66607], [-120.11018, 38.66606], [-120.11008, 38.66589], [-120.10967, 38.66576], [-120.10938, 38.66546], [-120.10909, 38.66489], [-120.10908, 38.66444], [-120.10921, 38.6641], [-120.11021, 38.66299], [-120.11085, 38.66285], [-120.11112, 38.66235], [-120.1115, 38.66192], [-120.11177, 38.66178], [-120.11174, 38.66147], [-120.11229, 38.66129], [-120.11209, 38.66013], [-120.11165, 38.65937], [-120.11162, 38.65915], [-120.11186, 38.6589], [-120.112, 38.65775], [-120.11226, 38.65736], [-120.11334, 38.65725], [-120.11372, 38.65745], [-120.11425, 38.65711], [-120.11471, 38.65697], [-120.11541, 38.65702], [-120.11591, 38.65674], [-120.11617, 38.6564], [-120.11635, 38.65462], [-120.11675, 38.65326], [-120.11678, 38.65221], [-120.11766, 38.65082], [-120.11824, 38.65036], [-120.11876, 38.64968], [-120.11961, 38.64919], [-120.12005, 38.64878], [-120.12034, 38.64833], [-120.12127, 38.64762], [-120.12171, 38.64679], [-120.12255, 38.64601], [-120.12319, 38.64583], [-120.1234, 38.64512], [-120.12366, 38.64473], [-120.12378, 38.64416], [-120.12372, 38.64251], [-120.12404, 38.64203], [-120.12433, 38.64205], [-120.12497, 38.64185], [-120.1257, 38.6418], [-120.12603, 38.64187], [-120.12716, 38.64223], [-120.12763, 38.64262], [-120.12809, 38.64322], [-120.12824, 38.64367]], [[-120.12168, 38.64997], [-120.12142, 38.6499], [-120.12023, 38.64997], [-120.11996, 38.6502], [-120.11958, 38.65141], [-120.11947, 38.65212], [-120.11944, 38.65342], [-120.11958, 38.65409], [-120.12005, 38.65514], [-120.12069, 38.6556], [-120.12104, 38.65569], [-120.12148, 38.6556], [-120.12189, 38.6551], [-120.12203, 38.65475], [-120.1223, 38.65436], [-120.1225, 38.65292], [-120.12291, 38.65148], [-120.1227, 38.65077], [-120.12215, 38.65022], [-120.12168, 38.64997]]]} Open Access 1 24343 Silver Lake 3403 2220 El Dorado Irrigation District 890 Special District 4 Irrigation District 17 http://www.eid.org/ Special District 4 2220 El Dorado Irrigation District 965 Special District 4 Irrigation District 16   Amador 52 514.385 Silver Lake   None 1047  

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