Resolve GeoIP

Extract geographic information from an IP address, including:

• Country name

• Country code: 2, 3 letters

• Region: Generate three new columns

  • Region code. Depending on country, this can be a state code, a region code, a department identifier, …

  • Region name. Depending on country, this can be a state name, a region name, a department name, …

  • Region hierarchy. When available, this is a comma-separated hierarchical list of region names, from most general to most specific

• City name

• Postal code

• Latitude and longitude

• GeoPoint

• Timezone identifier

• Continent name

Warning

The precision of the GeoIP database varies widely upon on the visitor’s ISP.