Final Project: The Ideal Neighborhood

In my final project I used Geographic Information System software, ArcGIS, to help a fictitious family find ideal neighborhoods to potentially live in. Mr. Wilson is the name of the dad of the family who reside in a suburb on the outskirts of Seattle, Washington. Recently though, Mr. Wilson has been informed that his business is transferring him to the city of Berkeley, located in Bay Area of Northern California. Mr. Wilson has never been to the Bay Area and knows that moving his family to the right neighborhood will not be an easy task. Since there are a lot of cities located near Berkeley, he knows that he will not have enough time to do all of the research. He has hired me, a freelance GIS specialist, to facilitate the process.

Berkeley is located east of San Francisco in Alameda County. Mr. Wilson wanted me to focus my work on Alameda County because a friend had informed him that its cities have a good variety of housing prices and good public schools. The main downside that his friend warned him of is the number of violent crimes per year in the area. Mr. Wilson informed me that I should research and analyze my data based on his friend’s advice. With this request I researched and analyzed the average school ranking, violent crimes, and average housing prices of each city in Alameda County. I used statistics from the year 2010 to help compare each city. To do the research I used the skills that I have acquired while attaining my degree from UCLA. I scoured the Internet until I found recent information that was reliable. With this information I made three different ArcGIS maps, each one representing one of the aspects Mr. Wilson was looking for in a city. To input the data that I found I used the edit tool bar and started an edit session. Once the edit session was started, I manually inputted the numbers in their respective maps. Once the numbers were finalized, I stopped and saved the edit session. I went through each map and opened up the preferences. From preferences I went to symbology tab, chose category, and made it so different number ranges would be represented by different colors on each map. Once I had the statistics  and three easily readable maps, I placed the maps on one sheet. I also added a North arrow, a scale bar, labels, and a title to make the map presentable.

I presented this map to Mr. Wilson before I did more research and analysis. I told him that GIS gives an objective representation of data and provides a visual representation of the problem we are solving. Ultimately though, it would be his subjective interpretation of the data and the maps that would lead to the choice that he thought best fit the needs of himself and his family. The best city for schools and the least violent was Pleasanton. There were two problems with Pleasanton though; the first was the extremely high housing prices and the second was that it was the farthest city from Berkeley in the county. Fremont is also far, relatively expensive, and relatively lower education ranking than other close by cities. Oakland was instantly crossed off the list because of its extremely high numbers of violent crimes. Hayward would not work either because of the low school rankings. The only cities left were Berkeley and Alameda. Although Alameda had a lower violent crimes number, Berkeley had cheaper housing and a better education ranking. Mr. Wilson decided that Berkeley was the winner because it had two out of the three criteria that he had set for a perfect city. 

With Berkeley as the choice of city, it was time for some more in depth spatial analysis. I asked Mr. Wilson to choose the paramount neighborhood detail he did not want his family to live near and the one  that he wanted. He chose Registered Sex Offenders as something he did not want to live near and local parks as something that he did want to live near. He told me that he chose registered sex offenders as something he did not want to live by because of Berkeley’s crime numbers in 2010; conversely, he chose parks to live by because he loves playing ball with this two sons. He told me that he did not want to live within 2,000 feet of a registered sex offender but wanted to live within 1,000 feet of a park. With this information I went to work again in GIS in order facilitate my spatial analysis of Berkeley. 

I did more research and found the name and address of every Registered Sex Offender living in the City of Berkeley from the City of Berkeley Police Department website. I inputted this information into an excel sheet, separating the name, address, and zip code into different columns. Once I finished the excel sheet I opened ArcCatalogue and exported the data into a dbf file. Then I right-clicked in ArcCatalogue and chose create address locator. I chose to create one that found both the address and zip code because that information was present in my newly created dbf file. I imported the dbf file into ArcMap and activated my address locator. Then I clicked on view Tools then Geocoding; geocoding allows me to take the information that was present on the dbf file and visualize the data, in order to perform spatial analysis with the GIS software. Once I had all of the address from the dbf file geocoded, I added a 2,000 feet buffer zone around them by using the buffer tool in the toolbox menu. This allowed me to see all of the neighborhoods in Berkeley that were not within 2,000 ft of a sex offender and thus suitable for the Wilson family. The next step was to add parks. The city of Berkeley has free GIS data to download and the city’s parks were available. Once I downloaded the parks I imported them into the GIS to match them up with the streets. I then added a 1,000 feet buffer zone around each park. To finalize my spatial analysis of Berkeley I put the both sets of buffer zones on the same map. This created a simple visualization to easily analyze the best neighborhoods where the Wilson’s could live near a park while avoiding registered sex offenders. I found three top neighborhoods that worked. I then zoomed in on these neighborhoods and made them presentable, labeling the streets and parks. I gave Mr. Wilson the maps and he thanked me for the great work. Mr. Wilson had narrowed down the neighborhoods that he liked without even visiting Berkeley. Now when he did visit he knew exactly where to look to find the right house and could be efficient with his valuable time.

