<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Paul,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have 1531 JPGs (500x500) to state of Sao
Paulo for example.</FONT></DIV>
<DIV><FONT face=Arial size=2>I think that it'll be more pratice to handle this
images in a database</FONT></DIV>
<DIV><FONT face=Arial size=2>with image_name, xmin, ymin, xmax, ymax, blob and
create and</FONT></DIV>
<DIV><FONT face=Arial size=2>spatial index for this data (by box of
image).</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>How can I manager many images files ??
And my vectors data</FONT></DIV>
<DIV><FONT face=Arial size=2>in the PostGIS??</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rosangela</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>------------</FONT></DIV>
<DIV>If you are not managing the rasters, just displaying them, why not just
<BR>store them as files?<BR><BR>Rosangela Silva wrote:<BR>><I>
Paul<BR></I>><I> <BR></I>><I> I only need raster like
background.<BR></I>><I> I have several jpeg+jpgw to be<BR></I>><I>
handle.<BR></I>><I> <BR></I>><I>
-------------------------<BR></I>><I> It's possible to use BLOBs to hold any
data at all, raster included.<BR></I>><I> Whether this is a "good idea" for
you depends alot on what you are<BR></I>><I> trying to do with your data. A
possible simple image-holding table for<BR></I>><I> postgis might
be:<BR></I>><I> <BR></I>><I> orig_filename varchar,<BR></I>><I>
projection varchar,<BR></I>><I> collected date,<BR></I>><I> extents
geometry,<BR></I>><I> image blob<BR></I></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>