Hi all, Apologies for cross-posting this to the RPostrgeSQL and PostGIS mailing lists, but I'm not sure where the problem lies.
I am using the RPostgreSQL package of R to connect to my installation of PostgreSQL/PostGIS. I want to retrieve some coordinates from my database and run the below command. Is this just that R doesn't know what to do with Geometry's, or is it something I should be more concerned about? I ask, as I'm having some wider issues with my workflow and this may be related. Thanks James > dbGetQuery(con, "SELECT st_transform(st_setsrid(st_makepoint(soose::numeric, > soosn::numeric),27700),4326) FROM stage WHERE ssid = '707187161010202'") st_transform 1 0101000020E6100000F71184EF3961B3BF830420AF33C64940Warning message:In postgresqlExecStatement(conn, statement, ...) : RS-DBI driver warning: (unrecognized PostgreSQL field type geometry (id:480912) in column 0)
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
