[postgis-tickets] [PostGIS] #3738: Using -s and -R together in raster2pgsql transforms raster data instead of setting srid

[PostGIS]

#3738: Using -s and -R together in raster2pgsql transforms raster data instead of
setting srid
---------------------+---------------------------
  Reporter:  robe    |      Owner:  robe
      Type:  defect  |     Status:  new
  Priority:  medium  |  Milestone:  PostGIS 2.4.0
 Component:  raster  |    Version:  2.3.x
Resolution:          |   Keywords:
---------------------+---------------------------
Changes (by robe):

 * owner:  dustymugs => robe


Old description:

> I haven't tested this myself, but on postgis users list, two people
> mentioned this behavior:
>
> https://lists.osgeo.org/pipermail/postgis-users/2017-April/042020.html
>

> {{{
> 2017-04-11 14:25 GMT+02:00 Tumasgiu Rossini <rossini.t at gmail.com>:
>
> > 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.
> >
> }}}

New description:

 I haven't tested this myself, but on postgis users list, two people
 mentioned this behavior:

 https://lists.osgeo.org/pipermail/postgis-users/2017-April/042020.html


 {{{
 2017-04-11 14:25 GMT+02:00 Tumasgiu Rossini <rossini.t at gmail.com>:

 > 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.
 >
 }}}


 As Pierre noted, best thing to do is use the same reprojection syntax and
 shp2pgsql -s from_srid:to_srid  (this might work already) have to test.
 and forbit transform with out-db.  Since there is no point if its going to
 end up being in-db.

 https://lists.osgeo.org/pipermail/postgis-users/2017-April/042050.html

--

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3738#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.