GIS data and MSAG

12292
20
11-09-2015 06:29 AM
TimWitt2
MVP Alum

Hey everybody,

Since NextGen 911 will result in the MSAG disappearing and being replaced by GIS data, I was wondering if anybody has a model or process in place that compares the MSAG and the GIS data?

Do you use 3rd party programs, if so which ones?

Tim

Tags (2)
20 Replies
by Anonymous User
Not applicable

As agencies migrate from the tabular capabilities within MSAG’s, (Master Street Address Guide) to geospatial reliance through the GIS platform, Esri will continue to support our business partners who provide tools and services to streamline this function.  We recommend agencies evaluate these options for best practice evolution of data.

Data Reviewer for ArcGIS can be configured with a set of checks to do this very thing. In addition, Esri also has a series of partners that can work with you to compare current GIS data to your MSAG information.  Please reach out to your local Esri rep for further assistance.

ChrisHarvey1
New Contributor

With the recent activity in this thread, I wanted to add a few comments.  Bradshaw Consulting Services (BCS) includes an MSAG comparison tool in our enterprise address management application, TheAddresser, that involves a three step process to locate discrepancies between both data sets using street names, postal communities, and address ranges.  In our experience, there will be issues in both data sets. 

Since centerlines are generally maintained with greater scrutiny and as NG911 becomes the standard, GIS utilities for addressing need the comprehensive ability to not only identify crucial errors that affect geocoding and routing but should also provide a business-logic approach to editing that protects data integrity as increasingly critical systems rely on those data.  This is the approach we've taken with TheAddresser as our public safety apps depend heavily on accurate addressing. 

0 Kudos
JeremyMullins4
New Contributor III

Tim,

There are a few tools that ESRI provides for free that will help you. However, some aspects of these tools will require a Standard or above license. The tool I would recommend the most is the ArcGIS for Local Government schema. This tool, while not NENA-compliant at this time, is fully configurable to be compliant at your discretion. It includes multiple relationship classes, tables, and domains already built so that your data can meet many standards already set by many agencies. The biggest benefit to you would be the integratino of the ArcGIS for Local Government data model and the Address Management tool that works with the schema to not only ensure accuracy between street centerlines, but across your datasets as a whole.

Another great aspect is that this model isn't just used for local government, but for many of the already created maps and apps from ESRI for Emergency Management, State Government, and Law Enforcement, to name a few. The most difficult part is migrating from your current dataset to the ArcGIS for Local Government model. There are many tools provided with this model that can guide you on best practices, including training, demos, etc. I would definitely look into this.

I would start here: Documentation | ArcGIS for Local Government

JasonBalmut
Occasional Contributor III

I concur, the Address Management tools are great.  I would add that at the time of this post, those tools have not yet migrated over to ArcGIS Pro.  

0 Kudos
RichardOwens
New Contributor II

I am also looking for a tool to replace one that we currently use from a company called InfoGeographics out of Traverse City Michigan.  The tool works very nicely but they are ending work on it sometime this year.  They do have a sample tool that you can try if you are interested in downloading it.  The sample tool only give you a few records and is only supported to 10.4.1 I believe.  Here is their website and the tool is called AQE(Address Quality Extension tool).

0 Kudos
by Anonymous User
Not applicable

We have a few partner who provide some nice tools to assist.  I would suggest you reach out to (alphabetically) Bradshaw Consulting Services (Chris Harvey) at: charvey@bcs-gis.com and/or GeoComm (Jody Sayre) at: jsayre@geo-comm.com

Get a demo from each to help you make an informed choice.  You might also look at some of the tools and templates on our solutions page, such as; Local Government Information Model | ArcGIS for Local Government 

0 Kudos
TimWitt2
MVP Alum

This week I have received an excel spreadsheet of all the phone numbers from our MSAG provider. We can request one of these once a year for free. Each phone number has an address attached to it. Here are the steps I came up with to compare it to our GIS address point layer.

1) Create a field in the phone number spreadsheet called FULL ADDRESS.

2) Use the excel concatenate function to populate the FULL ADDRESS field. Don't forget to include TRIM to remove extra spaces.The function will look similar to this: =TRIM(CONCATENATE(B2," ",C2," ",D2," ",E2," ",F2))

3) Now you will have a field that shows the full address that looks like this: 4660 N HIGHWAY 1  PALM SHORES

4) Select the FULL ADDRESS column, go to DATA on the ribbon and click "Remove Duplicates". In the window click on Expand the selection and then only put a check mark in your FULL ADDRESS field.

5) This leaves us with all unique address values in the phone number list. 

6) Export your Address Point GIS data in to an excel spreadsheet.

7) If you dont have a FULL ADDRESS field in your GIS data yet, create it in your Excel spreadsheet just like in step 2. IMPORTANT it needs to have the same name as in your MSAG spreadsheet.

8)Go to your MSAG spreadsheet and copy the FULL ADDRESS coulumn.

9) Go to your GIS spreadsheet and go to the last entry in your FULL ADDRESS column. Below this entry paste wha you have copied from your MSAG spreadsheet.

10) Now repeat step 4, which should eliminate all MSAG addresses that you have in GIS.

11) Anything below the last GIS entry will be addresses that you are missing in your GIS address point layer.

Hope this helps!

Tim 

0 Kudos
JoeBorgione
MVP Emeritus

"Anything below the last GIS entry will be addresses that you are missing in your GIS address point layer"

But...  that doesn't necessarily mean it's a valid address either.  Remember telephone companies do two things: provide dial tone, and charge you for that dial tone.  They don't verify addresses....

Nice methodology none the less Tim!

timw1984

That should just about do it....
0 Kudos
TimWitt2
MVP Alum

And it was also a good feeling that I had 99% in my address point layer

JoeBorgione
MVP Emeritus

Thats awesome Tim.  Makes clean up so much easier when you get big numbers like that.  And you are laying the ground work for NextGen 9-1-1.  That's pretty swesome too!

That should just about do it....
0 Kudos