How does one calculate direction?

  • Thread starter Frederick Wilson
  • Start date
F

Frederick Wilson

Hello,

I have a table of known points. We have a course we send out managers
through. They pick several of the known points any any random order. I
would like to figure out how to get access to calculate the direction
from one point to the next.

I have searched google and other places but nothing that I have found
seems to work. depending which quadrant the easting and northing is in
will tell base direction but I can not get the compass direction.

Any ideas?

Thanks,
Fred
 
R

Rob Oldfield

Give us an example of the data you have in your table. What data type is
it?
 
F

Frederick Wilson

Point = Number as Double
Easting = Number as double
Northing = Number as double
 
F

Frederick Wilson

OH Sorry. It is utm coordinate system. I am so sorry, guess I'm a little
slow.

Point (probably bad word to use), there are several known locations or
points.

So point 1 might be 5543 4756
point 2 5893 4322
point 3
point 4
..
..
..
Point 10 4972 5034

so how do I find the direction from point 10 to point 1
 
F

Frederick Wilson

I'm not normally that stingy. I do not have an excuse but I can give you
a reason, 2 kids, wife, dog, cat, 2 and half men.
 
R

Rob Oldfield

And that starts talking about which 'zone' you're in. Could you clarify how
that is recorded?

(Would "It's somewhere over there" be a good enough answer?)
 
F

Fred Wilson

Rob said:
And that starts talking about which 'zone' you're in. Could you clarify how
that is recorded?

(Would "It's somewhere over there" be a good enough answer?)



I
Okay. UTM is basically a metric grid system I guess it is very similar
to MGRS. One grid square is 1000 meters. You can find the distance
between two points by doing
sqrt(e1-e2 + n1-n2) where e=easting n=northing.

What I can not get worked out is the direction between two points.
 
P

PC Datasheet

Fred,

Please define quadrants. How many are there?

How do you tell what quadrant easting and northing are in?

Is there a 0,0 point?
 
F

Fred Wilson

I am REALLY not trying to be evasive I REALLY don't understand. I am
trying and I appreciate your patients.

Okay, 360 degrees are in effect. Cardinal headings are not good enough.
Northing and easting are the same measurements.

If anyone has been in the military it is just like using a military map,
compass and know points through the woods from point a to point b,
then to c and so on.

I did find some information from an aviation page but it is talking
about the great circle rule which applies to distances WAY bigger than I
am speaking of.

northing 'a' can be < or > or = northing 'b'
easting 'a' can be < or > or = easting 'b'

and any combination thereof.


Once again, thanks for your patients.
 
P

PC Datasheet

To get the direction you need to check these conditions:
1. northing 1 = northing 2, direction = due east or due west depending on
easting 1 and easting 2
2. northing 1 < northing 2, direction = north by east or north by west
depending on easting 1 and easting 2
3. northing 1 > northing 2, direction = south by east or south by west
depending on easting 1 and easting 2
4. easting 1 < easting 2, direction is easterly
5. easting 1 > easting 2, direction is westerly

To get the angle of travel (Xdegrees, Yminutes, Zseconds):
Calculate: Tangent of angle = (northing 1 - northing 2)/(easting 1 -
easting 2)


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com
 
F

Frederick Wilson

I found this formula

=atan2((e1-e2),(n1-n2))*180/PI()
e= easting
n=northing

It seems to work in Excel Kind of. I say this because it appears to give
the direction 180 degrees out.

Additionally, atan2 is not a function in Access and because I do not
know what this formula is doing I am not sure how to work around it.

Any ideas?
 
P

Paul Overway

In Access you'd use ATN

ATN((e1-e2)/(n1-n2))*(180/3.14159265)

There is no PI function...you'd need to use a constant.

The only other problem I see in converting the formula is that n1 and n2
cannot be the same, whereas ATAN2 would allow it (according to help in
Excel). The Access help discusses derived Math Functions...and the Inverse
Hyperbolic Tangent sounds like it might be what you're looking for to take
care of the 180 difference

Inverse Hyperbolic Tangent HArctan(X) = Log((1 + X) / (1 - X)) / 2
 
R

Ronald W. Roberts

PC said:
Frederick,

If we are going to help you, you need to answer our questions instead of
being evasive! I asked three questions and you did not answer any of them.

Are these statements fair to say ?

If easting Point 1 < easting Point 2 AND northing Point 1 = northing Point
2, you have moved due West?

If northing Point 1 < northing Point 2 AND easting Point 1 = easting Point
2, you have moved due North?

Another question ---
Is moving 10 units easting the same distance as moving 10 units northing?

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com
Below is the text from the web page on UTM. I don't know what Im
talking about, but here is
my take on it.

1. The Central Meridian is assigned a value of 500,000 and is the
vertical center of each zone.
2. In the northern hemisphere the value at the equator is 10,007,543 and
the North pole is 0.
3. In the southern hemisphere the value at the equator is 10,007,543 and
th South pole is 0.
Not sure about this. It could be Sequator 0 and south pole 10,007,543.
For the logic of point 1 less then or greater than point 2, the south
pole should be 0.

So if I'm half way between the equator and the north pole, my northing
is 4,746,040 N.
From my current location, say 328204 E, and I move East my new Easting
is greater.
If I move West my Easting is smaller.

West-------------------Central Meridian-------------------------East
0-----------------------------500,000----------------------------1,000,000

Not sure if the east number is 1,000,000

So, the answer to your 1st two questions is yes. The answer for the
units, as I see it is yes,
a unit is 1 meter. Those 10 units as a square would be 100 square meters.

Text fom th eWeb page about UTM.
The zones are then further subdivided into an eastern and western half
by drawing a line, representing a transverse mercator projection, down
the middle of the zone. This line is known as the 'central meridian' and
is the only line within the zone that can be drawn between the poles and
be perpendicular to the equator (in other words, it is the new 'equator'
for the projection and suffers the least amount of distortion). For
this reason, vertical grid lines in the UTM system are oriented parallel
to the central meridian. The central meridian is also used in setting
up the origin for the grid system.

Any point can then be described by its distance east of the origin (its
'easting' value). By definition the Central Meridian is assigned a
false easting of 500,000 meters. Any easting value greater than 500,000
meters indicates a point east of the central meridian. Any easting value
less than 500,000 meters indicates a point west of the central meridian.
Distances (and locations) in the UTM system are measured in meters, and
each UTM zone has its own origin for east-west measurements.

To eliminate the necessity for using negative numbers to describe a
location, the east-west origin is placed 500,000 meters west of the
central meridian. This is referred to as the zone's 'false origin'. The
zone doesn't extend all the way to the false origin.
The origin for north-south values depends on whether you are in the
northern or southern hemisphere. In the northern hemisphere, the origin
is the equator and all distances north (or 'northings') are measured
from the equator. In the southern hemisphere the origin is the south
pole and all northings are measured from there. Once again, having
separate origins for the northern and southern hemispheres eliminates
the need for any negative values. The average circumference of the
earth is 40,030,173 meters, meaning that there are 10,007,543 meters of
northing in each hemisphere.

UTM coordinates are typically given with the zone first, then the
easting, then the northing. So, in UTM coordinates, Red Hill is located
in zone twelve at 328204 E (easting), 4746040 N (northing). Based on
this, you know that you are west of the central meridian in zone twelve
and just under halfway between the equator and the north pole. The UTM
system may seem a bit confusing at first, mostly because many people
have never heard of it, let alone used it. Once you've used it for a
little while, however, it becomes an extremely fast and efficient means
of finding exact locations and approximating locations on a map.

Like I said, this is my take on the subject, but I really don't know
what I talking about. :)

Ron
 
Top