Outcome

Intention

What kind of relationship does Pittsburgh have with its surroundings? While this may be a loaded question with empirical loopholes, its worth noticing that it is human nature to actively go out and change our surroundings only when something passes a personal threshold level of tolerance. While the threshold itself might vary person to person- it does exist. This threshold determines the action we take. The intention is to better understand this region I call my home here in the United States and find its social irritants. What made Shadyside Talk? What makes this University area talk?

Collection

The Data source continued to be the 311 Complaints file sourced from WPRDC:

https://data.wprdc.org/dataset/311-data

What changed however was the the way in which the analysis was conducted. For instance, I found that while SQL increased the possibilities of use of data in analysis on Carto, I am not well versed enough (yet!) to be able to use it effectively. Hence I found data cleaning to be easier in Microsoft Excel. For instance, to better understand the time of day when 311 requests were made, it seemed easier to apply the 'IF' constraint on Excel than SQL.

Analysis

The university area is very interesting in that these are predominantly residential areas with a smattering of commerce that has burgeoned due to the university students who come from all over the world and call it home. The project parameter being to analyse a given data via a 3X3 matrix that tells story, the 311 data was perfect to understand its unique narrative. In this case, the idea was to find out if there were any patterns in the issues of the University Area. Hence I asked the three locations: Shadyside, Squirrel Hill & Oakland, three questions:

1. Which Departments do you think will solve the problem?
2. What media do you find most convenient to use/are aware of?
3. At what time of day do you seem to have/find most of your problems?

Product

The results were as predictable as they were surprising. While on the one hand, most complaints were predictably made in the morning/midday, the number of complaints made from university campuses was almost as robust as that of the residential locations. What was even more fascinating was the clusters that were noticed in the Shadyside data were consistent in that of Squirrel Hill and Oakland as well. The physical distribution of these clusters in more or less uniform and seems to act as a centroid of population density. This made me think that either these clusters are either people from apartments who end up acting as conservators of the neighborhood or there is a glitch in the data set. 

  1. Which Departments do you think will solve the problem?  

  2. What media do you find most convenient to use/are aware of?  

  3. At what time of day do you seem to have/find most of your problems?  

Data Windows

Reflection

I personally found it fascinating to see that despite being a resident of Shadyside for more than a year, it took an open source data set for me to understand my neighbors better. It was humbling to realize that despite the fact that many of us are looking at places that we think we know and we will be surprised. This exercise also marked my introduction to SQL which I am excited to see the potential of, specially with regard to Data Analysis. As for the software, although Carto has given the option to export the visual as an image, it has a very low pixel quality and I might have done better by taking snapshots of the screen. However, to maintain size/shape integrity I deemed it prudent to export the grainy pictures from Carto.