convert geocoordinates in semicircles

[chvizda]

Hi all

I have data from a garmin gps device where the geolocations are stores in semicircles:

record.position_lat[semicircles] record.position_long[semicircles]
566493475 99058858
566493495 99059401
566493408 99059981
566493322 99060553
566493339 99061126
566493310 99061708
566493262 99062262
566493222 99062809

I found a formula how Garmin converts this to degrees:

d = s * (180.0D / 2^31)

Did anyone know how I can solve this in Alteryx to get the right geocoordinates ?

If I want to use these formula I don't know how to write the 2^31 ?

Many thanks

Steffen

Steffen

[MarqueeCrew · Accepted solution]

@chvizda,

Êtes-vous en Suisse?

[record.position_lat] * 180 / POW(2, 31)

[record.position_long] * 180 / POW(2, 31) 

Cheers,

Mark

[chvizda]

Hi Mark

thanks a lot it works.

The locations are exact where I started the ride.

Yes I'm located in Switzerland. (but it's the German speaking part).

Steffen

[MarqueeCrew]

I'm glad to have been of service.

Einen schönen Tag noch

Cheers,

Mark