[postgis-users] Raster + Geometry Intersection

[Ed Linde]

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.Racine at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120227/b5c85d3e/attachment.html>