Hi freen,
Here you go, I believe I have found just what you are looking for -
it's an interactive table, so you can have as much, or as little
information, as you need. I've taken out a few exerpts, but read down
the entire webpage to see what is available. There's also a lengthy
discussion about relating Zip Codes to Geographic Areas with an
explanation of ZCTA (Zip Code Tabulation Areas).
MISSOURI CENSUS DATA CENTER: The ZIP Code Resources Page
Tools and Resources Related to U.S. ZIP Codes:
"This version focuses on the Census Bureau's new (for 2000) ZIP
Census Tabulation Area (ZCTA) codes, close cousins of ZIP codes. As
in the earlier version, we place special emphasis on tools for linking
ZIP (/ZCTA) codes to other geographies (such as counties, cities,
metro areas) and to demographic information from the latest decennial
census."
"The Missouri Census Data Center has created a directory on their
public census data server which has a complete set of geographic
header data as distributed with the Summary File 1 data from the 2000
census. These header records have information about the geographic
entities summarized on the SF1 data files. There are a great many such
entities, and they range from state and county level records all the
way down to 2000 census blocks. There are over 9 million of the latter
entities nationwide."
TABLE: Listing of Extracted Data (example of what you can make).
http://mcdc2.missouri.edu/webrepts/geography/ZIP.resources.html
1) Data Extractor:
http://mcdc2.missouri.edu/cgi-bin/broker?_PROGRAM=websas.uex2dex.sas&_SERVICE=appdev&path=/pub/data/sf12000/xxgeos&dset=akblks&view=0
"The MABLE/Geocorr web application... allow[s] you to dynamically
generate files and reports that show how various geographic layers are
related to one another. For example, you can choose one or more
states as your geographic universe of interest and then ask the
program to show you how ZCTAs within those states relate to just about
any other geographic layer you can think of. Want to see how ZCTAs
relate to counties? Easy. How about census tracts, school districts,
108th congressional districts or the latest urbanized areas? All
easy."
http://mcdc2.missouri.edu/webrepts/geography/ZIP.resources.html
2) MABLE/Geocorr2K: Geographic Correspondence Engine with Census 2000 Geography
http://mcdc2.missouri.edu/websas/geocorr2k.html
Demographic Data for 2000 ZCTA Codes: Tabular Data on 2000 Summary Files:
"The Census Bureau created detailed demographic summaries for ZCTA's
(both complete and within county) as part of their 2000 Summary File 1
and Summary File 3 data products. These are very large collections of
detailed tables that you might have occasion to use if you have a
specific item of interest that requires you to go deeper than what
most users will want to go. There are, for example, over 16,000 cells
of tabular data for every ZCTA on Summary File 3. You're probably
going to want this boilded down to something more readily accessible."
"Fortunately, you will probably never have to get involved directly
with the Summary Files. Both the Census Bureau and the Missouri Census
Data Center (MCDC - where the author works) have created demographic
profile products which take these thousands of data tables cells and
boil them down into a few hundred key data items, which are then
presented in easy to read reports. You can view these data one ZCTA at
a time in your browser, or you can access data files that have the
boiled-down data available for all ZCTA's in formats that can be
readily loaded into a spreadsheet or database access package (e.g.
Excel or Access)."
http://mcdc2.missouri.edu/webrepts/geography/ZIP.resources.html
3) MCDC Demographic Profile 3 index Page for United States ZIP Code
Tabulation Areas:
http://mcdc2.missouri.edu/websas/dp3_2kmenus/us/ZIP_Codes/
>>>>>>
Additional Links of Interest
4) Michigan ZIP Codes-Census Tracts Correspondence:
Search by:
County
Zip Code
Place
MSA or CMSA
PMSA
Urbanized Area
Congressional Districts
www.childrensboard.org/PDF/ 2000%20zip%20tract%20doc%20v2.pdf
>>>>>>
5) The FFIEC Geocoding System allows you to retrieve Metropolitan
Statistical Area (MSA), State, County, and Census Tract codes for
street addresses.
http://www.ffiec.gov/geocode/help_1.htm
FFIEC Geocoding System
http://www.ffiec.gov/geocode/default.htm
>>>>>>
6) METROPOLITAN AND MICROPOLITAN STATISTICAL AREAS AND COMPONENTS, 2003, WITH CODES
http://www.census.gov/population/estimates/metro-city/03mfips.txt
DEMOGRAPHIC PROFILES BY ZIP CODES:
http://mcdc2.missouri.edu/websas/dp3_2kmenus/us/ZIP_Codes/
DEMOGRAPHIC PROFILES BY MSAs:
http://mcdc2.missouri.edu/websas/dp3_2kmenus/us/Metro_Areas.html
>>>>>>
The ZIP Code Resources Page:
Tools and Resources Related to U.S. ZIP Codes:
http://www.oseda.missouri.edu/jgb/ZIP.resources.html
Standard Metropolitan Statistical Areas (MSAs):
State / City / SCF (Sectional Center Facility, first 3 digits of Zip):
http://www.prospectsinfluential.com/support/msa.shtml
>>>>>>
CENSUS GEOGRAPHY
"One area of geography not considered census geography are postal
codes or zip codes. The Census Bureau does report data in STF3 by zip
e but does not collect data by this geographic level. In addition zip
code level data is reported at least a couple of years post release of
other censes data."
http://www.uic.edu/sph/dataskills/skillbytes/census/census9.htm
Census Geography and Using Census Files:
http://staff.washington.edu/glynn/censusgeog.pdf
>>>>>>
I hope you find at least one of the websites suitable to your needs.
If not, or if you have any questions, please post a clarification
request before closing/rating my answer and I'll be happy to respond.
Thank you,
hummer
Google Search Terms Used:
"census tract" "zip codes"
"Metropolitan Statistical Areas" "zip codes"
msa "zip codes" |
