City/State Database??

CaptainKofu · 09-08-2004, 08:44 AM

Does anyone have a list of major US cities and the states they are located in?

I'm looking for just a 2 column exel spreadsheet or something like that...with city and corresponding state.

Any help would be great.

Pipeline-Webdesign · 09-08-2004, 09:25 AM

http://www.pc-shareware.com/zipcode.htm

??

littleFella · 09-08-2004, 09:39 AM

Quote:

Originally Posted by CaptainKofu

Does anyone have a list of major US cities and the states they are located in?

I'm looking for just a 2 column exel spreadsheet or something like that...with city and corresponding state.

Any help would be great.

I can send you a database of US zip codes. The table contains City/State/ZIP, current as of 1999.
What format?

littleFella · 09-08-2004, 09:41 AM

oops, I guess it's obvious you need it in Excell.
The database contains over 42K records.

Pipeline-Webdesign · 09-08-2004, 09:51 AM

can i see that database?

littleFella · 09-08-2004, 10:10 AM

Quote:

Originally Posted by Pipeline-Webdesign

can i see that database?

only if I know where to mail it. The size of zipped excell format is about 850KB

Pipeline-Webdesign · 09-08-2004, 10:19 AM

MichaelF[at]pipeline-webdesign.com

littleFella · 09-08-2004, 10:27 AM

mail sent with subject line "zip codes"
attachment included.

Pipeline-Webdesign · 09-08-2004, 10:28 AM

thank you

CaptainKofu · 09-08-2004, 11:51 AM

Quote:

Originally Posted by littleFella

oops, I guess it's obvious you need it in Excell.
The database contains over 42K records.

That would be amazing...could you send it to me

info[at]knowledgebed.com

Thanks littleFella!

seo newbee · 09-08-2004, 12:17 PM

oh wow, i can imagine that will be extremely helpful to anyone building a region-based site

littleFella · 09-08-2004, 05:09 PM

Quote:

Originally Posted by CaptainKofu

That would be amazing...could you send it to me....

done, happy reading

hatchet · 09-09-2004, 01:48 AM

Hey littleFella - I could also use that if you don't mind.
builder AT construction-resource DOT com
Greatly appreciated.

littleFella · 09-09-2004, 04:43 AM

hatchet · 09-12-2004, 06:36 PM

littlefella, I never did get that email. Sorry to ask you to send it again..

littleFella · 09-12-2004, 07:46 PM

Hey, no problem. I found something even better. Click around, you'll find lots of goodies.
Also some US Census records are very useful (include Counties)

If you still prefer my file, leave a note here.

hatchet · 09-12-2004, 08:04 PM

Hey.. don't worry about it..
I found a class to search for zipcodes and distances between - which includes the file also. Thanks though.

hatchet · 09-12-2004, 08:15 PM

wow.. totally missed your post littleFella

The one I found has just the zipcode, latitude, and longitude.. then includes a class to access the database. You can search for distance between zipcodes, or find zipcodes within a certain distance of a zipcode.
If anyone else is interested - http://www.sanisoft.com/ziploc/

thebassman · 09-12-2004, 08:17 PM

another good site for info like this is http://www.melissadata.com/Lookups/index.htm

littleFella · 09-12-2004, 08:46 PM

Quote:

Originally Posted by hatchet

If anyone else is interested - http://www.sanisoft.com/ziploc/

Thanks, all of them will be of use to me. Whenever I get a ZIP database I run a quick compare against what I have and then I suck in the records I don't. This way my database has over 47K record, but not all have geo-locations.

A file like that bought from USPS was over $100 the last time I checked.

Now, if I could inexpensive driving directions software to plug into my programs that would make me happy.