Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
IamTDR
Responsive Resident
Responsive Resident

Add Postal ZIP Code; Need Longitude & Latitude

Hi
In my data model, I have a field for Postal ZIP Code. 

What is the best method to add two additional fields for longitude/latitude?

1 ACCEPTED SOLUTION
quentin_vigne
Solution Sage
Solution Sage

Hi IamTDR,

 

You might want to find a database having the link between ZIP Code and Lat/Lon

Depending of your country there's open data on some website

 

Or you could take a look here : 

https://stackoverflow.com/questions/11354490/latitude-and-longitude-based-on-zip-code 

https://gis.stackexchange.com/questions/28035/how-to-convert-zip-codes-to-latitude-and-longitude

 

- Quentin

View solution in original post

1 REPLY 1
quentin_vigne
Solution Sage
Solution Sage

Hi IamTDR,

 

You might want to find a database having the link between ZIP Code and Lat/Lon

Depending of your country there's open data on some website

 

Or you could take a look here : 

https://stackoverflow.com/questions/11354490/latitude-and-longitude-based-on-zip-code 

https://gis.stackexchange.com/questions/28035/how-to-convert-zip-codes-to-latitude-and-longitude

 

- Quentin

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.