[mapserver-users] Re: GDAL and SDE raster

Tue Nov 4 13:44:33 EST 2008

Howard,

Is it possible we have a bad combination of libraries or something in our
mapserv compile?  it's like it doesn't understand the datastring coming out
of mapserver.  In the error message from gdal, it's prepending the
filesystem path.  So instead of it starting with SDE:  it starts with
/filepath/SDE:

Liz

On Tue, Nov 4, 2008 at 11:50 AM, Howard Butler <hobu.inc at gmail.com> wrote:

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