What would be the best way to put together a spreadsheet that contains all species of Diptera in the iNat taxonomy? I’d also like to have columns in this spreadsheet indicating all the parent taxa of each species between order and species.

[image] edanko: require 100 separate downloads to be combined for each page the page has an export function that will allow you to export 10000 records (the max number of records that the API will allow you to get per set of parameters). you can work around the max by speciffying order_by=id …

Like an Excel? If so, I actually adore Excel (it’s kind of my jam, yes I know this is weird) and would be happy to build this for you. PD: can provide references. :joy:

This is already built into iNaturalist in some data tables, and my question is how to download this information most efficiently for everyone. I don’t want to do it manually for 17,000 species.

[image] ItsMeLucy: PD: can provide references. :joy: What does this mean?

(references for Excel expertise, as I use it professionally, unrelated field though, no worries. I think pisum is going to have the best info.)

This tool looks like it would actually be perfect if it didn’t require 100 separate downloads to be combined for each page: https://jumear.github.io/stirfry/iNatAPIv1_taxa.html?is_active=true&taxon_id=47822&per_page=1000 Between the “parent ID” and “rank” columns, the data produced by the above to…

I had some trouble loading the file in SQL server desktop, but rowzero.io can handle the file just fine!

Taxonomic export of an order?

General

ItsMeLucy December 24, 2024, 1:47am 4

Right, the data from iNaturalist should be importable to Excel I mean. (You referenced columns, which suggested to me you would be adding data of some sort.)

edit to add: @pisum is usually very knowledgeable re: this stuff.

Topic		Replies	Views
Is there a way to export the taxonomy? General	1	416	September 17, 2023
Exporting species lists General	13	266	October 19, 2025
Exporting a list of taxa from an iNat search - API question General web , api	2	283	July 16, 2023
iNaturalist Taxonomy DarwinCore Archive does not contain tribes, subgenera, etc General api	20	403	March 2, 2026
API for complete list of "listed_taxa" entries? General api	8	794	January 8, 2023

Taxonomic export of an order?

Related topics