Database Software

Hi All,

I have a few geoRaster question.

What I would like to do with Oracle Spatial/geoRaster is:
import a geoTiff file into Oracle geoRaster
export into a geoTiff file a small portion of the original file.

It looked like the GeoRasterLoader and GeoRasterExporter that oracle supplied might do this for me but I haven't been able to get what I want out of them. The output file does not contain the geoTiff metadata.

I used the following commands to load a geoTiff file into my geoRaster tables and then export a clipped version of the tiff file. I found that if I did not include the world file in the load that the GeoRasterViewer did not give the Easting and Northing for the viewed image so I create a tfw file from my geoTiff and I added it to the load. I have also found that the exported tiff file does not contain geoTiff tags, I have lost the location information for the corners and the resolution information. Another issue I have is that an 80MB geoTiff file took over 800 seconds to load.

My questions are:
Is there a way to import a geoTiff file and store the geoTiff metadata without using a world file?
Is there a way to export a geoTiff file from Oracle with correct metadata for my clipped file?
How can I speed up the loading of geoTiff files?

Thanks

java GeoRasterLoader machinename dbname 1521 user passwd thin 32 T tablename columnname ""
"/home/oracle/filename.tif,273,rdt1,/home/oracle/filename.twf"

java GeoRasterExporter machinename dbname 1521 user passwd thin 32 T tablename columnname "273,rdt1"
"TIFF" "/home/oracle/clipped" "cropArea=(90,300,135,420)"