[R-sig-Geo] RE : RE : rgdal problem when connecting with postgres
Roger Bivand
Roger.Bivand at nhh.no
Tue Feb 2 11:07:43 CET 2010
On Mon, 1 Feb 2010, Cédric Briand wrote:
> Oh, I saw this one but did not continue as I did not find the pexports
> in the Mingw distributed with Rtools. It is not provided and must be
> downloaded. Getting help from Mingw is difficult as all their pages
> currently point to some commercial source.... So following your
> direction I've finally succeded in building the package. To say frankly
> it was difficult to me (I never included dll in my packages so far). So
> I'm providing other users with detailed instructions on how to proceed.
Cédric:
I don't think that you need to copy any OSGEO4W DLLs to the package tree.
I do think that you have to start R from within an OSGEO4W console or
environment, which has set up the PATH for the executables. I don't think
that you need to modify configure.win, just make sure that the package
build process is being run from within OSGEO4W. I think that running
everything within your target environment is the key.
Roger
>
> ## notes for building gdal against OSGeo4W (modified from Roger Bivand)
> ## 1- download rgdal sources http://cran.r-project.org/web/packages/rgdal/index.html
> ## in the following I just copied it in c:\
> ## 2- Run in OSGeo4W console, after setting:
> set OSGEO4W_BUILD=yes
> set GDAL_HOME=%OSGEO4W_ROOT%
>
> ## 3-get the Rdll.lib
> ## MinGW is avalaible with Rtools
> ## install pexports (available at http://sourceforge.net/projects/mingw/files/ somewhere down the long list ...
> cd C:\Program Files\R\R-2.10.1\bin
> C:\Rtools\MinGW\bin\ pexports R.dll > R.exp
> ## using visual c++ (vc9) command line url: http://www.microsoft.com/express/Downloads/#2008-Visual-CPP
> cd C:\Program Files\R\R-2.10.1\bin
> lib /def:R.exp /out:Rdll.lib
> cd C:/rgdal/src
> cl /MT /Ox /EHsc /D "WIN32" /c /I "C:/Program Files/R/R-2.10.1/include" /I C:/OSGeo4W/include /I "C:\Program Files\Microsoft Visual Studio 9.0\VC\include" /D OSGEO4W *.cpp
> link /dll /out:rgdal.dll /def:rgdal.def *.obj "C:/Program Files/R/R-2.10.1/bin/Rdll.lib" /libpath:"C:\Program Files\Microsoft Visual Studio 9.0\VC\lib" /libpath:"C:\Program Files\Microsoft SDKs\Windows\v6.0A\Lib" /libpath:"C:\OSGeo4W\lib" gdal_i.lib proj_i.lib
> ## 4. Ensure the configure.win, Makefile.win and RGDAL.def are all correct.
> ## these files are found in rgdal and rgdal/src
> ## set the location of GDAL_HOME in configure.win (GDAL_HOME="C:/OSGeo4W") for default OSGeo4W install
> -//-- start configure.win
> #!/bin/sh
> if test -z "$GDAL_HOME" ; then
> GDAL_HOME="C:/OSGeo4W"
> fi
> echo "GDAL_HOME=${GDAL_HOME}" > src/Makeconf.win
> echo "using GDAL_HOME: ${GDAL_HOME}"
> if test -z "$OSGEO4W_BUILD" ; then
> if test -z "$R_PACKAGE_DIR" ; then
> R_PACKAGE_DIR=${DPKG}
> fi
> mkdir "${R_PACKAGE_DIR}/libs"
> cp ${GDAL_HOME}/bin/adrg.dll "${R_PACKAGE_DIR}/libs"
> cp ${GDAL_HOME}/bin/cblas.dll "${R_PACKAGE_DIR}/libs"
> cp ${GDAL_HOME}/bin/dted.dll "${R_PACKAGE_DIR}/libs"
> cp ${GDAL_HOME}/bin/fribidi.dll "${R_PACKAGE_DIR}/libs"
> cp ${GDAL_HOME}/bin/gdiplus.dll "${R_PACKAGE_DIR}/libs"
> cp ${GDAL_HOME}/bin/gdal15.dll "${R_PACKAGE_DIR}/libs"
> cp ${GDAL_HOME}/bin/gdal16.dll "${R_PACKAGE_DIR}/libs"
> echo "OSGEO= " >> src/Makeconf.win
> else
> echo "OSGEO=-DOSGEO4W" >> src/Makeconf.win
> fi
> -//-- end configure.win
>
> ## RGDAL.def as supplied in rgdal/src (no modification there)
> ## Place Makefile.win in src/, containing a single line:
> all:
> ##5. Install package (my rdal sources are still in c:/)
> ## CD C:\
> C:\"Program Files"\R\R-2.10.1\bin\Rcmd INSTALL --build rgdal
> ## Note if this step does not work look if you have the Rtools properly installed and configured (especially the path)
> ## Then copy manually all dll of c:/OSGeo4W/bin in the newly rgdal/libs
> ##Post-installation, start R from the OSGeo4W console (command line). If you want
> ##to check that the OSGeo4W-aware rgdal is present, check the reported support
> ##file locations, and consider running:
> source(system.file("OSGeo4W_test", package="rgdal"), echo=TRUE)
> also list drivers with ogrDrivers() PostgresSQL should be on the list
>
> The test has worked fine but
> rdGDAL> GDALinfo(system.file("external/test.ag", package="sp")[1])
> Erreur dans .Call("RGDAL_GetMetadata", x, NULL, PACKAGE = "rgdal") :
> le nom C de symbole "RGDAL_GetMetadata" est introuvable dans la DLL pour le package "rgdal"
> De plus : Messages d'avis :
> 1: In getGeoTransFunc(dataset) : GeoTransform values not available
> 2: In getGeoTransFunc(dataset) : GeoTransform values not available
> 3: In x[20:50, 20:50] : GeoTransform values not available
> 4: In x.gdal[, , 3] : GeoTransform values not available
> 5: In x.gdal[] : GeoTransform values not available
> 6: In asMethod(object) : GeoTransform values not available
>
>
> and unfortunately
>
> Erreur dans .Call("R_OGR_types", as.character(dsn), as.character(layer), :
> le nom C de symbole "R_OGR_types" est introuvable dans la DLL pour le package "rgdal"
>
>
> Thanks again for your answers
>
> Cédric
>
> ________________________________________
> De : Roger Bivand [Roger.Bivand at nhh.no]
> Date d'envoi : lundi 1 février 2010 09:51
> À : Cédric Briand
> Cc : r-sig-geo at stat.math.ethz.ch
> Objet : Re: RE : [R-sig-Geo] rgdal problem when connecting with postgres
>
> On Sun, 31 Jan 2010, Cédric Briand wrote:
>
>> Dear Roger
>>
>> Thank you for your answer.
>>
>> I have done the following : -----------------------------------------
>> Run in OSGeo4W console, after setting: set OSGEO4W_BUILD=yes set
>> GDAL_HOME=%OSGEO4W_ROOT% download rgdal sources cd C:/rgdal/src using
>> visuel c++ (vc9) command line cl /MT /Ox /EHsc /D "WIN32" /c /I
>> "C:/Program Files/R/R-2.10.1/include" /I C:/OSGeo4W/include /I
>> "C:\Program Files\Microsoft Visual Studio 9.0\VC\include" /D OSGEO4W
>> *.cpp ------------------------------------------------------- at this
>> point, following your insctructions, I need a rdll.lib, and was not able
>> to produce it ...
>
> Cédric:
>
> This is discussed in README.packages in src/gnuwin32 in the source -
> online (for the development version) at:
>
> https://svn.r-project.org/R/trunk/src/gnuwin32/README.packages
>
> or 2.10.1:
>
> https://svn.r-project.org/R/tags/R-2-10-1/src/gnuwin32/README.packages
>
> your error messages suggest that trying the alternative
>
> pexports R.dll > R.exp
>
> might be worth trying. This step is needed for building any source package
> under Windows using VC++, so either make R.exp or using pexports should
> work once everything is lined up (PATH, etc.).
>
> For me with a command line in R-2.10.1/bin, "pexports R.dll > R.exp" does
> work, as does "lib /def:R.exp /out:Rdll.lib", but your mileage may vary.
>
> Roger
>
>
>>
>> I understand I have to download the source and try the following code, but it fails.
>>
>> C:\R-2.10.1\src\gnuwin32>make R.exp
>> -------------------------------------------------
>> gcc -std=gnu99 -I../include -I. -I../extra -DHAVE_CONFIG_H -DR_DLL_BUILD -O3 -W
>> all -pedantic -c console.c -o console.o
>> console.c:23:20: error: config.h: No such file or directory
>> console.c:73: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'Ch
>> aracterMode'
>> console.c: In function 'console_normalkeyin':
>> console.c:1357: error: 'CharacterMode' undeclared (first use in this function)
>> console.c:1357: error: (Each undeclared identifier is reported only once
>> console.c:1357: error: for each function it appears in.)
>> console.c:1357: error: 'RGui' undeclared (first use in this function)
>> make: *** [console.o] Error 1
>> ---------------------------------------------------
>> Cédric
>>
>> ________________________________________
>> De : Roger Bivand [Roger.Bivand at nhh.no]
>> Date d'envoi : vendredi 29 janvier 2010 20:11
>> À : Cédric Briand
>> Cc : r-sig-geo at stat.math.ethz.ch
>> Objet : Re: [R-sig-Geo] rgdal problem when connecting with postgres
>>
>> On Fri, 29 Jan 2010, Cédric Briand wrote:
>>
>>> Dear list members
>>> We are using R 2.10.1 and rgdal Version: 0.6-20, and are working with
>>> windows XP.
>>
>> If you mean the Windows binary rgdal package, then the answer is in
>>
>> file.show(system.file("README", package="rgdal"))
>> file.show(system.file("README.windows", package="rgdal"))
>>
>> The Windows binary package builds the minimal set of drivers, with only
>> one external dependency (expat for reading GPX and KML). The file refered
>> to describes how you might build rgdal from source, using FWTools or
>> OSGEO4W as the provider of GDAL and its dependent DLLs. If you do try this
>> out (look for the chunk beginning: "Initial notes for OSGeo4W"), and if:
>>
>> source(system.file("OSGeo4W_test", package="rgdal"), echo=TRUE)
>>
>> works, as well as PostGIS access, please let me know.
>>
>> Roger
>>
>>
>>> Following the nice example found at
>>> http://wiki.intamap.org/index.php/PostGIS<http://wiki.intamap.org/index.php/PostGIS>
>>> we tried to connect to our postgres database
>>>
>>
>> PS. That example was run on Linux with GDAL built with PostGIS, and rgdal
>> installed as a source package.
>>
>>> library(rgdal)
>>> trial = readOGR("PG:dbname=CCM", "riversegments")
>>>
>>>
>>> This does not work. We have tried to use ogr2ogr and examples found at
>>>
>>> http://www.bostongis.com/?content_name=ogr_cheatsheet
>>>
>>> and they work fine particularly we were able to connect to our database using the following script
>>>
>>>
>>> C:\OSGeo4W\bin\ogr2ogr -f "ESRI Shapefile" C:\base\basesig\essai.shp PG:"host=localhost user=postgres dbname=CCM password=postgres port=5433" "riversegments
>>>
>>>
>>>
>>>
>>>
>>> As this works we translated the more complex dsn into the rgdal command line
>>>
>>>
>>>
>>> require(rgdal)
>>>
>>> readOGR(dsn="PG:host=locahost user=postgres dbname=CCM password=postgres port=5433",layer="riversegments")
>>>
>>>
>>>
>>> but it always returns a "Cannot open file" error :
>>>
>>>
>>>
>>>> require(rgdal)
>>>
>>> Le chargement a n?cessit? le package : rgdal
>>>
>>> Le chargement a n?cessit? le package : sp
>>>
>>> Geospatial Data Abstraction Library extensions to R successfully loaded
>>>
>>> Loaded GDAL runtime: GDAL 1.6.2, released 2009/07/31
>>>
>>> Path to GDAL shared files: C:/Program Files/R/R-2.10.0/library/rgdal/gdal
>>>
>>> Loaded PROJ.4 runtime: Rel. 4.6.1, 21 August 2008
>>>
>>> Path to PROJ.4 shared files: C:/Program Files/R/R-2.10.0/library/rgdal/proj
>>>
>>>> readOGR(dsn="PG:host=localhost dbname=CCM user=postgres passwd=postgres port=5433",layer="riversegments")
>>>
>>> Erreur dans ogrInfo(dsn = dsn, layer = layer, input_field_name_encoding = input_field_name_encoding) : Cannot open file
>>>
>>>
>>> The ogrInfo in command line found at 'C:\OSGeo4W\bin\ogrInfo.exe' does seem to work (it does not return any error)
>>>
>>>
>>>
>>> The reason behind this failure seems to be that PostgresSQL is not listed in the drivers availaible with the package.
>>>
>>>> ogrDrivers()
>>>
>>> name write
>>>
>>> 1 AVCBin FALSE
>>>
>>> 2 AVCE00 FALSE
>>>
>>> 3 BNA TRUE
>>>
>>> 4 CSV TRUE
>>>
>>> 5 DGN TRUE
>>>
>>> 6 ESRI Shapefile TRUE
>>>
>>> 7 Geoconcept TRUE
>>>
>>> 8 GeoJSON TRUE
>>>
>>> 9 GML TRUE
>>>
>>> 10 GMT TRUE
>>>
>>> 11 GPX TRUE
>>>
>>> 12 KML TRUE
>>>
>>> 13 MapInfo File TRUE
>>>
>>> 14 Memory TRUE
>>>
>>> 15 REC FALSE
>>>
>>> 16 S57 TRUE
>>>
>>> 17 SDTS FALSE
>>>
>>> 18 TIGER TRUE
>>>
>>> 19 UK .NTF FALSE
>>>
>>> 20 VRT FALSE
>>>
>>> 21 XPlane FALSE
>>>
>>>
>>>
>>> After many trials we are at a loss on how to add a driver to the drivers in R. So any hint would be really valuable.
>>>
>>>
>>>
>>> C?dric
>>>
>>>
>>>
>>>
>>> [[alternative HTML version deleted]]
>>>
>>>
>>
>> --
>> 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
>
> --
> 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
--
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
More information about the R-sig-Geo
mailing list