superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2, MNG_AGENCY = 364 and MNG_AG_TYP = 1
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Federal Agency · 4 ✖
MNG_AGENCY 1
- United States Bureau of Reclamation · 4 ✖
ACCESS_TYP 1
- Restricted Access · 4 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8534 | 8534 | 8533 | {"type": "Polygon", "coordinates": [[[-122.53983, 39.5662], [-122.53971, 39.56976], [-122.53463, 39.56981], [-122.53495, 39.58098], [-122.53509, 39.59546], [-122.53045, 39.59543], [-122.51666, 39.59549], [-122.51672, 39.58828], [-122.52126, 39.58824], [-122.52126, 39.58045], [-122.52121, 39.56637], [-122.52062, 39.56637], [-122.52042, 39.56618], [-122.51933, 39.56425], [-122.52101, 39.5641], [-122.52106, 39.56278], [-122.5228, 39.56278], [-122.5228, 39.55915], [-122.52278, 39.55913], [-122.52183, 39.55918], [-122.52179, 39.55558], [-122.52107, 39.55552], [-122.52109, 39.55291], [-122.52032, 39.55176], [-122.51962, 39.55177], [-122.51972, 39.5448], [-122.51836, 39.54481], [-122.51829, 39.54119], [-122.51719, 39.54122], [-122.51697, 39.53751], [-122.51528, 39.53212], [-122.51623, 39.53209], [-122.51534, 39.52849], [-122.51594, 39.52849], [-122.51595, 39.52848], [-122.51442, 39.52192], [-122.51345, 39.52193], [-122.51318, 39.51042], [-122.51601, 39.51041], [-122.51621, 39.51074], [-122.51658, 39.51104], [-122.5167, 39.51163], [-122.51658, 39.51235], [-122.51758, 39.51227], [-122.51783, 39.51256], [-122.51802, 39.51305], [-122.51787, 39.51486], [-122.51812, 39.51534], [-122.51824, 39.51579], [-122.51812, 39.51598], [-122.51779, 39.51769], [-122.51765, 39.51862], [-122.51778, 39.51906], [-122.51847, 39.51908], [-122.51872, 39.51945], [-122.51896, 39.52014], [-122.51902, 39.52176], [-122.52143, 39.52347], [-122.52167, 39.52423], [-122.52261, 39.52555], [-122.52282, 39.52601], [-122.52317, 39.52607], [-122.52354, 39.52598], [-122.52346, 39.52534], [-122.52502, 39.52526], [-122.52447, 39.52569], [-122.52418, 39.52595], [-122.52364, 39.52674], [-122.52391, 39.52869], [-122.52358, 39.53014], [-122.52473, 39.53554], [-122.52965, 39.53549], [-122.53028, 39.53749], [-122.53006, 39.55173], [-122.53966, 39.55171], [-122.53984, 39.56586], [-122.53983, 39.5662]]]} | Restricted Access 2 | Stony Gorge Reservoir | 33687 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 2508.459 | Stony Gorge Reservoir | 1928 | |
9215 | 9215 | 9214 | {"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.13864], [-120.05742, 36.13805], [-120.05723, 36.13745], [-120.05725, 36.13538], [-120.05728, 36.13042], [-120.05882, 36.13046], [-120.05996, 36.12893], [-120.06172, 36.12649], [-120.06322, 36.12416], [-120.06351, 36.12334], [-120.06378, 36.12273], [-120.0641, 36.12137], [-120.06437, 36.11998], [-120.06441, 36.11734], [-120.06443, 36.10946], [-120.06437, 36.1091], [-120.06422, 36.10884], [-120.06436, 36.10851]]]} | Restricted Access 2 | San Luis Canal | 24929 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 327.847 | San Luis Canal | ||
10446 | 10446 | 10445 | {"type": "MultiPolygon", "coordinates": [[[[-120.31591, 36.61029], [-120.31586, 36.61748], [-120.30679, 36.61751], [-120.30685, 36.61383], [-120.30671, 36.6103], [-120.31591, 36.61029]]], [[[-120.3341, 36.59922], [-120.3341, 36.60278], [-120.33176, 36.60272], [-120.32724, 36.60271], [-120.32502, 36.60268], [-120.32502, 36.59918], [-120.32724, 36.59925], [-120.3295, 36.59918], [-120.33176, 36.59918], [-120.3341, 36.59922]]], [[[-120.36989, 36.6905], [-120.36959, 36.70536], [-120.36101, 36.70528], [-120.36105, 36.70454], [-120.3532, 36.69044], [-120.36989, 36.6905]]]]} | Restricted Access 2 | Tranquillity Land Retirement Demonstration Site | 26514 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 690.062 | Tranquillity Land Retirement Demonstration Site | ||
10505 | 10505 | 10504 | {"type": "MultiPolygon", "coordinates": [[[[-122.34626, 38.66214], [-122.34624, 38.66945], [-122.34626, 38.67298], [-122.34167, 38.67294], [-122.34166, 38.66942], [-122.33709, 38.66935], [-122.3371, 38.66574], [-122.33254, 38.66574], [-122.33258, 38.66221], [-122.34168, 38.66203], [-122.34626, 38.66214]]], [[[-122.35854, 38.67935], [-122.35842, 38.68289], [-122.35467, 38.68299], [-122.35478, 38.68008], [-122.3509, 38.68006], [-122.35088, 38.6765], [-122.3509, 38.67651], [-122.35493, 38.67653], [-122.35481, 38.67945], [-122.35854, 38.67935]]], [[[-122.39024, 38.70124], [-122.3763, 38.70106], [-122.37657, 38.68983], [-122.38125, 38.69003], [-122.38112, 38.69738], [-122.39016, 38.69755], [-122.39024, 38.70124]]]]} | Restricted Access 2 | United States Bureau of Reclamation | 26666 | 103 | United States Bureau of Reclamation 364 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 509.171 | United States Bureau of Reclamation |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);