ark' <dustym...@gmail.com>
Subject: RE: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected
I guess st_transform should be applied only when using the same syntax as
shp2pgsql : -s from_srid:to_srid.
And it should be prohibited when used with –R. I don’t think we want to go
[mailto:l...@pcorp.us]
Envoyé : 16 avril 2017 00:06
À : 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>
Cc : Pierre Racine <pierre.rac...@sbf.ulaval.ca>; 'Bborie Park'
<dustym...@gmail.com>
Objet : RE: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving A
to:postgis-users-boun...@lists.osgeo.org] *On
Behalf Of *Tumasgiu Rossini
*Sent:* Tuesday, April 11, 2017 8:32 AM
*To:* PostGIS Users Discussion <postgis-users@lists.osgeo.org>
*Subject:* Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As
Expected
Maybe a warning showing u
Discussion <postgis-users@lists.osgeo.org>
Subject: Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected
Maybe a warning showing up when using -s and -R options together could be a
nice thing to do ?
Or maybe implementing another option which would use st_setsrid i
Hi Tumasgiu,
Thanks a lot. You have been of great help.
On Tue, Apr 11, 2017 at 2:13 PM, Tumasgiu Rossini
wrote:
> Hi, I think that
> UPDATE table SET rast = ST_SetSRID(rast, mysrid) ;
> would do.
>
> However, doing so will leads to potentially inconsistent metadata
Hi Tumasgiu,
Thanks a lot, that solved the problem. You made my day.
On Tue, Apr 11, 2017 at 1:31 PM, Tumasgiu Rossini
wrote:
> Maybe a warning showing up when using -s and -R options together could be
> a nice thing to do ?
> Or maybe implementing another option which
Maybe a warning showing up when using -s and -R options together could be a
nice thing to do ?
Or maybe implementing another option which would use st_setsrid instead of
st_transform.
2017-04-11 14:25 GMT+02:00 Tumasgiu Rossini :
> Hi,
>
> I think I found the probelm, it is
Hi,
I think I found the probelm, it is the -s option which make the sql
applying a st_transfrom on the raster to reproject it into the desired CRS
before inserting it in the table, thus creating an in-db raster.
2017-04-11 12:14 GMT+02:00 Osahon Oduware :
> Hi Regina,
>
>
Hi Regina,
I would like to add that the SHOW command below returns "on":
SHOW postgis.enable_outdb_rasters;
which I believe indicates that the environment variable is SET to enable
out-db raster. However, the result from your 1st query shows that the
raster table isn't created with out-db. Any