search

hiiamrohit / Countries-States-Cities-database

Database & Dropdown Demo
http://www.iamrohit.in/countries-states-and-cities-database-of-world-in-mysql/
915 stars 1.07k forks source link

cities are listed in states table for USA #32

Open jawandsingh opened 6 years ago

jawandsingh commented 6 years ago

below are cities not states (3923, 'Byram', 231), (3925, 'Cokato', 231), (3940, 'Lowa', 231), (3944, 'Medfield', 231), (3964, 'Ramey', 231), (3968, 'Sublimity', 231), (3971, 'Trimble', 231),

this one is a repeated state name with misspell (3954, 'New Jersy', 231), this is state of Canada (3961, 'Ontario', 231),

javydreamercsw commented 6 years ago

Any idea where those cities are from?

javydreamercsw commented 6 years ago

Trying to fix this on PR #46

jawandsingh commented 6 years ago

ok cool,

below are cities not states (3923, 'Byram', 231), (3925, 'Cokato', 231), (3940, 'Lowa', 231), (3944, 'Medfield', 231), (3964, 'Ramey', 231), (3968, 'Sublimity', 231), (3971, 'Trimble', 231),

So, these records are listed in States.sql But these are actually cities. So, these must be in CIties.sql

P.S.:- I don't know which state these cities belong. As the data, I needed for my application was (Countries and States)

this one is a repeated state name with misspell (3954, 'New Jersy', 231),

This record in States.sql is repeated one and it is misspelled.

this is state of Canada (3961, 'Ontario', 231),

and this is actually a Canada State, Not USA State. So, This needs fix.

I hope this helps you to fix and merge in PR #46

javydreamercsw commented 6 years ago

I fixed Ontario and New Jersey and deleted the other cities. Will be added when someone provides the right data.

jawandsingh commented 6 years ago

well, I am closing this issue. Thanks for fixing it.

javydreamercsw commented 6 years ago

Keep in mind those won't show up until the PR is merged.