|
|
| GeoCommunity Mailing List |
| |
| Mailing List Archives |
| Subject: | RE: GISList: Convert degrees to decimal degrees |
| Date: |
06/17/2003 09:15:00 AM |
| From: |
William Howell |
|
|
How long is long? More than 64,000 rows? If not and you have excel, it
wouldn't be too hard to convert them using left() and mid() to separate
degrees, minutes and seconds.
Here is a sample for 3 digit degrees:
=3DLEFT(RC[-1],3)+MID(RC[-1],5,2)/60+(MID(RC[-1],8,2)/3600)
ie 134o55'35'' becomes 134.9263889
and for 2 digit degrees
=3DLEFT(RC[-1],2)+MID(RC[-1],4,2)/60+(MID(RC[-1],7,2)/3600)
45o20'15'' becomes 45.3375
Just insert the new decimal degree column to the right of the original
for both lat and lon. As long as you don't have 2 and 3 digit degree
longitudes, you can simply apply that formula to the whole column. If
not, sort the longitude column by using Data-> Sort and apply the
appropriate formula to each section.
If you don't have excel, similar functions can be done in other
spreadsheet or db programs.
William L. Howell
Web: www.McLaneEnv.com
-----Original Message-----
From: Vassil Vassilev [mailto:vassil_gis@hotmail.com]=20
Sent: Tuesday, June 17, 2003 2:58 AM
To: gislist@geocomm.com
Subject: GISList: Convert degrees to decimal degrees
Hi all.
I have a very long column with coordinates in degrees, minutes and
seconds.=20
Is it possible to convert them by some easy way automaticaly to decimal=20
degrees, not having to convert each coordinate pair by itself - I will
loose=20
too much time if so.
I will appreciate your solutions very much.
Thank you in advance,
Vassil Vassilev
Bulgarian Aerospace Agency
Remote Sensing Application Center
Sofia, Bulgaria
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online=20
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3D3963
To unsubscribe, write to gislist-unsubscribe@geocomm.com
________________________________________________________________________
GeoCommunity GeoBids - less than $1 per day!
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
Online Archive of GISList (and numerous others) available at:
http://spatialnews.geocomm.com/community/lists/
Setup a GeoCommunity Account and have access to=20
the GISDataDepot DRG & DOQQ Catalog
http://www.geocomm.com/login.php
To unsubscribe, write to gislist-unsubscribe@geocomm.com
________________________________________________________________________
GeoCommunity GeoBids - less than $1 per day!
Get Access to the latest GIS & Geospatial Industry RFPs and bids
http://www.geobids.com
Online Archive of GISList (and numerous others) available at:
http://spatialnews.geocomm.com/community/lists/
Setup a GeoCommunity Account and have access to
the GISDataDepot DRG & DOQQ Catalog
http://www.geocomm.com/login.php
|
|
Sponsored by:
For information
regarding
advertising rates
Click Here!
|
