Brian You should try to use the readOGR function in package rgdal, which has a PostGIS driver. Examples are on http://wiki.intamap.org/index.php/PostGIS
Best wishes, -- Edzer Brian Dolan schrieb: > Hello, > > I'm sure this is a well-understood problem. I appreciate your patience. > > I am attempting to use R as a visualization tool, pulling the data from my > postgresql/postgis system. I have followed the examples from this page: > > http://www.bostongis.com/?content_name=postgis_tut01#20 > > All the software is working correctly, including RODBC so that I may issue > queries to my database from within R. My question is, what is a good method > for plotting the results of a sql query? For instance, "select * from towns" > returns a column called the_geom, which is, I understand in Well Known > Binary. If simply wish to plot the borders of the towns in R, I suppose I > have to convert this to a spatial polygon. But honestly, I can't seem to > figure this out. Nor can I find references on line that take WKB or WKT and > plot this coordinates in R. > > So, I'm sure there is something fundamental that I am missing. I look > forward to learning from your suggestions! > > -brian > [EMAIL PROTECTED] > > > > > ~~~ > may all your sequences converge > > > > [[alternative HTML version deleted]] > > _______________________________________________ > R-sig-Geo mailing list > R-sig-Geo@stat.math.ethz.ch > https://stat.ethz.ch/mailman/listinfo/r-sig-geo > _______________________________________________ R-sig-Geo mailing list R-sig-Geo@stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-geo
