[postgis-users] Raster + Geometry Intersection

[Pierre Racine]

> I noticed that the OSM data is using srid = 900913. So I reloaded the tif files as
> the same srid, yet no luck with the intersection query! :( ALTER TABLE
> public.planet_osm_line ADD COLUMN way geometry(LineString,900913);

Specifying -s 900913 at load time do not make the rasters to be 900913... You have to reproject something with ST_Transform. Go for reprojecting the geometries since we still have a bug with reprojectings rasters. 

Pierre