units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where DES_TP = 87 sorted by COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11425 | 11425 | 11424 | {"type": "MultiPolygon", "coordinates": [[[[-121.3675, 38.67299], [-121.36388, 38.67606], [-121.36391, 38.67519], [-121.36103, 38.6752], [-121.36093, 38.67293], [-121.3675, 38.67299]]], [[[-121.38686, 38.71035], [-121.38621, 38.71061], [-121.38139, 38.71218], [-121.3813, 38.71244], [-121.38071, 38.71244], [-121.38078, 38.71216], [-121.38077, 38.71215], [-121.37652, 38.71218], [-121.37402, 38.71051], [-121.37491, 38.70982], [-121.37505, 38.70977], [-121.37599, 38.70985], [-121.37658, 38.71005], [-121.37976, 38.71], [-121.38052, 38.71011], [-121.38227, 38.71018], [-121.38356, 38.71001], [-121.38466, 38.70975], [-121.38501, 38.70956], [-121.38548, 38.70963], [-121.38581, 38.70997], [-121.38634, 38.71026], [-121.38686, 38.71035]]]]} | No Public Access 3 | 22268 | Other Federal | 23247 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Sacramento 41 | 79.009 | Other Federal | 0 | Federal Other or Unknown 87 | 4 | ||
3126 | 3126 | 3125 | {"type": "Polygon", "coordinates": [[[-124.40959, 40.43808], [-124.40951, 40.43842], [-124.40911, 40.43904], [-124.40909, 40.4399], [-124.40922, 40.44018], [-124.40919, 40.4405], [-124.40914, 40.44056], [-124.40888, 40.44096], [-124.40861, 40.4432], [-124.40831, 40.44347], [-124.40777, 40.4445], [-124.40762, 40.4451], [-124.40694, 40.44581], [-124.40685, 40.44369], [-124.39606, 40.44363], [-124.39606, 40.44008], [-124.40082, 40.44002], [-124.40086, 40.43661], [-124.40676, 40.43647], [-124.40675, 40.43542], [-124.40714, 40.43567], [-124.40757, 40.43584], [-124.40771, 40.43598], [-124.40797, 40.43603], [-124.40813, 40.43615], [-124.40828, 40.43652], [-124.40906, 40.43711], [-124.40912, 40.43739], [-124.40959, 40.43808]]]} | Open Access 1 | 25764 | Other Federal | 23248 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Humboldt 45 | 181.407 | Other Federal | 0 | Federal Other or Unknown 87 | 4 | ||
4767 | 4767 | 4766 | {"type": "MultiPolygon", "coordinates": [[[[-124.07188, 40.02141], [-124.0717, 40.02154], [-124.07142, 40.02186], [-124.07138, 40.02194], [-124.07093, 40.02203], [-124.07077, 40.022], [-124.07039, 40.02228], [-124.07027, 40.02238], [-124.07015, 40.02271], [-124.0698, 40.02258], [-124.06982, 40.02124], [-124.07026, 40.02134], [-124.0705, 40.02146], [-124.0707, 40.02155], [-124.07077, 40.02147], [-124.07095, 40.02136], [-124.07113, 40.02143], [-124.07099, 40.02123], [-124.07099, 40.02112], [-124.07109, 40.02104], [-124.0712, 40.02104], [-124.0715, 40.02123], [-124.07164, 40.02124], [-124.07185, 40.02127], [-124.07188, 40.02141]]], [[[-124.07536, 40.02553], [-124.07492, 40.0256], [-124.07487, 40.02547], [-124.0753, 40.02539], [-124.07536, 40.02553]]], [[[-124.07571, 40.02705], [-124.07534, 40.02713], [-124.07525, 40.02686], [-124.07566, 40.02676], [-124.07571, 40.02689], [-124.07571, 40.02705]]], [[[-124.07823, 40.02907], [-124.07811, 40.02949], [-124.07799, 40.02951], [-124.07792, 40.02949], [-124.07753, 40.02925], [-124.07779, 40.02903], [-124.07788, 40.02915], [-124.07778, 40.02926], [-124.07778, 40.02928], [-124.07791, 40.02918], [-124.07802, 40.02918], [-124.07823, 40.02907]]], [[[-124.07922, 40.0299], [-124.07922, 40.03005], [-124.07911, 40.03018], [-124.079, 40.03028], [-124.07875, 40.03011], [-124.07908, 40.02984], [-124.07922, 40.0299]]], [[[-124.07933, 40.03016], [-124.07925, 40.03046], [-124.07904, 40.03031], [-124.07922, 40.03015], [-124.07933, 40.03016]]], [[[-124.1686, 40.57766], [-124.16517, 40.57763], [-124.16391, 40.57524], [-124.16225, 40.57413], [-124.162, 40.57379], [-124.16671, 40.57381], [-124.16859, 40.57486], [-124.1686, 40.57766]]], [[[-124.20702, 40.62484], [-124.20654, 40.62667], [-124.20601, 40.62727], [-124.20538, 40.62782], [-124.20538, 40.62856], [-124.20373, 40.62856], [-124.20373, 40.62912], [-124.20237, 40.62912], [-124.20235, 40.62812], [-124.20222, 40.62451], [-124.20505, 40.62454], [-124.20545, 40.62473], [-124.20547, 40.62483], [-124.20702, 40.62484]]], [[[-124.24507, 40.70111], [-124.23975, 40.70113], [-124.23978, 40.70493], [-124.24384, 40.70491], [-124.24362, 40.70559], [-124.24366, 40.70705], [-124.24345, 40.70806], [-124.2428, 40.70893], [-124.24271, 40.7093], [-124.24081, 40.71136], [-124.23989, 40.71261], [-124.23923, 40.71499], [-124.23912, 40.71609], [-124.2355, 40.71611], [-124.23546, 40.71493], [-124.23555, 40.71084], [-124.23554, 40.70677], [-124.23558, 40.70283], [-124.23689, 40.70132], [-124.23685, 40.70119], [-124.23558, 40.7026], [-124.23559, 40.69411], [-124.24021, 40.69417], [-124.24029, 40.69762], [-124.24506, 40.69761], [-124.24507, 40.70111]]]]} | Unknown Access 4 | 46914 | Unnamed site - Other Federal | 30495 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Humboldt 45 | 389.611 | 0 | Federal Other or Unknown 87 | 4 | |||
12251 | 12251 | 12250 | {"type": "MultiPolygon", "coordinates": [[[[-122.76298, 40.62351], [-122.76272, 40.62388], [-122.762, 40.62424], [-122.762, 40.62472], [-122.76255, 40.62503], [-122.76209, 40.62637], [-122.75949, 40.62647], [-122.75548, 40.62724], [-122.7534, 40.62716], [-122.75256, 40.62641], [-122.751, 40.62619], [-122.75028, 40.62543], [-122.74671, 40.62535], [-122.74817, 40.61568], [-122.75035, 40.616], [-122.75162, 40.61811], [-122.75527, 40.61778], [-122.75564, 40.62017], [-122.7579, 40.6217], [-122.76143, 40.62163], [-122.7627, 40.62273], [-122.76298, 40.62351]]], [[[-122.93219, 40.65409], [-122.93218, 40.65583], [-122.93091, 40.65583], [-122.93092, 40.65412], [-122.93101, 40.65408], [-122.93219, 40.65409]]], [[[-122.81513, 40.69488], [-122.81502, 40.69754], [-122.81285, 40.6988], [-122.81266, 40.69785], [-122.81242, 40.69682], [-122.80848, 40.69668], [-122.80674, 40.69646], [-122.80299, 40.69702], [-122.80332, 40.69801], [-122.80312, 40.69816], [-122.80286, 40.69832], [-122.80225, 40.69861], [-122.80195, 40.69879], [-122.80163, 40.69906], [-122.80134, 40.69941], [-122.80146, 40.69465], [-122.80657, 40.6947], [-122.81513, 40.69488]]], [[[-122.80436, 40.71206], [-122.80405, 40.71284], [-122.80131, 40.71211], [-122.80131, 40.71162], [-122.803, 40.71162], [-122.80392, 40.71192], [-122.80364, 40.71244], [-122.80409, 40.71259], [-122.8043, 40.71204], [-122.80436, 40.71206]]]]} | Open Access 1 | 25779 | United States Bureau of Reclamation | 13858 | 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 | Trinity 46 | 344.626 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 |
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]);