I know challenges are more common on the coding-related Q&A sub-sites. But here we go:
I've got a dataset that comes with coordinates, however they seem to have gotten scrambled somewhere along the way of data-collection, data-entering and data-export. For some of the places the actual coordinates are known. Now the goal is to use this to figure out how they got scrambled, in order to be able to reverse this.
The following table lists the approximate real coordinates for those where this is known and the coordinates I found the data set.
real_latiude, real_longitde, data_lat, data_lon13.30214, -14.22023, 1318136, 14134713.31396, -14.21844, 1318268, 141256113.34097, -14.09441, 1320262, 1405442, , 1316060, 140818213.39157, -13.88993, 568980, 148451913.43406, -14.6541, 537144, 148510613.47477, -14.08452, 599042, 148964013.48308, -16.50089, 337657, 149117513.48558, -15.96453, 395687, 149138713.48643, -16.54477, 333733, 149148113.49866, -14.82873, 518529, 149192013.59012, -15.13228, 485738, 150217113.60742, -15.13525, 485367, 150418513.61425, -15.16174, 482322, 150433513.64409, -15.10624, 488472, 15082431/3 of the solution:
For the first three entries, I was able to figure out that the data was entered in UTC-format and then all-special characters where stripped. I.e. it corresponds to the real coordinate, i.e.:
1318136, 141347 => 13°18'13.6"N 14°13'47"W
Possible starting points
We have reasons to believe that the data was manually entered in Excel. So one possible thing could be that Excel interpreted the entered figures as dates somehow and save it's own weird date/time format. I was however so far not able to figure out how that could've happened.
Reward
I will set a bounty to this question (as many as I might have by then), as soon as I'm allowed to set a bounty.
أكثر...
I've got a dataset that comes with coordinates, however they seem to have gotten scrambled somewhere along the way of data-collection, data-entering and data-export. For some of the places the actual coordinates are known. Now the goal is to use this to figure out how they got scrambled, in order to be able to reverse this.
The following table lists the approximate real coordinates for those where this is known and the coordinates I found the data set.
real_latiude, real_longitde, data_lat, data_lon13.30214, -14.22023, 1318136, 14134713.31396, -14.21844, 1318268, 141256113.34097, -14.09441, 1320262, 1405442, , 1316060, 140818213.39157, -13.88993, 568980, 148451913.43406, -14.6541, 537144, 148510613.47477, -14.08452, 599042, 148964013.48308, -16.50089, 337657, 149117513.48558, -15.96453, 395687, 149138713.48643, -16.54477, 333733, 149148113.49866, -14.82873, 518529, 149192013.59012, -15.13228, 485738, 150217113.60742, -15.13525, 485367, 150418513.61425, -15.16174, 482322, 150433513.64409, -15.10624, 488472, 15082431/3 of the solution:
For the first three entries, I was able to figure out that the data was entered in UTC-format and then all-special characters where stripped. I.e. it corresponds to the real coordinate, i.e.:
1318136, 141347 => 13°18'13.6"N 14°13'47"W
Possible starting points
We have reasons to believe that the data was manually entered in Excel. So one possible thing could be that Excel interpreted the entered figures as dates somehow and save it's own weird date/time format. I was however so far not able to figure out how that could've happened.
Reward
I will set a bounty to this question (as many as I might have by then), as soon as I'm allowed to set a bounty.
أكثر...