Problem with OGR connection for XY point layer

[Gaston Izaguirre]

Murat,

Thank you very much for your quick answer. I've solved the problem. As a 
member of the ms4w-users list suggested, it was a locale issue... The 
numbers came back in the format -xx.xxxxxx -yy.yyyyyy and my local 
configuration defined the period for thousands separator and the coma for 
decimal seperator. So, I inverted the separators and the problem has gone.

Best regards,
Gaston.



----- Original Message ----- 
From: "Murat BEYHAN" <beyhan at DEPREM.GOV.TR>
To: <MAPSERVER-USERS at LISTS.UMN.EDU>
Sent: Tuesday, February 06, 2007 3:48 AM
Subject: Re: [UMN_MAPSERVER-USERS] Problem with OGR connection for XY point 
layer


> Dear Gaston,
> The point which you would like to se on the map should be define as double
> field type in the table for MySql.
> May be this can be help you.
> regards...
> Murat
>
>
> On Mon, 5 Feb 2007 22:34:54 -0300, Gaston Izaguirre wrote
>> Hi all,
>>
>> I'm using MS4W 1.5.5 on WinXP SP2 (mapserver 4.8.4, PHP 4.4.3,
>> php_mapscript_48.dll, GDAL to 1.3.2).
>> I'm trying to connect to a SQL server 2000 through an OGR Virtual
>> Format driver to obtain X,Y coordinates plus other ancillary data
>> from a View that I defined in the database. The data base is updated
>> constantly with new coordinates, so the number of rows can change,
>> actually there are about 20 points.
>>
>> The syntax of my .OVF file is:
>>
>> <OGRVRTDataSource>
>>     <OGRVRTLayer name="puntos">
>>
> <SrcDataSource>ODBC:mi_usuario/mi_password at mi_DSN,mi_vista_de_la_bd</SrcDataSource>
>>         <SrcLayer>mi_vista_de_la_bd</SrcLayer>
>>         <!--  <FID>Poul_id</FID>  -->
>>         <GeometryType>wkbPoint</GeometryType>
>>         <LayerSRS>WGS84</LayerSRS>
>>         <!--  <LayerSRS>EPSG:4326</LayerSRS>  -->
>>         <GeometryField encoding="PointFromColumns" x="Poul_longitud"
>> y="Poul_latitud"/>
>>     </OGRVRTLayer>
>> </OGRVRTDataSource>
>>
>> I´ve tested with OGRINFO and the result is something like the following:
>>
>> Layer name: puntos
>> OGRFeature(puntos):0
>>   Vehi_textid (String) = 276 33
>>   Poul_id (Integer) = 73
>>   Poul_vehi_id (Integer) = 9
>>   Poul_latitud (Real) = -34
>>   Poul_longitud (Real) = -58
>>   Poul_velocidad (Real) = 0
>>   Poul_sentido (String) = 0
>>   Poul_posi_fecha (String) = 31/01/2007 12:18:46
>>   POINT (-58 -34 0)
>>
>> OGRFeature(puntos):1
>>   Vehi_textid (String) = 276 58
>>   Poul_id (Integer) = 63
>>   Poul_vehi_id (Integer) = 9
>>   Poul_latitud (Real) = -34
>>   Poul_longitud (Real) = -58
>>   Poul_velocidad (Real) = 0
>>   Poul_sentido (String) = 0
>>   Poul_posi_fecha (String) = 05/02/2007 17:44:02
>>   POINT (-58 -34 0)
>> ...
>> ...
>> ...
>> ...
>> OGRFeature(puntos):19
>>   Vehi_textid (String) = 276 59
>>   Poul_id (Integer) = 64
>>   Poul_vehi_id (Integer) = 9
>>   Poul_latitud (Real) = -34
>>   Poul_longitud (Real) = -58
>>   Poul_velocidad (Real) = 12
>>   Poul_sentido (String) = 170
>>   Poul_posi_fecha (String) = 05/02/2007 22:09:35
>>   POINT (-58 -34 0)
>>
>> As you can see, the connection retrieves the 20 points, but there is
>> a problem with the X/Y (lat/lon) values: they are rounded to the
>> integer part, in spite of being defined as real in the database. For
>> example, for the last point (#19) I get: xcoord = -58 ycoord = -34
>> when the actual value is: x = -58.904272 y = -34.447837
>>
>> As a result of this, when I test the mapfile with SHP2IMG all 20
>> points are in the same place (all with the same coordinate values;
>> e.g. x,y = -58,-34)
>>
>> I am making some mistake?
>> My syntax is correct?
>> Is there someone to give me a hand on this problem?
>>
>> Thanks in advance,
>>
>> Gaston.
>>
>> -- 
>> This message has been scanned for viruses and
>> dangerous content by MailScanner, and is
>> believed to be clean.
>
>
> Murat Beyhan
> Jeofizik Yük. Müh.
>
> Afet İşleri Genel Müdürlüğü
> Deprem Araştırma Dairesi
> Eskişehir Yolu 12. Km. Lodumlu/Ankara
> Tel:+90 (312) 2872680-1550
>
>
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>