Friday

Breakfast in the Ballroom

Title: Enterprise Geodatabase Administration and Spatial Data Workflows with Postgres and ESRI ArcPro

Description: The Iowa State University (ISU) Information Technology Services (ITS) and the Center for Survey Statistics and Methodology (CSSM) teams have implemented ESRI Enterprise Geodatabase environments in Postgres, and are using ArcMap and ArcPro to create, maintain and administer spatial data. As an ISU Systems Analyst, part of my role in geodatabase design and administration involves developing data workflows which help GIS professionals with their data workflows and automation. This includes data architecture and design that will help normalize spatial datasets, allow multi-user edit environments (both connected and disconnected from the ISU network) and automate data validation and synchronization between development and production environments. This presentation will highlight the use of automation in geodatabase administration, and some best practices for the use of data versioned edits and replicas synchronization using ArcPro. The spatial data featured in this presentation will be a 3D multi-modal transportation network (roadways, parking, walkways, building hallways and buildings rooms) for ISU maintenance workers and a cable raceway network model for Communications spatial and logistic data integration, which are both currently in development for ITS. I will highlight the use of pL/pgSQL and python in my automation examples as part of this effort.


Presenters: Tracy J. McLane & Brad Boeckmann
Presenter Bio: Tracy (Engel) McLane is a Systems Analyst at Iowa State University (ISU), where her primary roles are as a GIS data architect and automation specialist for the ISU Center of Survey Statistics and Methodology (CSSM). Tracy supports CSSM with spatial analysis, data analytics and database architecture design in both Oracle Spatial and Postgres/PostGIS database environments. Her automation experience includes pLSQL, pL/pgSQL and python for USDA Natural Resource Inventory (NRI) Countybase Estimation, NASS Cropland Data Layer (CDL) sequenced sample matrix analytics development and other natural resource data analytics to support the CSSM team and its customers. Additionally, Tracy supports the ISU Information Technology Services (ITS) ESRI Enterprise Postgres geodatabase. There, she is responsible for data design, development, automation and integration of two Iowa State University transportation and communications network data models, both currently under development.