Share this
Explore your local earthquakes using this Tableau data visualisation
by Richard Leeke on 05 January 2011
I was at the Tableau data visualisation conference in Seattle when the Christchurch quake struck NZ in September, so I couldn't resist getting hold of some earthquake data from GNS and seeing what it looked like.
Ever since I got home I've been meaning to write this up for the blog, but I got busy as soon as I got back and never got around to it. But inspired by the boxing day aftershocks, plus some visual presentation ideas I got from this posting on Robert Mundigl's Clearly and Simply site, I finally got around to finishing it off.
The data visualisation below uses Tableau's free "Public" service, which allows interactive visualisations of publically available data to be hosted on Tableau's public servers. Anyone can create these visualisations, using the free version of the Tableau visualisation tool, available here.
The GNS site has details of around half a million New Zealand earthquakes, which is more than is allowed on Tableau Public, so I filtered down to the last 40 years and only included magnitude 3 and above, which just sneaks in under the 100,000 limit.
I have included several tabs in the visualisation. The main one allows you to explore the earthquakes in the vicinity of a given location, identified by a postcode. I've also included a couple of other tabs showing summary views of the maximum magnitude and maximum depth of quakes experienced over different parts of the country.
Enter a valid NZ postcode and a radius in km to display earthquakes near that location. You can also filter the display by date range, magnitude and depth.
As a starter, here are a few interesting postcodes:
Darfield: 7541
Edgecumbe: 3160
Wairoto (Fiordland): 9691
See the instructions tab for more details of how to navigate the page and also for suggestions of things to look at around these and a couple of other locations.
The "Magnitude" tab shows the maximum magnitude quakes experienced in different parts of the country, by dividing the country up into a grid. Adjust the resolution of the grid to see more or less detail.
This view also lets you explore different ways of visualising magnitude. The Richter scale (or more properly the Moment Magnitude scale, which is what is used these days) is a logarithmic scale, so comparing earthquakes visually with something proportional to the magnitude does not really convey relative size of quakes very effectively.
In this view, the magnitude is represented by both the colour and the size of the marks. But representing magnitude by size on a map like this can be misleading. Should the area of the mark be determined by the magnitude (which makes little distinction between a magnitude 3 which is not even felt and a magnitude 7 causing major destruction)? Or should it be a metric which conveys the power of the quake more realistically, such as amplitude or energy released?
Either way, the impression given is that the quake in some way "covered" the area of the mark, whereas in reality the area over which it was felt and the extent of the damage caused is quite different and depends on numerous other factors. Compare the impression of the relative sizes of quakes given by setting the mark size to magnitude, amplitude and energy. Which is the most appropriate?
The "Depth" tab shows the maximum depths of quakes experienced over different parts of the country, with the deepest one around Taranaki and up north.
Enjoy!
Acknowledgents
NZ earthquake data comes from GeoNet and is freely available thanks to the GeoNet project, sponsored by EQC, GNS Science and LINZ.
NZ postcode data comes from the GeoNames database, which has over 8 million international placenames available for free download.
The approach to finding earthquakes in the vicinity of a given location is based on Robert Mundigl's post refered to above.
The maths for dividing the earth's surface up into a uniform grid using latitude and longitude (which I used in the magnitude and depth tabs) comes from Robert Morton of Tableau.
See the "About this viz" tab for more details of each of these sources.
Share this
- Agile Development (153)
- Software Development (126)
- Agile (76)
- Scrum (66)
- Application Lifecycle Management (50)
- Capability Development (47)
- Business Analysis (46)
- DevOps (43)
- IT Professional (42)
- Equinox IT News (41)
- Agile Transformation (38)
- IT Consulting (38)
- Knowledge Sharing (36)
- Lean Software Development (35)
- Requirements (35)
- Strategic Planning (35)
- Solution Architecture (34)
- Digital Disruption (32)
- IT Project (31)
- International Leaders (31)
- Digital Transformation (26)
- Project Management (26)
- Cloud (25)
- Azure DevOps (23)
- Coaching (23)
- IT Governance (23)
- System Performance (23)
- Change Management (20)
- Innovation (20)
- MIT Sloan CISR (15)
- Client Briefing Events (13)
- Architecture (12)
- Working from Home (12)
- IT Services (10)
- Data Visualisation (9)
- Kanban (9)
- People (9)
- Business Architecture (8)
- Communities of Practice (8)
- Continuous Integration (7)
- Business Case (4)
- Enterprise Analysis (4)
- Angular UIs (3)
- Business Rules (3)
- GitHub (3)
- Java Development (3)
- Lean Startup (3)
- Satir Change Model (3)
- API (2)
- Automation (2)
- Scaling (2)
- Security (2)
- Toggles (2)
- .Net Core (1)
- AI (1)
- Diversity (1)
- Testing (1)
- ✨ (1)
- August 2024 (1)
- February 2024 (3)
- January 2024 (1)
- September 2023 (2)
- July 2023 (3)
- August 2022 (4)
- August 2021 (1)
- July 2021 (1)
- June 2021 (1)
- May 2021 (1)
- March 2021 (1)
- February 2021 (2)
- November 2020 (2)
- September 2020 (1)
- July 2020 (1)
- June 2020 (3)
- May 2020 (3)
- April 2020 (2)
- March 2020 (8)
- February 2020 (1)
- November 2019 (1)
- August 2019 (1)
- July 2019 (2)
- June 2019 (2)
- April 2019 (3)
- March 2019 (2)
- February 2019 (1)
- December 2018 (3)
- November 2018 (3)
- October 2018 (3)
- September 2018 (1)
- August 2018 (4)
- July 2018 (5)
- June 2018 (1)
- May 2018 (1)
- April 2018 (5)
- March 2018 (3)
- February 2018 (2)
- January 2018 (2)
- December 2017 (2)
- November 2017 (3)
- October 2017 (4)
- September 2017 (5)
- August 2017 (3)
- July 2017 (3)
- June 2017 (1)
- May 2017 (1)
- March 2017 (1)
- February 2017 (3)
- January 2017 (1)
- November 2016 (1)
- October 2016 (6)
- September 2016 (1)
- August 2016 (5)
- July 2016 (3)
- June 2016 (4)
- May 2016 (7)
- April 2016 (13)
- March 2016 (8)
- February 2016 (8)
- January 2016 (7)
- December 2015 (9)
- November 2015 (12)
- October 2015 (4)
- September 2015 (2)
- August 2015 (3)
- July 2015 (8)
- June 2015 (7)
- April 2015 (2)
- March 2015 (3)
- February 2015 (2)
- December 2014 (4)
- September 2014 (2)
- July 2014 (1)
- June 2014 (2)
- May 2014 (9)
- April 2014 (1)
- March 2014 (2)
- February 2014 (2)
- December 2013 (1)
- November 2013 (2)
- October 2013 (3)
- September 2013 (2)
- August 2013 (6)
- July 2013 (2)
- June 2013 (1)
- May 2013 (4)
- April 2013 (5)
- March 2013 (2)
- February 2013 (2)
- January 2013 (2)
- December 2012 (1)
- November 2012 (1)
- October 2012 (2)
- September 2012 (3)
- August 2012 (3)
- July 2012 (3)
- June 2012 (1)
- May 2012 (1)
- April 2012 (1)
- February 2012 (1)
- December 2011 (4)
- November 2011 (2)
- October 2011 (2)
- September 2011 (4)
- August 2011 (2)
- July 2011 (3)
- June 2011 (4)
- May 2011 (2)
- April 2011 (2)
- March 2011 (3)
- February 2011 (1)
- January 2011 (4)
- December 2010 (2)
- November 2010 (3)
- October 2010 (1)
- September 2010 (1)
- May 2010 (1)
- February 2010 (1)
- July 2009 (1)
- April 2009 (1)
- October 2008 (1)