If one adds an attribute for country and city and provinces etc then it helps but issue is how to enter all the data for each city and state.
@madhvendras84 made a post with some code.
could you detail the steps you followed to get the solution with the exhaustive list of cities etc