OS & Hardware
Docker on Ubuntu

Version
1.2.0

Describe the bug
I have around 1 million points in my database.
Approximately 600,000 points were successfully reverse geocoded, but around 400,000 remain without geodata.

After checking several of those points manually, I confirmed that many of them are located over the ocean (e.g. flight tracks), so it is expected that reverse geocoding returns no result.

However, Dawarich keeps trying to reverse geocode those same points again and again.
The ReverseGeocodingJob repeatedly processes points even if a previous attempt already returned no result.

This causes unnecessary load and continuous background processing.

To Reproduce
Import a number of GPS tracks (including flight data or ocean coordinates).

Run reverse geocoding.

Observe that points without reverse geocoding results remain with:

geodata = '{}'

reverse_geocoded_at = NULL

The ReverseGeocodingJob continues to attempt geocoding those points repeatedly.

Expected behavior
If reverse geocoding returns no result (empty FeatureCollection), the point should be marked as "processed" to prevent repeated attempts.

For example:

Set reverse_geocoded_at

Or store a marker in geodata

Or introduce a flag such as geocoding_attempted

Reverse geocoding should only be retried if explicitly triggered by the user.

Screenshots

Logs

Additional context

Points treated as “not geocoded”, even if a reverse geocoding attempt already returned no result.

This causes:

Continuous reprocessing

High database load

Unnecessary API calls

Long-running background jobs

Example Data:

id | battery_status | ping | battery | tracker_id | topic | altitude | longitude | velocity | trigger | bssid | ssid | connection | vertical_accuracy | accuracy | timestamp | latitude | mode | inrids | in_regions | raw_data | import_id | city | country | created_at | updated_at | user_id | geodata | visit_id | reverse_geocoded_at | course | course_accuracy | external_track_id | lonlat | country_id | track_id | country_name | raw_data_archived | raw_data_archive_id -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- 583308 |   |   |   |   |   | -1 | 99.894503 |   |   |   |   |   |   |   | 1356488693 | 9.533306 |   | {} | {} | {"ele": "-1.636166", "lat": "9.533306", "lon": "99.894503", "desc": "lat.=9.533306, lon.=99.894503, Alt.=-1.636166m. Speed=0.986398m/h.", "time": "2012-12-26T02:24:53Z"} | 6 |   |   | 2025-07-24 07:01:29.569352 | 2025-07-24 07:01:29.569353 | 1 | {} |   |   |   |   |   | 0101000020E610000021CB82893FF958406A85E97B0D112340 |   |   |   | f |   583309 |   |   |   |   |   | -3 | 99.894503 |   |   |   |   |   |   |   | 1356488694 | 9.533343 |   | {} | {} | {"ele": "-3.382567", "lat": "9.533343", "lon": "99.894503", "desc": "lat.=9.533343, lon.=99.894503, Alt.=-3.382567m. Speed=1.088811m/h.", "time": "2012-12-26T02:24:54Z"} | 6 |   |   | 2025-07-24 07:01:29.569361 | 2025-07-24 07:01:29.569362 | 1 | {} |   |   |   |   |   | 0101000020E610000021CB82893FF95840DF196D5512112340 |   |   |   | f |   583310 |   |   |   |   |   | -4 | 99.894521 |   |   |   |   |   |   |   | 1356488695 | 9.533367 |   | {} | {} | {"ele": "-4.757264", "lat": "9.533367", "lon": "99.894521", "desc": "lat.=9.533367, lon.=99.894521, Alt.=-4.757264m. Speed=1.197185m/h.", "time": "2012-12-26T02:24:55Z"} | 6 |   |   | 2025-07-24 07:01:29.56937 | 2025-07-24 07:01:29.56937 | 1 | {} |   |   |   |   |   | 0101000020E6100000742502D53FF958400188BB7A15112340 |   |   |   | f |   583311 |   |   |   |   |   | -5 | 99.894546 |   |   |   |   |   |   |   | 1356488696 | 9.533383 |   | {} | {} | {"ele": "-5.868792", "lat": "9.533383", "lon": "99.894546", "desc": "lat.=9.533383, lon.=99.894546, Alt.=-5.868792m. Speed=1.414098m/h.", "time": "2012-12-26T02:24:56Z"} | 6 |   |   | 2025-07-24 07:01:29.56938 | 2025-07-24 07:01:29.56938 | 1 | {} |   |   |   |   |   | 0101000020E610000021B1DD3D40F95840187C9A9317112340 |   |   |   | f |   582854 |   |   |   |   |   | -8 | 99.894463 |   |   |   |   |   |   |   | 1356488174 | 9.532827 |   | {} | {} | {"ele": "-8.586102", "lat": "9.532827", "lon": "99.894463", "desc": "lat.=9.532827, lon.=99.894463, Alt.=-8.586102m. Speed=2.152180m/h.", "time": "2012-12-26T02:16:14Z"} | 6 |   |   | 2025-07-24 07:01:29.563617 | 2025-07-24 07:01:29.563617 | 1 | {} |   |   |   |   |   | 0101000020E6100000DA1EBDE13EF9584001DA56B3CE102340 |   |   |   | f |