I suppose that this region has the advantage of the Pacific plate being subducted under the South American continent and pushing up the Andes mountain range. What are the 10 tallest volcanoes in the world? SELECT "Volcano Name", Country, "Elevation (m)" FROM GVPVolcano OR "Volcano Name" IS "Etna" Volcano Nameįuji wins! But Etna has been trying hard to catch up recently. Tectonic Setting = Tensional Oceanic Which is taller, Mt Fiji or Mt Etna? SELECT "Volcano Name", "Elevation (m)" FROM GVPVolcano There isn’t room to show all the columns as a table, but the data look like:ĭominant Rock Type = Andesite / Basaltic Andesite What can you tell me about Hekla? SELECT * FROM GVPVolcano SELECT "Volcano Name", Longitude, Latitude FROM GVPVolcano If you wanted to plot them on a map, you can get their latitude and longitude, too. WHERE "Country" IS "Iceland" Volcano Name Get a list of all the volcanoes in Iceland. There are 160 volcanoes whose name begins with ‘S’, but only one that begins with ‘X’ (Xianjindo in North Korea). This list is trimmed to give just the first example for each letter of the alphabet. That’s a big spreadsheet to manipulate by hand. The database contains information on 1555 volcanoes. Get an A-Z list of all the volcanoes in the world. If so, there are instructions for getting started at the end. The commands may look complicated at first, but hopefully you can see where the advantages in a real database lie. Querying the list can generate a wealth of interesting (and less-interesting) volcano facts. It lists locations and recent eruptions of over 1,500 active volcanoes. This example uses the Smithsonian Institute’s Global Volcanism Program catalogue of volcanoes, which can be downloaded as a csv file from their website, as the database. Once the data are imported, typically from a comma separated value ( csv) file, it simply provides an interface so that we can ask questions using Structured Query Language (SQL). It has none of the overly-complex wrappings of MS Access or LibreOffice Base and doesn’t need a server like MySQL or Oracle. These can also be read by other software e.g. Firefox) use to store your bookmarks and history. It uses an SQLite database, which is what many browsers (e.g. This post aims to show how using a real database makes this easier. They are convenient places to enter and store data, but not to get it out again. Even so, spreadsheets are commonly used as such.
0 Comments
Leave a Reply. |