Database
![]() |
IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-ISP-Domain-NetSpeed-AreaCode-Weather DatabaseIP2Location™ IP-Country-Region-City-Latitude-Longitude-ZIPCode-TimeZone-ISP-Domain-NetSpeed-AreaCode-Weather Database [DB18] provides a solution to determine the country, region or state, city, latitude and longitude, US ZIP code, time zone, Internet Service Provider (ISP) or company name, domain name, net speed, area code, weather station code, and weather station name of origin for any IP address in a few simple steps. First, retrieve the IP address from the networking protocol or server-side variable of the Web server. Next, translate the IP address to an IP number in decimal format to speed up the database query. Lastly, reverse lookup the IP number from the IP2Location™ database to pinpoint the exact geographical location. |
SAMPLE REQUEST
PRODUCT FEATURES| Features | Translates IP address to country, region or state, city, latitude and longitude, US ZIP code, time zone, Internet Service Provider (ISP) or company name, domain name, net speed, area code, weather station code, and weather station name. |
|---|---|
| Current Version | February 2012 |
| Next Update | March 2012 |
| Database Size | 109.94 MB (5,186,225 Rows) |
| Database Format | ASCII Text File (Comma Delimited) and BIN (API) |
DATABASE FIELDS| Name | Type | Description |
|---|---|---|
| ip_from | INT(10) | First IP address in netblock. |
| ip_to | INT(10) | Last IP address in netblock. |
| country_code | CHAR(2) | Two-character country code based on ISO 3166. |
| country_name | VARCHAR(64) | Country name based on ISO 3166. |
| region_name | VARCHAR(128) | Region or state name. |
| city_name | VARCHAR(128) | City name. |
| latitude | DOUBLE | Latitude of city. |
| longitude | DOUBLE | Longitude of city. |
| zip_code | VARCHAR(10) | ZIP code of United States city. |
| time_zone | VARCHAR(8) | UTC time zone. |
| isp | VARCHAR(255) | Internet Service Provider or company's name. |
| domain | VARCHAR(128) | Internet domain name associated to IP address range. |
| net_speed | VARCHAR(8) | Internet connection type. DIAL = dial up, DSL = broadband/cable, COMP = company/T1 |
| idd_code | VARCHAR(5) | The IDD prefix to call the city from another country. |
| area_code | VARCHAR(30) | A varying length number assigned to geographic areas for call between cities. |
| weather_station_code | VARCHAR(10) | The special code to identify the nearest weather observation station. |
| weather_station_name | VARCHAR(128) | The name of the nearest weather observation station. |
MISCELLANEOUSLicense Agreement: General Terms and Conditions for the database licensing.
Server License: The number of license required for server installation.
IP2Location™ is a registered trademark of HEXASOFT. All other trademarks are the property of their respective owners.



