[QGIS-Developer] QGIS and Proj 6

[Nyall Dawson]

On Tue, 4 Jun 2019 at 05:44, Richard Duivenvoorde <rdmailings at duif.net> wrote:
>
> On 03/06/2019 09.28, Nyall Dawson wrote:
> > Hi all,
> >
> > Following the merge of https://github.com/qgis/QGIS/pull/30040 , I now
> > consider QGIS' port to the Proj 6 API complete. Here's a bit of a
> > summary of what's been done here (on builds based on proj 6.1 and
> > later only, more on that later[1])
>
> Ubercool Nyall! Thanks!
>
> I've build QGIS with GDAL3 and proj6.1 here.
>
> Both with an my (old) profile or with a crisp fresh one, I get a lot of
> debug output with 'failed' in it... See below

This is "just" noise, it's not actually indicating anything is wrong.
I'll see what I can do to reduce this, because it annoys me too!

Nyall

>
> Wondering if my build is wrong or it is just 'normal' output
> (QGIS_DEBUG=5...)
>
> But: thanks for all this. Though, let's be honest, I only understand
> half of it :-)   Nobody with such knowledge willing to write a thorough
> "QGIS with proj magic" intro in our docs?
>
> Regards,
> Richard Duivenvoorde
>
> src/core/qgscoordinatereferencesystem.cpp:1057 : (createFromProj4)
> [27ms] Projection is not found in databases.
> src/core/qgscoordinatereferencesystem.cpp:1119 : (getRecord) [16ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat
> +a=529800 +no_defs' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1161 : (getRecord) [1ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat
> +a=529800 +no_defs' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1119 : (getRecord) [56ms]
> failed :  SELECT * FROM tbl_srs WHERE ' '||parameters||' ' LIKE '%
> +proj=longlat %' AND ' '||parameters||' ' LIKE '% +a=529800 %' AND '
> '||parameters||' ' LIKE '% +no_defs %' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1161 : (getRecord) [1ms]
> failed :  SELECT * FROM tbl_srs WHERE ' '||parameters||' ' LIKE '%
> +proj=longlat %' AND ' '||parameters||' ' LIKE '% +a=529800 %' AND '
> '||parameters||' ' LIKE '% +no_defs %' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1057 : (createFromProj4)
> [12ms] Projection is not found in databases.
> src/core/qgscoordinatereferencesystem.cpp:1119 : (getRecord) [11ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat
> +a=2575000 +no_defs' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1161 : (getRecord) [2ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat
> +a=2575000 +no_defs' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1057 : (createFromProj4)
> [35ms] Projection is not found in databases.
> src/core/qgscoordinatereferencesystem.cpp:1119 : (getRecord) [11ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat
> +a=25559000 +rf=43.616040955631398 +no_defs' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1161 : (getRecord) [1ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat
> +a=25559000 +rf=43.616040955631398 +no_defs' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1119 : (getRecord) [32ms]
> failed :  SELECT * FROM tbl_srs WHERE ' '||parameters||' ' LIKE '%
> +proj=longlat %' AND ' '||parameters||' ' LIKE '% +a=25559000 %' AND '
> '||parameters||' ' LIKE '% +rf=43.616040955631398 %' AND '
> '||parameters||' ' LIKE '% +no_defs %' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1161 : (getRecord) [1ms]
> failed :  SELECT * FROM tbl_srs WHERE ' '||parameters||' ' LIKE '%
> +proj=longlat %' AND ' '||parameters||' ' LIKE '% +a=25559000 %' AND '
> '||parameters||' ' LIKE '% +rf=43.616040955631398 %' AND '
> '||parameters||' ' LIKE '% +no_defs %' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1057 : (createFromProj4)
> [17ms] Projection is not found in databases.
> src/core/qgscoordinatereferencesystem.cpp:1119 : (getRecord) [25ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat
> +a=578900 +no_defs' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1161 : (getRecord) [7ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat
> +a=578900 +no_defs' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1119 : (getRecord) [41ms]
> failed :  SELECT * FROM tbl_srs WHERE ' '||parameters||' ' LIKE '%
> +proj=longlat %' AND ' '||parameters||' ' LIKE '% +a=578900 %' AND '
> '||parameters||' ' LIKE '% +no_defs %' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1161 : (getRecord) [2ms]
> failed :  SELECT * FROM tbl_srs WHERE ' '||parameters||' ' LIKE '%
> +proj=longlat %' AND ' '||parameters||' ' LIKE '% +a=578900 %' AND '
> '||parameters||' ' LIKE '% +no_defs %' order by deprecated
> src/core/qgscoordinatereferencesystem.cpp:1057 : (createFromProj4)
> [10ms] Projection is not found in databases.
> src/core/qgscoordinatereferencesystem.cpp:1119 : (getRecord) [10ms]
> failed :  select * from tbl_srs where parameters='+proj=longlat +a=33000
> +no_defs' order by deprecated
>