Opened 3 years ago

Last modified 2 years ago

#2843 reopened enhancement

[raster] Support reprojection on import

Reported by: strk Owned by: dustymugs
Priority: medium Milestone: PostGIS Future
Component: raster Version: trunk
Keywords: history Cc:

Description

shp2pgsql recently got a switch to reproject vectors during import (-s <from>:<to>). It would be nice to have the same switch in raster2pgsql, especially for handling overviews that are more annoying to deal with after import.

Change History (4)

comment:1 Changed 3 years ago by strk

Keywords: history added
Resolution: fixed
Status: newclosed

r12789 in trunk

comment:2 Changed 3 years ago by strk

Resolution: fixed
Status: closedreopened

I'm reopening this because in-db reprojection is very limited. The main 2 limits are:

  1. Tiled output can result in different tiles using different scales (easy, if you come from 4326 and project to webmercator/3857)
  2. You cannot use COPY mode (-Y)

Ideally the transformation would be done via GDAL instead.

comment:3 Changed 3 years ago by strk

One problem with having reprojection done by GDAL is that we cannot use a "srid" but rather we need an "srs". Constructing it from a query into spatial_ref_sys would break current isolation between the loader and the database.

comment:4 Changed 2 years ago by dustymugs

Milestone: PostGIS 2.2.0PostGIS Future
Note: See TracTickets for help on using tickets.