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
Le mer. 11 août 2021 à 20:04, <pgrouting-users-request@lists.osgeo.org> a écrit :
Send Pgrouting-users mailing list submissions to
pgrouting-users@lists.osgeo.orgTo 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@lists.osgeo.orgYou can reach the person managing the list at
pgrouting-users-owner@lists.osgeo.orgWhen replying, please edit your Subject line so it is more specific
than “Re: Contents of Pgrouting-users digest…”Today’s Topics:
- 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@georepublic.de>
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Pgrouting-users Digest, Vol 137, Issue
3
Message-ID:
<CABXBSH-SSnOoUZ8D9bh_LWQrnnNyO71bc1BsK_zc6SQqL9nKxg@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.
- Create a new database
- Install extensions PostGIS and pgRouting
- Load the sample network
https://docs.pgrouting.org/latest/en/sampledata.html- Test the pg_dijkstra function example from the documentation for
example https://docs.pgrouting.org/latest/en/pgr_dijkstra.htmlIf you get to that point, then the problem occurs with your data (loading)
and is not related to pgRouting.Best regards,
DanielOn Wed, 11 Aug 2021 at 06:39, Boubacar Bah <bahbouba.909@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@lists.osgeo.org> a
?crit :Send Pgrouting-users mailing list submissions to
pgrouting-users@lists.osgeo.orgTo 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@lists.osgeo.orgYou can reach the person managing the list at
pgrouting-users-owner@lists.osgeo.orgWhen replying, please edit your Subject line so it is more specific
than “Re: Contents of Pgrouting-users digest…”Today’s Topics:
- 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@georepublic.de>
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Pgrouting-users Digest, Vol 137, Issue
1
Message-ID:
<
CABXBSH9qU33gFXCZUdGAreSi46rBRFMEOERFDp61HTRJMTYFzA@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,
DanielOn Tue, 10 Aug 2021 at 04:39, Boubacar Bah <bahbouba.909@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 advanceLe lun. 9 ao?t 2021 ? 20:01, <pgrouting-users-request@lists.osgeo.org>
a
?crit :Send Pgrouting-users mailing list submissions to
pgrouting-users@lists.osgeo.orgTo 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@lists.osgeo.orgYou can reach the person managing the list at
pgrouting-users-owner@lists.osgeo.orgWhen replying, please edit your Subject line so it is more specific
than “Re: Contents of Pgrouting-users digest…”Today’s Topics:
- Asking help (Boubacar Bah)
- Re: Asking help (Rajat Shinde)
Message: 1
Date: Mon, 9 Aug 2021 14:24:55 +0100
From: Boubacar Bah <bahbouba.909@gmail.com>
To: pgrouting-users@lists.osgeo.org
Subject: [pgrouting-users] Asking help
Message-ID:
<
CALOg8kGhEwenrGrZ-e8XihFJ9Ycb-kjUx3x0TKf59gdARghpYw@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@gmail.com>
To: pgRouting users mailing list <pgrouting-users@lists.osgeo.org>
Subject: Re: [pgrouting-users] Asking help
Message-ID:
<
CAKyj99mMamWJCoeWx45cHCMnBGNpXVNEYsF1QiN-nJCUUqpuSQ@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,
RajatOn Mon, Aug 9, 2021 at 6:55 PM Boubacar Bah <bahbouba.909@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@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@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@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/pgrouting-users–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@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@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@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/pgrouting-users–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@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@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/pgrouting-users
End of Pgrouting-users Digest, Vol 137, Issue 5