search

ropensci / taxizedb

Tools for Working with Taxonomic SQL Databases
Other
30 stars 7 forks source link

wikidata data source #37

Closed sckott closed 6 years ago

sckott commented 6 years ago

using https://zenodo.org/record/1213477/files/wikidata-taxon-info20171227.tsv.gz from https://zenodo.org/record/1213477 we can dump it into sqlite, e.g., in sqlite3, not tried yet

create table wikidata (name text, param1 int, param2 int);
.mode tabs
.import wikidata-taxon-info20171227.tsv wikidata

may want to think about automating an updated version of the file, 🤔

sckott commented 6 years ago

see crosswalk for wikidata rank names - somewhere