# GPS and Geometry

This is an SQL problem.

I would like an SQL (Linux PostgreSQL) solution to a GPS problem, and I can't be arsed to do it myself. It's Geometry.

I want to be able to calculate (approximately) where something else is when I know where I am (exactly) given a set of distances and a directions from that object.

I also want to eliminate bad data - data that cannot possibly be correct, given the other data available - sometimes I get the data wrong.

I want to know where the other thing is when I have a set of data that tells me where I am (GPS), and how far, and what direction (mostly) the other thing is.

## Deliverables

Given a dataset in a PostgreSQL database of where I am, and how far/what direction the other thing is (maybe 1-20 records) I WANT AN SQL QUERY (or queries) that returns the (rough) calculation of where the other thing is, in decimal (GPS) degrees.

'rough' means a constant - use 1km as a guide, which means that the answer must be within a circle of 1km.

I want to be able to vary the 1km, so make it a variable constant ;)

Data is in decimal GPS co-ordinates, direction is either 1,2 or 3 (120 degrees separation), or 0, meaning I don't know what direction it is.

Distance is in decimal metres.

Location result to be delivered in decimal degrees. (a vector).

My idea was to use multiple toroids in an arc covering 120 (in the right direction) or 360 degrees (any direction), at the right distance from me to the target, overlap them and plot a polygon where they overlap.

The centroid of that polygon would be likely to be the location of the target. Ish.

My maths isn't good enough. I could learn.

## Platform

PostgreSQL query, or shell script using multiple PostgreSQL queries to produce the answers.

That's Linux that is. The best OS on the planet today.

And PostgreSQL. The best Database money cannot buy.

İşveren Hakkında:
( 1 değerlendirme ) United Kingdom

Proje NO: #3125683

## Seçilen:

jazzmusicman

See private message.

%selectedBids___i_period_sub_7% gün içinde 150%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(31 Değerlendirme)
4.3

## Bu iş için 4 freelancer ortalamada \$276 teklif veriyor

IWSolutions

See private message.

\$212.5 USD in 100 gün içinde
(108 Değerlendirme)
6.7
engineer1138

See private message.

\$484.5 USD in 100 gün içinde
(8 Değerlendirme)
4.4
himag82

See private message.

\$255 USD in 100 gün içinde
(0 Değerlendirme)
0.0