Converting Latitude and Longitude to Decimal Degrees Chicago IL

Many older reports and databases record latitude and longitude in degrees, minutes, and seconds. The following article talks about how you can take these figures and convert them into decimal degrees.

Local Companies

Popular Electronics Inc.
1-773-338-5460
2455 W. Devon
Chicago, IL
Cellular Phone Center
(312) 842-0170
2345 S Michigan Ave
Chicago, IL
Electrical Equipment Corp
(773) 463-8343
4050 N Rockwell St
Chicago, IL
Enterprise Service Corporation
(773) 589-2727
3828 N Pontiac Ave
Chicago, IL
Fox Farms
(773) 465-3634
7366 N Greenview Ave
Chicago, IL
Southtown Electric
(773) 776-1988
2548 W 59th St
Chicago, IL
Qualcomm Inc
(312) 441-1495
233 S Wacker Dr
Chicago, IL
Amer Trading
(773) 465-3634
7366 N Greenview Ave
Chicago, IL
M & N Trading Llc
(312) 738-0035
952 W Lake St
Chicago, IL
Viking Supply Co Inc
(773) 775-5797
6319 N Northwest Hwy
Chicago, IL

Many older reports and databases record latitude and longitude in degrees, minutes, and seconds. These coordinates are now commonly required to be in decimal degree format in order to be used in GIS or other software or online programs. Converting is easy and only takes a few steps. Microsoft Excel or another spreadsheet program makes the process easy for a large number of coordinates.

  1. Understand the symbols used to denote degrees, minutes, and seconds. Degrees are marked by a symbol. Minutes are marked by a ' symbol. Seconds are marked by a '' symbol.
  2. Understand the relationship between degrees, minutes and seconds. One degree is equivalent to 60 minutes. One minute is equivalent to 60 seconds. Therefore, one degree is also equivalent to 3,600 seconds.
  3. Do the math. To calculate each coordinate in decimal degrees, use the following calculation:

    Decimal Degrees = degrees + minutes/60 + seconds/3,600

  4. Make it easy in Microsoft Excel. Enter the degrees, minutes, and seconds of a coordinate into cell A1:

    If the coordinate has a three digit degree value, enter in the following format: DDDMMSS. (Example. 120 30' 45" = 1203045) Then enter the following equation into the cell where you want the decimal degree value to appear: =LEFT(A1,3) +MID(A1,4,2)/60+MID(A1,6,2)/3600

    If the coordinate has a two digit degree value, enter in the following format: DDMMSS (Example 75 15' 20" = 751520). Then enter the following equation into the cell where you want the decimal degree value to appear: =LEFT(A1,2)+MID(A1,3,2)/60+MID(A1,5,2)/3600

    This equation should provide the value of the coordinate in decimal degrees. Be sure to format the destination cell to be a number with at least four decimal places. Double check the result of your equation using the calculation in step 3. Once you are satisfied that you have entered the equation properly, you can copy and paste as often as needed.

    ...

Click here to read the rest of the article at HowToDoThings.com

Author: M. Heller

Featured Local Company

Popular Electronics Inc.

1-773-338-5460
2455 W. Devon
Chicago, IL

Related Articles
- Facts About Dubai Chicago IL
The climate in Dubai is sub tropical and arid with rainfall that is irregular and infrequent. Apart from gold, the world s largest horses can be found in Dubai. The best breeds of horses are imported from every corner of the globe and are used for racing.
- How To Plan a Spring Break Trip Chicago IL
Related Articles
- Facts About Dubai Chicago IL
The climate in Dubai is sub tropical and arid with rainfall that is irregular and infrequent. Apart from gold, the world s largest horses can be found in Dubai. The best breeds of horses are imported from every corner of the globe and are used for racing.
- How To Plan a Spring Break Trip Chicago IL
Related Local Events
Electronics Assembly Show
Dates: 9/21/2009 - 9/24/2009
Location: Donald E. Stephens Convention Center
Rosemont, IL
View Details

Electronics Assembly Show
Dates: 9/21/2009 - 9/24/2009
Location: Donald E Stephens Convention Center
Rosemont, IL
View Details

Assembly Technology Expo
Dates: 9/21/2009 - 9/24/2009
Location: Donald E Stephens Convention Center
Rosemont, IL
View Details

AD:TECH CHICAGO 2009
Dates: 9/1/2009 - 9/2/2009
Location: Navy Pier
Chicago, IL
View Details

FITC Chicago
Dates: 6/22/2009 - 6/23/2009
Location: Lakeshore Theater, Chicago
Chicago, IL
View Details

Rss   Delicious   Digg   Add To My Yahoo   Add To My Google   Bookmark   Search Plugin

Topics:
Advertising Family Home Services Real Estate Resources
Business Services Fashion Industrial Goods & Services Retail & Consumer Services
Career Financial Services Insurance Software
Cars Food & Beverage Internet Technology
Computer Hardware Franchise Legal Telecommunications
Construction Health Miscellaneous Trade Shows
Education Holidays Nightlife Travel
Entertainment Home Appliances Online Database Weddings
Environmental Home Electronics Pets World History