The geodatabase allows you to model real-world features as tables, feature classes, and relationships, and add behavior through geodatabase logic (domains, contingent values, attribute rules, and so on). Part of defining a geodatabase is creating the schema. In relational databases, the schema comprises a collection of tables. You can think of the schema as the blueprint of the database and, similarly, the geodatabase. Datasets and their definitions, rules, and relationships in a geodatabase define the geodatabase schema.
The Generate Schema Report geoprocessing tool generates a readable Excel, JSON, PDF, or HTML report detailing how the geodatabase schema is defined. It can be used as a way to visualize and explore your data model, as a data dictionary, or as the foundation for a more detailed document.
It's important to understand how your schema report fits into your workflow, such as in the following examples:
- Documenting the schema allows for both GIS and non-GIS staff to understand the data and how it relates to other data in their data model. For example, as part of the onboarding process, the schema report can be used as a resource to show a non-GIS user how their business process workflows contribute to the larger department data collection story.
- Collaboration and data modeling
- Designing the schema is one of the most important first steps. The geodatabase schema report allows you to make changes to the geodatabase and export the report for collaboration purposes. For example, a new department was created to collect water and waste-water data, and two groups have started to build out the data model. However, there are differences between the two data models. The schema report can be used as a collaboration method to align the differences.
- Reporting and stakeholder buy-in
- The schema report includes different types of outputs that can be sent to stakeholders to gather support. For example, a senior level executive has asked to see a report on the proposed data model changes and how the changes help address climate change concerns in their area of interest. As part of gathering stakeholder support, the schema report can be used to present how the data model is organized and how proposed changes can offer favorable outcomes.
- Data migration
- The schema report can be used in data migration efforts. Using two schema reports, you can compare the schema after migrating the data to the destination by ensuring that the source and target reports match. For example, you are migrating an enterprise geodatabase from one DBMS provider to another. Using the schema report from the source geodatabase, you can compare the destination schema report to the origin schema report to confirm that the data migration was successful.
- Auditing and compliance
- The schema report can be used as a point-in-time report of the geodatabase schema. This is helpful for auditing and compliance purposes when there are legal requirements around data retention records. For example, your department is required to have yearly records going back several years. You can use the geodatabase schema report to assist in the data retention record requirements. By capturing snapshots, you can see how the geodatabase has changed over time and when consequential schema changes were made.
The Generate Schema Report geoprocessing tool allows you to select a target destination folder and generate a readable Excel XLSX, JSON, PDF, or HTML representation of the geodatabase schema.
The following is an example of an Excel workbook generated from address data in a geodatabase. The table of contents (TOC) tab provides an overview of the information included in the report. To quickly navigate to other sections of the workbook, you can click the hyperlinked text or use the worksheet tabs along the bottom.
Generate a schema report
To generate a schema report, complete the following steps:
- In the Catalog pane, right-click the table, feature class, feature dataset, or geodatabase you want to use as the input to the Generate Schema Report geoprocessing tool.
- Click Export.
- Click Generate Schema Report.
- In the Generate Schema Report geoprocessing tool, fill in the remaining parameters, select the desired output formats, and click Run.
The selected reports are generated in the specified output location.