topic Re: Validating RouteName for Create Route in ArcGIS Roads and Highways Questions

Validating RouteName for Create Route

GraemeBrowning_Aurizon — Thu, 28 Sep 2023 05:08:02 GMT

Using ArcGIS Pro 3.1.3 with ArcGIS Enterprise 11.0 (soon to be upgraded to 11.1) the field for RouteName on the Create Route tool dialog allows me to type any text up to 255 characters.

We use the values in RouteName for a few Attribute Rules triggered when Create Route is run.

Is there any way to validate the text entered into RouteName prior to Create Route being run so that values which will break an Attribute Rule cannot reach it?

Re: Validating RouteName for Create Route

AmitHazra — Fri, 29 Sep 2023 15:45:21 GMT

Unfortunately, the underlying API calls to applyEdits does not occur until after you click Run. Therefore, you'll need to consider alternative methods to validate/construct your Route Name field.

amit@esri | Transportation LRS Team

Re: Validating RouteName for Create Route

AyanPalit — Fri, 29 Sep 2023 16:59:08 GMT

@GraemeBrowning_Aurizon There are 2 primary use cases to Route creation and my notes on how I see this worked out.

Route bulk load: This may employ 'Append Route' tool or other data loading tools. A best practice is to prepare and QC the source data (typically in a file geodatabase where schema is exact match to the target enterprise GDB). I have helped users come up with QC routines and automation on the source fGDB prior to the load. This takes care of load fails, LRS errors and issues like your example.
Create Individual Route: This uses the Create Route tool and offers interactive wizard based steps. Although the tool is simple, I coach users to be prepared with all the relevant details to build the route. Entering key attributes like Route Names, Measures should be a well thought out process. This is mostly handled through end-user training and awareness. QC routines developed for method #1 may also be used as guardrails; user can create the route in fGDB, validate and then re-create the route.

Re: Validating RouteName for Create Route

GraemeBrowning_Aurizon — Wed, 04 Oct 2023 22:15:18 GMT

Thanks @AyanPalit

Your Route Bulk Load sounds similar to the code I developed for our initial data load via a file geodatabase, and I've adapted that to perform subsequent bulk data loads.

Your Create Individual Route sounds like what I need for the current use case. If you had any code for that which could be shared it would be useful but, in the absence of that, I think the advice "to be prepared with all the relevant details to build the route" and having a route editor "create the route in fGDB, validate and then re-create the route" using a tiny "bulk" load might be the way for me to go.

- Graeme

Re: Validating RouteName for Create Route

GraemeBrowning_Aurizon — Wed, 04 Oct 2023 22:24:51 GMT

Thanks @AmitHazra

I thought that was likely to be the case.

- Graeme