[pgrouting-users] pgrouting installation
Charles Galpin
cgalpin at lhsw.com
Tue Sep 13 08:54:57 EDT 2011
I have used pgrouting on Windows 7 so I think this should work (everything else installed via stackbuilder)
What do you get for this query?
select * from ways where source = 24154 or target = 24157
charles
On Sep 13, 2011, at 8:37 AM, Daniel Kastl wrote:
> Hi Ali,
>
> I may be wrong, and if there are Windows users out there who know it better, please correct me.
> But the binaries for pgRouting were not compiled with Windows 7. They might work, but not necessarily.
>
> Daniel
>
>
> On Tue, Sep 13, 2011 at 2:39 AM, Ali Taha <ali.taha at ritaj.ps> wrote:
> Dear Daniel,
>
>
>
> I downloaded them from http://www.pgrouting.org/download.html (windows binaries section pgRouting-1.03_pg-8.4.2)
>
> I have windows 7 OS
>
>
>
> Thanks
>
>
>
>
>
> From: pgrouting-users-bounces at lists.osgeo.org [mailto:pgrouting-users-bounces at lists.osgeo.org] On Behalf Of Daniel Kastl
> Sent: Tuesday, September 13, 2011 6:34 AM
> To: pgRouting users mailing list
> Subject: Re: [pgrouting-users] pgrouting installation
>
>
>
>
>
> On Mon, Sep 12, 2011 at 11:20 AM, Ali Taha <ali.taha at ritaj.ps> wrote:
>
> Dear All,
>
>
>
> I am trying to setup and test pgrouting, I followed the setups but it is still not working. If ollowed the following steps:
>
>
>
> 1- Copay pgrouting libraries to ..\pgsql\8.4\lib
>
>
>
> >From where did you copy them?
>
> Did you compile? Which OS?
>
>
>
> Daniel
>
>
>
>
>
>
>
>
>
> 2- Execute routing_core.sql and routing_core_wrappers.sql
>
> 3- Create a newtwork:
>
> a. Added source and target fields
>
> b. Execute Execute assign_vertex_id('<table>', float tolerance, '<geometry column', '<gid>')
>
> c. Added indices
>
> d. Added reverse_cost column.
>
> Then I used the following query to retrieve records:
>
>
>
> SELECT * FROM shortest_path(‘
>
> SELECT gid as id,
>
> source::integer,
>
> target::integer,
>
> length::double precision as cost
>
> FROM ways’,
>
> 24154,
>
> 24157,
>
> false, false)
>
>
>
> the query executes without errors, but return no data. I checked the table and the records seems OK.
>
> is there a way to validate the database and verify the topology? How to make sure that the pgrouting library (dlls) are installed and working correctly?
>
>
>
> Thanks
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: http://georepublic.de
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: http://georepublic.de
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20110913/100c8d3f/attachment-0001.html
More information about the Pgrouting-users
mailing list