The use of Geographic information systems (GIS) in solving important problems in our society is augmenting rapidly. In this case, GIS’s ability to spatially analyze substantially facilitated Mr. Wilson’s moving process. At first he was looking at possible neighborhoods in a whole county. Doing the research on every good neighborhood in each city would have been a long and arduous process. Research in congruence with GIS data allowed me to go from a plethora of cities and possible neighborhoods to three ideal neighborhoods for Mr. Wilson and his family. Although I could have further spatially analyzed all of the final neighborhoods, there are limitations to this process. The deeper you go into spatial analysis, the more questions of invasion of privacy are introduced; data could be acquired to analyze each neighbor’s house, their profession, information about their children, and more, until the perfect house for sale in the most ideal neighborhood was found. In this project though, this was not the case. I used GIS in a responsible way to help the average citizen with a very hard decision. Overall, GIS greatly helped Mr. Wilson and his family and will continue to be used to solve some of the formost problems of our time.

References:
http://www.census.gov/geo/www/tiger/http://www.ci.berkeley.ca.us/police

http://www.ci.berkeley.ca.us/ContentDisplay.aspx?id=55708

/http://www.rereport.com/alc/

http://school-ratings.com/counties/Alameda.htmlhttp://www.neighborhoodscout.com/ca/berkeley/crime/
http://www.neighborhoodscout.com/ca/oakland/crime/
http://www.neighborhoodscout.com/ca/alameda/crime/
http://www.neighborhoodscout.com/ca/pleasanton/crime/
http://www.neighborhoodscout.com/ca/hayward/crime/
http://www.neighborhoodscout.com/ca/fremont/crime/

Lab # 7: Spatial Interpolation

The purpose of this lab was to practice and learn spatial interpolation techniques in ArcGIS. In this lab Los Angeles County wants to compare and analyze its precipitation levels from the current season to the average and has hired me to create a series of maps to present this information. Los Angeles County was nice enough to put its precipitation data from the county’s Water Resource department on the web and thus greatly facilitated the process of retrieving the data.

Spatial interpolation can be used in useful ways when attempting to extend and analyze spatial data. Interpolation is the process of predicting the values of locations that lack sample points. It measures the relationship between objects using spatial autocorrelation and spatial dependence principles. Once the sample point’s data is found it can predict the data in the remaining area. In terms of rainfall, counties will analyze their cities that are experiencing drought and which have a healthy supply of rain. Spatial interpolation facilitates the county’s ability to make good estimations of total precipitation levels from a relatively small set of sample points, which greatly facilitates the decision process.

The maps of Los Angeles County precipitation levels show that the majority of it received similar rainfall as the normal. East Los Angeles County received more rainfall than normal as well as the western tip and the south. Inland to the north western tip showed lower rainfall than normal. To use spatial interpolation on this map I used the IDW and Spline methods. Spline makes estimations of the cell values by using math to minimize the surface curvature. The result of this is a smooth surface. Inverse Distanced Weighted (IDW) is best when the set of points is dense and can capture local surface variation. It determines the values of each cell by using the sample points. IDW worked in this case, but I do not think it was the best method because of the size of Los Angeles County. When looking at the spread of precipitation throughout the county, the spline spatial interpolation method shows more detail. The IDW has large areas that show the same precipitation levels while in the Spline map, the precipitation levels are shown with more variation throughout the county over smaller areas. The more detail found on the spline map is why I believe that it was the best spatial interpolation method to use in this case.