Research Symposium

24th annual Undergraduate Research Symposium, April 3, 2024

Ibraheem Saqib Ellahi Poster Session 5: 4:00 pm - 5:00 pm/306


3c348207-8536-429a-9430-2dcc94c35276.jpg

BIO


I'm Ibraheem, a freshman from Pakistan interested in a variety of fields, one of them being economic research.

Construction of a Historical Infrastructure Price Index

Authors: Ibraheem Saqib Ellahi, Carl Kitchens
Student Major: Applied and Computational Mathematics, Economics
Mentor: Carl Kitchens
Mentor's Department: Economics
Mentor's College: Social Sciences
Co-Presenters: Christopher Lynch, Abhik Saha, Eden Sobalvarro, Jesse Valdes

Abstract


This research project aims to develop a comprehensive historical construction price index spanning from the 20th century onwards, recognizing significant shifts influenced by factors such as inflation, technological advancements, and efficiency improvements.
In the early 20th century, the pricing of American infrastructure construction lacked digitization. To address this, microfilms from the Engineering News-Record are digitized through scanning microfilm and processing to make them machine readable. Leveraging microfilm provides access to a historical journal with weekly editions dating back to the 19th century, enabling an examination of prices for various construction elements, job-related salaries, and awarded contracts. After processing the aggregate microfilm data, images are corrected for transcription errors, and weights are assigned to individual projects. The organized aggregate data is then categorized at the city-year-infrastructure type level.
The extraction process employs text parsing and image formatting techniques to unveil relevant construction pricing information. This involves identifying monthly awarded construction contracts based on regional parameters. Specifically, machine learning methods, including Amazon Textract and Python data scraping syntax, are utilized to efficiently extract construction pricing from thousands of pages at a time.
The findings from this project hold the potential to assist policymakers and those involved in constructing new buildings in estimating potential costs. By identifying trends among historical decisions, this information contributes to more informed decision-making regarding future construction expenses.

Screenshot 2024-03-25 at 7.14.35 AM.png

Keywords: construction price index microfilm economics