Oklahoma NG911 Toolkit | Adjustment | Comparison | Enhancement | MSAG | Okprep | Submission | Validation

Supplementary Documentation | Examples | Generate Fishbone Analysis Tool | Topology Rules | Change Log | Error Glossary

Validation Toolset

Toolset Credits

Last Revised:

June 15, 2022

Abstract

The data validation tools perform a variety of basic verification checks against the NG911 Data Model template to determine if the data is ready for submission. The scripts are organized to validate data by specific layers or groups of layers, and multiple optional tests are included for each set. Any issues found with the data will be reported in tables added to the geodatabase as an "Error" or a "Notice". Notices will not prevent submission.

The scripts can be run multiple times as necessary so users can correct basic issues prior to submitting their NG911 updates. Currently, these data validation tools do not provide complete quality assurance (QA) of the data.

Be advised that most of these checks do not correct any errors, only make note of them.

Methodology is expanded below for the following validation checks: Check Feature Locations, Check Topology, Check RCLMatch, Check Frequency, Check ESN and Muni Attributes, and Find Overlaps.

Tools

A total of nine tools exist in the Validation Toolset. The individual tools and their available checks are described below. Nested bullet points indicate checks that are automatically run when the option at the top-level bullet point is selected.

1 Check Template

2 Check Address Points

3 Check Roads

4 Check Boundaries

5 Check Additional Layers

6 Clear Results Table (Optional)

7 Verify Topology Exceptions (Optional)

7.1 ESB Gap Locations (Optional)

8 Check All Required

Expanded Validation Check Methodology

Check Feature Locations

Check Topology

Check RCLMatch

Check Frequency

Check ESN and Muni Attributes

Find Overlaps

Usage

  1. Open ArcCatalog and navigate to the toolbox called “Oklahoma NG911 GIS Tools”, expand the toolbox, then expand the toolset called “Validation Tools.” Use the tools in the numerical order presented with the following guidelines.
  2. In the “Geodatabase” parameter, select the geodatabase of data to be checked.
  3. Check which data checks you want to run. When running each tool for the first time, we recommend choosing all options.
  4. Run the tool.
  5. Alternatively, to run all checks, open and run 8 Check All Required.
  6. The basic results of the data checks are shared in the ArcGIS dialog box. A simple Pass/Fail text file is created in the folder containing the geodatabase called "[Geodatabase_Name].txt" when CheckAll validations are run. The detailed results of the data checks will appear in two tables that are added to your geodatabase: TemplateCheckResults & FieldValuesCheckResults. The results reported in these tables will accumulate until you run the script titled 6 Optional Clear Results Table.
  7. Based on the results of the data check, you can edit your data as necessary.
  8. After data is edited, the necessary data checks can be rerun.
  9. The script called 7 Optional Verify Topology Exceptions will double-check that all road centerline topology errors are recorded as exceptions in the data and the topology.
  10. The script called 7.1 ESB Gap Locations will look for the areas where the ESB Boundary layers are not overlapping with the Discrepancy Agency Boundary.

Support Contact

For issues or questions, please contact Emma Baker or Riley Baird with the Oklahoma Department of Transportation. Email Emma at ebaker@odot.org or Riley at rbaird@odot.org, and please include in the email which script you were running, any error messages, and a zipped copy of your geodatabase. Change the file extension from zip to piz so it gets through the email server. If there are further data transfer issues, contact Emma or Riley to make alternative data transfer arrangements.

If you have a domain issue to report, please email Emma Baker at ebaker@odot.org. Please indicate what type of domain the issue is with and the values needing corrections.

Disclaimer

The Oklahoma NG9-1-1 GIS Toolbox is provided by the Oklahoma Geographic Information (GI) Council, Oklahoma 9-1-1 Management Authority, Oklahoma Department of Transportation (ODOT), Oklahoma Office of Geographic Information (OGI) , and associated contributors "as is" and any express or implied warranties, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose are disclaimed. In no event shall the Oklahoma GI Council, Oklahoma 9-1-1 Management Authority, ODOT, OGI, or associated contributors be liable for any direct, indirect, incidental, special, exemplary, or consequential damages (including, but not limited to, procurement of substitute goods or services; loss of use, data, or profits; or business interruption) however caused and on any theory of liability, whether in contract, strict liability, or tort (including negligence or otherwise) arising in any way out of the use of this software, even if advised of the possibility of such damage.