[pgrouting-users] Pgrouting-users Digest, Vol 137, Issue 5

Boubacar Bah bahbouba.909 at gmail.com
Fri Aug 13 08:31:57 PDT 2021


good evening daniel indeed the problem was due to my data because i tried
on the data from the link you sent me and the pgr_djikstra function worked.
but what I don't understand is that my data comes from open street may that
I downloaded from the geofabrik site. here is the file of my data in
question Please can someone check this data to tell me the causes which
make the function pgr_dikstra not work on this data
thanks in advance
 midi-pyrenees-latest-free.shp.zip
<https://drive.google.com/file/d/1Z0c054zwcse_a43-PwHGV1pPgDeJem-X/view?usp=drive_web>


Le mer. 11 août 2021 à 20:04, <pgrouting-users-request at lists.osgeo.org> a
écrit :

> Send Pgrouting-users mailing list submissions to
>         pgrouting-users at lists.osgeo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.osgeo.org/mailman/listinfo/pgrouting-users
> or, via email, send a message with subject or body 'help' to
>         pgrouting-users-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         pgrouting-users-owner at lists.osgeo.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Pgrouting-users digest..."
>
>
> Today's Topics:
>
>    1. Re: Pgrouting-users Digest, Vol 137, Issue 3 (Daniel Kastl)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 11 Aug 2021 09:39:28 +0900
> From: Daniel Kastl <daniel at georepublic.de>
> To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
> Subject: Re: [pgrouting-users] Pgrouting-users Digest, Vol 137, Issue
>         3
> Message-ID:
>         <
> CABXBSH-SSnOoUZ8D9bh_LWQrnnNyO71bc1BsK_zc6SQqL9nKxg at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Thanks for sending the version information.
> It seems you are using a beta version of PostGIS 3.2, which I'm not sure we
> are testing this version with pgRouting already.
> But it shouldn't be the problem.
>
> I guess there is something wrong in your custom database setup.
> It would be good to try to test step by step to see where it stops working.
>
> There is a pgRouting workshop, but it's not written for Windows.
> You can use it on your Windows installation, but I would suggest to try the
> sample data from the pgRouting documentation.
>
>    1. Create a new database
>    2. Install extensions PostGIS and pgRouting
>    3. Load the sample network
>    https://docs.pgrouting.org/latest/en/sampledata.html
>    4. Test the pg_dijkstra function example from the documentation for
>    example https://docs.pgrouting.org/latest/en/pgr_dijkstra.html
>
> If you get to that point, then the problem occurs with your data (loading)
> and is not related to pgRouting.
>
> Best regards,
> Daniel
>
>
>
>
> On Wed, 11 Aug 2021 at 06:39, Boubacar Bah <bahbouba.909 at gmail.com> wrote:
>
> > Hello
> > effectively daniel i use a different public shema but I had changed the
> > search_path to this shema in question but pgrouting did not work after I
> > import my tables to the public shema I then change the search_path to the
> > shema the pg_dijkstra query still didn't work but the pgr_createtopology
> > query works apart from this function none of the others in pgrouting
> work.
> > here is the result of the queries you requested.
> > pending your greetings.
> >
> > Le mar. 10 ao?t 2021 ? 20:00, <pgrouting-users-request at lists.osgeo.org>
> a
> > ?crit :
> >
> >> Send Pgrouting-users mailing list submissions to
> >>         pgrouting-users at lists.osgeo.org
> >>
> >> To subscribe or unsubscribe via the World Wide Web, visit
> >>         https://lists.osgeo.org/mailman/listinfo/pgrouting-users
> >> or, via email, send a message with subject or body 'help' to
> >>         pgrouting-users-request at lists.osgeo.org
> >>
> >> You can reach the person managing the list at
> >>         pgrouting-users-owner at lists.osgeo.org
> >>
> >> When replying, please edit your Subject line so it is more specific
> >> than "Re: Contents of Pgrouting-users digest..."
> >>
> >>
> >> Today's Topics:
> >>
> >>    1. Re: Pgrouting-users Digest, Vol 137, Issue 1 (Daniel Kastl)
> >>
> >>
> >> ----------------------------------------------------------------------
> >>
> >> Message: 1
> >> Date: Tue, 10 Aug 2021 09:15:53 +0900
> >> From: Daniel Kastl <daniel at georepublic.de>
> >> To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
> >> Subject: Re: [pgrouting-users] Pgrouting-users Digest, Vol 137, Issue
> >>         1
> >> Message-ID:
> >>         <
> >> CABXBSH9qU33gFXCZUdGAreSi46rBRFMEOERFDp61HTRJMTYFzA at mail.gmail.com>
> >> Content-Type: text/plain; charset="utf-8"
> >>
> >> In PostgreSQL you can organize your tables, functions and others in
> >> SCHEMA's.
> >> Eventually your so-called "search_path" is not set correctly and you are
> >> using a different schema than the default "public".
> >>
> >> Can you run the following commands and post the result here?
> >>
> >> SELECT version();
> >> SELECT postgis_full_version();
> >> SELECT pgr_version();
> >>
> >> Best regards,
> >> Daniel
> >>
> >> On Tue, 10 Aug 2021 at 04:39, Boubacar Bah <bahbouba.909 at gmail.com>
> >> wrote:
> >>
> >> > hello ; l verified my database pgrouting is install and all the
> function
> >> > is load but l don't know why  it not working. this is  the error
> >> > message down
> >> > on the left of the image we can see  the function list and l see the
> >> > pgr_dijkstra function but it's don't work
> >> > waiting your response
> >> > thank  in advance
> >> >
> >> > Le lun. 9 ao?t 2021 ? 20:01, <pgrouting-users-request at lists.osgeo.org
> >
> >> a
> >> > ?crit :
> >> >
> >> >> Send Pgrouting-users mailing list submissions to
> >> >>         pgrouting-users at lists.osgeo.org
> >> >>
> >> >> To subscribe or unsubscribe via the World Wide Web, visit
> >> >>         https://lists.osgeo.org/mailman/listinfo/pgrouting-users
> >> >> or, via email, send a message with subject or body 'help' to
> >> >>         pgrouting-users-request at lists.osgeo.org
> >> >>
> >> >> You can reach the person managing the list at
> >> >>         pgrouting-users-owner at lists.osgeo.org
> >> >>
> >> >> When replying, please edit your Subject line so it is more specific
> >> >> than "Re: Contents of Pgrouting-users digest..."
> >> >>
> >> >>
> >> >> Today's Topics:
> >> >>
> >> >>    1. Asking help (Boubacar Bah)
> >> >>    2. Re: Asking help (Rajat Shinde)
> >> >>
> >> >>
> >> >>
> ----------------------------------------------------------------------
> >> >>
> >> >> Message: 1
> >> >> Date: Mon, 9 Aug 2021 14:24:55 +0100
> >> >> From: Boubacar Bah <bahbouba.909 at gmail.com>
> >> >> To: pgrouting-users at lists.osgeo.org
> >> >> Subject: [pgrouting-users] Asking help
> >> >> Message-ID:
> >> >>         <
> >> >> CALOg8kGhEwenrGrZ-e8XihFJ9Ycb-kjUx3x0TKf59gdARghpYw at mail.gmail.com>
> >> >> Content-Type: text/plain; charset="utf-8"
> >> >>
> >> >> Hello.I m New in postgresql so l try to use the pgrouting functions
> in
> >> my
> >> >> database which have postgis and pgrouting extension but they show me
> an
> >> >> error saying the function of pgrouting doesn't exist. So l please you
> >> to
> >> >> explain me how l can load the pgrouting function in my database . My
> >> >> exploitation  system is window 10 and postgresql 12
> >> >> Waiting your response
> >> >>  cordial receive my salutations
> >> >> -------------- next part --------------
> >> >> An HTML attachment was scrubbed...
> >> >> URL: <
> >> >>
> >>
> http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210809/c3f3d89a/attachment-0001.html
> >> >> >
> >> >>
> >> >> ------------------------------
> >> >>
> >> >> Message: 2
> >> >> Date: Mon, 9 Aug 2021 19:16:10 +0530
> >> >> From: Rajat Shinde <rajatshinde2303 at gmail.com>
> >> >> To: pgRouting users mailing list <pgrouting-users at lists.osgeo.org>
> >> >> Subject: Re: [pgrouting-users] Asking help
> >> >> Message-ID:
> >> >>         <
> >> >> CAKyj99mMamWJCoeWx45cHCMnBGNpXVNEYsF1QiN-nJCUUqpuSQ at mail.gmail.com>
> >> >> Content-Type: text/plain; charset="utf-8"
> >> >>
> >> >> Hi,
> >> >>
> >> >> It's hard to say anything without seeing the error messages but I
> >> think it
> >> >> is probably because pgRouting is not installed (See this:
> >> >> https://workshop.pgrouting.org/2.6/en/chapters/installation.html).
> It
> >> >> will
> >> >> be great if you could send an screenshot of the error or share the
> >> error
> >> >> logs.
> >> >>
> >> >> Also, please find the pgRouting workshop (
> >> >> https://workshop.pgrouting.org/2.6/en/index.html). It contains
> >> chapters
> >> >> on
> >> >> setting up and getting started with the pgRouting algorithms.
> >> >>
> >> >> Best,
> >> >> Rajat
> >> >>
> >> >> On Mon, Aug 9, 2021 at 6:55 PM Boubacar Bah <bahbouba.909 at gmail.com>
> >> >> wrote:
> >> >>
> >> >> >
> >> >> > Hello.I m New in postgresql so l try to use the pgrouting functions
> >> in
> >> >> my
> >> >> > database which have postgis and pgrouting extension but they show
> me
> >> an
> >> >> > error saying the function of pgrouting doesn't exist. So l please
> >> you to
> >> >> > explain me how l can load the pgrouting function in my database .
> My
> >> >> > exploitation  system is window 10 and postgresql 12
> >> >> > Waiting your response
> >> >> >  cordial receive my salutations
> >> >> >
> >> >> > _______________________________________________
> >> >> > Pgrouting-users mailing list
> >> >> > Pgrouting-users at lists.osgeo.org
> >> >> > https://lists.osgeo.org/mailman/listinfo/pgrouting-users
> >> >> >
> >> >> -------------- next part --------------
> >> >> An HTML attachment was scrubbed...
> >> >> URL: <
> >> >>
> >>
> http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210809/f464de94/attachment-0001.html
> >> >> >
> >> >>
> >> >> ------------------------------
> >> >>
> >> >> Subject: Digest Footer
> >> >>
> >> >> _______________________________________________
> >> >> Pgrouting-users mailing list
> >> >> Pgrouting-users at lists.osgeo.org
> >> >> https://lists.osgeo.org/mailman/listinfo/pgrouting-users
> >> >>
> >> >>
> >> >> ------------------------------
> >> >>
> >> >> End of Pgrouting-users Digest, Vol 137, Issue 1
> >> >> ***********************************************
> >> >>
> >> > _______________________________________________
> >> > Pgrouting-users mailing list
> >> > Pgrouting-users at lists.osgeo.org
> >> > https://lists.osgeo.org/mailman/listinfo/pgrouting-users
> >> >
> >>
> >>
> >> --
> >> Georepublic UG & Georepublic Japan
> >> eMail: daniel.kastl at georepublic.de
> >> Web: https://georepublic.info
> >> -------------- next part --------------
> >> An HTML attachment was scrubbed...
> >> URL: <
> >>
> http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210810/352e44d9/attachment-0001.html
> >> >
> >>
> >> ------------------------------
> >>
> >> Subject: Digest Footer
> >>
> >> _______________________________________________
> >> Pgrouting-users mailing list
> >> Pgrouting-users at lists.osgeo.org
> >> https://lists.osgeo.org/mailman/listinfo/pgrouting-users
> >>
> >>
> >> ------------------------------
> >>
> >> End of Pgrouting-users Digest, Vol 137, Issue 3
> >> ***********************************************
> >>
> > _______________________________________________
> > Pgrouting-users mailing list
> > Pgrouting-users at lists.osgeo.org
> > https://lists.osgeo.org/mailman/listinfo/pgrouting-users
> >
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: https://georepublic.info
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210811/f08bcbb4/attachment-0001.html
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
> ------------------------------
>
> End of Pgrouting-users Digest, Vol 137, Issue 5
> ***********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20210813/9c18c32c/attachment-0001.html>


More information about the Pgrouting-users mailing list