[postgis-users] [More Asks]: GeoTiff into PostGIS

[joshua.uyehara at syngenta.com]

Hey Paul,

I'm also looking to do the same thing as Ricardo, if only for ease of administration.  We'll be generating a steady stream of GeoTIFFs and geo-referenced images that need to be searchable by date, geographic extent, and type (e.g., panchromatic, multispectral, stereo, original source or ortho-rectified, etc.).  I'd rather not have to roll a separate framework to ensure that an external raster library stays synch'd to the database index tables, especially through backup/restore/replication cycles.  Also, retrieval of the raster data will happen over the DB connection, eliminating the need for separate access controls.

In short, I'm lazy :P.

Josh

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul Ramsey
Sent: Monday, October 23, 2006 9:23 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] [More Asks]: GeoTiff into PostGIS

Why not leave your GeoTIFF outside the database and skip the middleman.  What is the database providing you that you don't get just leaving it where it is?


Quoting Ricardo <ricardoluis at ufs.br>:

> > Date: Fri, 20 Oct 2006 13:35:31 -0700
> > From: Paul Ramsey <pramsey at refractions.net>
> > Subject: Re: [postgis-users] GeoTiff into PostGIS
> > To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> > Message-ID: <91709AF9-A842-47E6-8DD1-AE4F9485C5F3 at refractions.net>
> > Content-Type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed
> >
> > All kinds of ways. What are you planning on doing with it once you
> > get it there?
> >
> > Paul
> >
> > On 20-Oct-06, at 1:29 PM, Ricardo wrote:
> >
> > > Hi all,
> > >
> > > How can I load a GeoTiff file into my PostGIS data base?
> > >
> > > thanks you all.
> > >
> > > Ricardo Luís
> > >
> > > _______________________________________________
> > > postgis-users mailing list
> > > postgis-users at postgis.refractions.net
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> 
> Hi Paul,
> 
> I want to use the GDAL library to read a GeoTiff from my PostGIS data base,
> what is the best or easy way to load this file, exist some utility to do
> this for me? I must to use sql commands? What are my options, where can I
> found samples?
> 
> :D
> 
> Thank you for your reply,
> 
> Ricardo Luís
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 




_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users