I need a report, by major metropolitan area ,by each state, that
contains the following in simple format. If this can be in an excel
sheet - that is preferable.
For each state, total population size, the list of all metropolitan
areas by state as a sub-catagory, the name of each metro area, total
population size of each metro area,the population size not in metro
areas for each state, income levels of residents by state and
seperate for each metro area broken dowm by levels (i.e. % or # under
$50,000; $50,000-$100,000; $100,000- $150,000; over $150,000 ). The
income breakout catagories could be different if that is what is
available.
If this is not readily available - will consider options based on what
is easily obtainable - I think the Dept of Labor or Census data may be
potential sources. |
Request for Question Clarification by
rainbow-ga
on
19 Nov 2006 23:06 PST
Hi environ,
I have been working on your question and want to let you know of my progress.
I have compiled, in an excel sheet, the list of the states and their
corresponding Metropolitan Statistical Areas (MSA). Finding the
population for each is not a problem until some MSA's overlap into
different states.
For example:
Huntington-Ashland, W.Va.-Ky.-Ohio
In such cases, I have to find the counties each of these MSA's consist
of and then locate the population for each county. I have begun
working on this.
The following is an example of one state I have completed so far (with
no overlapping MSA's). Please let me know if this is the information
and format you are looking for:
POP.
ARIZONA 5,939,292
Flagstaff, Ariz. 123,866
Phoenix-Mesa-Scottsdale, Ariz. 3,865,077
Prescott, Ariz. 198,701
Tucson, Ariz. 924,786
Yuma, Ariz. 181,277
Remaining Areas 645,585
I have not yet begun looking for income levels for the requested
areas. I am sure I will come across obstacles since I doubt this
information is readily available. Anyway, I will let you know as I go
along.
Looking forward to hearing your views.
Best regards,
Rainbow
|
Clarification of Question by
environ-ga
on
20 Nov 2006 04:22 PST
You are certainly on the correct track - adding income levels is
critical but you can take some liberties and can be off a county or
three.
Maybe the census or labor dept can be a source for the income levels.
Thanks you.
You can also send me the report in two phases - population and metro
areas and later the complete report that includes the income levels.
Regards
Rob Trow
|
Request for Question Clarification by
rainbow-ga
on
20 Nov 2006 06:31 PST
Hi Rob,
I have finally located the required data. Now it's a matter of
compiling and formatting as you have requested. I will hopefully have
this completed in the next day or so.
I hope this does not cause you any incovenience.
Best regards,
Rainbow
|
Request for Question Clarification by
rainbow-ga
on
20 Nov 2006 13:17 PST
Hi Rob,
I need to clarify one point with you:
Since some MSA's overlap into one or more states, the number of those
in income levels for the MSA's will not always correspond to the
number of those in the same state.
For example:
TOTAL in HOUSEHOLD
MASSACHUSETTS 2448032
Barnstable Town, Mass. 100254
Boston-Cambridge-Quincy, Mass.-N.H. 168231
Pittsfield, Mass. 54580
Providence-New Bedford-Fall River, R.I.-Mass. 614431
Springfield, Mass. 265188
Worcester, Mass. 284040
Therefore, please note that for the MSA of Boston-Cambridge-Quincy,
Mass.-N.H., the household number is both those located in Mass. and in
New Hampshire. The same is true for Providence-New Bedford-Fall River,
R.I.-Mass.
Best regards,
Rainbow
|
Clarification of Question by
environ-ga
on
20 Nov 2006 14:56 PST
This is fine - your are on the correct path - take the time you need.
Regards
Rob
|
Hi Rob,
At the following url you will find an excel file with the requested information:
http://download.yousendit.com/0DC7190C771912A1
This file, which is available for you to save and download, will
remain on the server a limited period, so please download it as soon
as possible.
For some reason the income data for the following 3 MSA's is not available:
Hinesville-Fort Stewart, Ga.
Lewiston, Idaho-Wash.
Carson City, Nev.
Also please note there is a slight margin of error for the income
data. (Source: U.S. Census Bureau)
I usually describe my search strategy but to explain how I was able to
compile the information is much too complicated. :-)
However, the information was compiled mainly with the data available
at the U.S. Census Bureau from the following sites:
http://factfinder.census.gov/servlet/GCTTable?_bm=y&-geo_id=01000US&-_box_head_nbr=GCT-T1-R&-ds_name=PEP_2005_EST&-redoLog=false&-mt_name=ACS_2005_EST_G00_GCT2001_US9&-format=US-9S
http://www.census.gov/population/estimates/metro_general/List4.txt
http://www.census.gov/popest/counties/CO-EST2005-01.html
http://factfinder.census.gov/servlet/DCGeoSelectServlet?ds_name=ACS_2005_EST_G00_
I hope the information provided is helpful. If you have any questions
regarding my answer please don't hesitate to ask.
Best regards,
Rainbow |
Request for Answer Clarification by
environ-ga
on
21 Nov 2006 05:06 PST
thank you for the wonderful work - could you make a change so I can
fit it one one landscape sheet - can you combine income levels to teh
following catagories household income under $25, 25,-50, 5o-75,
75-100; 100-150, ove150
Looking to have the report print as a one page accross fit - leave as
many income grouping as possible so long as it can firt one page
across all date
thanks]
rob
|
Clarification of Answer by
rainbow-ga
on
21 Nov 2006 09:38 PST
Hi Rob,
I have formatted the excel file the way you have requested. It is
ready for download at the following url:
http://download.yousendit.com/EB221BE72409C157
Please let me know if this suits your purposes.
Best regards,
Rainbow
|
