Location picker will result in all locations be absolutely unique.
Yes, if two or more persons will specify just the same street address or even just the same city then they will have exactly the same location coordinates and will appear overlapping on a map. It is possible upon clicking on a marker to force the module to show Info of all entries with exactly the same that location coordinates though if that is what you're asking for.