readOGR and PostGIS: "Error getting field 0"
On Fri, 30 Nov 2012, Mathieu Basille wrote:
Roger, It works beautifully! Checkout and compilation went successfully without any problem, and now readOGR can read layers with no field. As a matter of fact, it doesn't even need a primary key, just the geometry field. If there is a primary key, it is used as 'FID', if there is no primary key, a 'FID' field is created starting at 0. This is perfect, thanks a lot!
Thanks for checking, I'll put a release submission together. Roger
Mathieu. Le 30/11/2012 11:56, Roger Bivand a ?crit :
On Fri, 30 Nov 2012, Mathieu Basille wrote:
Le 30/11/2012 11:27, Roger Bivand a ?crit :
[...] Thanks very much, this is the information needed, that there are no fields. It appears that at least in this driver, readOGR() needs to be able to return a geometry-only object, or to create a GID column in the data.frame. I'll let you know when I've committed to R-forge, and will be very grateful if you can check out the source package, install, and test whether the changes have helped. It may take a little time to get there, but I'll give it priority.
I'd be happy to test when it's ready! However, no need to hurry: in the meantime, it is still possible (and easy) to add a dummy field to make readOGR work.
OK, thanks. SVN revision 389 committed to R-forge project rgdal, checkout from: svn checkout svn://scm.r-forge.r-project.org/svnroot/rgdal/pkg and rename pkg -> rgdal (to avoid getting multiple branches), then try R CMD check rgdal, if OK INSTALL, and try your problem. Roger
Thank you very much for you work! Mathieu.
Roger
Roger Bivand Department of Economics, NHH Norwegian School of Economics, 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