List all image URLs in exported CSV file

In CSV file which I get after observation export I have URL only of the one image for observation. Is it possible to get images of all observations in the table?

this request was sort of covered in a previous discussion: https://forum.inaturalist.org/t/data-users-what-are-your-use-cases-and-requests-for-exporting-data/2972/7.

currently, it is possible to get all image files for a set of observations (including multi-photo observations), but you have to do it via one of the get observations endpoints in the iNaturalist API (see https://api.inaturalist.org/v1/docs/#/Observations).

just curious – what is your use case for getting all photo URLs into a list? (if i understand what you’re trying to do, i might be able to provide more info on how to achieve what you’re trying to do.)

2 Likes

If you’re working with research-grade data, you can do this from GBIF with a darwin core export. There will be a file in the export called ‘multimedia’ which will have each image with a link to it

2 Likes

I need to export my data from iNaturalist to another database which is used by local community. It needs a CSV file with list of photo URLs in one column.

1 Like

Which types of observations are you exporting? All, only verifiable, or only research-grade?

i modified something that i previously made (see https://forum.inaturalist.org/t/tool-for-making-observations-printer-friendly/4513/18) so that it can display photo URLs associated with each observation. here’s an example of how you might use it to view your observations: https://jumear.github.io/stirfry/iNatAPIv1_observations.html?user_id=dmitryshtol&per_page=200&locale=ru.

i didn’t add functionality to easily export results into CSV, but you can look at the thing mentioned here (https://forum.inaturalist.org/t/is-there-a-tool-code-snippet-that-allows-downloading-of-taxonomy-data-from-the-site/14268/6) to see how it accomplishes its export, if you wanted to do some coding on your own.

also see: https://forum.inaturalist.org/t/python-node-api-photo-access-possible/13391/4.

1 Like

just a quick note about a change to the thing i referenced above. instead of displaying photo URLs by default, the page will only display photo URLs if you add &options=photourl to the parameter list. for example: https://jumear.github.io/stirfry/iNatAPIv1_observations.html?user_id=dmitryshtol&per_page=200&locale=ru&options=photourl.

3 Likes

Is this functional now? In your example, “Photo URLs” column does not contain any URLs. Instead of multiple URLs, only separating commas are present in the table column.

1 Like

Perhaps @pisum ´s tool is more intuitive and/or does the same thing… but this is one of the main reasons I made this Jupyter Notebook for folks to use :
https://forum.inaturalist.org/t/tool-for-exporting-inaturalist-data-to-irecord-or-elsewhere/19160

Would be great to have this incorporated into the existing download interface on iNat though.

2 Likes

sorry… i think the way the URLs for the photos from the AWS open data bucket are delivered a little differently than the URLs for photos not in the AWS open data bucket. the URLs should now display regardless of which bucket the photos reside in.

1 Like