Level 11
Check out the data of https://www.geonames.org
Dec 7, 2021
7
Level 1
How to get longitude and latitude from zip and place in Laravel 8 ?
Hi,
I have a seeder function to import a CSV file which contains zip code and place name to the DB. Now Along with the zip and place I want to find out the coordinates of that place corresponding to the zip and place for each entry of the table where I previously imported the file.
How can I do that? Any suitable package available which I can run at the seeder itself? So that I can do both import and insert coordinates at the same time during the seeding time.
Level 1
@Sirik Sorry, I don't understand, How can I use this in my Laravel seeder?
Level 4
@athulya if you go to that website, then click on Free Postal Code Data then choose the country of choice (ch.zip is Switzerland) then you can read the text file into a database and use that! An easy fix for free!
1 like
Level 122
zip codes for which country?
Level 1
@Snapey is from multiple countries, majority is from Switzerland. I have more than 1000 zip codes and places in table, and i want to add its corresponding coordinates too in the same table.
Level 102
You can use a package like this to go through the records and get the data needed. It supports latitude and logitude https://packagist.org/packages/jcf/geocode
Level 1
Hi Guys,
https://packagist.org/packages/spatie/geocoder This package helped me, and it is working successfully.
Thank you for all of your help.
Please or to participate in this conversation.