search

dr5hn / countries-states-cities-database

🌍 Discover our global repository of countries, states, and cities! 🏙️ Get comprehensive data in JSON, SQL, PSQL, XML, YAML, and CSV formats. Access ISO2, ISO3 codes, country code, capital, native language, timezones (for countries), and more. #countries #states #cities
https://dr5hn.github.io/countries-states-cities-database/
Open Data Commons Open Database License v1.0
6.81k stars 2.44k forks source link

fix: add alimosho city to lagos state, nigeria #756

Closed laurentcodes closed 4 months ago

laurentcodes commented 4 months ago

added a new city to lagos, nigeria i want to know if i added this correctly before i proceed to add more, thanks.

dr5hn commented 4 months ago

@laurentcodes Thanks for the PR!

Can you please move your entry to very end of the world.sql and make sure to assign a ID (last_id + 1) to that newly added row?

laurentcodes commented 4 months ago

@dr5hn sure! will do that.

laurentcodes commented 4 months ago

@dr5hn, i have moved the entry to the end of the world.sql file and set an id (23), please check if correct

dr5hn commented 4 months ago

@laurentcodes You have moved to subregions table, can you please move it to cities table?

laurentcodes commented 4 months ago

@dr5hn i just did, please recheck, last entry under cities if that's correct

dr5hn commented 4 months ago

@laurentcodes You need to fix semi colon and comma at End of line of last and 2nd last row

laurentcodes commented 4 months ago

@dr5hn fixed