Greenman-Pedersen, Inc. (GPI) is a multi-disciplinary civil engineering firm with projects covering the eastern half of the United States. While the information GPI uses to manage clients and projects is stored in an Enterprise Resource Planning (ERP) Software, it is not easily viewable in a map, and therefore unavailable for any spatial analyses.
The Innovation Team at GPI has used the existing ERP data to create an Internal Mapping Application for assisting directors, project managers, engineers, marketing specialists, and other employees to realize various operational efficiencies using previously unmapped data.
This presentation will cover the end-to-end dataflow of the project. Beginning at the initial inputs in the ERP software, and the ETL (Extract, Transform & Load) process where the data is geocoded, cleaned and transformed using a combination of SQL and Python. The data is then securely provided to GPI staff using ArcGIS Online and ArcGIS Enterprise.
While the application is still in beta staff have already begun utilizing the data to enhance their existing workflows, particularly in marketing and branch logistics. Others, such as our corporate safety team, are using it to create completely new workflows which will save significant time and effort in their day-to-day tasks.
ArcGIS Online makes it easy to capture large volumes of data and photos in the field but few out-of-the-box tools exist to neatly convert these data into a traditional report. This presentation will cover the capabilities of the ArcPy and DocxTemplate Python packages towards generating a photo report in a .docx format, a companion photo location map, and hyperlinked spreadsheet for data review. This approach allows for the use of existing Microsoft Word templates in order to match organizational brand standards and enables the end user to make follow-up edits to photo comments and metadata.