HELP-Virtual Spatial Data

[Simbiosis Amorpha]

Thanks David,

I already switched my x,y and I still get a blank image. I'm accesing my map 
with:
http://maps.localizame.net/cgi-bin/mapserv?map=/var/www/html/starfinder/star.map&mode=map

If I do a ogrinfo virtual.ovf starfinder I get this:

OGRFeature(sorento):27
  UserID (String) = Sorento
  Lat (String) = 14.6538233333333
  Lon (String) = -90.5103
  Status (String) = A
  E/W (String) = W
  Date (String) = 051218
  TimeStamp (String) = 213533
  N/S (String) = N
  Speed (String) = 0.00
  Course (String) = 90.73
  Geofence (String) = (null)
  PowerOff (String) = (null)
  Panic (String) = (null)
  Opto1 (String) = (null)
  Opto2 (String) = (null)
  Relay1 (String) = (null)
  Relay2 (String) = (null)
  Serial No (String) = (null)
  Version (String) = (null)
  Memory Size (String) = (null)
  KeyNo (Integer) = 5767
  POINT (-90.5103 14.6538233333333 0)

Best regards,

Frank



>From: "Fawcett, David" <David.Fawcett at pca.state.mn.us>
>To: "Frank Fica" <simbiotico at hotmail.com>,    
><MAPSERVER-USERS at lists.umn.edu>
>Subject: RE: [UMN_MAPSERVER-USERS] HELP-Virtual Spatial Data
>Date: Mon, 19 Dec 2005 09:12:08 -0600
>
>Frank,
>
>Take a look at this line:          <GeometryField
>encoding="PointFromColumns" x="Lat" y="Lon"/>
>
>I belive that you have your x/y columns switched.  It should be that
>x=longitude and y=latitude.
>
>-----Original Message-----
>From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
>Behalf Of Frank Fica
>Sent: Sunday, December 18, 2005 11:51 PM
>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