i had been building my very own IP-Country Ripper tools....

Clearly i want database for ip to countrycity mapping

can one obtain a database file for this from some place ( CSV, SQL ) formats are preferred

i want the next information

ip - countrycode - countryname - regioncode - regionname - city - local zip code - latitude - longitude

can somebody let me know how to locate it :)

http://ipinfodb.com/download.php?file=ipinfodb_one_table_full.csv.zip http://geolite.maxmind.com/download/geoip/database/GeoLiteCity_CSV/GeoLiteCity_20101201.zip http://geolite.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz

The greater sources are likely to ask you for, but here is a free one: http://ipinfodb.com/ip_database.php It offers ISO country code, country title, FIPS region code, region title, city, local zip code, latitude, longitude and timezone which is what you request for with timezone as an additional benefit.

You will find commercial databases that maps the IP addresses to physical location information for example country, region, city, local zip code, lengthy/lat, mobile network company info. Try IP2Location.