ArcGIS for Microsoft 365 supports several degree-based notation formats for defining location coordinates.
In degree-based formats (x,y), x represents the longitude coordinate and y represents the latitude coordinate. Specify hemisphere with +, -, N, S, E, or W. These can be combined within a single latitude-longitude pair. If omitted, a value is assumed to be positive (N for latitude, E for longitude).
In the WGS84 coordinate system, latitude <DD> values range from -90 to 90, and longitude <DDD> values range from -180 to 180.
Note:
ArcGIS for Excel and ArcGIS for Power BI do not currently support single-line coordinate values. Store the latitude and longitude values in separate fields or columns.Notation types and formats
Notation types and formats use the following syntax:
- <DD.dddd> denotes a latitude (y) coordinate in which degree (DD) values range from -90 to 90, and fraction of degrees (dddd) range from 0 to 00.
- <DDD.dddd> denotes a longitude (x) coordinate in which degree (DDD) values range from -180 to 180, and fraction of degrees (dddd) range from 0 to 99.
- | means or. For example, + | - means that you can use either the + or the - character.
- [ ] denotes a choice list. For example, [ + | - | N | S ] indicates that you can use the +, -, N, or S characters.
The following table lists the supported notation formats and provides an example of each:
| Notation type | Supported latitude (y) format | Supported longitude (x) format | Example |
|---|---|---|---|
DD (decimal degrees) | [ + | - ] DD.dddd | [ + | - ] DDD.dddd | 34.056687222, -117.195731667 |
DD.dddd [ + | - ] | DDD.dddd [ + | - ] | 34.056687222, 117.195731667- | |
[ N | S ] DD.dddd | [ E | W ] DDD.dddd | N 34.056687222, W 117.195731667 | |
DD.dddd [ N | S ] | DDD.dddd [ E | W ] | 34.056687222 N, 117.195731667 W | |
DD° MM' SS.sss" | [ + | - ] DD° MM' SS.sss" | [ + | - ] DDD° MM' SS.sss" | 34° 3' 24.0726", -117° 11' 44.631" |
DD° MM' SS.sss" [ + | - ] | DDD° MM' SS.sss" [ + | - ] | 34° 3' 24.0726", 117° 11' 44.631" - | |
[ N | S ] DD° MM' SS.sss" | [ E | W ] DDD° MM' SS.sss" | N 34° 3' 24.0726", W 117° 11' 44.631" | |
DD° MM' SS.sss" [ N | S ] | DDD° MM' SS.sss" [ E | W ] | 34° 3' 24.0726" N, 117° 11' 44.631" W | |
[ + | - ] DD° MM' | [ + | - ] DDD° MM' | 34° 3', -117° 11' | |
DD° MM' [ + | - ] | DDD° MM' [ + | - ] | 34° 3', 117° 11' - | |
[ N | S ] DD° MM' | [ E | W ] DDD° MM' | N 34° 3', W 117° 11' | |
DD° MM' [ N | S ] | DDD° MM' [ E | W ] | 34° 3' N, 117° 11' W | |
DDMMSS.sss | [ + | - ] DDMMSS.sss | [ + | - ] DDMMSS.sss | 340324.0726, -1171144.631 |
DDMMSS.sss [ + | - ] | DDDMMSS.sss [ + | - ] | 340324.0726, 1171144.631- | |
[ N | S ] DDMMSS.sss | [ E | W ] DDDMMSS.sss | N340324.0726, W1171144.631 | |
DDMMSS.sss [ N | S ] | DDDMMSS.sss [ E | W ] | 340324.0726N, 1171144.631W |
Degrees, minutes, seconds
ArcGIS for Microsoft 365 supports the following:
| Mark type | Supported mark | Unicode |
|---|---|---|
Degree marks | Degree sign ° | U+00B0 |
Ring above ° | U+02DA | |
Masculine ordinal indicator º | U+00BA | |
Circumflex accent (caret) ^ | U+005E | |
Tilde ~ | U+007E | |
Asterisk * | U+002A | |
Minute marks | Minute sign ' | U+2032 |
Apostrophe ' | U+0027 | |
Second marks | Quotation mark " | U+0022 |
Diaeresis ¨ | U+00A8 | |
Double acute accent ˝ | U+02DD |
In most cases, all of the formats and markers listed above are valid regardless of spacing. For example, N 34° 3' 24.0726" and N34°3'24.0726" are both valid.