I'm really looking forward to Google rolling out their own already-announced maps app on iOS for this reason (although I have to imagine your city has dedicated apps that do public transit already, as mine does).
And as far as I know the maps app already used Apple's locations database, which was noticeably worse than Google's. I keep hoping that Apple will simply realize that location is not their strength, but so far this seems unlikely.