Looking for Sample Data set of US States, Cities, Zip codes

Question

Post reply

Looking for Sample Data set of US States, Cities, Zip codes

YSLGuru

SSC-Insane

Points: 21669
More actions
December 14, 2009 at 4:01 pm

#207539

I know there arenumerous subscription services for this info however I'm not in need of something that is kept up to date so much as something to provide a large sample data set of multiple levels of grouping or heirachical relationships that is easy to work with like States, Cities, Zip codes ect.
Anyone know if any such data set that can be accessed for free, something like a cvs file of all the states and all the zip codes is each state???
Thanks
Kindest Regards,
Just say No to Facebook!

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004638 More actions · Answer 1

Do you need accurate data for this or just a large amount of data to play with?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Lowell SSC Guru Points: 323546 More actions · Answer 2

here's one i use regularly:

ZipCityStateCounty.txt

it's a typical thing you find for free, 42K records more or less, in a TAB delimited format i think.

I can tweak it into comma delimited or insert statements with the definition table if you want.

if you want to really play with some data, http://geonames.usgs.gov/domestic/download_data.htm

cleaning up the data and importing all the files there can be a rewarding and learning experience.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lowell SSC Guru Points: 323546 More actions · Answer 3

ok i found an old project i was screwing around with, let me know if you want it;

it's a suite of tables, all inter related with FK's and all that, here's the table names, from which you can kind of infer what it contains:

GEOPLANET

GEOMOON

GEOCONTINENT

GEOCONTINENTAREA

GEOCOUNTRY

GEOSTATE

GEOCOUNTY

GEOCITY

it's got all the US stuff you were probably looking for, and a few countries that i added when i found some data sources for them as well.

let me know and i'll dump the data out to something you can BULK INSERT with, along with the table definitions.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Lowell SSC Guru Points: 323546 More actions · Answer 4

here you go:

GeoProject.zip

this was the product of an afternoon of too much time on my hands...i was surfing Wiki looking at planets when they renamed Pluto to a planetoid, and i started scraping sources to put together a realtionship database for fun.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

YSLGuru SSC-Insane Points: 21669 More actions · Answer 5

Thank you kindly sir

Kindest Regards,

Just say No to Facebook!

YSLGuru SSC-Insane Points: 21669 More actions · Answer 6

Jeff Moden (12/14/2009)
Do you need accurate data for this or just a large amount of data to play with?

Basically just a large set of easy to follow data to test with; for aggregation and grouping and the like. I'm mainly using it is report design (Crystal Reports) and the STATE-CITY-ZIPCODE data set is just easy to follow when troubleshooting report work.

Thanks

Kindest Regards,

Just say No to Facebook!