News for hackers. Stuff that matters.

A comment on Geologic Map of Mars. Parent comment

Re:Geologic Map of Mars by mrfusion on Thursday July 17, 2014 @02:34PM (#8049308)
Which file is it? There seem to be a lot of options on that page.

Would there be a way to query wikipedia for the same type of information, or combine the two sources?

[ Parent | on HN ]
Re:Geologic Map of Mars by daveslash on Thursday July 17, 2014 @04:55PM (#8050137)
It's "NationalFile_20140601.zip - Download all national features in one .zip file "

I can't think of a way to query wikipedia - not like this allows. Once this file has been imported into sql (I use SQL Server), I run queries like SELECT DISTINCT [feature_type] FROM dbo.nationalFile WHERE [state] = 'California'

This will give me a list of all types of features in California. From there, I'll see something that looks interesting (like "lava field" or "mine") and I'll run another query like SELECT [feature_name], [latitude], [longitude] FROM dbo.nationalFile WHERE [state] = 'California' AND feature_type='lava field'.

This will give me a very clear list list. I can't imagine there would be a way to do this with Wikipedia, or any other online source that doesn't offer an API.

[ Parent | on HN ]
Re:Geologic Map of Mars by capnrefsmmat on Thursday July 17, 2014 @06:04PM (#8050486)
The structured data (such as geodata) in Wikipedia is being migrated to Wikidata, which does offer APIs:

https://www.wikidata.org/wiki/Wikidata:Main_Page

If you dig, I think you can find RDF dumps of the database.

[ Parent | on HN ]