An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-sig-geo/attachments/20051206/0d61cb7b/attachment.pl>
OGR dataset to R
5 messages · Jean-Denis Giguere, Edzer Pebesma, Roger Bivand
On Tue, 6 Dec 2005, Jean-Denis Giguere wrote:
Hi all, I would like to know if someone is aware of project to import OGR dataset into R without using GRASS. I saw reference to OGR on r-spatial project page but didn't find if there was implemented functionnalities.
Please look at Barry Rowlingson's Rmap at: http://www.maths.lancs.ac.uk/Software/Rmap/ You will need to build/compile it yourself, on Linux/Unix feasible, on Windows I'm not sure, but since you are using PostGIS, I guess you are using Linux.
My first goal is to be able to load a part of points dataset using attribute query filter (SQL) and use this as import for points pattern analysis.
We looked briefly at reading data via OGR and Rmap into package "sp" classes this time last year - from there movement to spatstat and splancs is feasible. With a little work, moving points through OGR and Rmap into SpatialPoints or SpatialPointsDataFrame objects should be possible. The same applies to polygons for study area boundaries.
Since my first dataset will be store within postGIS, hints or pointers to up to date information about integration of PostgreSQL and R would also be very much appreciated.
PostgreSQL seems to be being actively used on BioConductor: http://www.bioconductor.org/packages/bioc/1.8/html/RdbiPgSQL.html http://www.bioconductor.org/packages/bioc/1.8/html/Rdbi.html apart from additional work done by Markus Neteler.
Regards, Jean-Denis [[alternative HTML version deleted]]
_______________________________________________ R-sig-Geo mailing list R-sig-Geo at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-geo
Roger Bivand Economic Geography Section, Department of Economics, Norwegian School of Economics and Business Administration, Helleveien 30, N-5045 Bergen, Norway. voice: +47 55 95 93 55; fax +47 55 95 95 43 e-mail: Roger.Bivand at nhh.no
Jean-Denis, currently, as fas as I know, there is only Rmap -- see http://www.maths.lancs.ac.uk/Software/Rmap/ but that does not live on CRAN, meaning that it may be outdated in some respects. On my linux box, which has a recent gdal installed, it does not compile. Also, rgdal does not read anything through OGR, currently. Anyone who wants to take this up?
Edzer Jean-Denis Giguere wrote: > Hi all, > >I would like to know if someone of project to import OGR dataset >into R without using GRASS. I saw reference to OGR on r-spatial project page >but didn't find if there was implemented functionnalities. > >My first goal is to be able to load a part of points dataset using attribute >query filter (SQL) and use this as import for points pattern analysis. > >Since my first dataset will be store within postGIS, hints or pointers to up >to date information about integration of PostgreSQL and R would also be very >much appreciated. > >Regards, > >Jean-Denis > > [[alternative HTML version deleted]] > >_______________________________________________ >R-sig-Geo mailing list >R-sig-Geo at stat.math.ethz.ch >https://stat.ethz.ch/mailman/listinfo/r-sig-geo > >
I must correct -- I did manage to compile Rmap after outcommenting the line SHAPE = -lshp in Rmap/src/Makevars -- Edzer
Jean-Denis Giguere wrote:
Hi all, I would like to know if someone is aware of project to import OGR dataset into R without using GRASS. I saw reryference to OGR on r-spatial project page but didn't find if there was implemented functionnalities. My first goal is to be able to load a part of points dataset using attribute query filter (SQL) and use this as import for points pattern analysis. Since my first dataset will be store within postGIS, hints or pointers to up to date information about integration of PostgreSQL and R would also be very much appreciated. Regards, Jean-Denis [[alternative HTML version deleted]]
_______________________________________________ R-sig-Geo mailing list R-sig-Geo at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-geo
On Tue, 6 Dec 2005, Edzer J. Pebesma wrote:
I must correct -- I did manage to compile Rmap after outcommenting the line SHAPE = -lshp in Rmap/src/Makevars
Yes, I can confirm this, building against gdal and proj works for me too, as does Barry's nice subsetting. So maybe your database link will be quite good - the [.ogr function makes an ogr object for the subset, and only when you do as.data.frame() og the ogr object does the data get read into R. Roger
-- Edzer Jean-Denis Giguere wrote:
Hi all, I would like to know if someone is aware of project to import OGR dataset into R without using GRASS. I saw reryference to OGR on r-spatial project page but didn't find if there was implemented functionnalities. My first goal is to be able to load a part of points dataset using attribute query filter (SQL) and use this as import for points pattern analysis. Since my first dataset will be store within postGIS, hints or pointers to up to date information about integration of PostgreSQL and R would also be very much appreciated. Regards, Jean-Denis [[alternative HTML version deleted]]
_______________________________________________ R-sig-Geo mailing list R-sig-Geo at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-geo
_______________________________________________ R-sig-Geo mailing list R-sig-Geo at stat.math.ethz.ch https://stat.ethz.ch/mailman/listinfo/r-sig-geo
Roger Bivand Economic Geography Section, Department of Economics, Norwegian School of Economics and Business Administration, Helleveien 30, N-5045 Bergen, Norway. voice: +47 55 95 93 55; fax +47 55 95 95 43 e-mail: Roger.Bivand at nhh.no