[R-sig-Geo] Shape to DB, DB to SpatialPolygon

[Germán Sánchez]

Dear all,

I've working with spatial data since only a few months. I know how to
handle this kind of data in R using the sp package. I know how to load
shapes, plot them, merge their polygons, plotting labels, etc.

I have installed a postgis database and I can connect to it from R via
RODBC without problems. I can load a shape file (.shp and so) into the
database (command shp2pgsql  to create the needed .sql). It creates a
table with some usual fields (area, perimeter, district, etc) and the
special one: the_geom.

Now, I want to load this data to a SpatialPolygon (or
SpatialPolygonDataFrame) object using the RODBC driver. I would like to
get the same object as if I have used the "readShapePoly" function from sp
package directly over the .shp file.

Any idea? Is there a direct solution or I have to build the polygon myself?

Thank you,
Germán Sánchez
german.sanchez at esade.edu