[mapserver-users] Re: GDAL and SDE raster

Tue Nov 4 10:36:58 PST 2008

tried this but I don't know how to get it to work with mapserver.

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
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081104/c787ba63/attachment.htm>