US/Canada database? - GoFuckYourself.com

acctman · 10-11-2011, 02:06 PM

anyone know of an up2date US and Canada database. that has city, state/prov, zip/post and lon/lat database (sql, excel, txt)...

fris · 10-11-2011, 02:11 PM

nothing thats canadian, but usa i think i have something

MediaGuy · 10-11-2011, 03:03 PM

Isn't that against the law/privacy protection that Canadians still have under our constitution?

:D

Babaganoosh · 10-11-2011, 03:05 PM

http://www.zip-codes.com/

acctman · 10-11-2011, 04:43 PM

Quote:

Originally Posted by fris

nothing thats canadian, but usa i think i have something

is it recent? i have an old US/CAN db about 2yrs old and a few cities that I know of are coming up wrong as well as some new zips that I don't know of have been added.

@MediaGuy wouldn't that make it difficult to receive mail?

I remember seeing a US gov site that had all city, state, zips, lat/lon and updated almost 2-3monthly with new postal code additions. they gave a raw text download of it for free. I never bookmarked it at the time.

email: pa_misc !!<at>!! live.com

garce · 10-11-2011, 05:02 PM

Quote:

Originally Posted by MediaGuy

Isn't that against the law/privacy protection that Canadians still have under our constitution?

:D

I think the Canadian Constitution was written before the internet existed - and I don't think its been updated much since then. I might have missed something, but there are privacy laws that about as effective as a Doug Flutie "Hail Mary!" pass if someone gets pissed off and snitches on you.

acctman · 10-11-2011, 08:20 PM

found it, this is the site I was talking about earlier
http://download.geonames.org/export/dump/
http://download.geonames.org/export/zip/
has all zips, cities, states, zones, etc for free and updated regularly for free.

10-11-2011, 02:06 PM	#1
acctman Confirmed User Join Date: Oct 2003 Location: Atlanta Posts: 2,840	US/Canada database? anyone know of an up2date US and Canada database. that has city, state/prov, zip/post and lon/lat database (sql, excel, txt)...

10-11-2011, 02:11 PM	#2
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,372	nothing thats canadian, but usa i think i have something __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

10-11-2011, 03:03 PM	#3
MediaGuy Confirmed User Industry Role: Join Date: Sep 2004 Location: Montrealquebecanada Posts: 5,500	Isn't that against the law/privacy protection that Canadians still have under our constitution? :D __________________ YOU Are Industry News! Press Releases: pr[at]payoutmag.com Facebook: Payout Magazine! Facebook: MIKEB! ICQ: 248843947 Skype: Mediaguy1

10-11-2011, 03:05 PM	#4
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	http://www.zip-codes.com/ __________________ I like pie.

10-11-2011, 08:20 PM	#7
acctman Confirmed User Join Date: Oct 2003 Location: Atlanta Posts: 2,840	found it, this is the site I was talking about earlier http://download.geonames.org/export/dump/ http://download.geonames.org/export/zip/ has all zips, cities, states, zones, etc for free and updated regularly for free.