GIS_REVERSE_COORDINATE: Returning 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.