Skip to main content
1 of 2
marty_c
  • 559
  • 1
  • 4
  • 15

Querying Postgis data in R using dplyr package

Does anyone have a workflow for querying postgis data in R using the dplyr package?

R doesn't like the spatial columns in postgis data so can't read them in like a postgres table. I get the error message:

Warning message:
In postgresqlExecStatement(conn, statement, ...) :
  RS-DBI driver warning: (unrecognized PostgreSQL field type geometry (id:17846) in column 1)

I know there are other ways of reading in spatial data as all I want to do is join some data that have in R to an existing postgis table using R. I'm trying to avoid exporting it to a shapefile first.

Any help greatly appreciated!

Marty

marty_c
  • 559
  • 1
  • 4
  • 15