superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 59 and YR_EST = 1925
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14634 | 14634 | 14633 | {"type": "Polygon", "coordinates": [[[-121.60522, 41.69165], [-121.60511, 41.70627], [-121.60479, 41.73534], [-121.60403, 41.76443], [-121.60396, 41.77595], [-121.58813, 41.77602], [-121.58456, 41.77601], [-121.56898, 41.77609], [-121.56908, 41.81943], [-121.56907, 41.8339], [-121.5529, 41.8342], [-121.55288, 41.82888], [-121.55095, 41.82937], [-121.5496, 41.82915], [-121.54923, 41.82844], [-121.54919, 41.82643], [-121.54712, 41.82637], [-121.54423, 41.82549], [-121.54289, 41.82596], [-121.5422, 41.8257], [-121.54188, 41.82493], [-121.54181, 41.82425], [-121.54119, 41.82378], [-121.54113, 41.8233], [-121.53976, 41.82232], [-121.54001, 41.82165], [-121.53975, 41.82073], [-121.54001, 41.81962], [-121.54234, 41.81799], [-121.54204, 41.8173], [-121.54106, 41.81697], [-121.53988, 41.81779], [-121.53708, 41.81694], [-121.53554, 41.81671], [-121.53375, 41.81571], [-121.5337, 41.8157], [-121.53233, 41.81357], [-121.53151, 41.81282], [-121.53108, 41.81266], [-121.53041, 41.81284], [-121.52976, 41.81347], [-121.52954, 41.81409], [-121.52923, 41.81514], [-121.52889, 41.81605], [-121.52815, 41.81705], [-121.52781, 41.81732], [-121.52698, 41.81787], [-121.52533, 41.81882], [-121.52484, 41.81918], [-121.52419, 41.82008], [-121.52363, 41.82112], [-121.52269, 41.82413], [-121.52149, 41.8262], [-121.52111, 41.8277], [-121.52114, 41.82834], [-121.52171, 41.82914], [-121.52149, 41.82971], [-121.5206, 41.83014], [-121.51984, 41.83044], [-121.51941, 41.83079], [-121.51928, 41.83124], [-121.5197, 41.83224], [-121.51914, 41.8341], [-121.51908, 41.83442], [-121.51436, 41.83442], [-121.51433, 41.82912], [-121.51169, 41.82761], [-121.50843, 41.82826], [-121.50666, 41.82559], [-121.50332, 41.82563], [-121.501, 41.82522], [-121.4992, 41.82829], [-121.4969, 41.82934], [-121.49793, 41.83142], [-121.49495, 41.83209], [-121.49492, 41.83409], [-121.47775, 41.83412], [-121.47657, 41.83333], [-121.4755, 41.83378], [-121.47492, 41.83413], [-121.47292, 41.83502], [-121.46271, 41.83784], [-121.45723, 41.837], [-121.45722, 41.83736], [-121.44849, 41.83465], [-121.4401, 41.83555], [-121.43784, 41.83475], [-121.43789, 41.8342], [-121.43758, 41.83366], [-121.43771, 41.81958], [-121.43761, 41.80509], [-121.43784, 41.79055], [-121.43798, 41.77602], [-121.44655, 41.77602], [-121.44949, 41.77603], [-121.45124, 41.77597], [-121.45123, 41.77596], [-121.44944, 41.77596], [-121.44955, 41.74988], [-121.44964, 41.74986], [-121.44964, 41.72052], [-121.44946, 41.69158], [-121.45951, 41.69157], [-121.48824, 41.69147], [-121.5074, 41.69151], [-121.52757, 41.69143], [-121.54613, 41.69144], [-121.54675, 41.69143], [-121.54681, 41.6896], [-121.55168, 41.68957], [-121.55165, 41.6914], [-121.55166, 41.69141], [-121.56643, 41.69136], [-121.58579, 41.69163], [-121.60522, 41.69165]]]} | Open Access 1 | Lava Beds National Monument | http://www.nps.gov/labe/index.htm | 14250 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 46263.645 | Lava Beds NM | 1925 |
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]);