# Extracting lat and long coordinates from payload

**URL:** <https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787>\
**Category:** General\
**Created:** [12 November 2020 07:30 UTC](https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787 "2020-11-12T07:30:56Z")\
**Posts on this page:** 6\
**Page:** 2

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [12 November 2020 11:05 UTC](https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787/21 "2020-11-12T11:05:06Z")

</div>

If you are having to do the comparison and subtraction doesn't that just mean the value is sint32 not uint32? Or am I missing something?

---

<div class="post-metadata">

**Author:** ![bachloo.rahul](https://avatars.discourse-cdn.com/v4/letter/b/779978/32.png) [@bachloo.rahul](https://discourse.nodered.org/u/bachloo.rahul)\
**Post date:** [12 November 2020 11:05 UTC](https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787/22 "2020-11-12T11:05:57Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/1/81e013988efaf7c0677486a199b14a3869a59d4c.png)  
I have pasted hexadecimal payload from my gateway's nw server into in thingpark api to check  
to see the latitude and longitude coordinates  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/8/d86378bd1c6f6c76012c51354a181c2127d3bf7f.png) [response\_1605178950283.json](https://discourse.nodered.org/uploads/short-url/sXcjF4Yhu6mizwwrvYtLp1OfeNQ.json) (831 Bytes)  
No @steve i am not 100% sure thats why i have referred the manual which is attached above.

```auto
{"applicationID":"1","applicationName":"cloud","data":"A0hkiAAMEOw9Ld8nBPZ5wQ==","devEUI":"20635f01d1000002","deviceName":"abeeway tracker","fCnt":11,"fPort":18,"rxInfo":[{"altitude":0,"latitude":0,"loRaSNR":10,"longitude":0,"mac":"24e124fffef0a78e","name":"24e124fffef0a78e","rssi":-59,"time":"2020-11-12T10:27:16.413008Z"}],"time":"2020-11-12T10:27:16.413008Z","txInfo":{"adr":true,"codeRate":"4/5","dataRate":{"bandwidth":125,"modulation":"LORA","spreadFactor":7},"frequency":865402500}}

```

---

<div class="post-metadata">

**Author:** ![bachloo.rahul](https://avatars.discourse-cdn.com/v4/letter/b/779978/32.png) [@bachloo.rahul](https://discourse.nodered.org/u/bachloo.rahul)\
**Post date:** [12 November 2020 11:15 UTC](https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787/23 "2020-11-12T11:15:07Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/4/f4eabd06088ca9caf96ba736df9eef11b27ac4f8.png)  
**output** after left shifting.No major change can be seen

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [12 November 2020 11:37 UTC](https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787/24 "2020-11-12T11:37:13Z")

</div>

Try this instead...

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/8/98bc62a0a9077ab4af63e9a944cdd2885b033dbb.png)

```auto
//combine bytes manually
var lat = (msg.payload.lat[0] << 24) + (msg.payload.lat[1] << 16) + (msg.payload.lat[2] << 8) 
var lon = (msg.payload.lon[0] << 24) + (msg.payload.lon[1] << 16) + (msg.payload.lon[2] << 8) 

if (lat > 0x7FFFFFFF) {
  lat -= 0x100000000;
}

if (lon > 0x7FFFFFFF) { 
  lon -= 0x100000000;
}

lat /= 10000000;
lon /= 10000000;

msg.payload.latitude = lat;
msg.payload.longitude = lon;
return msg;

```

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/8/b8f528ee7e5bec0450d3662184d1dde25748c697.png)

```auto
[{"id":"ec72da90.ce7808","type":"inject","z":"ac69cd26.4f506","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[3,72,94,140,0,12,16,236,55,45,223,38,4,245,106,62]","payloadType":"bin","x":350,"y":820,"wires":[["118cfc21.5bdf74"]]},{"id":"118cfc21.5bdf74","type":"buffer-parser","z":"ac69cd26.4f506","name":"Bulid Tags","data":"payload","dataType":"msg","specification":"spec","specificationType":"ui","items":[{"type":"byte","name":"lat","offset":6,"length":3,"offsetbit":0,"scale":1,"mask":""},{"type":"byte","name":"lon","offset":9,"length":3,"offsetbit":0,"scale":1,"mask":""}],"swap1":"","swap2":"","swap3":"","swap1Type":"swap","swap2Type":"swap","swap3Type":"swap","msgProperty":"payload","msgPropertyType":"","resultType":"keyvalue","resultTypeType":"output","multipleResult":false,"setTopic":true,"x":550,"y":820,"wires":[["30ec8af.4eae476"]]},{"id":"30ec8af.4eae476","type":"function","z":"ac69cd26.4f506","name":"","func":"var lat = (msg.payload.lat[0] << 24) + (msg.payload.lat[1] << 16) + (msg.payload.lat[2] << 8) \nvar lon = (msg.payload.lon[0] << 24) + (msg.payload.lon[1] << 16) + (msg.payload.lon[2] << 8) \n\nif (lat > 0x7FFFFFFF) { // 0x7FFFFFFF not 0x7FFFFFF\n lat -= 0x100000000;\n}\n// else << DONT DO IF ELSE HERE!\nif (lon > 0x7FFFFFFF) { // 0x7FFFFFFF not 0x7FFFFFF\n lon -= 0x100000000;\n}\n\nlat /= 10000000; //outside of the IF\nlon /= 10000000; //outside of the IF \n\nmsg.payload.latitude = lat;\nmsg.payload.longitude = lon;\nreturn msg;\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":740,"y":820,"wires":[["e17a639a.c6e5"]]},{"id":"e17a639a.c6e5","type":"debug","z":"ac69cd26.4f506","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":890,"y":820,"wires":[]}]

```

---

<div class="post-metadata">

**Author:** ![bachloo.rahul](https://avatars.discourse-cdn.com/v4/letter/b/779978/32.png) [@bachloo.rahul](https://discourse.nodered.org/u/bachloo.rahul)\
**Post date:** [12 November 2020 11:47 UTC](https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787/25 "2020-11-12T11:47:32Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/6/16b77f6d5f6db355099f506abeda111f9321f02d.png)  
Thanks @steve works great,  
calculated manually also getting exact results  
2^24 \* 16 +2^16 \* 236 +2^8 \* 55=268,435,456+15,466,496+14,080=283,916,032/10000000=28.3916032

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [26 November 2020 11:47 UTC](https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787/26 "2020-11-26T11:47:33Z")

</div>

Closed on 26 November 2020 11:47 UTC

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

[Previous page](https://discourse.nodered.org/t/extracting-lat-and-long-coordinates-from-payload/35787.md?page=1)
