Re: [mapserver-users] Re: GDAL and SDE raster

[Lucena, Ivan]

Ron,

Some raster driver in GDAL are not flie based but RDBMS based but most of the softwares based on GDAL did not 
noticed that change. In those case, instead of a file path what you need is a identification string but those software 
usually have code to grab the file path, to check if the file really exist, to check other files on the same folder and 
that is where it crashes.

What I suggest to Liz is to use a VRT file instead of the identification string. As you might know, a VRT file does not 
contain the data but a path to the real data set.

I use that trick to load images direct from the RDBMS server to OpenEv and QuantumGIS:

% gdal_translate -of VRT <the identification string of your dataset> <temporary.vrt>
... check if it works:
% gdalinfo <temporary.vrt>
... check what is inside it:
% more <temporary.vrt>
... load it:
% openev <temporary.vrt>
% qgis
... click on add layer
... select your <temporary.vrt>

I thought that it would work for mapserve too...

/filepath/<temporary.vrt>

But Liz tried and said it doesn't. Too bad, I was counting on it. ;(

Regards,

Ivan

>  -------Original Message-------
>  From: Ron Goldman <ron at ocean.org.il>
>  Subject: [mapserver-users] Re: GDAL and SDE raster
>  Sent: Nov 04 '08 14:01
>  
>  I had a similar problem with NetCDF raster. It probably won't help much for SDE
>  but make sure you have absolute filepath after the "SDE:" and not before it.
>  
>  
>  Date: Tue, 4 Nov 2008 08:24:52 -0500
>  From: "Liz Godwin" <godwin.liz at gmail.com>
>  Subject: Re: [mapserver-users] GDAL and SDE raster
>  To: "Lucena, Ivan" <ivan.lucena at pmldnet.com>
>  Cc: eidsnessl at agr.gc.ca, mapserver-users at lists.osgeo.org,
>  whittekerc at agr.gc.ca
>  Message-ID:
>  <d33d7cc00811040524o6642e27w234e060f5ed87cd4 at mail.gmail.com>
>  Content-Type: text/plain; charset="iso-8859-1"
>  
>  
>  Thank you, but that option doesn't appear to work for Raster data types.
>  
>  
>  Liz
>  
>  
>  On Mon, Nov 3, 2008 at 7:40 PM, Lucena, Ivan <ivan.lucena at pmldnet.com>wrote:
>  
>  
>  > > I don't have SDE to tell you the truth but I would suggest you to create a
>  > > VRT version of your dataset and use the VRT on your map file. [
>  > > gdal_translate -of vrt
>  > > /filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER
>  > > replacement.vrt ]
>  > >
>  >  
>  >> > >  -------Original Message-------
>  >> > >  From: Liz Godwin <godwin.liz at gmail.com>
>  >> > >  Subject: [mapserver-users] GDAL and SDE raster
>  >> > >  Sent: Nov 03 '08 22:19
>  >> > >
>  >> > >  Hey folks,
>  >> > >
>  >> > >  We've been beating ourselves up over this problem and I'm not sure
>  >> > >  what to try next.
>  >> > >
>  >> > >  We can't seem to connect to SDE for a raster using GDAL in mapserver.
>  >> > >  This is happening on Linux.
>  >> > >
>  >> > >  snippit from mapfile:
>  >> > >  TYPE RASTER
>  >> > >  DATA "SDE:server,port:5151,sde,user,pass,schema.table,RASTER"
>  >> > >
>  >> > >  when trying to draw a map, i get a seg fault.  When trying a
>  >> > >  getFeatureinfo request, I get this error:
>  >> > >
>  >> > >  /filepath/SDE:server,port:5151,sde,user: Image handling error. Unable to
>  >> > >  open file LayerName for layer
>  >> > >  `/filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER' does
>  >> > >  not exist in the file system, and is not recognised as a supported
>  >>    
>  > > dataset
>  >  
>  >> > >  name.
>  >> > >  ... fatal error.
>  >> > >  msRasterQueryByRect()
>  >> > >
>  >> > >  Any ideas how I might start to debug this?  I have DEBUG set to 5 in
>  >>    
>  > > both
>  >  
>  >> > >  the LAYER and MAP object in the map file.
>  >> > >
>  >> > >  Thanks!
>  >> > >
>  >> > >  Liz
>  >> > >
>  >> > >  --------------------
>  >> > >  _______________________________________________
>  >> > >  mapserver-users mailing list
>  >> > >  [LINK: compose.php?to=mapserver-users at lists.osgeo.org]
>  >> > >  mapserver-users at lists.osgeo.org
>  >> > >  [LINK: http://lists.osgeo.org/mailman/listinfo/mapserver-users]
>  >> > >  http://lists.osgeo.org/mailman/listinfo/mapserver-users
>  >>    
>  > >
>  >  
>  -------------- next part --------------
>  An HTML attachment was scrubbed...
>  URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081104/fee291c7/attachment.html
>  
>  ------------------------------
>  
>  _______________________________________________
>  
>  mapserver-users mailing list
>  mapserver-users at lists.osgeo.org
>  http://lists.osgeo.org/mailman/listinfo/mapserver-users
>  
>  
>  
>  ***********************************************************
>  This outgoing email was scanned for viruses and other malicious content by the IT Department of Israel 
Oceanographic & Limnological Research.
>  AntiVirus system managed by Eli W. Tel. 972-4-8565267
>  IMPORTANT: Do not open attachments from unrecognized senders.
>  Never open attached files with extensions: *.pif, *.scr, *.vbs, *.exe.
>  
***********************************************************________________________________
_______________
>  mapserver-users mailing list
>  mapserver-users at lists.osgeo.org
>  http://lists.osgeo.org/mailman/listinfo/mapserver-users
>