Re: [R-sig-Geo] PostGIS and sp integration

2008-10-09 Thread Roger Bivand
On Thu, 9 Oct 2008, Barry Rowlingson wrote: Hi All, I'm now very impressed with PostGIS and what it can do with spatial data. Given the easy setup with Ubuntu, the easy admin with pgAdmin3, and the great interface with Qgis, I'm won over totally. Of course I still need to read my spatial data

Re: [R-sig-Geo] PostGIS and sp integration

2008-10-09 Thread Dylan Beaudette
On Thursday 09 October 2008, Edzer Pebesma wrote: > Barry Rowlingson wrote: > > 2008/10/9 Edzer Pebesma <[EMAIL PROTECTED]>: > >> Why is this better practice than having a single 100x61 table with > >> monthly rainfall in the usual columns and a geometry column? > > > > Because when I get another

Re: [R-sig-Geo] PostGIS and sp integration

2008-10-09 Thread Edzer Pebesma
Barry Rowlingson wrote: 2008/10/9 Edzer Pebesma <[EMAIL PROTECTED]>: Why is this better practice than having a single 100x61 table with monthly rainfall in the usual columns and a geometry column? Because when I get another year's data, I have to change the table definition. SQL does

Re: [R-sig-Geo] PostGIS and sp integration

2008-10-09 Thread Barry Rowlingson
2008/10/9 Edzer Pebesma <[EMAIL PROTECTED]>: > Why is this better practice than having a single 100x61 table with monthly > rainfall in the usual columns and a geometry column? Because when I get another year's data, I have to change the table definition. SQL doesn't like that[1]. Keep your orig

Re: [R-sig-Geo] PostGIS and sp integration

2008-10-09 Thread Edzer Pebesma
Barry Rowlingson wrote: Hi All, I'm now very impressed with PostGIS and what it can do with spatial data. Given the easy setup with Ubuntu, the easy admin with pgAdmin3, and the great interface with Qgis, I'm won over totally. Of course I still need to read my spatial data into R (until I d

Re: [R-sig-Geo] PostGIS and sp integration

2008-10-09 Thread Barry Rowlingson
2008/10/9 G. Allegri <[EMAIL PROTECTED]>: > Hi Barry, > just a curiosity. Do you simply need a cloropleth with rainfall > amount/rate coloring, or you have to do more complex operations? > Just simple colouring, but I will have to make sure the scales are consistent across the 60 maps, so I will

Re: [R-sig-Geo] PostGIS and sp integration

2008-10-09 Thread G. Allegri
Hi Barry, just a curiosity. Do you simply need a cloropleth with rainfall amount/rate coloring, or you have to do more complex operations? 2008/10/9 Barry Rowlingson <[EMAIL PROTECTED]>: > Hi All, > > I'm now very impressed with PostGIS and what it can do with spatial > data. Given the easy setup

[R-sig-Geo] PostGIS and sp integration

2008-10-09 Thread Barry Rowlingson
Hi All, I'm now very impressed with PostGIS and what it can do with spatial data. Given the easy setup with Ubuntu, the easy admin with pgAdmin3, and the great interface with Qgis, I'm won over totally. Of course I still need to read my spatial data into R (until I do all my analysis in Python.