Revfad Blog

Tag: sql

  • Playing with iNaturalist taxonomy data in MariaDB

    —

    by

    David Faden
    in

    You can download the iNaturalist taxonomy data (updated monthly) from https://www.inaturalist.org/pages/developers under “iNaturalist Taxonomy DarwinCore Archive” (https://www.inaturalist.org/taxa/inaturalist-taxonomy.dwca.zip). After unzipping, you’ll find “taxa.csv”. Here’s one way of importing this into MariaDB (and I guess MySQL too). I know that the schema for my table isn’t optimal. (I would love to hear suggestions on how to improve…