GEO Data Functions

Return Country Codes, Language, Country Names, Distance Between Two Coordinates.
  • COUNTRY_CURRENCY

    Returns currecy code by country. "gb" - "GBP"

    COUNTRY_CURRENCY("de")
    Try this example
    code (string)
    Country code, 2 characters
  • COUNTRY_LANGUAGE

    Returns language code by country. "de" - "German"

    COUNTRY_LANGUAGE("de")
    Try this example
    code (string)
    Country code, 2 characters
  • COUNTRY_NAME

    Returns country name by code. "eg" - "Egypt"

    COUNTRY_NAME("gb")
    Try this example
    code (string)
    Country code, 2 characters
  • COUNTRY_NAME_ISO

    Returns country ISO 3166-1 alpha2 code. "de" - "DE"

    COUNTRY_NAME_ISO("de")
    Try this example
    code (string)
    Country code, 2 characters
  • COUNTRY_NATIVE_NAME

    Returns country native name by code. "de" - "Deutschland"

    COUNTRY_NATIVE_NAME("de")
    Try this example
    code (string)
    Country code, 2 characters
  • COUNTRY_OFFICIAL_NAME

    Returns country official name by code. "de" - "Bundesrepublik Deutschland"

    COUNTRY_OFFICIAL_NAME("de")
    Try this example
    code (string)
    Country code, 2 characters
  • GEO_DISTANCE

    Measures distance between two coordinates. Returns distance in meters

    GEO_DISTANCE(48.809242, 2.428167, 52.458210, 13.370549)
    Try this example
    lat_from (number)
    Latitude from
    lng_from (number)
    Longitude from