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
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users