units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 80, MNG_AG_TYP = 1 and UNIT_NAME = "Lava Beds National Monument"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Federal Agency · 2 ✖
MNG_AGENCY 1
DES_TP 1
- National Monument or Landmark · 2 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15487 | 15487 | 15486 | {"type": "Polygon", "coordinates": [[[-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.81959], [-121.43761, 41.80509], [-121.43784, 41.79055], [-121.43798, 41.77602], [-121.44655, 41.77602], [-121.44949, 41.77604], [-121.45196, 41.77595], [-121.45718, 41.77594], [-121.45722, 41.83736]]]} | Open Access 1 | 10121 | Lava Beds National Monument | 14250 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/labe/index.htm | Modoc 56 | 2641.853 | Lava Beds NM | 1925 | National Monument or Landmark 80 | 3 |
15730 | 15730 | 15729 | {"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.82887], [-121.55095, 41.82937], [-121.5496, 41.82915], [-121.54923, 41.82844], [-121.5492, 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.54235, 41.81798], [-121.54205, 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.81919], [-121.52419, 41.82007], [-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.83078], [-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.82558], [-121.50332, 41.82563], [-121.50099, 41.82522], [-121.4992, 41.82829], [-121.4969, 41.82934], [-121.49793, 41.83142], [-121.49495, 41.83208], [-121.49492, 41.83409], [-121.47774, 41.83412], [-121.47657, 41.83333], [-121.47549, 41.83378], [-121.47492, 41.83413], [-121.47292, 41.83502], [-121.46271, 41.83784], [-121.45722, 41.837], [-121.45718, 41.77594], [-121.44944, 41.77596], [-121.44955, 41.74988], [-121.44964, 41.74987], [-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.54676, 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 | 10119 | Lava Beds National Monument | 14250 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/labe/index.htm | Siskiyou 28 | 43621.479 | Lava Beds NM | 1925 | National Monument or Landmark 80 | 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]);