Opened 10 years ago

Last modified 7 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:

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

comment:1 by strk, 10 years ago

Keywords: history added
Resolution: → fixed
Status: new → closed

r12789 in trunk

comment:2 by strk, 10 years ago

Resolution: fixed
Status: closed → reopened

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 by strk, 10 years ago

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 by Bborie Park, 9 years ago

Milestone: PostGIS 2.2.0 → PostGIS Future

comment:5 by robe, 7 years ago

Milestone: PostGIS Future → PostGIS Fund Me

Milestone renamed

Note: See TracTickets for help on using tickets.