units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, AGNCY_TYP = 13 and DES_TP = 280
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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
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]);