Re: Derive latitude/longitude from integer values
- From: Peter <prathman@xxxxxxxxxxx>
- Date: Thu, 30 Jun 2005 13:19:46 -0700
turntableguy@xxxxxxxxx wrote:
I'm a software developer hired to work on a GIS application. My client has an Access database they purchased a long time ago from some website that no one remembers. The database contains a list of cities along with their coordinates (latitude/longitude). I have to process the coordinates as latitudes and longitudes, but the database has stored them as signed integers (not decimals). I can't figure out the conversion from integer to degress/minutes/seconds and was hoping someone here can help me.
Here is some of the sample data: (The 'ACTUAL' values displayed below are from a sample application that shipped with the data, but we don't have the source code for it).
Austin, TX ACTUAL: 30 17N, 97 44W STORED IN DB: 3028, -9773
Berkeley, CA ACTUAL: 37 52N, 122 16W STORED IN DB: 3787, -12227
Birmingham, AL ACTUAL: 33 31N, 86 48W STORED IN DB: 3352, -8680
As you can see, the data provider seems to have encoded the degrees as is (e.g. 30, 37, 97, 122). What I don't get is how you calculate the minutes/seconds from the integer. For example, in Austin, TX above, how do you figure 17 minutes (latitude) from 3028?
There are 60 minutes per degree, so in .28 degrees there are 17 minutes (0.28 * 60).
.
- References:
- Derive latitude/longitude from integer values
- From: turntableguy
- Derive latitude/longitude from integer values
- Prev by Date: Re: Derive latitude/longitude from integer values
- Next by Date: Re: Derive latitude/longitude from integer values
- Previous by thread: Re: Derive latitude/longitude from integer values
- Next by thread: Re: Derive latitude/longitude from integer values
- Index(es):
Relevant Pages
|
|
