units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 16 and SUID_NMA = 3403
This data as json, copyable, CSV (advanced)
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
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]);