3 ms·
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
by daveslash 12y ago
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.
- capnrefsmmat 12y agoThe structured data (such as geodata) in Wikipedia is being migrated to Wikidata, which does offer APIs: https://www.wikidata.org/wiki/Wikidata:Main_Page https://www.wikidata.org/wiki/Wikidata:Main_Page If you dig, I think you can find RDF dumps of the database.