Team Name:Team 6
Metric: The neighborhood that has the highest population, with the lowest crime rate and the best trees is the best neighborhood.
Group Members: Justin Booth, Isaac Bredbenner, Kevin Fung
Emails: JDB201@pitt.edu, IEB7@pitt.edu, KLF95@pitt.edu
Data Sets: Police:https://data.wprdc.org/dataset/uniform-crime-reporting-data The police data set shows all the crime incident reports in all the neighborhoods around Allegheny County. It tells of the locations and the incidents reported at said locations. Is a great way to tell what the safest neighborhood is.
Trees: https://data.wprdc.org/dataset/city-trees/resource/1515a93c-73e3-4425-9b35-1cd11b2196da This data set about all the trees in Pittsburgh contains a lot of relevant and useful information. It includes the type of tree, height and width, as well as the location (street name, neighborhood, even different police and fire zones). It also has the benefits in dollar values for different categories, such as electricity and gas energy benefits or stormwater benefits.
Population:https://data.wprdc.org/dataset/c6265ffb-c86e-4a2c-870b-1aaa0772c449/resource/d53bfc16-9518-4c5b-b102-847654dabe21/download/employment-status-for-the-population-16-years-and-over.csv this data set is about hte population in Pittsburgh. It contains the total population in each neighborhood and gives us an understanding of what neighborhoods are the most and least populated.
Abstract: We determined Squirrel Hill North as the best Neighborhood since it is 4th best in population, 4th best in trees, and is only the 29th highest in crime rates. From this it is easy to see why it is the best it has the best population to crime ratio and has some very nice trees in the area.