[postgis-users] select "ST_AsSvg" from multiple tables in relation to decimal degree coordinates

Robert Coup robert.coup at onetrackmind.co.nz
Sun May 2 14:01:27 PDT 2010

Hi Bruce,

On Mon, May 3, 2010 at 8:46 AM, bruce bushby
<bruce.bushby at googlemail.com> wrote:
> Then I have a map of roads which I know has roads all around my coordinates,
> so I wanted to select "ST_AsSvg" a 1 Kilometre square block around my
> coordinates, I tried to do this with:
> UK=# select ST_AsSvg(the_geom) from minor_rd_polyline where the_geom &&
> SetSRID('BOX3D(51.4095 -0.211098 0,51.4080 -0.211080 0)'::box3d,-1);

It should be
BOX3D(-0.211098 51.4095 0, -0.211080 51.4080 0)

The order of coordinates for anything in postgis is (X, Y[, Z])

Rob :)

More information about the postgis-users mailing list