Stack Overflow
Stack Overflow

Questions tagged [pgrouting]

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

pgRouting is an Open Source software add-on to PostgreSQL / PostGIS to find routes through road networks and solves general graph analysis problems.

Project homepage: http://pgrouting.org/index.html

144 questions
0
votes
1 answer

Create a consistent topology using pgrouting

I'm developing an application that needs routing information for certain cities. First, I downloaded a openstreetmap datafile (*.osm) and then I imported it into a postgreSQL database using osm2pgrouting tool…
user1809983
  • 105
  • 3
0
votes
2 answers

assign_vertex_id error

I am trying to test if pgrouting works fine or not. To do so I have created a table containing the following attributes. Columns: gid | length | the_geom | source | target Now my problem is that when I try to execute the…
IT_info
  • 707
  • 4
  • 16
  • 36
0
votes
1 answer

Creating graph for pgRouting with PostGIS?

Let the line A (0.98,0.562,3.27536,5.9723) and line B (3.33221,5.899287,10.7656,9.653627). Does pgrouting take a point near (3.27536,5.9723) or (3.33221,5.899287) as a node? Really theses two points are just one, they have only a little error range.
José Alejandro
  • 131
  • 2
-1
votes
1 answer

Find distance using gps coordinate to next vertex

I am creating a Bus arrival prediction system using Java and Postgres.There is fixed route for each bus, so we are storing whole driving route as LineString in postgres. There are 3 bus stoppage, and each bus stop lat lon is also stored as…
raw
  • 409
  • 1
  • 5
  • 11
-1
votes
1 answer

PostgreSQL ,Postgis and Pgrouting compatible versions

I am trying to work with PostgreSql 9.3, Postgis 2.1.3 and Pgrouting 2.0.0 versions in Ubuntu (VPS). I have installed PostgreSql 9.3,but when i run CREATE EXTENSION postgis SCHEMA public VERSION "2.0.0"; in PgAdmin3 i get ERROR: could not stat…
user19566
  • 153
  • 1
  • 12
-1
votes
1 answer

Pgrouting - pgr_kdijkstraCost int limitations

I've been able to map the driving time and distance between different points in a small city, but I would now like to be able to do this for the United States. However, I've learned that the function pgr_kdijkstraCost is limited by int arguments.…
geomaps9
  • 27
  • 6
-3
votes
1 answer

Which are the best tools available for an online routing application?

So here's my question. Supposing that one is about to create an online web appliation that takes as user input a current location and a location for destination, and displays as a result one of the 5-6 available routes that are stored in a database…
drizo
  • 267
  • 6
  • 14
-3
votes
1 answer

Routing in MS SQL Server 2012

CREATE INDEX source_idx ON road_network("source"); CREATE INDEX target_idx ON road_network("target"); ALTER TABLE road_network ADD COLUMN length double precision; UPDATE road_network SET length = length(the_geom); ALTER TABLE road_network ADD…
Vikram
  • 151
  • 1
  • 1
  • 4
-5
votes
1 answer

How to get a road path which can be travelled in 10 minutes from a location

I have postgis road network table data base with speed limits based on type of road. I can able to get shortest path/route between two points by using Dijkstra or any other algorithm. Now I want to get possible paths that can be travelled from a…
Satya Chandra
  • 728
  • 2
  • 12
  • 26
1 2 3
…
9
10