topic Re: Address Data Management - Update RoadNameIndex Bug in State & Local Government Questions

Address Data Management - Update RoadNameIndex Bug

JoshSaad1 — Thu, 13 Feb 2020 15:40:25 GMT

I've been testing out the new Address Data Management solution for ArcGIS Pro 2.5. I've populated my Master Road Names table based on our live data and I'm trying to update the RoadNameIndex domain using the task provided with the solution. I get an error that the records it's importing aren't unique. The problem is that the task process updates the RoadNameIndex with records from the Full Road Name field in the Master Road Names Table, but there can be multiple records with the same Full Road Name if there are records for the same road in different municipalities, or with different statuses.

Re: Address Data Management - Update RoadNameIndex Bug

ChrisFox — Thu, 20 Feb 2020 18:47:01 GMT

Hi Josh,

Thank you for reporting the issue. We will be working on a fix for this issue to handle the same road name in different municipalities. I am curious though for you reason for the same road name in the same municipality with different statuses. This isn't a workflow we account for in the solution and wanted to better understand your reasoning to see if we may be missing something with the solution.

Re: Address Data Management - Update RoadNameIndex Bug

JoshSaad1 — Thu, 20 Feb 2020 19:00:22 GMT

Thanks for responding. When converting our existing road centerline, our status options included Built (B), or Platted Not Built (P-NB). I converted those to Current and Pending, respectively. I checked a few and it looks like they are roadway extensions filed through our Planning department that are being developed.

Re: Address Data Management - Update RoadNameIndex Bug

ChrisFox — Thu, 20 Feb 2020 19:43:26 GMT

Thanks Josh, I would say in the solution that the Master Road Name table is primary there to ensure integrity of the road names in your centerlines and site address points. So that being said, having multiple copies of the same road name with different statuses isn't going to add additional capabilities in the solution. So I would just keeping one unique row per road name and municipality.

Re: Address Data Management - Update RoadNameIndex Bug

JoshSaad — Wed, 08 Apr 2020 19:57:14 GMT

I have another question that I was wondering if you could help with. I'm building a model to convert my existing data and import it into the new model. If I follow the instructions in the task to disable the attribute rule that generates unique IDs for my centerlines, then none of the imported centerlines have an ID. If I leave the rule enabled, they call get the same ID. Is there a way to import my data where they all get different IDs?

Re: Address Data Management - Update RoadNameIndex Bug

ChrisFox — Sun, 12 Dec 2021 01:01:29 GMT

I would recommend you use a field calculation in ArcGIS Pro to calculate a unique id:

Calculate Field Python examples—Data Management toolbox | Documentation

Below is a modified version that will calculate a sequential id like RD-1, RD-2, RD-3, etc.

Expression:

autoIncrement()‍

Code Block:

rec=0
def autoIncrement():
    global rec
    pStart = 1 #adjust start value, if req'd 
    pInterval = 1 #adjust interval value, if req'd
    if (rec == 0): 
        rec = pStart 
    else: 
        rec = rec + pInterval 
    return "RD-" + rec‍‍‍‍‍‍‍‍‍‍

Re: Address Data Management - Update RoadNameIndex Bug

JoshSaad1 — Thu, 09 Apr 2020 14:50:58 GMT

Thanks for responding. I tried this but I get an error on line 10. It looks like it can't concatenate a string and an integer.

Re: Address Data Management - Update RoadNameIndex Bug

ChrisFox — Thu, 09 Apr 2020 14:53:50 GMT

Try this on the last line:

return "RD-" + str(rec)

Re: Address Data Management - Update RoadNameIndex Bug

JoshSaad1 — Thu, 09 Apr 2020 14:55:46 GMT

That did it. Thanks!

Re: Address Data Management - Update RoadNameIndex Bug

ChrisFox — Mon, 22 Nov 2021 14:55:53 GMT

@JoshSaad1 In versions 2.0 of the Address Data Management solution you can now define the same road name in multiple municipalities, in fact this is recommended. In addition, if a road has a different municipality on the left and right side of the road it should be defined uniquely for each municipality in the Master Road Names table.

https://doc.arcgis.com/en/arcgis-solutions/latest/reference/introduction-to-address-data-management.htm

Re: Address Data Management - Update RoadNameIndex Bug

SuzanneWhitcomb — Tue, 14 Dec 2021 17:23:24 GMT

Chris,

I have tried for the past two days to get the RoadNameIndex to update for AddressDataManagement Solution. I keep getting errors that state the data is already in the system and save your pending edits. Neither are true. I have been using ADM for 10 years in ArcMap incorrectly, and I would like to be able to teach someone else how to use pro and this solution. But I am obviously configuring it wrong. Please help!

Re: Address Data Management - Update RoadNameIndex Bug

ChrisFox — Tue, 14 Dec 2021 18:08:47 GMT

Hi @SuzanneWhitcomb, my recommendation would be to grab the latest release of the Address Data Management solution. There have been several significant improvements, but we also moved away from the Road Name Index because there were a few issues with it. We still use the Master Street Name table, just use the values in it in a different way.

Re: Address Data Management - Update RoadNameIndex Bug

SuzanneWhitcomb — Tue, 14 Dec 2021 20:10:21 GMT

OK So I did and I get this error:

I was just loading from my SQL to the gdb so I can move to Pro