Opened 7 years ago
Last modified 18 months ago
#1379 new enhancement
[raster] raster2pgsql: load a raster as a band(s) of an existing raster
Reported by: | chdemars | Owned by: | pracine |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS Fund Me |
Component: | raster | Version: | trunk |
Keywords: | Cc: |
Description
It would be nice to be able to load a raster as a band of an existing raster table. For instance, landsat data comes with each band a separate single band raster. I am currently loading each band as a separate table, merging them into a multi-band raster using AddBand?, then removing the individual band tables. Seems like a kludgy way to do a common task.
Change History (8)
comment:1 Changed 7 years ago by
Version: | 1.5.X → trunk |
---|
comment:2 Changed 7 years ago by
Milestone: | PostGIS Raster Future → PostGIS Future |
---|
comment:3 Changed 6 years ago by
comment:4 Changed 6 years ago by
What would be possible however is to have an extra option to "interpret 1, 2, 3, or 4 '#' characters in wildcard based input filenames as a search for band numbers and load corresponding bands as a one multiple band raster"...
Would not be possible to append to existing rasters, but would be able to load landsat easily.
comment:7 Changed 6 years ago by
That probably won't work. The filenames (and usage of wildcards) are depending upon the environment in which raster2pgsql is called. As for pulling specific bands, -b already exists for that purpose.
raster2pgsql does not have any connection to the database to verify that there is a raster (and the raster's attributes) to append to. It would need access to the database to even check which raster the new band should be added to (especially for tiles).
The lack of database connection is by design (specifically following the design and behavior of shp2pgsql).