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