Easy Insight Logo
Call 1-(720)-316-8174

Geographic Functions

decimaldegrees

decimaldegrees converts the specified value from decimal degrees to latitude/longitude coordinates for use in Map reports.

decimaldegrees([Field])

latitudefrompostal

latitudefrompostal converts the specified value from postal code to latitude for use in Map reports.

latitudefrompostal([Field])

longitudefrompostal

longitudefrompostal converts the specified value from postal code to longitude for use in Map reports.

longitudefrompostal([Field])

normalizestate

normalizestate translates state or province codes into a consistent format. For example, if your data contains AL, al, Alabama, and alabama, all four would be converted to AL by doing:

normalize([your state field])

Twitter Logo