vendredi 23 janvier 2015

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





Aucun commentaire:

Enregistrer un commentaire