Hi Pierre, I checked the srids of the geometry and the rasters and they are both now set to --> 900913! I was using qgis and I think I made a mistake because I think the tif files on disk are using srid = 4326, while the postgis layer I added was using 900913 for osm. I have never used OpenJump.. is it possible to view both my raster and road geometries from postgis on to qgis? Or you recommend installing OpenJump? Also, do I still need to do some sort of reprojection on the geometries? Is the SRID of 900913 reported for my rasters...reliable information?
Cheers, Ed On Mon, Feb 27, 2012 at 3:40 PM, Pierre Racine <pierre.rac...@sbf.ulaval.ca>wrote: > > 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 >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users