Dublin has a very large urban park, called Phoenix Park, with a commuter train line running to the north of it. There's a station close to the park, within 10 minutes walking distance. About 20 years ago, Irish Rail opened a new station, 20 minutes from the nearest edge of the park. Obviously, they called _this_ station 'Phoenix Park'. And then had to put up posters in other stations warning people that if they wanted to go to Phoenix Park, they shouldn't go to the station called Phoenix Park, they should go to Ashtown. Obviously.

(It eventually got renamed; it's now called "Navan Road Parkway", the 'parkway' referring to a park and ride facility, not to the park. This may seem like a reasonable rename, but it's actually a masterstroke in forward planning for confusing names, because the line is being extended to Navan.)

Reminds me of this bit in Joseph Conrad’s “The Secret Agent” about London’s topographical mysteries:

”With a turn to the left Mr Verloc pursued his way along a narrow street by the side of a yellow wall which, for some inscrutable reason, had No. I Chesham Square written on it in black letters. Chesham Square was at least sixty yards away, and Mr Verloc, cosmopolitan enough not to be deceived by London’s topographical mysteries, held on steadily, without a sign of surprise or indignation. At last, with business-like persistency, he reached the Square, and made diagonally for the number 10. This belonged to an imposing carriage gate in a high, clean wall between two houses, of which one rationally enough bore the number 9 and the other was numbered 37; but the fact that this last belonged to Porthill Street, a street well known in the neighbourhood, was proclaimed by an inscription placed above the ground-floor windows by whatever highly efficient authority is charged with the duty of keeping track of London’s strayed houses. Why powers are not asked of Parliament (a short Act would do) for compelling those edifices to return where they belong is one of the mysteries of municipal administration. Mr Verloc did not trouble his head about it, his mission in life being the protection of the social mechanism, not its perfectionment or even its criticism.”

Berlin has the same issue.

I believe it’s pretty common for cities that used to be several independent municipalities that were merged relatively recently, or at least where street names were already too established to make renaming for uniqueness feasible at that point.

Edinburgh has some confusion of its own too, where streets will have two names. Usually because several smaller streets eventually got joined up and became one.

So walk in a straight line and you pass along Nicolson Street -> St.Patrick Street -> Clerk Street -> Newigton Road.

Sometimes you see these signposted in a fun way too with signs for both the individual components and the "main" street:

https://thescottishpearl.uk/2022/06/28/streets-with-two-name...