367 reputation
214
bio website N/A
location Edinburgh
age 31
visits member for 2 years, 9 months
seen Jul 10 at 15:15

Working with and discovering geo-information :)


Oct
10
awarded  Popular Question
Sep
19
accepted Why does ST_Transform fail?
Sep
17
comment Why does ST_Transform fail?
My postgis_full_version() - POSTGIS="1.4.0" GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.8.0
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.