Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options questions only not deleted user 37519

pgRouting extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality.

0 votes
1 answer
413 views

from coordinates can i find from multilinestring from database

Hello i have the coordinates from two points(x,y) and i have a database with roads and i want to find with dijstrak algorithm wich road i take but the algorithm want source and target but in my applic …
vagelis's user avatar
  • 609
1 vote
1 answer
279 views

problem in pgRouting with data from google earth

Hello i am new in forum an in Postgesql,postgis and pgRouting. I try to make a pgrouting for my city roads. … 26.7095018,37.8014089,0.0 </coordinates></LineString></MultiGeometry>'),4326)); Update After the inserts i create topology and other step from the http://workshop.pgrouting.org/chapters/topology.html for make a pgRouting
vagelis's user avatar
  • 609
2 votes
1 answer
647 views

Using pgrouting and algorithms in PostgreSQL?

I am trying my first pgrouting in a roads shapefile I load it in PostgreSQL first, the table has osm_id, gid, name, ref, type, oneway, maxspeed Then I add columns source and target in table: ALTER TABLE …
vagelis's user avatar
  • 609
3 votes
2 answers
205 views

Can pgr_dijkstra use a boolean column for routing?

I want to use Dijkstra algorithm. I would like to have the algorithm find a route based on a boolean traffic column, using only roads where the boolean column value is true. The code below does not …
vagelis's user avatar
  • 609
1 vote
1 answer
414 views

how to Find nearest line for the given point from a collection of lines?

I have table with lines(linestring).For a point wich i give it , I want to find out nearest line in point. I almost developed a query, but it is return the same line every point i give. the query …
vagelis's user avatar
  • 609
5 votes
0 answers
241 views

A* pgRouting issue with x1,y1 and x2,y2 values

I am trying to use the A* algorithm in a topology I have made in PostgreSQL. I can fill the x1,y1 and x2,y2 the latitude/longitude, but I have read that the same version has problems with ST_StartPoin …
vagelis's user avatar
  • 609
1 vote
1 answer
2k views

Using Pgrouting dijkstra algorithm in PostGIS?

I own two tables one with streets and one points, i use the table with the roads to calculate routes with dijkstra algorithm. But I want when someone add one point in the table Point and this point is …
vagelis's user avatar
  • 609
5 votes
4 answers
10k views

Take from multilinestring the start and end points

I have to use the A* algorithm and my geometry is in multilinestring and I want to take stratpoint(x1,y1) and endpoint(x2,y2) . I use this queries but the columns after the execute is still empty UP …
vagelis's user avatar
  • 609