World Eathquake Map (Yahoo Pipes)

This demo shows a map of the world depicting the locations of all earthquakes of mignitude greater than 3.0, dph of less than 50 miles, over the previous seven days. Clicking on a location shows additional details.

Technical Highlights

In this demo, we show how RDF can be used to consumed by yahoo! pipes which is a popular web based tool for building Mashups. Following is a step-by-step instruction showing
  • how conventional Web data publishing and consumption can be connected with RDF
  • how RDF + SPARQL can be used to support data manipulation in mashups.

Step 1 locate earthquake data on
The earthquake dataset published at

Step 2 convert earthquake data from CSV to RDF
Web interface of CSV2RDF that was used to convert earthquake data from CSV to RDF
* CSV data:
* xmlbase:
* property namespace:  
note: we reused property namespace from a similar dataset Dataset 32 (Worldwide M1+ Earthquakes, Past Hour, Department of the Interior)
Step 3 query RDF data and get the results back into a CSV file
  • we use the following query to filter earthquake data by magnitude and depth. Note that some proposed SPARQL 1.1 features were used here including datatype casting (e.g. "xsd:floaf").
PREFIX dgp32:  <>
PREFIX xsd:  <> 
SELECT ?id ?label ?datetime  ?lat ?lon (xsd:float(?mag) as ?magnitude) (xsd:float(?dep) as ?depth)  ?region ?src ?uri

         ?uri dgp32:eqid ?id. 
         ?uri dgp32:eqid ?label. 
         ?uri dgp32:region ?region.
         ?uri dgp32:datetime ?datetime. 
	 ?uri dgp32:magnitude ?mag .
         ?uri dgp32:depth ?dep. 
         ?uri dgp32:lat ?lat.
         ?uri dgp32:lon ?lon. 
         ?uri dgp32:src ?src.
         filter ( xsd:float(?mag) >= 3 && xsd:float(?dep) <= 50 )  }

Web interface of SparqlProxy that was used to query earthquake data in RDF and return the results back in CSV
* type of past the above SPARQL query in "SPARQL query" field
* check "CSV"  as output format
* click "query" button
Step 4 build a Yahoo Pipes! demo
  • you need a yahoo ID to access Yahoo Pipes!
  • build a yahoo pipe that consume the filtered CSV and plot the data on a map
    • use "Sources">"Fetch CSV" to retrieve SPARQL query result
    • use "Operations">"rename" to rename column names
    • use "Operations">"Loop" together with "String">"String Builder" to compose a text "description" for each earthquake
    • use "Operations">"Loop" together with "String">"String Builder" to compose a USGS "url" for each earthquake
    • use "Locaiton">"Location Extraction" to put data on map.
Web interface of SparqlProxy display filtered earthquake data (query results in CSV)
Uses Technology: 
Uses Technology: 
Your rating: None Average: 1 (1 vote)

Warning: Table './drupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:12:\"user warning\";s:8:\"%message\";s:354:\"Table &#039;./drupal/accesslog&#039; is marked as crashed and last (automatic?) repair failed\nquery: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values(&#039;World Eathquake Map (Yahoo Pipes)&#039;, &#039;node/71&#039;, &#039;&#039;, &#039;;, 0, &#039;ha0himi3s1me2597jlrgn6jji5&#039;, 32, 1618681716)\";s:5:\"%file\";s:58:\"/data/www/html/drupal/modules/statistics/statistics.module\";s:5:\"%line\";i:63;}', 3, '', ' in /data/www/html/drupal/includes/ on line 134