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

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

MSAG Toolset

Toolset Credits

Last Revised:

June 15, 2022

Abstract

The MSAG NG911 Comparison tool compares a Master Street Address Guide (MSAG) Excel File with the NG911 Road Centerline address ranges. The Telephone Number tools compares a telephone number spreadsheet to the NG911 Road Centerline address ranges. All MSAG tools have a legacy option to use the legacy fields in the NG911 geodatabase if MSAG or TN spreadsheets are formatted with legacy format.

Tools

MSAG NG911 Comparison

Script: MSAG_NG911comparison.py

Tool Requirements

What the Tool Flags

Tool Tips

Tool Output

Viewing the Results

Table View Example
Table Comparison Low High Report
MSAG_YYYYMMDD 1200AVE|HOPE|1112 100 249 Not in MSAG- Range: 250-299
RoadCenterline 1200AVE|HOPE|1112 100 149 Not in NG911 road- Range 150-199
RoadCenterline 1200AVE|HOPE|1112 200 299 Not in NG911 road- Range 150-199

Interpreting the results:

The term "segment" refers to the concatenation of the full street name, community and ESN such as 1200AVE|HOPE|1112. All ranges for a given segment for both MSAG and road centerlines are compared with each other.

Message Meaning

Editing the Data:

How it works:

Check AT&T TN List

Script: MSAG_CheckTNList.py

Tool Requirements

This tool is for PSAPs who have AT&T as their provider. The tool geocodes a list of telephone number addresses against the MSAG information in the NG911 Address Points and Road Centerlines. This tool requires a TN (telephone number) list. Please see detailed tool instructions below for information on the geocoding results.

Using the Tool

This tool requires a telephone number list to be extracted as a spreadsheet from AT&T.

Understanding the Results

The results will be contained in a folder that sits next to your NG911 geodatabase. The name of the folder will be your NG911 geodatabase name with “_TN” appended to the end. If your geodatabase name is “Oklahoma_NG911.gdb”, the folder will be named “Oklahoma_NG911_TN”. Inside this folder will be a geodatabase called “TN_Working.gdb”. In this geodatabase, you will find two tables and a feature class with the day’s date appended to the end.

Your TN list spreadsheet is copied in the geodatabase as TN_List_YYYYMMDD with one column added called NGTNID for a unique ID. If you had columns for NPA, NXX and PHONELINE, the unique ID is a concatenation of these columns to form the phone number. If the ID is the phone number, this ID is persistent throughout all of your MSAG reviewing and editing. If the ID is not a phone number, then the ID has been randomly generated and is persistent for this single geocoding session.

All results from the geocoding operation will be found in TN_List_YYYYMMDD. This table can be brought into ArcMap and viewed as a normal point file. The geocoding status for each record can be found in the “MATCH” column. M = Matched, T = Tied, U = Unmatched.

Check Other TN List

Script: MSAG_GeocodeTNList_Prepped.py

This tool is intended for PSAPs who do not have AT&T as their provider. This tool geocodes full addresses housed in a spreadsheet against MSAG information in an NG911 geodatabase.

Tool Requirements

Using the Tool

Understanding the Results

The results will be contained in a folder that sits next to your NG911 geodatabase. The name of the folder will be your NG911 geodatabase name with “_TN” appended to the end. If your geodatabase name is “Oklahoma_NG911.gdb”, the folder will be named “Oklahoma_NG911_TN”. Inside this folder will be a geodatabase called “TN_Working.gdb”. In this geodatabase, you will find two tables and a feature class with the day’s date appended to the end.

Your TN list spreadsheet is copied in the geodatabase as TN_List_YYYYMMDD with one column added called NGTNID for a unique ID. If you defined a Phone Number field when running the tool, the phone number is the unique ID. If the ID is the phone number, this ID is persistent throughout all of your MSAG reviewing and editing. If the ID is not a phone number, then the ID has been randomly generated and is persistent for this single geocoding session.

All results from the geocoding operation will be found in TN_List_YYYYMMDD. This table can be brought into ArcMap. The geocoding status for each record can be found in the “MATCH” column. M = Matched, T = Tied, U = Unmatched.

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.