[postgis-users] Raster + Geometry Intersection

[Pierre Racine]

> ok, just to get this right.. :) , you are suggesting I keep my OSM as is (id: 900913).
> Load in the tif rasters as srid (4326) and then "reproject" the OSM road geometry
> to srid = 4326 right? So it matches the srid of my raster! I ask because you said
> to reproject to 900913 in your mail.

Correct. We're on the right way.

You can  create a new raster table (after loading them properly with 4326) with your rasters reprojected to 900913 but as I said you might hit our bug:

http://trac.osgeo.org/postgis/ticket/1618

Pierre