Include the seconds in the time when sorting by Date Observed

When sorting by “Date observed”, it would be nice to include the full time precision in the sort so that the sorted observation order matches the order of photos in my camera roll. Otherwise, observations made within the same minute are sorted randomly and inconsistently.

My workflow is generally to upload all my photos to iNaturalist while identifying them as best as I can. A few days later, after other people have added their identifications, I’ll go back to my photos and tag them with the consensus IDs. Thus, it’s easiest for me if the order of observations in iNaturalist matches the order of photos in my computer.

I usually upload my photos in the same order I took them, but sometimes I pick a few out to upload first because I’m curious about the suggested ID, and sometimes a few get missed until a second upload pass later. So sorting by ‘observation date’ generally works better for me than sorting by ‘date added’, except when two observations are within the same minute and so don’t get ordered correctly.

I’ve constructed this artificial search to demonstrate the issue. The search results include only a few observations, sorted by observation date in ascending order (oldest on top):
https://www.inaturalist.org/observations/chris_nelson?swlat=37.3076&swlng=-122.199&nelat=37.308&nelng=-122.197&year=2020&order_by=observed_on&order=asc

At 11:20 AM PDT, I observed Castilleja exserta, then Erodium cicutarium, then Eschscholzia california, but that is not the listed order.

At 11:24 AM PDT, I observed Tragopogon porrifolius, then Rumex crispus. The listed order is correct, but if I click at the top of the “Date observed” column to switch to descending order, these two observations don’t reverse order and are therefore now in the wrong order.

Poking through the exported data, I notice that the time_observed_at field includes seconds, but the value is always rounded off to “:00”. I checked the EXIF data of the photos I uploaded, and it has precision to fractions of a second, so I’m guessing that iNaturalist rounds off the value during upload.

Ideal feature update: Record the observation date with precision at least to seconds and use this precision when sorting by observation date. (The time can still be displayed as hours:minutes as usual.)

If it’s too painful to add more precision to the observation date, a partial solution could break ties in the observation date by using the date added field (or observation ID). This would be acceptable to me since I usually submit observations in sequential order.

This is not a high priority request. It’d be a nice improvement for me and perhaps other people as well, but I can continue to work around the issue if nothing changes.

Thanks!

I have had exactly the same request in my mind for a long time, but didnt know if it was feasible or at what cost… For similar reasons, plus others.

Eg Sometimes I go into the Photo details in iNat to see the seconds, in order to establish whether an image belongs to one observation or the next one, if I have taken a couple of dozen photos in a minute, covering more than one specimen, maybe of the same species, and uploaded them to separate observations, but some time later come to suspect one photo of being in the wrong obs. Being able to differentiate the times of the two key photos would be very helpful in this situation.

1 Like

Yes, please add the seconds to the “observed on” time! This shall also apply to the downloaded csv file.

I wrote a code to update the metadata of my offline picture archive with the iNat identifications and related taxonomy.

I created an excel list of my picture archive that I match with the observation file downloaded from iNat using the observation time (“date taken” for the offline file) and
feed it to the ExifTool to update files on disk with the iNat data.

It works great but because the time only goes to the “minute” I have several duplicate matchings (more than I would have thougth, almost 5% of all observations), that I have to “discard” (or process manually).

The only other field in the iNat download that can be used to uniquely identify back the file in the offiline archive could be the tag_list but that works only until the offline and the online tag list doesn’t change (that happens already after the first update of the offline archive with the iNat metadata).

The issue was also discussed here: https://forum.inaturalist.org/t/is-it-possible-to-retrieve-the-original-filename-of-an-observation/4419

@brentturcotte

1 Like