Strange OGR VRT Issue

[Pascoe,Tim [Burlington]]

Murat,

 

            Thanks for the suggestion. Unfortunalty, this has had no effect on the behavior. Also, how would I do this if I had a SELECT statement involving more tables? Or would I just put all the tables in the list?

Timothy Pascoe 
Environmental Systems Scientist 

Environment Canada / Environnement Canada
Canada Centre for Inland Waters / Centre Canadien des Eaux Intérieures
867 Lakeshore Road / 867, chemin Lakeshore
Burlington, Ontario / Burlington (Ontario) 
L7R 4A6

Tel/Tél: (905) 336-6239
Fax/Téléc: (905) 336-4699
E-mail/C. élec: tim.pascoe at ec.gc.ca <mailto:tim.pascoe at ec.gc.ca> 
Government of Canada/Gouvernement du Canada 
This e-mail represents the opinions and views solely held by its author and in no manner may be considered as representing those of his/her employer.

  _____  

From: Murat BEYHAN [mailto:beyhan at deprem.gov.tr] 
Sent: October 12, 2006 3:58 PM
To: Pascoe,Tim [Burlington]; MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Strange OGR VRT Issue

 

Tom,

At the following line I think, but I'm not sure, You should write the name of table as your old ovf file.

>         <SrcDataSource>ODBC:****/****@CABIN</SrcDataSource> 

Please try to change the line as follows,

<SrcDataSource>ODBC:****/****@CABIN</SrcDataSource,OGRPoints>

Good luck...

Murat

On Thu, 12 Oct 2006 13:10:33 -0400, Pascoe,Tim [Burlington] wrote 
> I'm experimenting with placing my OVF file in line, in order to pass in some variables for a custom WHERE Statement. The first step I took was changing my OVF file to use the scrSQL tag with a very simple SQL statement, instead of the srcLayer tag. Both OVF files point to the same view, in the same database. 
> New File: 
> <OGRVRTDataSource> 
>     <OGRVRTLayer name="CABINPoints"> 
>         <SrcDataSource>ODBC:****/****@CABIN</SrcDataSource> 
>         <SrcSQL>SELECT * FROM OGRPoints</SrcSQL> 
>           <FID>sitedetailsid</FID> 
>         <GeometryType>wkbPoint</GeometryType> 
>         <LayerSRS>WGS84</LayerSRS> 
>     <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/> 
>     </OGRVRTLayer> 
> </OGRVRTDataSource> 
> Old FIle: 
> <OGRVRTDataSource> 
>     <OGRVRTLayer name="CABINPoints"> 
>         <SrcDataSource>ODBC:****/****@CABIN,OGRPoints</SrcDataSource> 
>         <SrcLayer>OGRPoints</SrcLayer> 
>           <FID>sitedetailsid</FID> 
>         <GeometryType>wkbPoint</GeometryType> 
>         <LayerSRS>WGS84</LayerSRS> 
>     <GeometryField encoding="PointFromColumns" x="longitude" y="latitude"/> 
>     </OGRVRTLayer> 
> </OGRVRTDataSource> 
> The problem is, the old OVF returns a proper image, while the new one returns a blank image. I ran the new file through OGRInfo and shp2ogr, and both behave properly. 
> So........why am I getting a blank image with the scrSQL tag? I'm using the latest version of the MS4W file set, but running on IIS on Windows 2000. Any suggestions would be great - it's probably somthing very simple I'm missing :) 
> Tim Pascoe 
> -- 
> This message has been scanned for viruses and 
> dangerous content by MailScanner <http://www.mailscanner.info/> , and is 
> believed to be clean. 


-- 
Open WebMail Project (http://openwebmail.org <http://openwebmail.org/> ) 


-- 
This message has been scanned for viruses and 
dangerous content by MailScanner <http://www.mailscanner.info/> , and is 
believed to be clean. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061013/9de4b5b4/attachment.htm>