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

[bruce bushby]

Hi

I'm guessing my question is a very common example however I've been
struggling (3 days) to find an example that works for me.

I have converted my NMEA gps into decimal degrees:
track=# select lat,long,the_geom from t001;
    lat     |    long     |
the_geom
------------+-------------+----------------------------------------------------
 51.4096    | -0.210978   |
0101000020AD100000647616BD5301CBBF8638D6C56DB44940



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);
 st_assvg
----------
(0 rows)

UK=#

My goal is to "select" from multiple maps (maps/tables were created with
shp1pgsql) around given gps coordinates and return as svg.

Any help much appreciated!

Thanks
Bruce
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100502/c2af0871/attachment.html>