I'm interested in querying data with a geometry field from SQL server and using it in R as a spatialPolygonsDataFrame.
I've seen plenty of examples of using rgdal to import a shapefile, but shapefiles are far from the ideal storage medium for a map layer.
Can anyone point me to the correct syntax?
Does the geometry data have to be converted on it's way out of sql server in order for R to recognize it? to WKT or WKB for example?
In the end, I want a live connection to this data so that my maps are pulled directly from SQL and not from an exported shapefile.