Entrance

This USGS web site provides a list of earthquakes that occurred the previous week:
http://earthquake.usgs.gov/eqcenter/catalogs/eqs7day-M1.txt

To import it: Copy and paste the link into the URL box in the Entrance Tools | Import data… dialog, set the type to CSV, check “Get the column names”, check “Guess the data types” and the table name to “earthquakes” and then click OK.

The map above plots recent earthquakes (as of July 18th), highlighting those with magnitude greater than magnitude 5.0. Use a script like this to make your own:

      PLOT EARTHCHART
        X, RED FILLED TINY CIRCLE, WHITE UNFILLED CIRCLE
      SELECT
        lon, lat, IF(magnitude > 5.0, lat, null)
        FROM earthquakes
        ;


If you downloaded Entrance recently, i.e. your version >= 1.4.25, you will be able to select quakes from the map, because we have added support for calculated columns (Bug #315). With the map displayed, drag out a selection box over some of the quakes and click “Select these…” to try out the new feature.
.

This entry was posted on Friday, October 30th, 2009 at 4:29 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.