Reputation
387
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 3 16
Impact
~48k people reached

  • 0 posts edited
  • 0 helpful flags
  • 9 votes cast
Feb
6
revised How to convert MultiLinestring to Linestring?
added 1789 characters in body
Feb
6
asked How to convert MultiLinestring to Linestring?
Feb
6
accepted Vertex point is returning None
Feb
6
comment Vertex point is returning None
alright, ST_AsEWKT() did the job. Thanks for helping me out on the ST_Dump etc.
Feb
6
comment Vertex point is returning None
I am trying ST_AsText(ST_Dump(%s)) but it returns an ERROR: function st_astext(geometry_dump) does not exist on character 8
Feb
6
comment Vertex point is returning None
Cool, do you know if there is a way to get the WKT of the ST_dump? I can only get the binary format..I read the doc but I do not understand how it gets the ST_AsText().. Thanks!
Feb
6
asked Vertex point is returning None
Feb
2
comment Passing parameters to PostGIS SQL queries in Python: weird behaviour
Yeap, I have excausted coding alternatives based on this document initd.org/psycopg/docs/usage.html#query-parameters..
Feb
2
comment Passing parameters to PostGIS SQL queries in Python: weird behaviour
Hi, yes I tried hard coding it and still does not work...
Feb
2
asked Passing parameters to PostGIS SQL queries in Python: weird behaviour
Jan
27
comment clip linestring by length
You are right, some of my lines have a double ending like a double fork and that is probably causing trouble to postgis...Anyway, thank you very much for your help!
Jan
27
accepted clip linestring by length
Jan
27
comment clip linestring by length
Right, your suggestion works fine but it seems that postgis has problems converting some specific multilinestrings into linestrings which is necessary before calling the st_line_substring function. Is there a way to come around this postgis issue?
Jan
26
comment clip linestring by length
thx, i ll give it a try!
Jan
26
asked clip linestring by length
Jan
16
accepted Is there a straightforward way to get the source/target point geometry of an edge?
Jan
16
asked Is there a straightforward way to get the source/target point geometry of an edge?
Jan
16
comment line segments using points
hi, i am now usign 1.5 but i will definatelly install 2.0 once it gets a bit more stable. Anyway, what I did to solve this issue was to get the npoint count and create a dictionary in my code with vertex id as key and point geom as value. I could then use postgis 1.3 functions to come around my problem. Of course when 2.0 is installed, i will be able to greatly optimise my code :)
Jan
10
comment How does pgRouting shortest_path work?
Yes, I agree this is a straightforward answer to the title. My issue has to do with how the algorithm is identifying the verticies so that the dijkstra algorithm can work.
Jan
10
comment How does pgRouting shortest_path work?
Yes, I just saw your update. I will try and work with smaller line segments. Thank you very much for your input.