Unable to delete a marked location in Maps

Dave Low wrote:

Searching on this issue, I see others have the same problem. Some time ago I marked a location in maps. It shows up like this:

https://discussions.apple.com/content/attachment/1edd7b86-357e-42d9-b93f-5b947bd092b0

I click on it and there are no options to remove it:

https://discussions.apple.com/content/attachment/f42f4412-f483-44ab-862a-1b650abffe1b

My guess is that the location is marked as a favorite (there is a star on the icon) but Maps doesn't think it is favorited. Something is out of sync. I can add and remove it from favorites but the marked location remains and I still have no way of deleting it from maps. Any suggestions?

Did you try Control Click for a contextual menu...(?)

ref: Mark a location with a pin in Maps on Mac

I have had the same problem for quite a while. When trying to delete a guide point, it briefly disappears and then returns. If I try to rename it, it simply ignores the new name. I solved the problem in the following manner.

1) Made sure none of my devices have the Maps app running.

2) In a terminal, go to directory $HOME/Library/Containers/com.apple.Maps/Data/Maps

3) Start the sqlite3 program with the database MapsSync_0.0.1:

$ sqlite3 MapsSync_0.0.1

4) List all guides using:

sqlite> select * from ZCOLLECTIONITEM;

5) I needed to delete number 4 (first integer on each line is an index called Z_PK):

sqlite> delete from ZCOLLECTIONITEM where Z_PK = 4;

6) Exit sqlite, (commands to sqlite itself is prefixed with a period):

sqlite> .quit