meta user
network profile
|
Jan 10 |
comment |
How does pgRouting shortest_path work? Hi, Yes, I used assign_vertex_id() and it was completed successfully. When I check my table \d <table> it looks like the example in the documentation with the vertices_tmp and vertices_tmp_seq.. When I created my lines in qgis, I was snapping them together so there are intersection that can be picked up. I also found this example, underdark.wordpress.com/2011/02/07/…, Should I try this instead? Although I do not understand what is going wrong.. |
|
Jan 10 |
asked | How does pgRouting shortest_path work? |
|
Jan 4 |
accepted | How to correctly use cursor.execute() with PostGIS? |
|
Jan 4 |
comment |
How to correctly use cursor.execute() with PostGIS? hmm, I will try your solution! I also tried another method and it worked! I re-assigned my point to a new variable and used that instead. Somethign like this newPoint = point. Right, so what should I do now? should I re-post or leave it like this? |
|
Jan 4 |
comment |
How to correctly use cursor.execute() with PostGIS? Nope, it does not work like that either.. Also, my point is ususally passed not hardcoded but loaded from the database etc. So my code looks like this but still does not work, a = "SELECT ST_Distance(ST_GeomFromText(%s),ST_GeomFromWKB(geometry)),ST_AsText(ST_Centroid(geometry)) FROM cameron_toll_nodes As a WHERE name=%s;" b = (point,'exit') # point is POINT(x y) format cc.execute(a,b) Any ideas? :) |
|
Jan 4 |
asked | How to correctly use cursor.execute() with PostGIS? |
|
Dec 30 |
comment |
line segments using points I 'll explain step by step. I am buffering a polygon and getting its boundary which returns a linestring in which the start and end are the same point. Then, I have random points on the buffered linestring and I want to use them to cut the linestring into pieces. I have written down methods that involve st_split or st_dumppoints but these functions are all in other postgis versions. I hope this makes sense. THX! |
|
Dec 29 |
asked | line segments using points |
|
Dec 29 |
awarded | Scholar |
|
Dec 29 |
comment |
Why does st_split not work? Yes, I was using 1.4 Thank you for your answer. |
|
Dec 29 |
accepted | Why does st_split not work? |
|
Dec 29 |
comment |
Why does st_split not work? Hi, I am sorry I forgot to add the error. ERROR: function st_split(geometry, geometry) does not exist LINE 1: select ST_Split( ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts. |
|
Dec 29 |
awarded | Student |
|
Dec 28 |
asked | Why does st_split not work? |
