Added Timestamp to City and Numeric Code to Country. Fixed eloquent modeling on all models. Added two extra static Timezone functions to City

khsing / laravel-world

provide countries, states, and cities relations and database.

MIT License

431 stars 90 forks source link

Added Timestamp to City and Numeric Code to Country. Fixed eloquent modeling on all models. Added two extra static Timezone functions to City #51

Closed seche closed 2 years ago

seche commented 3 years ago

Bug Fix for Eloquent Models: added code to ignore that created_at and updated_at do not exist on the model.

Added to City Model a function timezoneAbbrev($iana_timezone) to retreive a timezone Abbreviation Added to City Model a function timezoneOffset($iana_timezone) to retreive the timezone offset.

seche commented 3 years ago

Also working on seeding more data, just not ready to add it to the PR just yet.

seche commented 3 years ago

@khsing here you go. 3 different commits with my changes.

I also created myself a front end for data manipulation to use as a tool for Laravel Nova Admin Panel: https://packagist.org/packages/seche/nova-laravel-world

seche commented 3 years ago

Updated Cities Table with cities of 5000+ population from https://download.geonames.org/export/dump/.

seche commented 2 years ago

Seems some cities are missing, I will update the data again in the coming days if life permits. Thanks :)

seche commented 2 years ago

@khsing I completed the data import/validation from Geonames. Roughly 200k cities