I'm trying to import a spatial database (PostGIS) to R using the RpostgreSQL package. When I use the command
enum_areas <-dbReadTable(con,"enum_areas")
I get the following error.
Warning message:
In postgresqlExecStatement(conn, statement, ...) :
RS-DBI driver warning: (unrecognized PostgreSQL field type geometry (id:31716) in column 6)
Any pointers on how to read/write a spatial database between R/postgresql and preserve the geometry without going through an extra step (such as using a merge and/or join statement).
Thanks,
Ty