tried this but I don't know how to get it to work with mapserver.<br><br><div class="gmail_quote">On Tue, Nov 4, 2008 at 10:13 AM, Lucena, Ivan <span dir="ltr"><<a href="mailto:ivan.lucena@pmldnet.com">ivan.lucena@pmldnet.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Ron,<br>
<br>
Some raster driver in GDAL are not flie based but RDBMS based but most of the softwares based on GDAL did not<br>
noticed that change. In those case, instead of a file path what you need is a identification string but those software<br>
usually have code to grab the file path, to check if the file really exist, to check other files on the same folder and<br>
that is where it crashes.<br>
<br>
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<br>
contain the data but a path to the real data set.<br>
<br>
I use that trick to load images direct from the RDBMS server to OpenEv and QuantumGIS:<br>
<br>
% gdal_translate -of VRT <the identification string of your dataset> <temporary.vrt><br>
... check if it works:<br>
% gdalinfo <temporary.vrt><br>
... check what is inside it:<br>
% more <temporary.vrt><br>
... load it:<br>
% openev <temporary.vrt><br>
% qgis<br>
... click on add layer<br>
... select your <temporary.vrt><br>
<br>
I thought that it would work for mapserve too...<br>
<br>
/filepath/<temporary.vrt><br>
<br>
But Liz tried and said it doesn't. Too bad, I was counting on it. ;(<br>
<br>
Regards,<br>
<font color="#888888"><br>
Ivan<br>
</font><div><div></div><div class="Wj3C7c"><br>
> -------Original Message-------<br>
> From: Ron Goldman <<a href="mailto:ron@ocean.org.il">ron@ocean.org.il</a>><br>
> Subject: [mapserver-users] Re: GDAL and SDE raster<br>
> Sent: Nov 04 '08 14:01<br>
><br>
> I had a similar problem with NetCDF raster. It probably won't help much for SDE<br>
> but make sure you have absolute filepath after the "SDE:" and not before it.<br>
><br>
><br>
> Date: Tue, 4 Nov 2008 08:24:52 -0500<br>
> From: "Liz Godwin" <<a href="mailto:godwin.liz@gmail.com">godwin.liz@gmail.com</a>><br>
> Subject: Re: [mapserver-users] GDAL and SDE raster<br>
> To: "Lucena, Ivan" <<a href="mailto:ivan.lucena@pmldnet.com">ivan.lucena@pmldnet.com</a>><br>
> Cc: <a href="mailto:eidsnessl@agr.gc.ca">eidsnessl@agr.gc.ca</a>, <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>,<br>
> <a href="mailto:whittekerc@agr.gc.ca">whittekerc@agr.gc.ca</a><br>
> Message-ID:<br>
> <<a href="mailto:d33d7cc00811040524o6642e27w234e060f5ed87cd4@mail.gmail.com">d33d7cc00811040524o6642e27w234e060f5ed87cd4@mail.gmail.com</a>><br>
> Content-Type: text/plain; charset="iso-8859-1"<br>
><br>
><br>
> Thank you, but that option doesn't appear to work for Raster data types.<br>
><br>
><br>
> Liz<br>
><br>
><br>
> On Mon, Nov 3, 2008 at 7:40 PM, Lucena, Ivan <<a href="mailto:ivan.lucena@pmldnet.com">ivan.lucena@pmldnet.com</a>>wrote:<br>
><br>
><br>
> > > I don't have SDE to tell you the truth but I would suggest you to create a<br>
> > > VRT version of your dataset and use the VRT on your map file. [<br>
> > > gdal_translate -of vrt<br>
> > > /filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER<br>
> > > replacement.vrt ]<br>
> > ><br>
> > <br>
> >> > > -------Original Message-------<br>
> >> > > From: Liz Godwin <<a href="mailto:godwin.liz@gmail.com">godwin.liz@gmail.com</a>><br>
> >> > > Subject: [mapserver-users] GDAL and SDE raster<br>
> >> > > Sent: Nov 03 '08 22:19<br>
> >> > ><br>
> >> > > Hey folks,<br>
> >> > ><br>
> >> > > We've been beating ourselves up over this problem and I'm not sure<br>
> >> > > what to try next.<br>
> >> > ><br>
> >> > > We can't seem to connect to SDE for a raster using GDAL in mapserver.<br>
> >> > > This is happening on Linux.<br>
> >> > ><br>
> >> > > snippit from mapfile:<br>
> >> > > TYPE RASTER<br>
> >> > > DATA "SDE:server,port:5151,sde,user,pass,schema.table,RASTER"<br>
> >> > ><br>
> >> > > when trying to draw a map, i get a seg fault. When trying a<br>
> >> > > getFeatureinfo request, I get this error:<br>
> >> > ><br>
> >> > > /filepath/SDE:server,port:5151,sde,user: Image handling error. Unable to<br>
> >> > > open file LayerName for layer<br>
> >> > > `/filepath/SDE:server,port:5151,sde,user/pass,schema.table,RASTER' does<br>
> >> > > not exist in the file system, and is not recognised as a supported<br>
> >> <br>
> > > dataset<br>
> > <br>
> >> > > name.<br>
> >> > > ... fatal error.<br>
> >> > > msRasterQueryByRect()<br>
> >> > ><br>
> >> > > Any ideas how I might start to debug this? I have DEBUG set to 5 in<br>
> >> <br>
> > > both<br>
> > <br>
> >> > > the LAYER and MAP object in the map file.<br>
> >> > ><br>
> >> > > Thanks!<br>
> >> > ><br>
> >> > > Liz<br>
> >> > ><br>
> >> > > --------------------<br>
> >> > > _______________________________________________<br>
> >> > > mapserver-users mailing list<br>
> >> > > [LINK: compose.php?to=<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>]<br>
> >> > > <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
> >> > > [LINK: <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>]<br>
> >> > > <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
> >> <br>
> > ><br>
> > <br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <a href="http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081104/fee291c7/attachment.html" target="_blank">http://lists.osgeo.org/pipermail/mapserver-users/attachments/20081104/fee291c7/attachment.html</a><br>
><br>
> ------------------------------<br>
><br>
> _______________________________________________<br>
><br>
> mapserver-users mailing list<br>
> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
><br>
><br>
><br>
> ***********************************************************<br>
> This outgoing email was scanned for viruses and other malicious content by the IT Department of Israel<br>
Oceanographic & Limnological Research.<br>
> AntiVirus system managed by Eli W. Tel. 972-4-8565267<br>
> IMPORTANT: Do not open attachments from unrecognized senders.<br>
> Never open attached files with extensions: *.pif, *.scr, *.vbs, *.exe.<br>
><br>
</div></div>***********************************************************________________________________<br>
<div><div></div><div class="Wj3C7c">_______________<br>
> mapserver-users mailing list<br>
> <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
><br>
<br>
</div></div></blockquote></div><br>