QA/QC Script

[stdavis]

Create a script or scripts that verify data integrity. Some checks that would be important for the app:

• Verify that required common fields are present in both sets of datasets with valid values
• Verify that all values in the TILE_INDEX field in the tile index datasets are present in the corresponding extents dataset Tile_Index field and vice versa

Tile Indexes Checks:

• Validate that PATH, TILE, and EXT are populated for all features where In_House is marked as Y in their corresponding extent features.
• Validate that SIZE has a value?

Extents Checks:

• Verify ServiceName in extents is a valid discover service name
• Verify that HTML_Page field contains valid URL

There may be other checks that arise.

Should this script be run on a schedule? Or manually when the data is changed?

ManageIndexes.py has some checks in it that may be useful.