Opened 9 years ago
Last modified 6 years ago
#2843 reopened enhancement
[raster] Support reprojection on import
|Reported by:||strk||Owned by:||Bborie Park|
|Priority:||medium||Milestone:||PostGIS Fund Me|
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 , 9 years ago
|Status:||new → closed|
comment:2 by , 9 years ago
|Status:||closed → reopened|
I'm reopening this because in-db reprojection is very limited. The main 2 limits are:
- Tiled output can result in different tiles using different scales (easy, if you come from 4326 and project to webmercator/3857)
- You cannot use COPY mode (-Y)
Ideally the transformation would be done via GDAL instead.
comment:3 by , 9 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 , 8 years ago
|Milestone:||PostGIS 2.2.0 → PostGIS Future|
comment:5 by , 6 years ago
|Milestone:||PostGIS Future → PostGIS Fund Me|
r12789 in trunk