meta user
network profile
|
Sep 17 |
comment |
Why does ST_Transform fail? Hi, I started testing in the UK but now it has gone global so I am trying to come around this problem. |
|
Sep 17 |
comment |
Why does ST_Transform fail? Hi, I tried it today and it worked, then I tried it again and it did not by throwing an error like this, ERROR: AddToPROJ4SRSCache: couldn't parse proj4 string: '+proj=utm +zone=47 +ellps=WGS84 +datum=WGS84 +units=m +no_defs ': latitude or longitude exceeded limits |
|
Sep 14 |
comment |
Why does ST_Transform fail? i just copied it from postgresql log file in which E indicates a string if I am not mistaken.. |
|
Sep 14 |
comment |
Why does ST_Transform fail? hi, i tried the 32647 and it still throws the same error. Thanks for your help though! |
|
Sep 14 |
asked | Why does ST_Transform fail? |
|
Sep 4 |
awarded | Supporter |
|
Sep 3 |
comment |
How do I use st_dwithin with meters? Thank you for your answer. I used the functions above and they indeed return meters but i can only use them to calculate a distance between two latlong geometries and I need to use it to calculate distance from polygon edges. I thought of a solution with the above info, I could use st_closestPoint() to my polygon and then st_distance_sphere() which will do the trick. Problem is I am using postgis 1.4 and st_closestPoint() is unavailable. Also, I would like to use minimum code because ST_WDistance() will return a simple true/false whilst the other alternatives need more coding. |
|
Sep 3 |
asked | How do I use st_dwithin with meters? |
|
Mar 2 |
comment |
postgis minimum distance among many points I found my answer here, stackoverflow.com/questions/2098186/… Thanks! |
|
Mar 2 |
comment |
postgis minimum distance among many points Yes, I am trying to get the geometry which has the minimum distance from the given point. In the provided link, it is requesting a less than or more than using a default value. which works fine in the WHERE section. |
|
Mar 1 |
asked | postgis minimum distance among many points |
|
Feb 7 |
accepted | How to convert MultiLinestring to Linestring? |
|
Feb 6 |
awarded | Editor |
|
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 |
