Re: [UMN_MAPSERVER-USERS] 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" <[EMAIL PROTECTED]>
To: "Frank Fica" <[EMAIL PROTECTED]>,    
<MAPSERVER-USERS@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:[EMAIL PROTECTED] On
Behalf Of Frank Fica
Sent: Sunday, December 18, 2005 11:51 PM
To: MAPSERVER-USERS@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