[postgis-users] bring PostGIS into the raster world

[Gregory S. Williamson]

As Steven Woodbridge pointed out in an earlier post, storing the raster images on disk and referring to them in postGIS is certainly a way to go.

One reason to put images into the database is if the data is somewhat volatile and you need to endure transactional integrity; that's harder to do when some of the data is in a regular file system. A drawback can be the overhead of processing the data in/out of postgres, depending on how much of it there is and how it is stored. I've done systems in the past where we stored TIFF images in blobs in a database; we were able to tune the blob size to handle the TIFFs so disk access was quite efficient. 

That said, we at GX put our imagery on disks (ok, usually an image and a backup on a second storage device); the database has the metadata about who owns the thing and what it is, the spatial coordinates, the primary and secondary locations and so on. We have some scripts that we use to move the actual files and maintain sync with the database. We're moving toward putting frequently used imagery on faster devices and migrating the lesser used data to slower cheaper storage; hard to do that with everything in one database.

HTH,

Greg Williamson
DBA
GlobeXplorer LLC


-----Original Message-----
From:	postgis-users-bounces at postgis.refractions.net on behalf of Warren Noll
Sent:	Mon 7/3/2006 8:11 AM
To:	postgis-users at postgis.refractions.net
Cc:	
Subject:	[postgis-users] bring PostGIS into the raster world

What is the best way to handle raster images when using PostGIS?  Is it
possible to store the location of the raster and have that returned by the
query and then let the viewer retrieve the image based upon the gml or
something.

 

I'm new to this stuff, so sorry if this is a strange way to handle rasters.

 

Warren Noll

21st Century Systems, Inc.

199 East 4th Street, Suite B

University of Missouri Technology Park, Building 2081

Fort Leonard Wood, MO 65473

573-329-8526 ext. 2165

573-329-8509 (Fax)

WARREN.NOLL at 21CSI.COM   <http://www.21CSI.COM> WWW.21CSI.COM

 

 

 

********************************************************************

  This electronic mail transmission contains confidential

  information intended only for the person(s) named.

  Any use, distribution, copying or disclosure by another

  person is strictly prohibited.

********************************************************************

 

 






!DSPAM:44a933c1149656491211187!



-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 5934 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060703/237159a9/attachment.jpg>