Originally Posted by rowan

I believe the Maxmind paid DB goes down to city level. GeoIP is never going to be 100% accurate, especially once you're narrowing it down to a relatively small region. It's probably paid because there are staff manually deciphering that the hostname ip1.2.3.4-nyc.provider.com is probably in New York City... but according to WHOIS the administrative contact details for that block are on the other side of the USA.

Originally Posted by hadden

Latitudes and longitudes Alex

Originally Posted by Barry-xlovecam

https://github.com/maxmind/GeoIP2-perl

The information is in the free GeoIP2 database but you would need to extract it not IP specific (in reverse) -- the intended use.

Use a zip code database to get the Ohio latitude and longitude coordinates for each Ohio city then query the GeoIP2 data.

Originally Posted by Barry-xlovecam

10:19 AM-barry@:barry/SATA4/sites/geoIP/GeoLite2-City-CSV_20150106$ grep --color=always -rni "postal\|zip\|code" *|more
GeoLite2-City-Blocks-IPv4.csv:1:network,geoname_id,registered_country_g eoname_id,represented_country_geoname_id,is_an
onymous_proxy,is_satellite_provider,postal_code,la titude,longitude
GeoLite2-City-Blocks-IPv6.csv:1:network,geoname_id,registered_country_g eoname_id,represented_country_geoname_id,is_an
onymous_proxy,is_satellite_provider,postal_code,la titude,longitude

The location data is in the Free GeoLite2-City-CSV_20150106 at Maxmind -- some assembly required ;)

I think you can do some free lookups if you are just backtracking at Maxmind.

Wasn't all in vain -- nice to know that current US zip code and other countries postal codes data is available on an updated basis for another project of mine ...