HELP-Virtual Spatial Data

[Skalski Artur - askals]

Try to modify your mapfile like this, I had the same problem and it helped:
LAYER
    NAME "sorento"
    TYPE POINT
    CONNECTIONTYPE OGR
    CONNECTION "virtual.ovf" # the name and path to the virtual.ovf file, relative to shapepath may
work?
    DATA "sorento" # the name of the OGRVrtLayer
    STATUS DEFAULT
    CLASS
      STYLE
       SYMBOL "circle"
       SIZE 6
       COLOR 255 0 0
      END
    END
END

regards

Artur Skalski


-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]On Behalf Of Frank Fica
Sent: Monday, December 19, 2005 6:51 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: [UMN_MAPSERVER-USERS] HELP-Virtual Spatial Data


Hello,

I'm testing an OGR ODBC connection to my postgresql database to map Lat and Lon columns, but
when I test my file.map I only get a blank screen and no errors.
When I test with ogrinfo I get all the columns listed including the new POINT column with my
coordinates, works fine.

Here's my ovf file:

<OGRVRTDataSource>
    <OGRVRTLayer name="sorento">
        <SrcDataSource>ODBC:@PostgreSQL</SrcDataSource>
        <SrcLayer>record</SrcLayer>
        <GeometryType>wkbPoint</GeometryType>
        <LayerSRS>WGS84</LayerSRS>
        <GeometryField encoding="PointFromColumns" x="Lat" y="Lon"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

Here's my file.map:

MAP
  IMAGETYPE PNG
  EXTENT -92.241493 13.738197 -88.223198 17.815220
  SIZE 640 480
  PROJECTION
   "proj=latlong"
   "ellps=WGS84"
   "datum=WGS84"
  END

  SYMBOL
   NAME 'circle'
   TYPE ELLIPSE
   FILLED TRUE
   POINTS
    1 1
   END
  END

 LAYER
    NAME "sorento"
    TYPE POINT
    CONNECTIONTYPE OGR
    CONNECTION "virtual.ovf" # the name and path to the virtual.ovf file, relative to shapepath may
work?
    DATA "sorento" # the name of the OGRVrtLayer
    STATUS DEFAULT
    CLASS
      SYMBOL "circle"
      SIZE 6
      COLOR 255 0 0
    END
 END
END
***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.
****************************************************************************