[R-sig-Geo] gdal error

[Nicolas Saby]

> library(rgdal)
Le chargement a nécessité le package : sp
rgdal: version: 1.5-19, (SVN revision 1092)
Geospatial Data Abstraction Library extensions to R successfully loaded
Loaded GDAL runtime: GDAL 3.0.4, released 2020/01/28
Path to GDAL shared files: /usr/share/gdal
GDAL binary built with GEOS: TRUE
Loaded PROJ runtime: Rel. 6.3.1, February 10th, 2020, [PJ_VERSION: 631]
Path to PROJ shared files: /usr/share/proj
Linking to sp version:1.4-4
To mute warnings of possible GDAL/OSR exportToProj4() degradation,
use options("rgdal_show_exportToProj4_warnings"="none") before loading rgdal.

----------------
I have uninstall and reinstall proj, sf and rgdal

But it is still not possible to pick up the latest version of PROJ... should be 7.2 instead of 6.3

Thanks

-----Message d'origine-----
De : Nicolas Saby 
Envoyé : mardi 19 janvier 2021 11:25
À : 'Roger.Bivand using nhh.no' <Roger.Bivand using nhh.no>
Cc : r-sig-geo using r-project.org
Objet : RE: [R-sig-Geo] gdal error

Yes, thanks it clarifies. 
I need now to find how to uninstall the older version of proj-bin I have already tried sudo apt remove package_name but it did not fixed the pb Many thanks

-----Message d'origine-----
De : Roger Bivand <Roger.Bivand using nhh.no> Envoyé : mardi 19 janvier 2021 10:17 À : Nicolas Saby <nicolas.saby using inrae.fr> Cc : r-sig-geo using r-project.org Objet : Re: [R-sig-Geo] gdal error

On Tue, 19 Jan 2021, Nicolas Saby wrote:

> Dear all,
>
> I recently updated my  linux system. I am running R 4.0.3
>
> Since this update, I get this error with the CRS function:
>
> CRS(SRS_string='EPSG:4326')
> proj_create: SQLite error on SELECT name, type, 
> coordinate_system_auth_name, coordinate_system_code, datum_auth_name, 
> datum_code, area_of_use_auth_name, area_of_use_code, text_definition, 
> deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such
> column: area_of_use_auth_name
> proj_create: SQLite error on SELECT name, type, 
> coordinate_system_auth_name, coordinate_system_code, datum_auth_name, 
> datum_code, area_of_use_auth_name, area_of_use_code, text_definition, 
> deprecated FROM geodetic_crs WHERE auth_name = ? AND code = ?: no such
> column: area_of_use_auth_name Error in CRS(SRS_string = "EPSG:4326") : 
> NA
>
> I checked the proj package with the command apt-cache show proj-bin, I 
> got this. I think I have 2 packages installed

With only 7.2.1 installed, I see:

> library(sp)
> CRS(SRS_string='EPSG:4326')
CRS arguments: +proj=longlat +datum=WGS84 +no_defs
> cat(wkt(CRS(SRS_string='EPSG:4326')), "\n")
GEOGCRS["WGS 84 (with axis order normalized for visualization)",
     DATUM["World Geodetic System 1984",
         ELLIPSOID["WGS 84",6378137,298.257223563,
             LENGTHUNIT["metre",1]],
         ID["EPSG",6326]],
     PRIMEM["Greenwich",0,
         ANGLEUNIT["degree",0.0174532925199433],
         ID["EPSG",8901]],
     CS[ellipsoidal,2],
         AXIS["geodetic longitude (Lon)",east,
             ORDER[1],
             ANGLEUNIT["degree",0.0174532925199433,
                 ID["EPSG",9122]]],
         AXIS["geodetic latitude (Lat)",north,
             ORDER[2],
             ANGLEUNIT["degree",0.0174532925199433,
                 ID["EPSG",9122]]]]

You are probably right that your two proj-bin (and other proj) ununtu packages are confusing each other. There should be one only, and rgdal (and sf) should be re-installed from source to pick up the correct unique version.

Hope this clarifies,

Roger

>
> Package: proj-bin
> Source: proj
> Priority: optional
> Section: science
> Installed-Size: 470
> Maintainer: Debian GIS Project
> <pkg-grass-devel using lists.alioth.debian.org>
> Architecture: amd64
> Version: 7.2.0-1~focal0
> Depends: libc6 (>= 2.29), libgcc-s1 (>= 3.0), libproj19 (>= 7.2.0), libstdc++6 (                >= 5.2)
> Filename: pool/main/p/proj/proj-bin_7.2.0-1~focal0_amd64.deb
>
> Package: proj-bin
> Architecture: amd64
> Version: 6.3.1-1
> Priority: extra
> Section: universe/science
> Source: proj
> Origin: Ubuntu
> Maintainer: Ubuntu Developers <ubuntu-devel-discuss using lists.ubuntu.com>
> Original-Maintainer: Debian GIS Project <pkg-grass-devel using lists.alioth.debian.org                                                                             >
> Bugs: https://bugs.launchpad.net/ubuntu/+filebug
> Installed-Size: 319
> Depends: libc6 (>= 2.29), libgcc-s1 (>= 3.0), libproj15 (>= 6.2.1), libstdc++6 (                >= 5.2)
> Filename: pool/universe/p/proj/proj-bin_6.3.1-1_amd64.deb
> Task: ubuntustudio-video, ubuntustudio-publishing, ubuntustudio-photography, ubu                                                                             ntustudio-graphics
>
>
> Thank you
> Nicolas
>
> [Logo-Signature-INRAE]
>
> Bdat.gissol.fr
>
> Nicolas Saby
> Chef de projet en information statistique
> https://orcid.org/0000-0001-8964-1194
>
>
>

--
Roger Bivand
Department of Economics, Norwegian School of Economics, Helleveien 30, N-5045 Bergen, Norway.
voice: +47 55 95 93 55; e-mail: Roger.Bivand using nhh.no
https://orcid.org/0000-0003-2392-6140
https://scholar.google.no/citations?user=AWeghB0AAAAJ&hl=en