[pgrouting-users] about use of navteq data

[Daniel Kastl]

>
>
> Yes, I have to build topology if I want to use pgRouting because id from
> TeleAtalas are 'long integer' and not 'integer' (this create a type error)
> and
> don't start from 1,
> this is an example: 173800024175760.
>
>  <http://lists.osgeo.org/mailman/listinfo/pgrouting-users>
>

If your overall number of network links fits into type "integer" (what I
think is the case for Italy), then you could create a temporary table with
all existing start or end ID's. If you add a column with type serial, this
column will be then populated with numbers starting from 1.
You then can add additional columns to your network table for integer start
and end ID and update them with the serial ID from the temporary table.

Daniel


-- 
Georepublic UG & Georepublic Japan
eMail: daniel.kastl at georepublic.de
Web: http://georepublic.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110131/7fe62b75/attachment.html