Hi Bruce,
On Mon, May 3, 2010 at 8:46 AM, bruce bushby
<bruce.bus...@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 :)
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
