Abstract

The Use of Python Scripting in Enterprise Geodatabase Schema Inventory
Track: Defense and Intelligence
Authors: Jonathan Hutchinson, Melissa Walker

As the United States Marine Corps GEOFidelis Program prepares to migrate to a new, SDSFIE 3.0-based, geospatial data model, the East Coast Regional GEOFidelis Center (GEOFIEAST) is utilizing Python scripting to manage the schema for multiple versioned enterprise geodatabases. GEOFIEAST developed a Python script that queries the geodatabases and outputs a single XML file, which can be easily loaded into an Excel workbook or an Access database, making comparisons of schema across geodatabases faster and easier, which is critical to SDSFIE 3.0 adaptation design, data gap analysis, application dependency management, and database commonality studies. This script has condensed several days of work, exporting separate XML workspace documents and querying geodatabases, into a Python script that generates a single, formatted file, which runs independently, facilitating the analysis and reporting of up-to-date schema information, which is essential for ensuring both data model compliance and a well-designed SDSFIE 3.0 adaptation.