Item 4130 - Marker jumps around, changing issue id

[Famlam]

The screenshots are from: https://osmose.openstreetmap.fr/nl/map/#zoom=16&lat=51.83874&lon=5.86743&item=4130&level=1%2C2%2C3&tags=&fixable

Item 4130 / class 1

The marker jumps around and (due to this) the issue ID changes all the time. Hence, if I want to mark this one as a false positive, I would have to mark it a dozen of times.

For example,

• on 12-6 the issue ID was https://osmose.openstreetmap.fr/nl/issue/15da88fd-869f-8342-1c1e-690314061fd1
• on 20-6 the issue ID was https://osmose.openstreetmap.fr/nl/issue/2132165d-c7a3-8a5d-8908-f3d6a195805a

I guess there should be an ORDER BY id or ORDER BY tid at the end of the query?

[frodrigo]

Not sure. Because sub query already ordered. It is not required by SQL, but I think postgres keep the order. on the the group by.

We can try to refactor all order by to the main query.

[frodrigo]

@Famlam do you think it is ok now ?

[Famlam]

I'll check tonight. For some reason I can't find the marker for the item in the first post

Ah found it (in front of Groesbeekseweg 122)

I'll check it a bit coming weeks, to be sure it's stable

[Famlam]

Seems pretty stable :)