units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, COUNTY = 37 and MNG_AG_TYP = 1
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9904 | 9904 | 9903 | {"type": "Polygon", "coordinates": [[[-120.98125, 37.06945], [-120.98076, 37.06939], [-120.98053, 37.06916], [-120.9804, 37.069], [-120.98041, 37.06827], [-120.9806, 37.06846], [-120.98083, 37.06901], [-120.98125, 37.06945]]]} | Open Access 1 | 16996 | 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 | Merced 37 | 0.907 | United States Bureau of Reclamation | 0 | Federal Other or Unknown 87 | 4 | |
9934 | 9934 | 9933 | {"type": "MultiPolygon", "coordinates": [[[[-120.91337, 36.99133], [-120.90983, 36.99135], [-120.90983, 36.99135], [-120.90983, 36.99124], [-120.91018, 36.99107], [-120.91061, 36.99088], [-120.91085, 36.99074], [-120.9129, 36.98907], [-120.91258, 36.98963], [-120.91273, 36.99023], [-120.91337, 36.99112], [-120.91337, 36.99133]]], [[[-120.9107, 36.99063], [-120.91051, 36.99074], [-120.91006, 36.99093], [-120.90984, 36.99104], [-120.90986, 36.99061], [-120.9107, 36.99063]]]]} | Open Access 1 | 17099 | Los Banos Reservoir | 21508 | 199 | Other Federal 284 | Federal 1 | Federal Agency 1 | Other Federal 13 | 199 | Other Federal 280 | Federal 1 | Federal Agency 1 | Merced 37 | 8.468 | Los Banos Reservoir | 0 | Resource Management Area 82 | 3 | ||
11251 | 11251 | 11250 | {"type": "MultiPolygon", "coordinates": [[[[-120.81619, 36.87248], [-120.81613, 36.87486], [-120.81608, 36.87965], [-120.81172, 36.87958], [-120.81232, 36.8833], [-120.80781, 36.88321], [-120.8072, 36.8795], [-120.80734, 36.87503], [-120.80738, 36.87225], [-120.8074, 36.86882], [-120.81191, 36.8689], [-120.81188, 36.8724], [-120.81619, 36.87248]]], [[[-120.86716, 36.80008], [-120.86715, 36.80731], [-120.85823, 36.8071], [-120.85819, 36.79988], [-120.86716, 36.80008]]], [[[-120.93752, 36.78778], [-120.93744, 36.79504], [-120.93387, 36.79478], [-120.93395, 36.78752], [-120.9307, 36.78692], [-120.93067, 36.78731], [-120.9306, 36.79419], [-120.92187, 36.79259], [-120.92184, 36.79484], [-120.92181, 36.79618], [-120.91575, 36.79507], [-120.91296, 36.79458], [-120.913, 36.79099], [-120.91302, 36.78376], [-120.91302, 36.77637], [-120.90375, 36.77718], [-120.90393, 36.75895], [-120.90846, 36.75854], [-120.90846, 36.76226], [-120.91298, 36.76186], [-120.92201, 36.76256], [-120.92202, 36.76642], [-120.93109, 36.76715], [-120.93109, 36.76328], [-120.93246, 36.76339], [-120.93406, 36.78016], [-120.93405, 36.78252], [-120.93397, 36.78735], [-120.93395, 36.7875], [-120.93752, 36.78778]]], [[[-120.92713, 36.75924], [-120.92173, 36.75881], [-120.91301, 36.75816], [-120.913, 36.75436], [-120.90847, 36.75477], [-120.90846, 36.75107], [-120.90561, 36.75133], [-120.90726, 36.74998], [-120.91299, 36.74539], [-120.91299, 36.74679], [-120.92647, 36.74619], [-120.92712, 36.7467], [-120.92713, 36.75924]]], [[[-120.96079, 36.78862], [-120.96008, 36.78864], [-120.95118, 36.78871], [-120.95116, 36.78918], [-120.95115, 36.79235], [-120.94664, 36.79204], [-120.94667, 36.78841], [-120.94216, 36.7881], [-120.94217, 36.78446], [-120.93758, 36.78413], [-120.93762, 36.78039], [-120.93762, 36.77461], [-120.93838, 36.7746], [-120.93838, 36.77223], [-120.95118, 36.77242], [-120.95977, 36.77252], [-120.95976, 36.77452], [-120.96078, 36.77452], [-120.96077, 36.78128], [-120.96079, 36.78862]]], [[[-120.94247, 36.81582], [-120.94247, 36.81582], [-120.93889, 36.81321], [-120.94243, 36.81328], [-120.94247, 36.81582]]], [[[-121.14563, 36.92035], [-121.14558, 36.92398], [-121.14415, 36.92394], [-121.1442, 36.92032], [-121.14563, 36.92035]]], [[[-121.14584, 36.90514], [-121.14576, 36.91255], [-121.14432, 36.91252], [-121.14438, 36.90874], [-121.1444, 36.90511], [-121.14584, 36.90514]]], [[[-121.14781, 36.85234], [-121.1461, 36.85231], [-121.14611, 36.84976], [-121.14626, 36.84999], [-121.14652, 36.85017], [-121.14672, 36.85036], [-121.14685, 36.85059], [-121.14715, 36.85148], [-121.14729, 36.85168], [-121.14746, 36.85199], [-121.14766, 36.85221], [-121.14781, 36.85234]]], [[[-121.17305, 36.90515], [-121.17296, 36.91251], [-121.16391, 36.91258], [-121.16384, 36.92004], [-121.15933, 36.92011], [-121.15939, 36.91257], [-121.15939, 36.90878], [-121.16391, 36.90878], [-121.16848, 36.90875], [-121.16849, 36.90518], [-121.17305, 36.90515]]]]} | Open Access 1 | 21632 | BLM | 16162 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | Merced 37 | 3993.055 | BLM | 1899 | National Public Lands 1 | 3 |
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]);