[postgis-users] Raster + Geometry Intersection

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Mon Feb 27 06:40:27 PST 2012

> 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. 


More information about the postgis-users mailing list