issue importing GPS coordinates

[decarsul]

Hi all!

Recently i was asked to create a heatmap, with this i had to load in data with GPS coordinates Latitude and Longtitude.

Unfortunately my file isn't as specific as i want it to be, and contains a lot of ending 0's to make the coordinates 'work'.

However, when importing them to PowerBI, they are removed and i end up with 2 - 3 decimals while i should have 8.

Increasing the amount of decimals to 8 works luckily, but i'm wondering if there is an easier way to do this?

(the data is delivered in non decimal text format, which makes me have to split the column first, to add a comma when merging)

Or is there an open source somewhere i can download the data from with more specific coordinates based on zip code? (in this case for the netherlands / europe)

[az38]

Hi @decarsul 

it's difficult to advice something here without example of your data. preferably from the source

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin

[decarsul]

I don't really see how a screenshot or something similar helps, but i geuss for visualization purposes . . .

Before editting layout etc.:

PC, PC NUM, Woonplaats, PCALPHANUM, Straat, Woonplaats, Latitude, Longitude
1000 AA 1000 Amsterdam 1000AA Postbus Amsterdam 5235000000 491666700
1000 AB 1000 Amsterdam 1000AB Postbus Amsterdam 5235000000 491666700
1000 AC 1000 Amsterdam 1000AC Postbus Amsterdam 5235000000 491666700
1000 AD 1000 Amsterdam 1000AD Postbus Amsterdam 5235000000 491666700
1000 AE 1000 Amsterdam 1000AE Postbus Amsterdam 5235000000 491666700

After editting:

Jaar Week Last Resolver Name Zip Code Country Latitude Longtitude PC NUM Address City
2019 43 VVV 1017VW Netherlands 52,35 4,916667 1017 straat Amsterdam

Site won't

[az38]

@decarsul 

not sure your zip-code or any other field from your data will be more accurate then coordinates you have

anyway, is it a bad picture for you? or i didnt understand your question correct?

do not hesitate to give a kudo to useful posts and mark solutions as solution
Linkedin

[decarsul]

The zipcode is very accurate, it is actually the only information i'm 100% sure is proper.

But for some reason when using the zipcode's, it will plot them all over the world as there is multiple countries using the same zipcode system.

The issue i am mainly having is that the latitude and longtitude i have is in most cases not complete, as in, it is not the required minimum of 9 characters long (8 right from the comma, 1 infront) in most cases its about 3 - 4 decimals. Which results into residents living in the north sea. Far i know we are not atlantians 😛

So the main question i would have is, can i get accurate GPS coordinates based on zipcodes?