Simple ad-hoc sql query to export location data from immich

[kamaeff]

Hi!

After importing my data from Google timeline I found out that quality of imported data was poor.

But I also know that location data in my immich photos should be precise.

To enrich my gps data I needed to take the data from immich and to import it to geopulse.
There are two possible ways: use immich api or get data from immich database directly.
I prefer the latter because it's easier for me to write some sql than to learn immich api and issue api tokens.

Here is how to do it:

1. Run docker compose exec immich-database psql -s immich postgres to open Immich PostgreSQL shell
2. Copy the query. Replace username@example.org with your immich user's email.
3. Paste the query into the psql shell and hit Enter to run it. It will print to stdout a CSV table suitable for importing into GeoPulse. Ensure that result contains a csv header at the top of output (timestamp,latitude,longitude,accuracy,velocity,altitude,battery,device_id,source_type)
4. Copy the data (including header) into a .csv file and import that file using geopulse web ui.