Geographic Information Systems – TRSP 319 HW 5: Geocoding (Pin-mapping) Create an

Geographic Information Systems – TRSP 319

HW 5: Geocoding (Pin-mapping)

Create an Excel file including these columns: Name, Street Address, Zip Code, State, and City of 10 high schools in sheet 1 of Excel file and 6 universities/colleges (including Morgan State) in sheet 2 of Excel file, in the Baltimore Metropolitan Area.

Download line shapefile of Baltimore City, Baltimore County, Cecil County, Howard County and Harford County from Census.gov.

Add all 5 downloaded shapefiles and excel file to ArcMap. Merge 5 downloaded shapefiles and save it as Your First Name_Merge_County.

Using the Your First Name_Merge_County files, Create Address Locator and geocode the addresses of the 10 high schools and save it as Your First Name_Highschools and 6 universities/colleges and save it as Your Firt Name_Universties compiled in task 1.

Use buffer analysis to identify all the universities/colleges within 5 miles from Morgan State University and create a layer and save it as Your First Name_Universities_5Miles_Morgan.

Use buffer analysis to determine all the high schools with 5 miles from Morgan State University and create a layer and save it as Your First Name_HighSchools_5Miles_Morgan.

Develop a two-color thematic map showing the high schools within 5 miles versus greater than 5 miles from Morgan State University and create a layer and save it as Your First Name_HighSchools_Less_Greater_5Miles_Morgan.

Pack and save your final map containing all layers as Your First Name_HW5 and submit it on canvas.