Forum Discussion

decarsul's avatar
decarsul
Helper V
6 years ago

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 co...
Need Help
Tips and Tricks
az38's avatar
az38
Community Champion
6 years ago

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's avatar
decarsul
Helper V
6 years ago

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's avatar
    az38
    Community Champion
    6 years ago

    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's avatar
      decarsul
      Helper V
      6 years ago

      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?