Not quite related to apostrophes, but I feel the need to point out my favourite street name of all time (as read on a street sign): St John St (-> Saint John Street)