units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, AGNCY_NAME = 369 and DES_TP = 515
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6356 | 6356 | 6355 | {"type": "Polygon", "coordinates": [[[-120.06436, 36.10851], [-120.06462, 36.10843], [-120.06472, 36.1081], [-120.06474, 36.10732], [-120.06459, 36.10624], [-120.06428, 36.1054], [-120.06369, 36.10452], [-120.06335, 36.10411], [-120.063, 36.10402], [-120.06158, 36.10285], [-120.06294, 36.10181], [-120.06367, 36.10233], [-120.06466, 36.10355], [-120.06547, 36.10478], [-120.06571, 36.10522], [-120.06631, 36.10758], [-120.06636, 36.10886], [-120.06624, 36.10917], [-120.06596, 36.10943], [-120.06593, 36.11201], [-120.06592, 36.11647], [-120.06594, 36.1184], [-120.06585, 36.12112], [-120.06563, 36.12228], [-120.0651, 36.12381], [-120.06458, 36.12488], [-120.06321, 36.12693], [-120.06263, 36.1277], [-120.06199, 36.12863], [-120.06084, 36.13019], [-120.05989, 36.13156], [-120.05912, 36.13284], [-120.05892, 36.13375], [-120.05887, 36.13603], [-120.05892, 36.13662], [-120.05907, 36.13692], [-120.05954, 36.13801], [-120.05943, 36.13826], [-120.05921, 36.13848], [-120.05879, 36.14024], [-120.05644, 36.1436], [-120.05485, 36.14574], [-120.05292, 36.14839], [-120.05151, 36.15028], [-120.05072, 36.15122], [-120.05045, 36.15212], [-120.05075, 36.15246], [-120.05147, 36.15253], [-120.05035, 36.15321], [-120.0502, 36.15351], [-120.05025, 36.15883], [-120.05021, 36.1629], [-120.05022, 36.16702], [-120.05008, 36.17477], [-120.0501, 36.17897], [-120.05013, 36.18062], [-120.05103, 36.18127], [-120.05105, 36.18162], [-120.05002, 36.18159], [-120.0484, 36.18167], [-120.04838, 36.18015], [-120.04846, 36.17576], [-120.04852, 36.16708], [-120.04862, 36.16683], [-120.04875, 36.1641], [-120.04886, 36.15717], [-120.04889, 36.15422], [-120.04888, 36.15293], [-120.04895, 36.15202], [-120.04918, 36.15121], [-120.04973, 36.15034], [-120.05174, 36.14754], [-120.05277, 36.14615], [-120.05514, 36.14305], [-120.05724, 36.14018], [-120.05761, 36.13949], [-120.05773, 36.13865], [-120.05742, 36.13805], [-120.05723, 36.13745], [-120.05725, 36.13538], [-120.05728, 36.13042], [-120.05881, 36.13046], [-120.05996, 36.12893], [-120.06172, 36.12649], [-120.06322, 36.12415], [-120.06351, 36.12334], [-120.06378, 36.12273], [-120.0641, 36.12137], [-120.06437, 36.11999], [-120.06441, 36.11734], [-120.06443, 36.10946], [-120.06437, 36.1091], [-120.06422, 36.10884], [-120.06436, 36.10851]]]} | Restricted Access 2 | 1709 | San Luis Canal | 24929 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | Fresno 9 | 327.822 | San Luis Canal | None 515 |
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]);