Virtual Tables

[Daniel Morissette]

For the record, we have figured part of the mystery offlist, it turns 
out the VRT definition had two problems:

1- Missing required <SrcDataSource> (path to the .csv file)

2- <SrcLayer> was wrong (layer name for CSV sources is only the basename 
of the .csv file)

With the above fixes "ogrinfo" could read the data, but we still do not 
see the points on the map, however converting the VRT to a shapefile 
does work for the same layer... that's another mystery to solve.

Daniel


Kevin Flanders wrote:
> I would like to map a virtual table, and I am told I can do it without 
> declaring an ODBC…using the following mapfile layer definition:
> 
>  
> 
>   LAYER
> 
>     NAME "Fire Data"
> 
>     GROUP "Fire Data"
> 
>     STATUS on
> 
>     TYPE point
> 
>     CONNECTIONTYPE OGR
> 
>     CONNECTION "<OGRVRTDataSource>
> 
>                                      <OGRVRTLayer  
> name='firegis'>                                         
> 
>                     
>                    <SrcLayer>mapsonline.csv</SrcLayer>                                    
> 
> 
>                                        <GeometryField 
> encoding='PointFromColumns' x='XCOORD' y='YCOORD'/>           
> 
>                                        <GeometryType>wkbPoint</GeometryType>
> 
>                                      </OGRVRTLayer>
> 
>                                    </OGRVRTDataSource>"
> 
>     TEMPLATE "ttt"
> 
>     TOLERANCE 4
> 
>     CLASS
> 
>       NAME "Fire 
> Data"                                                               
> 
>       SYMBOL "circle"
> 
>       OUTLINECOLOR 80 80 80
> 
>       COLOR 219 0 0
> 
>       SIZE 12
> 
>     END
> 
>   END
> 
>  
> 
>  
> 
> But this fails.  Do I need an ODBC….or is it true I can access a text 
> file directly in this manner.  The data is being placed with all my 
> other shapefiles (ie. in the same folder).
> 
>  
> 
> Also, can the .csv file just as easily be a .txt file….and can the 
> entries have quotations around them?
> 
>  
> 
>  
> 
> Kevin
> 
>  
> 


-- 
Daniel Morissette
http://www.mapgears.com/