I am trying to set up offline streeet routing in ArcGisRuntime for Qt, Using LocalRouteTask.
However, I cannot find adequate documentation for how to obtain/configure an appropriate database.
The info I've found, just refers to two string parameters, with no further details. The main things I've been able to guess, is from examining/reverse engineering the demo "RuntimeSanFrancisco.geodatabase" files.
What I've learned so far:
- There are 4 "geodatabase" formats. (One for each format name would have been sufficient for me.)
Until that page is moved, a link here: https://developers.arcgis.com/qt/cpp/guide/supported-geodatabase-formats.htm
describing the 4 formats.
- the 'RuntimeSanFrancisco' is format 1 - .geodatabase-SQLite.
Using QGis, I can see the SanFrancisco offline-routing example contains
ALL the following data - I don't know how much of it is required for a street routing example.
I notice the N_1_* tables, and the 3 Streets* tables (relevant because the named network is called Streets_ND)
and the ND_27* tables, and Streets_ND_Junctions.
(however, I note that the geometry-type is different compared to the next picture I show.)
We had an ESRI partner prepare a 'geodatabase' data set for our client for offline routing, and they came up with
a ".gdb" folder, which I, based on the link above, guess to be a socalled "file geodatabase" type (it's called 'file', because it's stored in a directory, as opposed to the SQLite variant, which is stored in a file. In case you wonder.)
When I open that 'file geodatabase' in QGis, I get this:
Again we see names 'Streets', 'Streets_ND_Junctions', and 3 ND_XXX* tables.
However, trying to load this in our ArcGis Runtime application, just leads to crashes giving us no relevant info.
(executing the LocalRouteTask constructor gives a crash.)
The only documentation I find is this:
https developers.arcgis.com/qt/cpp/guide/find-a-route.htm
Find a route—ArcGIS Runtime SDK for Qt | ArcGIS for Developers
from which I don't seem to find any info about how to obtain/build routing geodatabases?
QUESTION: Anybody got any hints for how to figure this out / how one is supposed to figure this out?
The ESRI partners who built the 'geodatabase' are nice people, but it appears to me, they have access to the same lack of documentation as I find..? How does one figure out how to build a usable routing-network data set for ArcGisRuntime LocalRouteTasks, and is it possible to diagnose it with other things than mute crashes?
I spent some time googling this, but only found people asking similar questions in threads around the web, that never attracted any replies 😞
Detail question: I would like to know, if LocalRouteTask only works with the SQLite variant? From the linked 'supported' page, it suggests that "geodatabase file" would work too, but given the very little doc-details on LocalRouteTask itself, and my crashes, I'm wondering..? IE SQLite is the thing I've seen it work with..
Thank you for any help or advice you can offer on this.
URLs:
http developers.arcgis.com/qt/cpp/guide/supported-geodatabase-formats.htm
Accepted Solutions
Hi Jakob,
I think you have a couple of potential issues here. First is that when I look at the streets dataset and where your coordinates are, I think the streets dataset is clipped to not include some of the streets you need to solve. I tested this by adding the streets layer from your geodatabase into the map, and I can see that the coordinates are not over a street.
My best guess is that the data is getting unintentionally clipped when created in ArcMap. The data will automatically clipped by the extent of the data frame. Sometimes, the "Analyze" window that pops up further shrinks the data frame and causes this issue, so perhaps your analyst can undock the window to make sure they are getting the correct extent to you.
The other potential issue is mixing spatial references. I don't know what spatial reference your map is in, but it may be good to try and have a basemap in 3057, since your network dataset is in this spatial reference. I also recommend projecting your input points to 3057.
The above gif shows the original points outside of the street extent. However, as I click inside of the street network, I am able to solve successfully.
I attached my code for you to try.
Hope this helps!
Luke
Thank you for the useful answer - my ESRI partner and I have tried to follow this, and it certainly brings us closer.
However, I still get a crash when we try to load the .geodatabase.
I am unsure, if the .geodatabase is enough on its own, or if an accompanying folder is necessary, which was there in the ESRI test data: "RuntimeSanFrancisco.tn".
UPDATE: it would seem 'xxx.tn' subfolder may be required.. at least, if I hide that folder, in the ESRI demo example, I get a similar(?) crash when trying to load the geodatabase..?
[UPDATE2: the .tn folder was indeed critical, see next reply]
I went through the check-list on the webpage you've linked above (see below next screenshot.)
I include a screenshot of the contents of the built geodatabase, according to QGis:
It seems to include Streets, Streets_ND_Junctions, and RestrictedTurns.
I assume, but am not sure, that layers 20-21-22 would be the coordinate-system description.
I
The checklist, with my uninformed comments:
[[JG: ]] I was going through the info from http://desktop.arcgis.com/en/arcmap/10.3/map/working-with-arcmap/creating-arcgis-runtime-content.htm
to see if we are violating anything obvious. I've listed the relevant sections here below, with comments:
"(quoting) Network Data -"
"If your map contains a network dataset or a network analysis layer that references a network dataset, you can include the network dataset in your ArcGIS Runtime content as a transportation network for routing and driving directions. When including a network, all feature layers the network references become part of the ArcGIS Runtime content. This may include layers that are not part of the map. For example, if you only have a network layer in the map, your ArcGIS Runtime content includes the streets, junctions, and turns feature classes associated with the network.
For a network dataset to become a transportation network, there are a few restrictions to keep in mind:
- The network dataset must be part of a geodatabase [JG: I assume this part is OK?] . This excludes networks that are in SDC or shapefile format.
- The network dataset must be from ArcGIS 10.0 or later. [JG: I assume OK.. You can judge this.] If your network is from an earlier version, you can upgrade your geodatabase and your network.
- The network dataset cannot have an unknown coordinate system. [JG: I can see layer 20,21 and 22 mention something like this, but don't know if that is the required part.]
- The network dataset cannot use any VB or Python script evaluators. [JG: shouldn't apply here.]
- The network dataset cannot use any custom COM evaluators. [JG: shouldn't apply here.]
- A network dataset that uses live traffic [JG: shouldn't apply here.] will be ported to a transportation network, but the live traffic components are excluded since they are not supported.
style="margin-bottom:20.55pt;background:#FEFEFE"
- Do not include network data—Exclude network datasets from the ArcGIS Runtime content.
- [JG: I assume you chose the first of these two options?]
In short, it doesn't appear obvious to me, that we are violating any items on this list..
I'll return with more info, if we figure more out.
Update: Since march 15th, we have locally had a lot of back-and-forth on this issue (between me and my 'esri partner'), trying to get it to work. The good news is that it 'sort of works'. The bad news is the 'sort of' part..
We experience that 'benign'/obvious connections unexpectedly don't work. E.g. a major road intersection, that in reality allows traffic in all directions, is impossible to pass from north to south.
The routing error we get is is code -1, "an unexpected error occured".
What makes this so strange, is that the ESRI partner has no problems whatsoever, doing this "same" routing task in her source data (ie from/to same lat/lon as I get errors with.)
Note that the ESRI partner is not running off the SQLLite-geodatabase - she's running on the source data set, which she uses to build the sqllite-network.
We've so far spent fruitless weeks trying to resolve this, having an impatient client that was supposed to do production on our result, if it would work.
I'll try to include (some of) my data case here. I'm considering posting this issue as a new post instead, and closing this existing query off as resolved (whose subject was the proper format of LocalRouteTask data.)
However the queries are somewhat related, since it's the same goal - we were/are attempting the 'nobrainer of just setting up a local routing network :-)'..
Here the details:
(edit: I HAVE ATTACHED the sqllite Geodatabase that fails/on which we can't route between the following coordinates.)
I'm trying to route from -21,949970 / 64,079085 to -21,950415 with 64,078141
(supposedly WGS84 / decimal degrees lat lon.)
On this screenshot, that is from point 24 to point 25.
And the problem is, it won't move south across the west-east-going road.
As the basemap (and reality) suggests, this should very much be possible.
The esri partner says she is using "I am using the network dataset in Arc GIS desktop, and the network extension there".
And she can trace across here, just fine.
She sends me this screenshot, of how the street-graph actually looks:
(ignore the green (2) circle on the right. The trace goes to the leftmost southern green dot.)
What is visible from this screenshot is, that the intersection is a bit weird (the triangle),
but I think I've seen that structure arise in other similar cases, with roads that split/merge.)
I just received a mail from the esri partner, with some technical notes on how they build the data set.
I qoute them here:
"
We have street centerlines as a feature class in ArcGIS File Geodatabase. The feature class has attributes that describes things like speed limit, road class and route weight.
There is also another feature class that contains restricted turns.
Then we used ArcGIS 10.4 Network Analyst to create a Network dataset from these feature classes, through wizards and with directions from Esri.
The network dataset runs fine in our ArcGIS software (ArcMap) and routes everything correctly. It is a rather simple dataset based on few rules as we lack good information about lot of places but that should not cause errors in the routing.
After that we used ArcMap to create a run time geodatabase with the Network and sent it to you.
"
If you deem necessary, we can try to provide you with the 'working' source data too.
Thank you in advance for any light you can shed on this issue.
Hi Jakob,
I think you have a couple of potential issues here. First is that when I look at the streets dataset and where your coordinates are, I think the streets dataset is clipped to not include some of the streets you need to solve. I tested this by adding the streets layer from your geodatabase into the map, and I can see that the coordinates are not over a street.
My best guess is that the data is getting unintentionally clipped when created in ArcMap. The data will automatically clipped by the extent of the data frame. Sometimes, the "Analyze" window that pops up further shrinks the data frame and causes this issue, so perhaps your analyst can undock the window to make sure they are getting the correct extent to you.
The other potential issue is mixing spatial references. I don't know what spatial reference your map is in, but it may be good to try and have a basemap in 3057, since your network dataset is in this spatial reference. I also recommend projecting your input points to 3057.
The above gif shows the original points outside of the street extent. However, as I click inside of the street network, I am able to solve successfully.
I attached my code for you to try.
Hope this helps!
Luke
It works for me with your new geodatabase and the code I posted earlier. Did you try that code? However, the network dataset still doesn't cover the area for the coordinates you provided. Below you can see that the original points you gave are not within the network dataset extent. However, using the code I provided, I can click on the map (near roads) and get routes back.
