Opened 7 years ago

Last modified 4 years ago

#2843 reopened enhancement

[raster] Support reprojection on import

Reported by: strk Owned by: Bborie Park
Priority: medium Milestone: PostGIS Fund Me
Component: raster Version: master
Keywords: history Cc:


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 (5)

comment:1 Changed 7 years ago by strk

Keywords: history added
Resolution: fixed
Status: newclosed

r12789 in trunk

comment:2 Changed 7 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 7 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 7 years ago by Bborie Park

Milestone: PostGIS 2.2.0PostGIS Future

comment:5 Changed 4 years ago by robe

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.