Getting sequence of original network line features in route analysis & accumulating non-impedance attribute value for each resulting path vertex

Question

I'm using ArcGIS Network Analyst's (Enterprise server, not AGOL) Routing service:

https://developers.arcgis.com/rest/services-reference/route-sync-services.htm

I have 2 issues I'm missing:

1. I need to be able to accumulate some non-impedance attribute value per each vertex of the resulting calculated route and not only for each input/output stop.

For instance, I'm using a "cost_length" attribute for the impedanceAttributeName parameter, but want to get an accumulated value of a "cost_seconds" attribute (which is another cost attribute defined in the network). If I specify outputlines=esriNAOutputLineTrueShapeWithMeasure, I do get a third value for each vertex in the resulting route, but that value represents an accumulated value of the "cost_length" attribute (which is the requested impedanceAttributeName ). Is there any way to get an accumulated value of any other attribute, which is not the impedance attribute?

2. The resulting route is given as a line geometry (list of vertices).

This is not enough for me. I need to know the actual sequence of the network's underlying line features,         which have been traversed to create the calculated route - i.e. feature class + ObjectIDs.

I know that the behind-the-scenes algorithm traverses the line features, so is there any way to receive that sequence as a part of the routing service response?

If the above is not available - any suggestions how those can be implemented?

MaxZeng · Answer

I am so sorry that I missed your message somehow. Unfortunately publish routing services in 10.7.1 doesn't support network dataset in enterprise geodatabase. It is supported in 10.8 and later. We also have a major performance improvement to routing services published using publish routing services in 10.8 and later.

Is it still the case that the client cannot move to 10.8 and later? If that's the case, there are other ways you could potentially publish a geoprocessing service in 10.7.1 with network dataset in enterprise geodatabase.

GISTaldor · Answer

Thank you.

Another question though.

The documentation states that one of the conditions is that my network dataset is "stored in a file geodatabase". But in my case it is stored in an enterprise geodatabase (SDE for SQL Server).

Is there any chance of publishing this kind of service vs a network dataset inside an enterprise geodatabase?

It seems like later versions (10.8 & later) have removed this condition..

But my client is using 10.7.1 and cannot perform an upgrade for some internal reason.

MaxZeng · Answer

Here is the doc for using publish routing services utility in Enterprise 10.7. Once you run the publish routing services utility, you will have a folder with these four services.

The NetworkAnalysis map service (second service in the screenshot) has network analysis capabilities turned on. And it corresponds to the NAServer synchronous service. The NetworkAnalysis geoprocessing service (the first service in the screensho), is published as asynchronous geoprocessing service by publish routing services utility. And it corresponds to GPServer asynchronous service. You could potentially go into the service parameters (by clicking the pencil next to the service) and change it to synchronous geoprocessing service. By doing this, instead of using submitJob on the geoprocessing service and query the job id for the job status, you will use execute on the geoprocessing service and wait for the job to finish. Here are some more information about executing sync geoprocessing service.

Does this answer your question?