List labels with "Overwrite pre-existing GEO location info" checked

[Roman]

Can a someone with more scripting knowledge than me provide a script to list all labels that have "Overwrite pre-existing GEO location info" checked?
Thanks,
Roman

[Roman]

Is this function scriptable?
If not, is it achievable via a SQL query?

[Hert]

https://repository.idimager.com/openres ... 37A156714E

[Roman]

Thank you Hert, the script is exactly what I wanted.
I was surprised how many of my Place labels had the "Overwrite pre-existing GEO location info" option checked. I think that this is probably due to my workflow. My cameras do not have inbuilt GPS so almost all my Place labels have GPS co-ordinates assigned. When assigning labels I frequently assign more than one location label. For example, if I take a photograph from "Hill A" looking towards "Hill B" I will assign both labels. When I sync the labels to the image file sometimes the wrong GPS co-ordinates get assigned to the image. I know I should assign the first label, sync, then assign the others, but I am sometimes in a rush, or just forget. To fix this up I have to edit the relevant label's details to set the "Overwrite pre-existing GEO location info" option, sync the file, then unset the "Overwrite pre-existing GEO location info" option on the label. Unfortunately I sometimes forget to unset the option resulting in the incorrect location being written to other images on subsequent syncs. It would be good if you could right click on an assigned label to write the label's co-ordinates to the selected images without the need to edit the label's details.

Screenshot 2022-11-19 200741a.jpg (77.89 KiB) Viewed 2252 times

[snowman1]

I might be missing something here but to correct the errors would you not simply go to the details of the label whose location is the one you want, "copy coordinates to clipboard", open geo panel, select the images you want to change, and in geo panel "paste coordinates from clipboard"?

I appreciate this doesn't change the workflow problem causing the issue. It may be easier not to use the "overwrite option" and just apply the coordinates "manually" via the geo panel. Personally I take that approach. I tend to assign locations by using a GPX file and applying this to the images using the geo panel; sometimes I'll assign a generic or base location to a label first which gets applied to the images but in these cases I don't want that location to override the more specific locations from the GPX file. I'm not suggesting this would suit your workflow, just mentioning it in case it helps.

[Roman]

I might be missing something here but to correct the errors would you not simply go to the details of the label whose location is the one you want, "copy coordinates to clipboard", open geo panel, select the images you want to change, and in geo panel "paste coordinates from clipboard"?

Thank you for the suggestion, that is a better approach and would avoid the confusion I am creating for myself using the overwrite option. Now that Hert's script as allowed me to clean up the mess I made for myself I will adopt this method.