[pgrouting-dev] Problems in Importing .osm to Database

[Jinfu Leng]

Hey Daniel,

I tried the existing algorithm based on the road data imported from .osm
file. and it worked.

Right now I have one question:
How to match the "source" and "target" in table "way" with the node in
table "nodes"?

Thanks,
Jinfu

On Thu, May 31, 2012 at 3:26 AM, Daniel Kastl <daniel at georepublic.de> wrote:

> Hi Jinfu,
>
> As far as I remember this is only a log message. I think it would be
> better to reduce the number of messages.
> At the end it should tell you the number of imported road segments.
>
> Daniel
>
>
> On Wed, May 30, 2012 at 6:57 PM, Jinfu Leng <logicnut at gmail.com> wrote:
>
>> Hey Daniel, Dave,
>>
>> Thanks. The problem is solved by settings the pg_hba.conf to trust.
>>
>> But I got some error messages like:
>> "We DON'T need a way of type  and class
>> We need a way of type highway and class steps
>> We need a way of type highway and class footway
>> We need a way of type highway and class steps
>> We need a way of type highway and class footway"
>>
>> Do these errors matter? Or I can ignore them and go to the next step?
>>
>> Thanks again,
>> Jinfu
>>
>> On Wed, May 30, 2012 at 10:44 PM, Daniel Kastl <daniel at georepublic.de>wrote:
>>
>>> Hi Jinfu,
>>>
>>> Look at the "Note" in the workshop:
>>> http://workshop.pgrouting.org/chapters/osm2pgrouting.html#run-osm2pgrouting
>>> When you don't need to care about server security you can set the
>>> settings in pg_hba.conf to trust.
>>>
>>> Daniel
>>>
>>>
>>> On Wed, May 30, 2012 at 8:34 AM, Dave Potts <dave.potts at pinan.co.uk>wrote:
>>>
>>>> Hello,
>>>>
>>>> From the text of the error message, it appears your having a problem
>>>> connecting to your database, its not a pgroute package error but rather
>>>> a
>>>> postgres error.
>>>>
>>>> What happens if you try
>>>>
>>>> psql -d routing -U postgres
>>>>
>>>> This should connect directly to your database without using any of the
>>>> routing software.
>>>>
>>>>
>>>>
>>>>
>>>> Jinfu Leng wrote:
>>>> > Hello all,
>>>> >
>>>> > I created the database "routing" from the "template_routing", and
>>>> > downloaded the .osm file of London. But I got a problem when I was
>>>> trying
>>>> > yo import this .osm file to the database.
>>>> >
>>>> > command:
>>>> > "osm2pgrouting -file "London.osm" -conf
>>>> > "/usr/share/osm2pgrouting/mapconfig.xml" -dbname routing -user
>>>> postgres
>>>> > -clean"
>>>> > error message:
>>>> > "connection failed"
>>>> >
>>>> > Any ideas?
>>>> >
>>>> > Thanks a advance.
>>>> > Jinfu
>>>> > _______________________________________________
>>>> > pgrouting-dev mailing list
>>>> > pgrouting-dev at lists.osgeo.org
>>>> > http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>>> >
>>>>
>>>>
>>>> --
>>>>
>>>>
>>>> _______________________________________________
>>>> pgrouting-dev mailing list
>>>> pgrouting-dev at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>>>
>>>
>>>
>>>
>>> --
>>> Georepublic UG & Georepublic Japan
>>> eMail: daniel.kastl at georepublic.de
>>> Web: http://georepublic.de
>>>
>>> _______________________________________________
>>> pgrouting-dev mailing list
>>> pgrouting-dev at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>>
>>>
>>
>> _______________________________________________
>> pgrouting-dev mailing list
>> pgrouting-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>
>>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: http://georepublic.de
>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20120531/0e1901f2/attachment.html>