Midterm Presentation: Chicago Hipster Neighborhood

midterm chicago hipster neighborhood


Chicago Neighborhood Analysis Indicators

Class classification

1. Working class

2.Service Class

3. Creative Class (creative class diagram)

Compared Neighborhood

  • Wicker Park (Creative-hipster subgroup)
  • Pilsen (Working class neighborhood)
  • Englewood (Service Class Neighborhood)
  • Lakeview/Lincoln Park (Established Creative Class Neighborhood)
  • Logan Square (Potential Creative Class Neighborhood)

Chicago Neighborhood Indicators (chicago neighborhood analysis)


  • size
  • ethnic diversity
  • education level (>bachelor)
  • income
  • job

Existing building fabric:

  • typology
  • rent cost
  • house value
  • ownership
  • density

Transport and infrastructure:

  • distance to public transportation
  • traffic flow
  • parking availability
  • bicycle lane

local context:

  • restaurant
  • bar
  • coffee shop
  • grocery shop
  • farmers market


  • residential
  • office
  • commercial

public facility/service:

  • public school
  • safety
  • health

green space:

  • recreational park
  • playground
  • dog park

Comparison Diagram

 chicago neighborhood comparison diagram

calculating bicycle lane percentage over neighborhood


rawdata as
–join the table, #of bike route in a neigh, total length of bike route in a neigh
select n.pri_neigh,
count(s.f_street) as totalroutes,
sum(st_length(s.geom)) as length,
sum(n.shape_area) as neigh_area
from jur_neighborhoods as n
left join cty_bikeroutes as s
on st_within(st_transform(s.geom,3435),n.geom)
group by pri_neigh
limit 100
–divide total lenght of bike route by neigh area
select pri_neigh,
(r.length/r.neigh_area)*100 as percentage
from rawdata as r
group by percentage, pri_neigh
order by percentage


bicycle percentage table

Routing the water path

593 Yikai_4weeks

— 2. create topology
drop table street_vertices_pgr;
alter table street drop column source;
alter table street drop column target;
alter table street add column source integer;
alter table street add column target integer;
select pgr_createTopology(‘street’, 0.0001, ‘geom’, ‘id’); — function create table ‘street_vertices_pgr’
— 1.join building information
WITH building_updated
AS (
SELECT b.id, b.geom, b.bldg_id, b.shape_area, n.pri_neigh, st_centroid(b.geom) AS cen_pt, z.zone_type, b.shape_area*z.zone_type AS water FROM building AS b
LEFT JOIN neighboorhood AS n
ON st_within(b.geom, n.geom) — result table will be called ‘building_center’ or update ‘builidng’
LEFT JOIN zoning AS z
ON st_within(b.geom, z.geom)

— 3. finding nearest pt
AS (
g2.id ::INT4 As node_id,
FROM building_updated As g1, street_vertices_pgr As g2 — g1 = source table ; g2 = target table
WHERE g1.id <> g2.id
AND ST_DWithin(g1.geom, g2.the_geom, 1000)
ORDER BY g1.id, ST_Distance(g1.geom,g2.the_geom)

— 4. routing
AS (
SELECT seq,id1, id2 as node, id3 as gid, route.cost, street.geom FROM pgr_kdijkstraPath(‘
SELECT id as id,
st_length(geom) as cost
FROM street’, 001, array(SELECT “node_id” from building_final), false, false )
AS route
LEFT JOIN street
ON route.id3 = street.id

— 5. Join water usage to route
SELECT SUM(bf.water), r.gid, r.geom
FROM building_final AS bf
LEFT JOIN route AS r
ON bf.”node_id” = r.id1
GROUP by r.gid, r.geom;

Nearest point ref: http://gis.stackexchange.com/questions/3249/postgis-assign-id-of-point-in-layer-a-to-closest-point-in-layer-b

Zoning Reference: http://secondcityzoning.org/

Screen Shot 2014-02-21 at 12.27.42 PM

Screen Shot 2014-02-21 at 1.35.38 PM

Chicago: Worst Traffic Congestion Nationally

A study done in December of 2012 by the Texas A&M Transportation Institute listed Chicago as having the worst traffic congestion. Annually, a driver spends an average of 38 hours in non-moving traffic, while the average is closer to 70 hours in Chicago. Each year this transportation insitute realases an Urban Mobility Report. 2012 Report

Further Traffic Congestion News Headlines

Select Reading Quotes, Further Traffic Congestion News Headlines and Chicago Smart Grid News Headlines

From the above articles, one can see that congestion in Chicago does not only apply to car transportation. Issues are raised about Chicago’s trains, from the freight trains to the ‘El’. A new York Times article claims that freight trains generally can reach Chicago from LA in 48 hours, but can take up to 30 hours to make it through the Chicago. Chicago is widely known throughout the freight industry as America’s speedbump, which would be completely inaccurate if it was the mid-1800’s. New York Times Article

All this being said, Chicago is making strides to decrease congestion, particularly in the public transit systems, replacing much of the red line and the Wells St. Bridge along the North Loop. These changes are yet to show if they make much change, but has caused temporary closings of 3 of the 8 train lines. Some sources even suggest that the addition employees for these projects are not only holding up the transit system, but also the creating more commuters, which creates even more traffic.

Illinois statewide GIS information on traffic can be found on the Illinois Dept. of Tansportation. 2011 traffic data can be found below (on the left).

GIS Transportion Data and GIS Experimentation

GIS Transportion Data and GIS Experimentation

Some research was also done on the new Chicago Smart Grid system, which is an interesting new technology system that tracks and reroutes energy to prevent power outages and reduce the length of power outages when there is one. See below links for further news articles and the Illinois Dept. of Transportation.

CTA Closed for Bridge Construction
Worst Traffic Congestion In The U.S.: Chicago Ranked Most Congested
CTA Riders Feel Effects of Red Line Construction
More jobs means worse traffic congestion
Chicago No. 1 in road congestion
‘Smart grid’ holds promise, but problems await
GE, ComEd sign $200MM Chicago Smart Grid deal
Smart Grid Innovation

Illinois Department of Transportation GIS Traffic Page


Situated Technologies Reading

Week 1 Reading

Situated Technologies Pamphlet Series #3:

Suspicious Images : Latent Interfaces

by Benjamin Bratton & Natalie Jeremijenko

(Section 1 of the Pamphlet, Pages 1 – 53)

download the pdf here

We will discuss this reading on Friday, August 30


“You can’t walk through a design graduate program anywhere in the first world, whether in architecture, interaction design, or media arts, without seeing at least half a dozen beautiful “data smog” projects modeling ambient urban-environmental information in one way or another… There is something great about this, but also something troubling. The danger is that in their spectacularization of information, they in fact distance people…even further from their abilities and responsibilities to understand relationships between the multiple ecologies in which they live, and the possibilities for action that they have… They produce the effect of a “missing expert,” the implicit presumption that somewhere along the line, whether inside a mountain in Wyoming, at the EPA, or through an activist on her bicycle, somewhere someone must be using this interface to actually modulate these things. In this they further distance people from their own ability to look, hypothesize, and act. But in their own way, they are projective images of a parliament of the material public that doesn’t exist yet. The question is…do they provoke the possible emergence of this new form of political engagement, or do they provide an alibi for it never happening because they make it appear that the parliament is already there?”

natalie jeremijenko/NYU environmental health clinic:  http://www.nyu.edu/projects/xdesign/

benjamin bratton:  http://bratton.info/