Wednesday, August 31, 2011

Courtyard Apartments- Graphs and Charts!

When you're working with about 200 buildings it's natural to organize them into a list.  And of course, if you're making a list why not use Excel?   And as long as it's in Excel why not generate a few pie charts and line graphs?  And why not import that table into a free geocoding site and see what kind of maps it comes up with?  

Anyway, it was only a matter of time before I could inflict some abstract illustrations on the viewing public.  I believe I've already included a distribution map in an earlier post, but sometimes it's hard for me to stop fiddling.  

The above maps are good representations of the distribution of the various types of courtyard apartments.  The map to the left uses individual markers for each address, while the one on the right uses pie charts of various sizes to represent building clusters and distribution of types within the cluster.  Both clearly show the dominance of the U-Court building.  Not bad for free maps from BatchGeo.

Above a more comprehensive pie chart from Excel showing the courtyard type breakdown much more clearly.  Yep, the U-Courts win.  L-Courts are a distant second.  

But I'm also looking at the construction dates for these buildings.  Nice to know Excel can do such an clear chart showing total buildings by year and by type breakdown.  Took me a bit to figure this out, but I think it's worth it.  Still trying to get the total building counts placed at the top of the column...   Anyway, it's interesting to show that all building didn't end with the onset of the Great Depression.  Not until after 1933 does construction of these types appear to cease.

Click to actually read these numbers.
One of the things that I'm interested in showing is how drastically the density in Rogers Park increased during the time in which the courtyard apartment colonized the neighborhood.  Sure, the Census figures (and the Local Community Factbook) show that Chicago's population increased 150% between 1910 and 1930,  but the population of Rogers Park increased more than 800%.

Farwell between Greenview and Glenwood
It helps to illustrate the change with a snapshot of the block of Farwell bounded by Glenwood and Greenview.  The du/ac notation above indicates dwelling units per acre.  Coincidentally, it shows almost exactly an 800% increase.   

OK, that should do it for charts and diagrams, at least for the moment.

No comments:

Post a Comment