Reverse geocaching returns null about immich

[mmomjian]

The coordinate you gave looks like a relatively remote location in Iceland. I forget the exact radius, but this message prints when a named city is not found within a certain distance of the image. You can probably check a few other coordinates and you’ll find they are all in distant locations.

Can you print the logs of a few more? I don’t think this is a timeout, it’s just logging this for each picture it finds that isn’t near a city.

[diy97]

I also have this problem here。
[Nest] 221 - 03/01/2024, 10:32:12 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289694444444, longitude: 106.657030555556 was null
[Nest] 221 - 03/01/2024, 10:32:12 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4302222222222, longitude: 106.657483333333 was null
[Nest] 221 - 03/01/2024, 10:32:13 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4302222222222, longitude: 106.657483333333 was null
[Nest] 221 - 03/01/2024, 10:32:13 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4302277777778, longitude: 106.657491666667 was null
[Nest] 221 - 03/01/2024, 10:32:13 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4302277777778, longitude: 106.657491666667 was null
[Nest] 221 - 03/01/2024, 10:32:13 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4302277777778, longitude: 106.657491666667 was null
[Nest] 221 - 03/01/2024, 10:32:14 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4302277777778, longitude: 106.657491666667 was null
[Nest] 221 - 03/01/2024, 10:32:14 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289416666667, longitude: 106.657019444444 was null
[Nest] 221 - 03/01/2024, 10:32:14 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289472222222, longitude: 106.657055555556 was null
[Nest] 221 - 03/01/2024, 10:32:14 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289416666667, longitude: 106.657019444444 was null
[Nest] 221 - 03/01/2024, 10:32:15 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289416666667, longitude: 106.657019444444 was null
[Nest] 221 - 03/01/2024, 10:32:15 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289416666667, longitude: 106.657019444444 was null
[Nest] 221 - 03/01/2024, 10:32:15 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4288777777778, longitude: 106.657066666667 was null
[Nest] 221 - 03/01/2024, 10:32:15 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289416666667, longitude: 106.657019444444 was null
[Nest] 221 - 03/01/2024, 10:32:15 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4288694444444, longitude: 106.657069444444 was null
[Nest] 221 - 03/01/2024, 10:32:15 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4288694444444, longitude: 106.657063888889 was null
[Nest] 221 - 03/01/2024, 10:32:17 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289416666667, longitude: 106.657019444444 was null
[Nest] 221 - 03/01/2024, 10:32:18 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4320805555556, longitude: 106.660069444444 was null
[Nest] 221 - 03/01/2024, 10:32:18 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4320805555556, longitude: 106.660069444444 was null
[Nest] 221 - 03/01/2024, 10:32:19 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4320611111111, longitude: 106.659541666667 was null
[Nest] 221 - 03/01/2024, 10:32:19 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4320805555556, longitude: 106.660069444444 was null
[Nest] 221 - 03/01/2024, 10:32:19 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4286972222222, longitude: 106.656888888889 was null
[Nest] 221 - 03/01/2024, 10:32:20 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4320638888889, longitude: 106.659505555556 was null
[Nest] 221 - 03/01/2024, 10:32:21 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4295416666667, longitude: 106.656347222222 was null
[Nest] 221 - 03/01/2024, 10:32:21 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4292388888889, longitude: 106.656441666667 was null
[Nest] 221 - 03/01/2024, 10:32:22 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.5688583333333, longitude: 101.995416666667 was null
[Nest] 221 - 03/01/2024, 10:32:23 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.5739444444444, longitude: 101.992916666667 was null
[Nest] 221 - 03/01/2024, 10:32:23 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.5636361111111, longitude: 101.979780555556 was null
[Nest] 221 - 03/01/2024, 10:32:27 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.1473055555556, longitude: 100.617413888889 was null
[Nest] 221 - 03/01/2024, 10:32:27 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3896972222222, longitude: 100.149977777778 was null
[Nest] 221 - 03/01/2024, 10:32:27 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3896972222222, longitude: 100.149977777778 was null
[Nest] 221 - 03/01/2024, 10:32:28 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3896972222222, longitude: 100.149977777778 was null
[Nest] 221 - 03/01/2024, 10:32:28 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3896972222222, longitude: 100.149977777778 was null
[Nest] 221 - 03/01/2024, 10:32:28 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.38805, longitude: 100.148616666667 was null
[Nest] 221 - 03/01/2024, 10:32:28 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3885194444444, longitude: 100.149125 was null
[Nest] 221 - 03/01/2024, 10:32:29 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3896972222222, longitude: 100.149977777778 was null
[Nest] 221 - 03/01/2024, 10:32:34 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4295888888889, longitude: 106.656258333333 was null
[Nest] 221 - 03/01/2024, 10:32:34 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4295388888889, longitude: 106.656827777778 was null
[Nest] 221 - 03/01/2024, 10:32:36 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.1960138888889, longitude: 103.893097222222 was null
[Nest] 221 - 03/01/2024, 10:32:49 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4281081944444, longitude: 106.657180777778 was null
[Nest] 221 - 03/01/2024, 10:32:49 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4281654166667, longitude: 106.6571655 was null
[Nest] 221 - 03/01/2024, 10:32:50 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4280738611111, longitude: 106.657394388889 was null
[Nest] 221 - 03/01/2024, 10:32:50 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4281654166667, longitude: 106.6571655 was null
[Nest] 221 - 03/01/2024, 10:32:50 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4280738611111, longitude: 106.657394388889 was null
[Nest] 221 - 03/01/2024, 10:32:50 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4282131111111, longitude: 106.65715025 was null
[Nest] 221 - 03/01/2024, 10:32:50 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4282131111111, longitude: 106.65715025 was null
[Nest] 221 - 03/01/2024, 10:33:11 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289, longitude: 106.6564 was null
[Nest] 221 - 03/01/2024, 10:33:12 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289, longitude: 106.6564 was null
[Nest] 221 - 03/01/2024, 10:33:16 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.087, longitude: 101.4808 was null
[Nest] 221 - 03/01/2024, 10:33:27 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.429, longitude: 106.657 was null
[Nest] 221 - 03/01/2024, 10:33:28 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.429, longitude: 106.657 was null
[Nest] 221 - 03/01/2024, 10:33:31 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4289, longitude: 106.6571 was null
[Nest] 221 - 03/01/2024, 10:33:32 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.5636, longitude: 101.9798 was null
[Nest] 221 - 03/01/2024, 10:33:32 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.574, longitude: 101.9917 was null
[Nest] 221 - 03/01/2024, 10:33:37 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.5734, longitude: 101.9931 was null
[Nest] 221 - 03/01/2024, 10:33:37 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.5734, longitude: 101.9931 was null
[Nest] 221 - 03/01/2024, 10:33:37 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.574, longitude: 101.9916 was null
[Nest] 221 - 03/01/2024, 10:33:42 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3897, longitude: 100.15 was null
[Nest] 221 - 03/01/2024, 10:33:42 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3881, longitude: 100.1486 was null
[Nest] 221 - 03/01/2024, 10:33:42 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3897, longitude: 100.15 was null
[Nest] 221 - 03/01/2024, 10:33:42 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.1594, longitude: 100.5795 was null
[Nest] 221 - 03/01/2024, 10:33:42 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3897, longitude: 100.15 was null
[Nest] 221 - 03/01/2024, 10:33:45 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 29.3897, longitude: 100.15 was null
[Nest] 221 - 03/01/2024, 10:34:06 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.196, longitude: 103.8931 was null
[Nest] 221 - 03/01/2024, 10:34:07 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.1688, longitude: 103.8848 was null
[Nest] 221 - 03/01/2024, 10:34:07 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.1688, longitude: 103.8848 was null
[Nest] 221 - 03/01/2024, 10:34:09 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.1614, longitude: 103.8784 was null
[Nest] 221 - 03/01/2024, 10:34:09 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.1614, longitude: 103.8784 was null
[Nest] 221 - 03/01/2024, 10:34:09 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.16, longitude: 103.8804 was null
[Nest] 221 - 03/01/2024, 10:34:12 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.1589, longitude: 103.8763 was null
[Nest] 221 - 03/01/2024, 10:34:12 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 33.1601, longitude: 103.8803 was null
[Nest] 221 - 03/01/2024, 10:34:29 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.43695, longitude: 106.653525 was null
[Nest] 221 - 03/01/2024, 10:34:30 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0864694444444, longitude: 101.480308333333 was null
[Nest] 221 - 03/01/2024, 10:34:30 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0849944444444, longitude: 101.480427777778 was null
[Nest] 221 - 03/01/2024, 10:34:30 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0870333333333, longitude: 101.480822222222 was null
[Nest] 221 - 03/01/2024, 10:34:30 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0870333333333, longitude: 101.480733333333 was null
[Nest] 221 - 03/01/2024, 10:34:30 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.3243805555556, longitude: 101.524466666667 was null
[Nest] 221 - 03/01/2024, 10:34:32 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.054675, longitude: 101.482119444444 was null
[Nest] 221 - 03/01/2024, 10:35:23 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0871361111111, longitude: 101.481436111111 was null
[Nest] 221 - 03/01/2024, 10:35:24 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0870388888889, longitude: 101.480688888889 was null
[Nest] 221 - 03/01/2024, 10:35:24 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0870388888889, longitude: 101.480688888889 was null
[Nest] 221 - 03/01/2024, 10:35:24 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0870194444444, longitude: 101.480658333333 was null
[Nest] 221 - 03/01/2024, 10:35:24 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.0870194444444, longitude: 101.480658333333 was null
[Nest] 221 - 03/01/2024, 10:35:24 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.4399972222222, longitude: 101.544083333333 was null
[Nest] 221 - 03/01/2024, 10:35:25 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.4399972222222, longitude: 101.544083333333 was null
[Nest] 221 - 03/01/2024, 10:35:25 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.4399972222222, longitude: 101.544083333333 was null
[Nest] 221 - 03/01/2024, 10:35:25 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.4399972222222, longitude: 101.544083333333 was null
[Nest] 221 - 03/01/2024, 10:35:26 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 30.3238277777778, longitude: 101.525516666667 was null
[Nest] 221 - 03/01/2024, 10:35:26 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4327111111111, longitude: 106.6549 was null
[Nest] 221 - 03/01/2024, 10:35:26 AM WARN [MetadataRepository] Response from database for reverse geocoding latitude: 31.4327111111111, longitude: 106.6549 was null

[diy97]

Places only displays 12 addresses

[utrack]

Hm, you're right! Apologies @mmomjian

I've enabled the debug log and it turns out that most of null locations are either remote or in the sea, everything else was geocoded successfully...
The only non-remote null place I've found is 53.183239, 44.0651321, which is in Kamenka's bounds, but I guess that's too small of a town for the database.

However, I've found another interesting thing - sometimes the lookups do hang for a minute or two, and it's always the same pair of coordinates... I'll look into the Postgres index situation and open a new bug if I find something. :)

Not closing this issue since there are reports from other people as well; handing it over to you.

[utrack]

Hm, is it possible to geocode points like 63°32'54.0"N 19°45'00.0"W as near Lake Holtsós or maybe near Skógar (that town to the east, which I think can be the closest one)?

I think that'll require looking for the nearest geo feature unbound by any radius, but if the point is farther than (radius) then add near prefix to it. And for the lakes, geo DB should have the lakes/geo features, but that might explode the size of the DB I guess