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.sanc...@esade.edu _______________________________________________ R-sig-Geo mailing list R-sig-Geo@stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-geo
