Re: [postgis-users] Routing with POSTGIS question

2010-08-15 Thread Daniel Kastl
I haven't heard about shp2pgrouting. I think you need to download the .osm file from cloudmade servers instead. Another way to import OSM data is osm2po (osm2po.de). It can handle larger amount of data and works also on Windows. Daniel 2010/8/16 bdair2002 > > Thank you very much, the reason I

Re: [postgis-users] Routing with POSTGIS question

2010-08-15 Thread bdair2002
Thank you very much, the reason I didn't ask in Pgrouting forum is that I wanted another way to calculate route, when I downloaded the maps from cloudmade, the roads wasn't in network shape, so I was thinking how do they do their route, probably their road network is private. on another topic, I

Re: [postgis-users] Routing with POSTGIS question

2010-08-15 Thread Daniel Kastl
For pgrouting you need to have a suitable road network and so you have to use osm2pgrouting for example to split your long OSM roads. If you want to know how cloudmade does, you probably need to ask them. But I don't think they take a raw OSM file as it is either. Daniel PS: you probably better a

[postgis-users] shp2pgsql fails on malformed integer attribute

2010-08-15 Thread Andrea Peri
>I don't quite understand your example : > >"if the field numeric in the shapefile instead of be fill with numbers was >filled with '1', '2', '3', etc... >where the number are however not really numbers but text based, an action of >importing always 0. >Will be more confusing. The user don't und

[postgis-users] Routing with POSTGIS question

2010-08-15 Thread bdair2002
Hello Guys, I have used pgrouting with postgis, but I have noticed, when I downloaded the maps from openstreemaps, I have noticed they don't use "segments for the street" meaning, the street has the same name in each intersection, and no start and end for the street. My question is there a way t

[postgis-users] Routing with POSTGIS question

2010-08-15 Thread bdair2002
Hello Guys, I have used pgrouting with postgis, but I have noticed, when I downloaded the maps from openstreemaps, I have noticed they don't use "segments for the street" meaning, the street has the same name in each intersection, and no start and end for the street. My question is there a way t

[postgis-users] PostGIS in Action Book Technical Reviewers needed

2010-08-15 Thread Paragon Corporation
We are currently looking for technical reviewers for PostGIS in Action upcoming book. Ideally we would like to have one person, but we suspect that is too much to ask. We have permission to split the book into separate sections and have each reviewer review each part. The pay is $2 per page. Re