Database Software

Hi,
We have done some prototype integrating Navteq Traffic Patterns with Oracle Network Data Model. What we did was to model traffic flow(traffic speed) as a dynamic link cost for travel time (distance/speed = travel time). We then use NDM routing functions to compute the fastest routes based on the given start time.
NDM java API is the core analysis API for Oracle route server. Currently Oracle routes erver does not take into account of traffic patterns in routing.

Jack

Jack,

Thank you for your response.

We are trying to prototype sample estimates (travel time, route) using routeserver,
which it appears that you have already done.

If I understand you correctly, Oracle routeserver cannot be used for route calculations
using real time traffic (e.g. navteq) data?

Thanks again,
J

Jack,

Do you know how to setup routeserver working for a sample dataset ?

Do I have to create the four oracle tables (below) and set relevant data into it?
EDGE
NODE
PARTITION
SIGN_POST

If you could help me direct with any information that would be very helpful.
Thanks,
J

Hi,

If you have Navteq ODF (Oracle Data Format) data, then all necessary tables for Oracle routing engine are there. No need to populate these tables.
If you have your own network tables, you have to populate these table yourself.
Please see Oracle Spatial Manual on Routing Engine (Chapter 13 on 11gr2) for details on the definition of these tables.

As for the traffic information support. Navteq provides two kinds of traffic information: historical traffic patterns(CS and real time traffic (XML). Route Server does not support either of them. We did some prototype using historical traffic patterns with NDM API. The real-time traffic cannot be pre-planned as the traffic information is not available until the time occurs. A good approach is to compute the route with traffic patterns and then use the real time traffic information to modify the pre-planned route if needed.

jack

Jack,

Thank you for your response.

1. The problem is I am not sure if I have all the Navteq sample SF data. I followed the instructions that came with the pdf. And after running the following query in my schema (created for navteq_sf), I am seeing only 10 tables. The document lists around 50 tables in its output.

select table_name
from user_tables
where table_name like 'WOM%' or table_name like 'NTC_MAP%'
order by table_name;

2. I have installed route server (from 10gR2). The route server app loads up, however on trying
Simple Route Request (single source, single destination) sample on the page, I am getting a 404 resource not
found error. I do not see anything inside the log file.

Below are relevant elements from my web.xml configuration:

<init-param>
<param-name>geocoder_http_url</param-name>
<param-value>http://123.456.233.78:8888/routeserver/servlet/RouteServerServlet</param-value>
</init-param>

<init-param>
<param-name>geocoder_schema_mode</param-name>
<param-value>thin</param-value>
</init-param>

<init-param>
<param-name>log_filename</param-name>
<param-value>c:\oc4j_extended_101350\j2ee\home\log\RouteServer.log</param-value>
</init-param>


Any idea.. Thanks,
J

After adding the following to web.xml the 404 error went away... getting 500 error code (internal server error).

+<servlet-mapping>+
+ <servlet-name>RouteServerServlet</servlet-name>+
+ <url-pattern>/servlet/RouteServerServlet</url-pattern>+
+</servlet-mapping>+

however for a "thinclient" what should be the geocoder_http_url ?

<param-name>geocoder_type</param-name>
<param-value>thinclient</param-value>

J

Closing this thread.

1. Working with Navteq support for the original issue.
2. Memory issue - for route servlet

Thanks,
J