360 reputation
210
bio website rawkes.com
location London, United Kingdom
age
visits member for 1 year, 2 months
seen Apr 14 at 10:02

Mar
22
revised Looking for a free program for 3D visualization
added 152 characters in body
Mar
20
comment 3D perspective on maps in Leaflet, CartoDB?
No worries, just wanted to give you a heads-up.
Mar
20
revised 3D perspective on maps in Leaflet, CartoDB?
added 47 characters in body
Mar
20
answered Looking for a free program for 3D visualization
Mar
18
awarded  Yearling
Mar
18
answered 3D perspective on maps in Leaflet, CartoDB?
Dec
7
awarded  Notable Question
Oct
13
comment ST_ShortestLine gives different results for 4326 and 900913 projections. Which is correct?
Aha, that begins to make a little more sense. So if I were to go outside and find the GPS coordinates of the nearest physical point on the road (from a bus stop) then it should match up with the blue line (900913) rather than the pink one. Correct?
Oct
13
asked ST_ShortestLine gives different results for 4326 and 900913 projections. Which is correct?
Jul
15
awarded  Popular Question
Apr
19
awarded  Nice Question
Mar
2
comment ST_Buffer won't accept bevel join styles (always displays as round)
Thanks for the help. Here is the output of the version query… "POSTGIS="2.0.2 r10789" GEOS="3.3.7-CAPI-1.7.7" PROJ="Rel. 4.8.0, 6 March 2012" LIBXML="2.7.8" LIBJSON="UNKNOWN"" I've been checking that every time I upgrade GEOS and it always reflects the latest version installed (without using ALTER EXTENSION).
Mar
1
awarded  Promoter
Feb
28
awarded  Tumbleweed
Feb
24
asked Is there a public shapefile with the London Underground stations and lines?
Feb
21
revised ST_Buffer won't accept bevel join styles (always displays as round)
Added new information
Feb
21
asked ST_Buffer won't accept bevel join styles (always displays as round)
Feb
15
revised How can I create polygons of the area surrounded by roads / lines?
Added solution code
Feb
15
comment How can I create polygons of the area surrounded by roads / lines?
Thank you! ST_Polygonize did the trick. I've updated the question with the code that worked.
Feb
15
accepted How can I create polygons of the area surrounded by roads / lines?