Re: [R-sig-Geo] reading PostGIS table into sp data frame

2012-12-22 Thread Roger Bivand
: 4 Date: Wed, 19 Dec 2012 14:58:52 +0100 From: Raffaele Morelli raffaele.more...@gmail.com To: r-sig-geo@r-project.org Subject: Re: [R-sig-Geo] reading PostGIS table into sp data frame Message-ID: cad4guxot5fsupbk4vbbpuzf-otbrcy-uvnpcguvuyt4qs0+...@mail.gmail.com Content-Type: text/plain

Re: [R-sig-Geo] reading PostGIS table into sp data frame

2012-12-21 Thread Edward Vanden Berghe
-geo@r-project.org Subject: Re: [R-sig-Geo] reading PostGIS table into sp data frame On Thu, 20 Dec 2012, Edward Vanden Berghe wrote: Thanks! Unfortunately I have no luck trying to get readOGR to work directly with the PostGIS database. I tried different variations: Did you check whether your

Re: [R-sig-Geo] reading PostGIS table into sp data frame

2012-12-21 Thread Edzer Pebesma
Vanden Berghe Cc: r-sig-geo@r-project.org Subject: Re: [R-sig-Geo] reading PostGIS table into sp data frame On Thu, 20 Dec 2012, Edward Vanden Berghe wrote: Thanks! Unfortunately I have no luck trying to get readOGR to work directly with the PostGIS database. I tried different variations

Re: [R-sig-Geo] reading PostGIS table into sp data frame

2012-12-21 Thread Roger Bivand
VFK FALSE 42VRT FALSE 43 XPlane FALSE -Original Message- From: Roger Bivand [mailto:roger.biv...@nhh.no] Sent: 20 December 2012 20:58 To: Edward Vanden Berghe Cc: r-sig-geo@r-project.org Subject: Re: [R-sig-Geo] reading PostGIS table into sp data frame On Thu, 20 Dec

[R-sig-Geo] reading PostGIS table into sp data frame

2012-12-20 Thread Edward Vanden Berghe
, 19 Dec 2012 14:58:52 +0100 From: Raffaele Morelli raffaele.more...@gmail.com To: r-sig-geo@r-project.org Subject: Re: [R-sig-Geo] reading PostGIS table into sp data frame Message-ID: cad4guxot5fsupbk4vbbpuzf-otbrcy-uvnpcguvuyt4qs0+...@mail.gmail.com Content-Type: text/plain 2012/12/19 Edward

Re: [R-sig-Geo] reading PostGIS table into sp data frame

2012-12-20 Thread Roger Bivand
Message: 4 Date: Wed, 19 Dec 2012 14:58:52 +0100 From: Raffaele Morelli raffaele.more...@gmail.com To: r-sig-geo@r-project.org Subject: Re: [R-sig-Geo] reading PostGIS table into sp data frame Message-ID: cad4guxot5fsupbk4vbbpuzf-otbrcy-uvnpcguvuyt4qs0+...@mail.gmail.com Content-Type: text

[R-sig-Geo] reading PostGIS table into sp data frame

2012-12-19 Thread Edward Vanden Berghe
I wanted to create a global map with squares in lat-lon. I have PostGIS tables to define these squares – but I haven’t been able to figure out an efficient way of reading those tables into R. The code I am using now is: crs - CRS(+proj=longlat +ellps=WGS84) s - paste(select id,

Re: [R-sig-Geo] reading PostGIS table into sp data frame

2012-12-19 Thread Raffaele Morelli
2012/12/19 Edward Vanden Berghe evber...@gmail.com I wanted to create a global map with squares in lat-lon. I have PostGIS tables to define these squares – but I haven’t been able to figure out an efficient way of reading those tables into R. The code I am using now is: crs -