[mapserver-users] Re: GDAL and SDE raster

Howard Butler hobu.inc at gmail.com
Tue Nov 4 11:50:30 EST 2008


Liz,

To use SDE raster data in MapServer, you must use GDAL compiled with  
SDE raster support.  The "native" SDE raster support that was in  
MapServer was removed and no longer works.

Ensure that your GDAL SDE raster is working with gdalinfo and then  
specify your layer as follows:


LAYER

TYPE RASTER
DATA "SDE:sdemachine.iastate.edu, 
5151,database,username,password,fully.specified.tablename,RASTER"
...

END

On Nov 4, 2008, at 9:41 AM, Liz Godwin wrote:

> I'll give it a try.  I didn't actually try it - I read the docs and  
> it didn't suggest that it would support rasters.
>
> Liz
>
> On Tue, Nov 4, 2008 at 10:13 AM, Lucena, Ivan  
> <ivan.lucena at pmldnet.com> wrote:
> 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
> >
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users



More information about the mapserver-users mailing list