[postgis-users] ST_SetSRID
dustymugs
dustymugs at gmail.com
Wed Feb 20 15:30:28 PST 2013
Hey Laurent,
The following should work. It works on my production server.
WITH foo AS (
SELECT ST_AddBand(ST_MakeEmptyRaster(5, 5, -1987330.654, -39780.983,
1000, -1000, 0, 0, 97125), 1, '8BUI', 1, 0) AS rast
)
SELECT
ST_SRID(rast),
ST_SRID(ST_Transform(rast, 3310))
FROM foo
Also, please provide the output of the following so that we can see
replicate any issues.
SELECT postgis_full_version()
-bborie
On 02/20/2013 03:21 PM, laurent 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
>
More information about the postgis-users
mailing list