4 ms·
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
by mrfusion 12y ago
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?
- daveslash 12y agoIt'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.