DataMigrator > Simplified Geography Functions > GIS_REVERSE_COORDINATE: Returning a Geographic Component

GIS_REVERSE_COORDINATE: Returning a Geographic Component

How to:

Given longitude and latitude values and the name of a geographic component, GIS_REVERSE_COORDINATE returns the specified geographic component values associated with those coordinates.

Note: This function uses GIS services and requires an Esri ArcGIS adapter connection with named credentials.

Syntax: How to Return a Geographic Component 

GIS_REVERSE_COORDINATE(longitude, latitude, component)

where:

longitude

Numeric

Is the longitude of the component to return.

latitude

Numeric

Is the latitude of the component to return.

component

Keyword

Is one of the following components:

  • MATCH_ADDRESS, which returns the matching address.
  • METROAREA, which returns the metro area name.
  • REGION, which returns the region name.
  • SUBREGION, which returns the subregion name.
  • CITY, which returns the city name.
  • POSTAL, which returns the postal code.

The value is returned as text and can be assigned to a field with text or alphanumeric (fixed or variable length) format.

Example: Returning Geographic Components Associated With Coordinates

GIS_REVERSE_COORDINATE returns the REGION, given a city longitude and city latitude.

GIS_REVERSE_COORDINATE(CITY_LONGITUDE, CITY_LATITUDE, REGION)

For Annapolis, the result is Maryland.

For Baton Rouge, the result is Louisiana.

 WebFOCUS

Feedback