In an attempt to learn more about how to best and seamlessly import external geo data and map them in Drupal I recently mapped all the German soccer stadiums, that are listed in Wikipedia, and which I harvested from from DBpedia (as in the following screenshot).
This is how it worked for me.
I used the following SPARQL query to download the data.
SELECT ?subject ?lat ?long
?subject geo:lat ?lat
?subject geo:long ?long
Note that here I opted to select the lat long fields, but the data are also provided as WKT.
To be submitted directly as URL and access an XML version of the query results this query needs to be encoded into a URL that starts with
I basically copied and pasted the link from the query builder and edited it to return XML. The following link will take you there: http://goo.gl/8KHmW
Next, set up an appropriate content type in Drupal, and set up a view with OpenLayers, both described elsewhere.
Lastly use the Feeds Module and teh Feeds XML add on and use the XML parser to read in the data. Here is a snippet of the results.
So configuration of the Feeds Importer is as follows.