Quick Example - Parsing USGS Earthquake Data

Apparently there were a few earthquakes yesterday. All I know is that I’m happy I live in a state where our natural disasters are huge and slow moving. (Not that I left last time a hurricane hit anyway.) One of the cool services the US Geological Service provides is a set of feeds for earthquake data. These are organized by how far back they go in time as well as how low of a magnitude they include. Since there’s quite a few small earthquakes every day this helps you focus on more of the “OMG THE WORLD IS ENDING” variety quake as opposed to the “Did the garbage truck just go by” mini-quake. The USGS provides both RSS feeds and CSV, and I thought it would be cool to whip up a quick ColdFusion demo that makes use of this data stream.

I began by looking at the RSS feeds. I know ColdFusion makes RSS parsing easy and in general CSV just feels messy. But I noticed something odd. None of the RSS feeds provided the magnitude of the earthquake in a "data safe" format. What do I mean? Well consider this snippet:

<entry> <id>urn:earthquake-usgs-gov:us:b0006b3y</id> <title>M 4.9, Tonga</title> <updated>2011-10-21T14:56:05Z</updated> <link rel="alternate" type="text/html" href="http://earthquake.usgs.gov/earthquakes/recenteqsww/Quakes/usb0006b3y.php"/> <link rel="related" type="application/cap+xml" href="http://earthquake.usgs.gov/earthquakes/catalogs/cap/usb0006b3y" /> <summary type="html"> <![CDATA[ <img src="http://earthquake.usgs.gov/images/globes/-20_-175.jpg" alt="21.107°S 175.602°W" align="left" hspace="20" /> <p>Friday, October 21, 2011 14:56:05 UTC<br> Saturday, October 22, 2011 03:56:05 AM at epicenter</p> <p><strong>Depth</strong>: 191.60 km (119.05 mi)</p> ]]> </summary> <georss:point>-21.1065 -175.6015</georss:point> <georss:elev>-191600</georss:elev> <category label="Age" term="Past day"/> </entry>

While you can see the mangitude in the title, and it is pretty consistent, I didn't like the idea of regexing it out just to get the value. So I took a look at the CSV data instead. Here's a sample from their feed:

Src,Eqid,Version,Datetime,Lat,Lon,Magnitude,Depth,NST,Region us,b0006b3y,3,"Friday, October 21, 2011 14:56:05 UTC",-21.1065,-175.6015,4.9,191.60,17,"Tonga"

Perfect! Not only is this exactly what I want - it's actually a lot slimmer than the XML. But how will I parse it? I'm going to use an old feature - one I haven't used in years. Did you know that CFHTTP automatically supports parsing CSV type files? Check it out:

<!--- This URL represents M2.5+ quakes over the past day ---> <cfset m25oneday = "http://earthquake.usgs.gov/earthquakes/catalogs/eqs1day-M2.5.txt"> <!--- get the URL and turn it into a query ---> <cfhttp url="#m25oneday#" method="get" firstrowasheaders="true" name="items">

Do I need to parse the CSV? Not at all. Here's how the dump looks:

Wow, I'm done. So I whipped up a small little application that let's me use jQuery to click for a map detail of the earthquake epicenter. This makes use of the super-simple static Google Map API. Here's the complete source:

<!--- Source: http://earthquake.usgs.gov/earthquakes/catalogs/ ---> <!--- This URL represents M2.5+ quakes over the past day ---> <cfset m25oneday = "http://earthquake.usgs.gov/earthquakes/catalogs/eqs1day-M2.5.txt"> <!--- get the URL and turn it into a query ---> <cfhttp url="#m25oneday#" method="get" firstrowasheaders="true" name="items"> <html> <head> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script> <script> $(document).ready(function() { var mapImg = $("#quakeMap"); $("div.quakeItem").click(function(e) { var lat = $(this).data("lat"); var lon = $(this).data("lon"); mapImg.attr("src","http://maps.googleapis.com/maps/api/staticmap?center="+lat+","+lon+"&zoom=7&sensor=false&size=400x400"); console.log(mapImg.attr("src")); }); }) </script> <style> #quakeMap { float:right; } div.quakeItem { cursor:hand; } </style> </head> <body> <h2>M2.5+ Earthquakes</h2> <img id="quakeMap" > <cfoutput query="items"> <div class="quakeItem" data-lat="#lat#" data-lon="#lon#"> <h3>#region#</h3> <p> A #magnitude# earthquake at #datetime# </p> </div> </cfoutput> </body> </html>

So how does it work? I simply loop over my query and output the data. Notice I make use of data attributes to store my latitude and longitude. This is one of my favorite HTML5 features. If you look up at the JavaScript code you can see how easy it is to fetch that data out. Once I have it I simply update my image to point to Google's API. And I'm done! Try the demo below. (And yes, I removed the console.log message.)

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate looking for his next gig. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support.

Lafayette, LA https://www.raymondcamden.com

Comments