How to convert a SQL Server geom column when it is a Blob in R (its x,y UTM coordinates)?
I am using the DBI package to connect to a SQL Server database and I am able to pull data from the table into R where the geom column is a geometry type according to SQL Server Management Studio.
How to convert an MSSQL geom column when it is a Blob in R (its x,y UTM coordinates)?
I am using the DBI package to connect to an MSSQL database and am able to pull in the table into R where the geom column is a geometry type according to MSSQL Server Manager. But when the table is pulled into R, the geom column is shown as blob. This is how I am pulling the data into R: