[R-sig-Geo] reading spatial coordinates from a database

[Sebastien]

Dear R users,

I work with the RODBC package. I would like to read the coordinates xy 
of a polyline in a table called 'populations'. The connexion with the 
database (postgresql) seems good but when I try to select the 
coordinates of a population, the string of characters is truncated at 
255 character which is too short to obtain all the point of the 
corresponding polyline. An example with the populations 5396 :

library(RODBC)
channel <- odbcConnect("colza_ansi")
cde <- paste('select xy from populations where id_pop=5396;')
xy <- sqlQuery(channel, cde)

xy
1 
[(515041.60200000001,2306276.1310000001),(515041.59899999999,2306276.1359999999), 

(515041.59600000002,2306276.1320000002),(515041.59100000001,2306276.1409999998), 

(515041.59100000001,2306276.1340000001),(515041.61700000003,2306276.1170000001), 

(515041.618000


There is probably a parameter to change but I don't find which one. 
Could someone help me?
Thanks

Sébastien Ollier
University of Paris
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Sebastien.ollier.vcf
Type: text/x-vcard
Size: 188 bytes
Desc: not available
URL: <https://stat.ethz.ch/pipermail/r-sig-geo/attachments/20070831/4239b524/attachment.vcf>