Skip To Content

Supported notation formats

ArcGIS Maps for Power BI supports several degree-based notation formats for defining location coordinates.

In degree-based formats, latitude represents the Y coordinate and longitude the X coordinate. Specify hemisphere with +, -, N, S, E, or W. These can be mixed within a single latitude-longitude pair. If omitted, a value is assumed to be positive (N for latitude, E for longitude).

In the World Geodetic System 1984 (WGS84) coordinate system, latitude <DD> values range from -90 to 90; longitude <DDD> values range from -180 to 180.

Note:

ArcGIS Maps for Power BI does not currently support single-line coordinate values. Store the latitude and longitude values in separate fields or columns.

The following syntax is used in the table below:

  • <DD.dddd> denotes a latitude (Y) coordinate, where degree (DD) values range from -90 to 90 and fraction of degrees (dddd) range from 0 to 99.
  • <DDD.dddd> denotes a longitude (X) coordinate, where 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 - character.
  • [ ] denotes a choice list. For example, [ + | - | N | S ] means that you can use either a +, -, N, or S character.

The following table lists the supported notation formats and provides an example of each:

Notation typeSupported latitude (Y) formatSupported longitude (X) formatExample

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

[ + | - ] DDDMMSS.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

ArcGIS Maps for Power BI supports the following degree, minute, and second marks:

Mark typeSupported markUnicode

Degree marks

Degree sign °

U+00B0

Ring above °

U+02DA

Masculine ordinal indicator masculine ordinal degree mark

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, any of the formats and markers listed above will be valid regardless of spacing. For example, N 34° 3' 24.0726" and N34°3'24.0726" are both acceptable.