Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-18 Thread Regina Obe
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

Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-18 Thread Pierre Racine
[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

Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-17 Thread Osahon Oduware
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

Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-15 Thread Regina Obe
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

Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-11 Thread Osahon Oduware
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

Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-11 Thread Osahon Oduware
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

Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-11 Thread Tumasgiu Rossini
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

Re: [postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-11 Thread Tumasgiu Rossini
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, > >

[postgis-users] Fwd: PostGIS Out-DB Raster Not Behaving As Expected

2017-04-11 Thread Osahon Oduware
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