Demographic Maps

Discuss new retail, dining, business and residential projects in Jefferson County, Lincoln County, and Franklin County, Missouri.
Through the miracle of Excel macros and VBA programming, I've transferred the data from the fields in profiles for each zip code in the STL metro area into excel, and have been plotting some of the data. I can use Excel 3D mapping by zip code to look at data, or I can do an x/y scatter plot by zip code by distance from STL city hall. Or some other creative plots. If anyone has a plot they'd like to see from this data, reply here and I'll try to create it.

Here are the fields I have for each zip code in STL Metro:

Stl City Hall Lat
Stl City Hall Lon
Zip Latitude
Zip Longitude
Dist to Stl City Hall
Stl City or Stl County
Population Change Since 1990
Population in 1990
Population Increase Count since 1990
Population Density
Population Density 1990
Population Density Delta
Never Married
Number of households
Average Household Size
Median Age
Income and Jobs
Median Household Income
Average household Income
Per capita income
Median Disposable Income
Average Total Household Expenditure
White Collar Jobs
Blue Collar Jobs
African American
Native American, Eskimo, Aleut
Asian / Pacific Islander
Hawaiian / Pacific Islander
Not B or W
Less than 9th Grade
Some High School
High School Graduate
Some College
Associate Degree
Bachelors Degree
Graduate Degree
Average January High Temperature
Average January Low Temperature
Average July High Temperature
Average July Low Temperature
Annual Precipitation
Earthquake Risk
Weather Risk
Air Pollution Index
Total Crime Risk
Personal Crime Risk
Property Crime Risk
Average Home Sale Price
Homes Owned
Homes Rented
Vacant Homes
Median Dwelling Age (Years)
Median Years in Residence
Annual Residential Turnover
Median Travel Time to Work
Transportation to Work: Public
Transportation to Work: Drive / Carpool
Transportation to Work: Walk / Bike / Other
Transportation to Work: Work at Home

Here is an interesting example of % ethnicity breakdown within each zip code area, if you leave out whites completely. If I hover over each zip code area in XL, it gives me actual counts in a pop up text box. Or I can show actual counts as colored bars heights, but it gets kind of busy.

Non_White_STL_Metro_Map by Gary Kreie, on Flickr
This map shows actual counts of two ethnic groups to give a better idea of the proportion. And the following one adds whites.

ImageAfrican Americans and Hispanics by Zip Codes STL Metro by Gary Kreie, on Flickr

ImageCounts White African American and Hispanics by Gary Kreie, on Flickr
Here is a map of relative air pollution for the STL metro area by zip code. shows pollution in terms of % of US average. The lowest air pollution is 73% of the US average at zip code 63383 in Warrenton, and the highest is 145% of the US average at zip code 62009 in McCoupin County in Illinois. To spread the delta between lowest and highest bars for this map, I subtracted 73 from each index number to drive the Warrenton number to zero and let the program scale the delta of 73 to 145 over the range 0 to 72 for the map. (145-73=72)

ImageRelative Polution in St. Louis by Gary Kreie, on Flickr
Saw this piece on the the St. Louis Chamber of Commerce goal to get the St. Louis region into the top 10 most educated regions. ... 01550.html

Here is a map of education attainment for zip codes in the metro area.
ImageEudcation Counts St. Louis Metro by Gary Kreie, on Flickr