Geography Types

Bing
 

These geography types can be used to:

  • Add a geography property to a data source entity schema. See Load Data Source Data Schema and Sample Input.

  • Query for entities that are within a specified geography using the 'intersects' spatial filter. See Query Options.

  • Query for entities and return the intersection of the geography for each entity with a specified geography using the 'intersections' function. See Query Options.

Limits and Requirements

  • The maximum number of points for any entity geography value is 100,000.

  • The maximum number of points for the 'intersects' spatial filter and 'intersection' function is 250.

  • When using CSV format to define entity data, enclose the geography description in quotes ("").

  • When using 'intersects' and 'intersection' functions, enclose the geography description in single quotes(' ').

The following geography types are recommended to give the best performance when querying.

Attribute

Description

Input Data Type

OData Data Type

Point

A pair of latitude and longitude values. For a more detailed description, see Point.

Examples:

POINT(116.03059 44.49031)

well-known text (WKT)

Edm.Geography

LineString

A set of latitude and longitude values that are connected by line segments. For a more detailed description and examples, see LineString.

For CSV files, this value must be enclosed in quotes ("") when the value contains a comma (,).

Examples:

LINESTRING(-116.03059 44.49031, -116.03117 44.4928)

CSV file: "LINESTRING (-116.03059 44.49031, -116.03117 44.4928)"

well-known text (WKT)

Edm.Geography

Polygon

One or more sets of latitude and longitude points that describe a closed outer shape and closed shapes within the outer shape. The area of the polygon is the space between the inner and outer shape boundaries. Points are connected by line segments. The first and last points of each set must be the same. For a more detailed description and examples, see Polygon.

For CSV files, this value must be enclosed in quotes ("") when the value contains a comma (,).

Examples:

POLYGON ((-95.44067 48.6559, -95.44083 48.66306, …-95.44067 48.6559))

CSV file: "POLYGON ((-95.44067 48.6559, -95.44083 48.66306, …-95.44067 48.6559))"

well-known text (WKT)

Edm.Geography

The following geography types are supported, but for best performance when querying, use line string, polygon and point types.

Attribute

Description

Input Data Type

OData Data Type

MultiPoint

A set of points. For a more detailed description and examples, see MultiPoint.

For CSV files, this value must be enclosed in quotes ("") when the value contains a comma (,).

Examples:

MULTIPOINT((-122.3, 47),( -121.3 47))

CSV file: "MULTIPOINT((-122.3, 47),( -121.3 47))"

well-known text (WKT)

Edm.Geography

MultiLineString

A set of line strings. For a more detailed description and examples, see MultiLineString.

For CSV files, this value must be enclosed in quotes ("") when the value contains a comma (,).

Examples:

MULTILINESTRING((-122.3 47, -121.3 47), (-121.3 45, -122.3 47))

CSV file: "MULTILINESTRING((-122.3 47, -121.3 47), (-121.3 45, -122.3 47))"

well-known text (WKT)

Edm.Geography

MultiPolygon

A set of polygons that to not overlap. For a more detailed description and examples, see MultiPolygon.

Examples:

MULTIPOLYGON((-95.44067 48.6559, -95.44083 48.66306, -95.43524 48.66315, -95.44067 48.6559)),((-95.43503 48.65588, -95.42981 48.65556, -95.4297 48.6524, -95.43503 48.65588)))

CSV file: " MULTIPOLYGON((-95.44067 48.6559, -95.44083 48.66306, -95.43524 48.66315, -95.44067 48.6559)),((-95.43503 48.65588, -95.42981 48.65556, -95.4297 48.6524, -95.43503 48.65588)))"

well-known text (WKT)

Edm.Geography

GeometryCollection

A set of multiple geography types. For a more detailed description and examples, see GeometryCollection.

For CSV files, this value must be enclosed in quotes ("") when the value contains a comma (,).

Examples:

GEOMETRYCOLLECTION(POINT(116.03059 44.49031),LINESTRING(-115.92223 44.23223, -115.73234 44.432784))

CSV file: "GEOMETRYCOLLECTION(POINT(116.03059 44.49031),LINESTRING(-115.92223 44.23223, -115.73234 44.432784))"

well-known text (WKT)

Edm.Geography

Show: