In early January students in Harrisburg University’s Applied Geographic Information Systems (GIS) class were notified of the course requirement for a semester long applied GIS project. This course builds on the freshman year Introduction to GIS class and encourages students to explore unique and practical ways to apply GIS technology. Students at this level in the Geospatial Technology program are encouraged to find opportunities to collaborate with outside organizations that could benefit from their work. A mapping component to Digital Harrisburg rose to the top of this list of collaborative projects. Two Harrisburg University Geospatial Technology students volunteered to work with Messiah College to create the base map of turn of the 20th century Harrisburg for 1900 US Census data to be displayed within. The following base map development and census data mapping methodology was applied to the project.
Step 1: Obtain 1901 atlas map plates and 1900 census data in digital form
The Messiah College Digital History Professor David Pettigrew conducted the research into available maps of the late 1800’s to early 1900’s time period. After review of various sources, including several time periods of Sanborn Fire Insurance Maps, the 1901 Atlas was located and provided by the Dauphin County Historical Commission. This atlas was compiled from plans, deeds, and surveys and published by the Harrisburg Title Company. The commission already had archived digital raster images of the atlas index plate (figure 1) as well as 21 individual map plates (figure 2) spanning the extent of the city at that time. These files were shared with HU students via a Dropbox folder. Details such as building/property owner names, property frontage dimensions and addresses were included in the detailed plates. The average file size for the high resolution images was 6 to 10 Megabytes. A compiled spreadsheet containing all census records and attributes was also provided from Messiah College by the Digital History students.
Figure 1: Harrisburg Title Company Atlas of Harrisburg 1901, Index map
Figure 2: Detailed individual plate view showing detail including address ranges
Step 2: Georeference 1901 Atlas maps to 2014 street network using ArcGIS
The 21 individual atlas map plates were divided between two HU students to be georeferenced to the current 2014 Dauphin County Street network which was provided by the Dauphin County GIS Department. The georeferencing process required the students to first identify the extent of the historic map plate and center the ArcGIS base map to the same location. Once centered the students second task was to work with the ArcGIS Georeferencing toolbar (figure 3) to rotate, scale and shift the raster map to obtain the best alignment with the current city base map. This process primarily relied upon the city street network but aerial photos, a Susquehanna River layer and even google maps were used as additional reference information for the alignment. The third and final georeferencing process required the students to create links for coincident features between the historic raster map and the 2014 street network. These links were created from Intersections that were depicted on the 1901 atlas maps to the current street intersections. Only roads that maintained the same relative alignment between 1901 and 2014 were used for link placement. As can be seen below (figure 4) the center point of non-developed intersecting street spaces on the 1901 maps were aligned with 2014 intersections.
Figure 3: ArcGIS Georeferencing tool bar
Figure 4: 1901 atlas plate aligned to 2014 street network (shown in red)
Step 3: Recreate the street network for Harrisburg in 1901 based upon raster atlas maps
The primary challenges to georeferencing the 1901 maps was the addition, removal and realignment of streets over the last 113 years. In many areas of the city a dramatically different street network exists today, particularly in the south end where Interstate 83 and its exit/entrance ramps have been built. With the end goal of locating all of the 1900 city census data records by address the 1901 street network needed to be recreated in digital form. Students began this process by first removing all 2014 street/highway centerlines that did not exist in 1901. This relatively straight forward process was completed quickly however the second step required the students to digitize streets from the 1901 maps that were not present into a version of the 2014 street network, or had a radically different alignment. Figure 5 depicts a region of the city where the street network has changed. During this process the students also updated the 2014 street attribute table to include address ranges from 1901 for both left and right sides of streets. Figure 6 depicts the street attribute table and address range details. NOTE: This digitizing process is currently underway.
Figure 5: Map depicting Strawberry Square which is now connected buildings without streets)
Figure 6: Street network attribute table
Step 4: Geocode records extracted from Ancestry.com by Messiah College Digital History students
To place the digital census data on the newly created 1901 map of Harrisburg each census record with a valid address must be geocoded using street network reference sources containing address ranges. A geocode field (Figure 7) was created in the Census data spreadsheet, provided by Messiah College, by concatenating the address and street fields. Geocoding generates an x,y coordinate along the left or right side of a the appropriate street segment. The inherent challenge to this process is the absence of a street network with historic address ranges. The creation of the 1901 street network with address ranges (Step 3 above) is currently underway. A second challenge to geocoding was identifying a current street network with complete address range information that could be merged with the streets from 1901. The most up-to-date street network is maintained by the Dauphin County GIS department however a significant number of the streets do not include a portion of the required address range data for geocoding. The county does have a much more complete set of address data stored at the property level however many property boundaries have changed over 113 years which prohibit accurately locating historic addresses. The solution to these challenges was to geocode the 1900 census data in the following incremental fashion:
1) Geocode ~ 28,000 census records using the incomplete Dauphin County centerlines
- This process located ~ 15,000 records (Figure 8 depicts these results)
2) Geocode the remaining ~13,000 census records using the ArcGIS online geocoding service
- This fee based service was reserved for the second pass to limit expense
3) Geocode any remaining records using the 1901 street centerline data created in step 3
- This process will be run on the entire dataset and compared to the results above
- This step is on hold pending completion of the 1901 street network
The results of all incremental geocoding steps will be reconciled and merged into a final layer of census record locations. Initial geocoding results can be seen in figure 8 and 9. It should also be noted that a significant number of the digital census data records were either not located or miss-located due to missing or incomplete address data.
Figure 7: Concatenated address field from census records
Figure 8: Initial geocoded census records at the citywide level
Figure 9: Initial geocoded census records at the block level
Step 5: Initial visualization of key census data attributes (race, ethnicity, etc)
Using ArcGIS’s Layer Property Symbology editor students are able to select attribute based categories to symbolize each census record. Figure 9 depicts the ArcGIS Interface for editing symbology. By selecting the attribute field that contains values for visualization users are able to specify unique symbols for each unique or categorized value. Figure 10 shows unique point symbology for race in the first block of Walnut Street. It is important to note that the census records relate to individuals so in most cases multiple individuals who live at the same address have points stacked directly on top of each other. Using GIS each unique address can be given a count value for the number of individuals residing at that address and the count can then be used to create point symbols of graduated sizes based upon number of residents.
Figure 10: ArcGIS Layer Properties interface showing attribute field based symbology
Figure 11: Census records symbolized by race
Step 6: Future: Move geocoded points to lie within historic building/property boundaries
The geocoded Census data provided a realistic visualization of the demographic distribution in 1900 Harrisburg however the exact placement of these geocoded records, while placed within the correct city blocks, are not always aligned with the correct property boundary and/or building footprints. A significant effort is still required to physically move the location of these geocoded records into the extents the 1901 properties/buildings. One HU Geospatial Technology program student has indicated an interest in continuing this project during his Junior year. Undoubtedly many of the building extents have changed over the years but properly locating these records to the 1901 buildings will very likely allow the vast majority of them to be spatially linked to the current property extents, thereby establishing a baseline for future census data to be more accurately geocoded and compared to current demographics.
Step 7: Future: Additional visualization
Now that the 1900 census data records have initial locations relative to city blocks, and the potential to be accurately aligned with property boundaries, many different historic visualizations are possible. Using GIS display capabilities combined with the census record attributes interested historians can peer into the details, density and distribution of historic demographic factors such as race, ethnicity, literacy, and occupation. A completed digitization of the 1900 census and subsequent census years can be processed by students in a similar manner. These future GIS datasets will allow trend analysis to be performed in GIS shedding further light onto the demographic dynamics of Harrisburg.