Forum Discussion
issue importing GPS coordinates
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)
4 Replies
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 491666700After 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 AmsterdamSite won't
