[gdal-dev] Cannot find proj.db

Tue Apr 4 01:43:10 PDT 2023

Thank you very much,

I have put the files proj.db, proj.ini and proj.exe together with the dll proj_9_1.dll this solved the problem when I use gdal executables like gdalwarp.exe
and also I have added OSRSetPROJSearchPaths(), when I use the gdal API,
and it works correctly for me in all cases,
so it seems that the path of the proj.db file in an environment variable was not enough.

Thank you very much and regards

________________________________

Elena Ruiz

[https://www.aplitop.com/descargas/logo.png]
Sofware Development & Technical Support
Tel.: +34 952 43 97 71
eruiz at aplitop.com
www.aplitop.com

<http://www.aplitop.com/Product/es/6/5/tcptunnel>

<http://www.aplitop.com/New/es/281/mdt-75-a-la-venta>

De: Chris Smemoe <csmemoe at aquaveo.com>
Enviado el: jueves, 30 de marzo de 2023 19:21
Para: Elena Ruiz <eruiz at aplitop.com>; gdal-dev at lists.osgeo.org
Asunto: RE: [gdal-dev] Cannot find proj.db

Elena,

I have had this same problem.  We have a few methods of setting the location of the proj.db file.  When we call from C++ (or from python), there's a function called OSRSetPROJSearchPaths that's handy.  If you're calling from a command line, you could try setting your environment variable just before calling your function (set "PROJ_LIB=c:\path\to\proj\"). I think there's also a command line option to set your PROJ_LIB.  You could try adding "--config PROJ_LIB "c:\path\to\proj"" to your command line and see what that does.  I haven't personally tried it.

I haven't had to do these things as much with the python/conda distributions of the commandline programs for whatever reason.

HTH,

Chris

From: gdal-dev [mailto:gdal-dev-bounces at lists.osgeo.org] On Behalf Of Elena Ruiz
Sent: Thursday, March 30, 2023 6:02 AM
To: gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>
Subject: [gdal-dev] Cannot find proj.db

Hello,
I am using GDAL 3.6.2 on Windows 11 and am having problems with the following error:

ERROR 1: PROJ: proj_create_from_database: Cannot find proj.db

I have set as environment variable PROJ_LIB= "D:\MDT\V9\bin\gdal\gdal_latest\share"  and PROJ_DATA= "D:\MDT\V9\bin\gdal\gdal_latest\share", as user variable and in the system variable, but it still doesn't work and the file proj.db exits in D:\MDT\V9\bin\gdal\gdal_latest\share  .

D:\MDT\V9\bin\gdal\gdal_latest\x64>gdalwarp -s_srs EPSG:4326 -t_srs EPSG:25831 -r near -of GTiff C:\Users\elena\Downloads\D37531385_0101_DTM.asc C:/Users/elena/Downloads/D37531385_0101_DTM_25831_qgis_.tif
ERROR 1: PROJ: proj_create_from_database: Cannot find proj.db
ERROR 1: Translating source or target SRS failed:
EPSG:4326

The funny thing is that I have the same version of GDAL installed on my computer using Anaconda3, to do tests, and from the anaconda directory it works for me, and if I look in the environment variables I don't see any path that refers to where Anaconda has the Proj.db. Is there another way to set the PROJ_LIB path besides adding an environment variable? Is there any way to know where the PROJ_LIB is looking for my version of GDAL?

C:\Users\elena\Anaconda3\envs\mygdal\Library\bin>gdalwarp -s_srs EPSG:4326 -t_srs EPSG:25831 -r near -of GTiff C:\Users\elena\Downloads\D37531385_0101_DTM.asc C:/Users/elena/Downloads/D37531385_0101_DTM_25831_qgis_.tif
Creating output file that is 1003P x 1201L.
Processing C:\Users\elena\Downloads\D37531385_0101_DTM.asc [1/1] : 0Using internal nodata values (e.g. -9999) for image C:\Users\elena\Downloads\D37531385_0101_DTM.asc.
Copying nodata values from source C:\Users\elena\Downloads\D37531385_0101_DTM.asc to destination C:/Users/elena/Downloads/D37531385_0101_DTM_25831_qgis_.tif.
...10...20...30...40...50...60...70...80...90...100 - done.

Thank you and regards
________________________________

[https://www.aplitop.com/descargas/firma1.jpg]

Elena Ruiz
Sofware Development & Technical Support
Tel. +34 952 43 97 71
eruiz at aplitop.com<mailto:eruiz at aplitop.com>
Sumatra, 9 - 29190 Málaga (Spain)
www.aplitop.com<http://www.aplitop.com>

[cid:image001.jpg at 01D966E2.3C7E4310]<https://www.facebook.com/AplitopSL/>   [cid:image002.jpg at 01D966E2.3C7E4310] <https://twitter.com/aplitop>    [cid:image003.jpg at 01D966E2.3C7E4310] <https://www.linkedin.com/company/aplitop>    [cid:image004.png at 01D966E2.3C7E4310] <https://www.youtube.com/user/aplitop>

In accordance with the provisions of the European Regulation of Data Protection 2016/679 (Reglamento Europeo de Protección de Datos 2016/679), we inform you that the data and the information you provide us through this medium will be used by APLITOP, S.L., with C.I.F. B-92543396 and with address at C / Sumatra, 9, Malaga, 29190, in order to answer your questions and inform you about our products. The data provided will be kept as long as it does not request its cessation and will not be transferred to third parties except in cases where there is a legal obligation. You have the right to access your personal data, correct inaccurate data or request its deletion when the data is no longer necessary for the purposes that were collected, as well as any rights recognized in the RGPD 2016/679

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230404/6b9afc81/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 718 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230404/6b9afc81/attachment-0003.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 712 bytes
Desc: image002.jpg
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230404/6b9afc81/attachment-0004.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 737 bytes
Desc: image003.jpg
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230404/6b9afc81/attachment-0005.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 672 bytes
Desc: image004.png
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20230404/6b9afc81/attachment-0001.png>