[postgis-users] indexing images stored in PostGres

[Paul Ramsey]

P Kishor wrote:
> The topic of storing satellite imagery in the db vs. on the filesystem
> has been discussed before. I am hoping for answer to the following --
> 
> Can I store imagery in the db with the hope of being able to query for
> specific areas of interest (AOI) in the imagery and retrieving just
> those portions of the image?

Use PostGIS to hold your Mapserver TILEINDEX of your images, and store 
your images on disk.
Use Mapserver WMS to pull AOI from this "master image" managed by the 
TILEINDEX.

> The images repository is not static -- new images are being added
> constantly, at a pretty high rate... several Gb a day.
> 
> I am hoping for a config like so --
> 
> Images from source --> PostGres with images <--> PostGIS with spatial
> index of images <--> MapServer <--> Application with a map interface
> to allow zooming into the AOI and retrieving the relevant portion from
> the underlying imagery
> 
> Does PostGIS/PostGres allow for such spatial indexing of images?

Images from Source -> Disk Archive -> Insert metadata record into 
PostGIS -> use TILEINDEX in Mapserver to reference particular images -> 
web map etc.

Paul




-- 

   Paul Ramsey
   Refractions Research
   http://www.refractions.net
   pramsey at refractions.net
   Phone: 250-383-3022
   Cell: 250-885-0632