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.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/
No comments:
Post a Comment