1,497 reputation
1640
bio website
location
age
visits member for 3 years, 4 months
seen Jul 17 at 8:18

Jun
29
comment How to add column length in a pgRouting PostGIS database?
@underdark let us continue this discussion in chat
Jun
29
comment How to add column length in a pgRouting PostGIS database?
I realized that it gives me results only when I put two nodes in a row (3,4 or 5,6) like: SELECT * FROM shortest_path ('SELECT gid AS id, start_id::int4 AS source, end_id::int4 AS target, cost_length::double precision AS cost FROM network', 5, 6, false, false); Any idea what is the problem?
Jun
29
comment How to add column length in a pgRouting PostGIS database?
I just figured it out, but of course it gives me an error: No rows found. Total runtime: 6.056 ms SQL executed. What that means? How is possible that no rows is found?
Jun
29
comment How to add column length in a pgRouting PostGIS database?
Yeah, that's right, thank you. But now it gives me another error: SQL error: ERROR: Error, query must return columns 'id', 'source', 'target' and 'cost' I don't understand what that means?
Jun
29
comment How to add column length in a pgRouting PostGIS database?
I did it. Now I tried to calculate shortest route with Shortest Path Dijkstra, I saw an example on your blog underdark.wordpress.com/2011/02/07/…. But when I execute sql: SELECT * FROM shortest_path('SELECT gid AS id, start_id::int4, end_id::int4, cost_length::double precision AS cost, FROM network', 3, 7, false, false); it gives me an error: SQL error: ERROR: syntax error at or near "FROM" LINE 3: FROM network ^ QUERY: SELECT gid AS id, start_id::int4, end_id::int4, cost_length::double precision AS cost, FROM network
Jun
29
comment How to add column length in a pgRouting PostGIS database?
I succeeded with creating view. Thank you :)
Jun
29
accepted How to add column length in a pgRouting PostGIS database?
Jun
28
awarded  Nice Question
Jun
28
comment How to add column length in a pgRouting PostGIS database?
It gives me error: SQL error: ERROR: parse error - invalid geometry LINE 5: ST_Length3D('the_geom') as "length" ^ HINT: You must specify a valid OGC WKT geometry type such as POINT, LINESTRING or POLYGON
Jun
28
comment How to add column length in a pgRouting PostGIS database?
I'm using phpPgAdmin.
Jun
26
comment How to add column length in a pgRouting PostGIS database?
I wrote it this way: ALTER TABLE network ADD COLUMN cost_length double precision; UPDATE network SET cost_length = ST_Length3D(the_geom);
Jun
26
comment How to add column length in a pgRouting PostGIS database?
It gives me an error: ERROR: syntax error at or near "TABLE" LINE 1: SELECT COUNT(*) AS total FROM (ALTER TABLE network ADD COLUM...
Jun
26
asked How to add column length in a pgRouting PostGIS database?
Jun
21
accepted Is Orbit EOS Lite Free GIS Map Server an OpenSource software?
Jun
21
comment Is Orbit EOS Lite Free GIS Map Server an OpenSource software?
Ok, I understand, thank you!
Jun
21
asked Is Orbit EOS Lite Free GIS Map Server an OpenSource software?
Jun
15
accepted Webmapping with pgRouting and Mapserver for Beginners
Jun
15
accepted How to zoom to full map extent with mapserver?
Jun
15
comment Webmapping with pgRouting and Mapserver for Beginners
I developed web map which need to have this shortest path function. I don't think it is too broad. I just want you to tell me how to start. I am beginner with pgRouting, not with web mapping.
Jun
15
revised Webmapping with pgRouting and Mapserver for Beginners
added 165 characters in body