[postgis-users] ST_SetSRID

Rebecca Clarke r.clarke83 at gmail.com
Wed Feb 20 15:25:05 PST 2013


Did you reproject using st_transform(rast,4326)
?
What's the error you get?

On Wed, Feb 20, 2013 at 11:21 PM, laurent
<lcelati at latitude-geosystems.com>wrote:

> Hello,
>
> I tried to reproject one of my postgis raster layer (called 'bd_ortho')
> from
> SRID 2154 to SRID 4326 . It seems work.
> But the metadata are not updated. Indeed when i tape
>
>  SELECT ST_SRID(rast) As srid FROM bd_ortho WHERE rid=1;
>
> The result is always 2154.
>
> So that's why i tape this following query in order to Set the SRID of a
> raster defined in the spatial_ref_sys tabl:
>
>  ST_SetSRID(rast, 4326);
>
> But this SQL query is not accepted and a error message appears.
>
>
> Could you throw light for me please? Is there a way to reproject & update
> metadata in one SQL query?
>
> Thanks.
>
> Regards.
>
>
>
> --
> View this message in context:
> http://postgis.17.n6.nabble.com/ST-SetSRID-tp5002645.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130220/72018cc7/attachment-0001.html>


More information about the postgis-users mailing list