• USD $

Select Language

Language

Select Currency

Currency

GeoIP Update







Geo IP Lookup

Our GeoIP database contains over 4 billion IPv4 Addresses and over 370,000 Cities/Town records, and provide the country code for each IP Address, along with Latitude and Longitude, City Name and Region.

How it works

Our GeoIP service connects directly to any Firebird, MySQL or MS SQL Server database and directly updates the GeoIP data based on changes made by the controlling authorities.

Updates only include the relevant changes made during the previous 24 hour period, making updating your database quick and easy. You only need to supply the connection details for your database.

The latest version of GeoIP data is version 826, last updated 26/05/2017.

Firebird

To query the table using firebird you can call a stored procedure with the IP Address you want to query:

SELECT p.OPCOUNTRY
FROM WD$GEO_DECODE_IP('158.32.56.128') p

Or if you need more detailed information about the IP Address

SELECT p.OPCOUNTRY, p.OPCITY, p.OPREGION, p.OPPOSTCODE, p.OPLATITUDE, p.OPLONGITUDE
FROM WD$GEO_DECODE_IP('158.32.56.128') p

MySQL

To query the table using firebird you query the table directly:

SELECT wd$country_code
FROM sieradelta.wd$iptocountry
WHERE wd$from_ip < INET_ATON('85.17.24.66') AND wd$to_ip > INET_ATON('85.17.24.66')

MS SQL

To query the table using MS SQL you call a function with the IP Address you want to query:

SELECT [dbo].[WD$GEO_DECODE_IP] ('158.32.56.128')
GO

Possible Applications

There are many possible applications for this data including:

  • Real Time Country Geo-Location
  • Auto country detection for rapid form entry such as country, currency, language.
  • On-line campaigns such as targeted Banner Ads
  • Fraud Detection, Credit Card Fraud vetting etc.
  • Web Server Log analysis
  • Creation of Location Aware Content such as language, currency, etc
  • Filter web access on basis of originating country
  • Spam mail Filtering
  • Firewall and HTTP filtering rules
  • Email services for identifying the country of the sender
  • Digital Rights Management such as music or film distribution

Service Application

The service comes with a simple management interface and runs in the back ground

Please note you will need to sign up for an account to obtain the free 3 database licence, once signed up you can goto your licence page to view and activate your licence.

Features
  • GUI Interface.
  • Small, fast daily updates, where available.
  • Free for commercial/non commercial use (maximum connection of 3 databases) *.
  • Unlimited Updates/Patches.
  • Only works on local databases.

What information is provided?

The following information is available within our database:

  • The country
  • The region/state
  • The city
  • Postcode, if available
  • The latitude and longitude of the location
  • The area code for that region

What information is not available.

There is no personal information available like a person's name or street address.

Download


* A licence is created in your licence page when you sign up for an account.

This product includes modified IP data available from WebNet77 and GeoLite2 data created by MaxMind, available from http://www.maxmind.com.