Re: [QGIS-Developer] QGIS Full Stack Web Developer Report

2024-07-22 Thread Emma Hain via QGIS-Developer
Thanks Lova! On Fri, 19 Jul 2024 at 20:10, Lova Andriarimalala via QGIS-Developer < qgis-developer@lists.osgeo.org> wrote: > Hi everyone, > > > > Here's the report regarding the development and maintenance of the > QGIS-related websites for this week: > > > > *Overview:* > > I continued resolving

Re: [QGIS-Developer] qgis / ogr converts INT & DATE values from spatial view to STRING

2024-07-22 Thread Even Rouault via QGIS-Developer
I've reported the issue to the OGC GeoPackage specification issue tracker: https://github.com/opengeospatial/geopackage/issues/683 Le 22/07/2024 à 15:57, Even Rouault via QGIS-Developer a écrit : Benjamin, Explicit casts like "(CAST(SUM(D.QAI) as INTEGER) as n_qai" did not solve my problem.

Re: [QGIS-Developer] qgis / ogr converts INT & DATE values from spatial view to STRING

2024-07-22 Thread Even Rouault via QGIS-Developer
Benjamin, Explicit casts like "(CAST(SUM(D.QAI) as INTEGER) as n_qai" did not solve my problem. Yeah, I recently came across a similar issue, and the finding is that it is related to the SQLite version. Such casts apparently work since SQLite 3.42. So if your QGIS build uses an older SQLit

[QGIS-Developer] qgis / ogr converts INT & DATE values from spatial view to STRING

2024-07-22 Thread Benjamin Jakimow via QGIS-Developer
Dear Developers, I like to use a GPKG to store and visualize statistical information on files in a remote sensing data cube. The GPKG contains three layers: 1. ard_data - a table with all kinds of information but without geometries 2. ard_tiles - a table with polygon geometries. 3. ard_data_by