Dms To Dd Excel How To Achieve This

For optimum use in the GIS you require the coordinate data in decimal-degrees format.

Dms To Dd Excel How To Achieve This

Lets look at how to achieve this using Excel and the data below for three cities, Dublin, Paris, and Sydney.

If the last character is not a W, leave the entry as positive.

See this post for an introduction to Geographic Coordinate Systems.

Press enter to populate the cell with the decimal degree value.

Click enter and grab the bottom right corner of the new cell entry and drag down for the other two records.

The code, itself, does not compensate for negative coordinates so we have added a formula to use with the conversion to compensate for this.

VBA scripts are specific to the version of VBA that was shipped with the version of ArcMap in use.

However, this script may serve as a template for modification, if desired.

Support for Visual Basic for Applications (VBA) for ArcMap and ArcCatalog ended with the ArcGIS 10.2.2 release, and Esri has not included VBA compatibility setups since version 10.5.

See: ArcGIS Desktop and VBA Moving Forward.

Starting at ArcGIS 10.0, expressions in the Calculator are created using only VBScript or a standard Python format.

The values must be stored in a field in a table as Degrees Minutes Seconds with no symbols.

After the conversion is complete, multiple any fields that need to be negative by -1.

The format of the records within the DegreesMinutesSecond fields must be DD MM SS.

Any blank records or records with extra spaces or characters, such as single or double quotes, may cause a user interrupted error.

Right-click on the table in the Table of Contents and click Open.

Enter Lat2 in the Name field and select Double from the Type drop-down list.

If Lat2 is already used as a field name, select a name that is not used.

Verify that the Scale and Precision is set to 0 and click OK.

Replace the word Latitude in the code with the name of the field that stores the latitude values in the table.

Null values in the DMS field will cause an error when running the VBA code in the Field Calculator.