Chicago Urban Migration-Wigdan Al-Guneid,Sakshi Aggarwal

OBJECTIVE

Obtain the relationship between the quality of neighborhood and the migrations of people of people to them. Through the analysis of attributes such as health care, education, transportation accessibility, and crime rate, we were able to indicate the popularity of a neighborhood and wither some attributes are more important than others in ranking the value of a property. Our analysis will be focusing on the relationship between housing value in 6 main neighborhoods from different location of Chicago and amount of people who relocated from or to them.

The neighborhoods chosen are:

-China Town (District 31)

-Hyde Park (District 41)

-Lincoln Park (District 7)

-Logan Square (District 22)

-Garfield Ridge (District 56)

1- The data available with us should be translated into maps that illustrate the quality score for each of the chosen neighborhoods.

2- The analysis of the data should be driven from maps that are done using the CSV files, and shape files downloaded from Chicago website.

Using the Software QGIS, PG Admin will help in driving maps with analysis of Chicago neighborhoods.

In order to understand the pattern of migrations within the neighborhood’s of Chicago, the study had to include a method of scoring the quality of a neighborhood. A quality would be driven from series of calculations and equations that will be translated later into queries in PQ Admin II then into maps.

EQUATIONS

School Equation

School safety score+ family involvement score+ Parent engagement score+

College eligibility+ college enrollment

______________________________________             = School Score

5

Hospital Equation

Accessibility of hospitals+ number of hospitals

______________________________________= Hospital Score

2

Accessibility Equation

School safety score+ family involvement score+ Parent engagement score+

College eligibility+ college enrollment

___________________________________________________________= Accessibility Score

5

Neighborhood score Equation

Home value index +School Score +Hospital Score + Accessibility Score +

___________________________________________________________= Quality of

Neighborhood

4

TABLES & MAPS

After   checking the accuracy of the data in the tables that are done with POST ADMIN II, queries were made to connect the tables we have to the QGIS .This step is important in order to match the data to the shape file of the neighborhoods of Chicago city.

After making the maps, analytic comparison driven from the visual information in the maps, and also from the value of the quality averages driven from the neighborhood’s score equations.

Summary:

The quality scores showed that the higher quality neighborhoods were Lincoln Park, followed by Logan Square, Garfield Ridge, Hyde Park, China Town, and Avalon Park.

This conclusion however, matched the Real Estate value of Lincoln Park and Logan Square, and Avalon Park only. Hyde Park and China Town had different real-estate values that didn’t correlate necessarily to the neighborhood quality.

This led us to a conclusion that there are other reasons such as ethnic backgrounds of populations living there. China Town is a neighborhood that is heavily populated with Asian communities, Same as Hyde Park that is also heavily populated with African Americans.

The study was only focusing on amenities that a neighborhood would offer and if they would affect the decision of selecting a neighborhood or not.

Advertisements

One thought on “Chicago Urban Migration-Wigdan Al-Guneid,Sakshi Aggarwal

  1. Pingback: Chicago Urban Migration-Wigdan Al-Guneid,Sakshi Aggarwal « wigdanguneid

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s