[R-sig-Geo] PostGIS, R and WKT

[Edzer Pebesma]

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 
> buddha_314 at yahoo.com
>
>
>
>  
> ~~~ 
> may all your sequences converge
>
>
>
> 	[[alternative HTML version deleted]]
>
> _______________________________________________
> R-sig-Geo mailing list
> R-sig-Geo at stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-geo
>