Virtual Tables

[Kevin Flanders]

I put the full path in..and I got the map to draw.  However, all layers draw
EXCEPT the points from this virtual table.

 

I did notice that not all records in the table have x and y values...could
that be an issue?

 

Also..the x and y values are not lat/long.but rather a state plane system.
So too is the entire project, so I am assuming this is alright and I don't
need a <LayerSRS> set of tags.

 

 

Kevin

 

From: Brent Fraser [mailto:bfraser at geoanalytic.com] 
Sent: Wednesday, April 18, 2007 2:14 PM
To: Kevin Flanders; MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Virtual Tables

 

Kevin,

  Try putting the full path to the mapsonline.csv between the <SrcLayer>
tags.

 

Brent Fraser
GeoAnalytic Inc.
Calgary, Alberta

----- Original Message ----- 

From: Kevin Flanders <mailto:kevin at PEOPLEGIS.COM>  

To: MAPSERVER-USERS at LISTS.UMN.EDU 

Sent: Wednesday, April 18, 2007 12:09 PM

Subject: Re: [UMN_MAPSERVER-USERS] Virtual Tables

 

I am using a chameleon app.and getting the following error:

 

"Error rendering map image:

A fatal error occurred drawing the map"

 

I did try setting the STATUS to default with no change.

 

 

Kevin

 

 

From: Fawcett, David [mailto:David.Fawcett at state.mn.us] 
Sent: Wednesday, April 18, 2007 2:04 PM
To: Kevin Flanders; MAPSERVER-USERS at lists.umn.edu
Subject: RE: [UMN_MAPSERVER-USERS] Virtual Tables

 

How is it failing?  

 

Are you getting an error message? 

 

Are you specifically calling the layer by name in the URL or post request,
or have you tried setting STATUS to DEFAULT?

 

David.

-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of Kevin Flanders
Sent: Wednesday, April 18, 2007 12:41 PM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] Virtual Tables

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 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070418/2dc1c5eb/attachment.html