dbWriteTable() of PostGIS enabled database

45 views
Skip to first unread message

Ty Frazier

unread,
Jul 21, 2014, 11:03:49 AM7/21/14
to rpostgr...@googlegroups.com
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
Reply all
Reply to author
Forward
0 new messages