Re: [QGIS-Developer] OSGEO4W nightlies broken?

2022-09-02 Thread Andrea Giudiceandrea via QGIS-Developer 
*i-s-o*46.i.s.o.64 at gmail.com 


/Fri Sep 2 04:16:59 PDT 2022/

Not sure if it is a similar issue: 3.22 and 3.26 nightlies got updated
today, but the latest 3.27 update is from August 22.


Hi i-s-o,
qgis-dev has been updated (293-fc1b1cac1c-1 2022-Sep-02 17:09) just few 
hours ago.


Regards.

Andrea Giudiceandrea___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] OSGEO4W nightlies broken?

2022-09-02 Thread i-s-o via QGIS-Developer 
Not sure if it is a similar issue: 3.22 and 3.26 nightlies got updated
today, but the latest 3.27 update is from August 22.

On Thu, Aug 11, 2022, 02:46 Jürgen E. Fischer via QGIS-Developer <
qgis-developer@lists.osgeo.org> wrote:

> Hi Nyall,
>
> On Thu, 11. Aug 2022 at 14:51:16 +1000, Nyall Dawson via QGIS-Developer
> wrote:
> > It looks like the osgeo4w qgis dev releases are stuck with an ~10 day
> > old build right now. Is this a known issue? Or something broken on the
> > osgeo4w infrastructure?
>
> Another unique_ptr template issue:
>
> C:/PROGRA~2/MICROS~3/2019/COMMUN~1/VC/Tools/MSVC/1429~1.300/bin/Hostx64/x64/cl.exe
> /nologo /TP -DNOMINMAX -DQT_CONCURRENT_LIB -DQT_CORE_LIB
> -DQT_DEPRECATED_WARNINGS -DQT_DISABLE_DEPRECATED_BEFORE=0x050800
> -DQT_GUI_LIB -DQT_NETWORK_LIB -DQT_NO_CAST_TO_ASCII -DQT_NO_DEBUG
> -DQT_NO_FOREACH -DQT_POSITIONING_LIB -DQT_PRINTSUPPORT_LIB
> -DQT_SERIALPORT_LIB -DQT_SQL_LIB -DQT_SVG_LIB -DQT_USE_QSTRINGBUILDER
> -DQT_WEBKITWIDGETS_LIB -DQT_WEBKIT_LIB -DQT_WIDGETS_LIB -DQT_XML_LIB
> -DSIP_VERSION=0x060101
> -DTEST_DATA_DIR=/"C:/src/OSGeo4W/src/qgis-dev/qgis/tests/testdata/"
> -DWITH_COPC -DWITH_EPT -DWITH_QTWEBKIT -D_CRT_NONSTDC_NO_WARNINGS
> -D_CRT_SECURE_NO_WARNINGS -D_HAS_AUTO_PTR_ETC=1 -D_HAVE_WINDOWS_H_
> -D_USE_MATH_DEFINES -Dqgis_core_EXPORTS
> -IC:/src/OSGeo4W/src/qgis-dev/osgeo4w/build/src/core/qgis_core_autogen/include
> -IC:/src/OSGeo4W/src/qgis-dev/osgeo4w/build
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/external/poly2tri
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/providers/ept
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/providers/copc
> -IC:/src/OSGeo4W/src/qgis-dev/osgeo4w/build/src/core
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/3d
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/annotations
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/auth
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/browser
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/callouts
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/classification
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/diagram
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/dxf
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/editform
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/effects
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/elevation
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/expression
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/externalstorage
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/fieldformatter
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/geometry
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/geocms
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/geocms/geonode
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/geocoding
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/gps
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/labeling
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/layertree
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/layout
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/locator
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/maprenderer
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/mesh
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/metadata
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/network
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/numericformats
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/pal
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/plot
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/pointcloud
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/pointcloud/expression
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/processing
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/processing/models
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/proj
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/project
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/providers
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/providers/arcgis
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/providers/memory
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/providers/gdal
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/providers/ogr
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/providers/meshmemory
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/raster
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/renderer
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/scalebar
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/settings
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/symbology
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/textrenderer
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/validity
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/vector
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/src/core/vectortile
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/external
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/external/nlohmann
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/external/kdbush/include
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/external/nmea
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/external/rtree/include
> -IC:/src/OSGeo4W/src/qgis-dev/qgis/external/meshOptimizer
> -IC:/src/OSGeo4W/src/qgis-dev/osgeo4w/osgeo4w/include
> -IC:/src/OSGeo4W/src/qgis-dev/o

[QGIS-Developer] Model for Temporal Measurement (vector) Datasets ?

2022-09-02 Thread Richard Duivenvoorde via QGIS-Developer 

Hi All,

Anybody is aware of a model in which data owns a location, but THAT location 
has a (growing) set of [timestamp, value] observation data to it

In GIS/QGIS everything is tabular (talking about vector here, I know meshes can 
have more shapes).

But in the IOT world the 'location' is 'just an attribute', and the 'other' 
data is actually more of interest (and growing in time).

Currently to view measurements, 'we' often replicate the location for every 
value/measurement: we create a 'Feature' for every time step (eg for example 
via a WFS)

The OGC has a SensorThingsApi (STA) standard, in which for given location you 
can request all values/observations (of filter a certain sensortype/parameter). 
So one geometry has a full table of data to it.

BUT to 'work' with that data in QGIS, you always have to 'flatten' it, one way 
or another, (I think), for every time step: create a feature with: location, 
time, value...

My Question:

- isn't there some model (or can we come up with one) in which a location can 
actually have a range of time/value data (like some table join like), and when 
you use the Temporal Controller, you style your layer by RE-using the one 
location, but getting the value for current Timestamp (in the TimeController). 
Some sort of indirect filtering?

- or is this the mesh model (I know netcdf's in which you have often predefined 
meshes/location and the data/time vector is growing)?
And would a solution be to have some kind of in memory vector -> mesh loader or 
so???

I hope this makes sense to others. Any input appreciated.

Regards,

Richard Duivenvoorde

PS, if you want to play with SensorThingsApi:
- install: https://github.com/AirBreak-UIA/SensorThingsAPI_QGIS-plugin
- connect it to: 
https://airquality-frost.k8s.ilt-dmz.iosb.fraunhofer.de/v1.1/Locations
(around 5000 location and 500-million 'observations')
- load all locations in one layer, and click on a location
My point: the data is then viewable/selectable by table and graph, but NOT 
loadable in a sense way (yet) in QGIS...
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] Work on QgsAbstractDatabaseProviderConnection for MS SQL Server

2022-09-02 Thread Alessandro Pasotti via QGIS-Developer 
Hi Bo,

I could have a look but I need a few days...

On Fri, Sep 2, 2022 at 12:08 PM Bo Victor Thomsen via QGIS-Developer
 wrote:
>
> Hi List -
>
> I am working on a plugin that's is using for connections 
> (QgsAbstractDatabaseProviderConnection) to several types of databases, 
> including Postgres, GeoPackage and MS SQLServer.
>
> I was hoping to use the method "createSqlVectorLayer"  for converting some 
> fairly complex SQL queries into QGIS vector layers. This works super nice for 
> Postgres and GeoPackage. However the current version (QGIS 3.26) doesn't 
> support this method for MS SQLServer. As illustrated in this piece of code:
>
> conns = 
> QgsProviderRegistry.instance().providerMetadata('mssql').connections(False)
> conn = conns['geodata @ localhost'] # SQL server connection
> capabilities = conn.capabilities()
> print(bool(capabilities & QgsAbstractDatabaseProviderConnection.SqlLayers))
>
> The last statement shows "False" for MS SqlServer connections, indicating the 
> missing functionality. (QGIS ver. 3.26 or older)
>
>
> My first question is: Has there been done any work on this for MS SQL Server 
> connections in QGIS master (next version) ?
>
> The second question: Is it possible for someone in the group of Core 
> developers to provide me with a ballpark figure for implementing the missing 
> functionality for the mssql driver ??
>
> To be specific: get method "createSqlVectorLayer" to work for MS SQL Server 
> connections.
>
> If somebody steps up to the challenge I will send the information to my 
> customers so they can consider making QGIS better instead of paying me for an 
> ugly workaround.
>
>
> Med venlig hilsen / Kind regards
>
> Bo Victor Thomsen
>
> ___
> QGIS-Developer mailing list
> QGIS-Developer@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer



-- 
Alessandro Pasotti
QCooperative:  www.qcooperative.net
ItOpen:   www.itopen.it
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

[QGIS-Developer] Work on QgsAbstractDatabaseProviderConnection for MS SQL Server

2022-09-02 Thread Bo Victor Thomsen via QGIS-Developer 

Hi List -

I am working on a plugin that's is using for connections 
(QgsAbstractDatabaseProviderConnection) to several types of databases, 
including Postgres, GeoPackage and MS SQLServer.


I was hoping to use the method "createSqlVectorLayer 
" 
for converting some fairly complex SQL queries into QGIS vector layers. 
This works super nice for Postgres and GeoPackage. However the current 
version (QGIS 3.26) doesn't support this method for MS SQLServer. As 
illustrated in this piece of code:


conns = 
QgsProviderRegistry.instance().providerMetadata('mssql').connections(False)

conn = conns['geodata @ localhost'] # SQL server connection
capabilities = conn.capabilities()
print(bool(capabilities & QgsAbstractDatabaseProviderConnection.SqlLayers))

The last statement shows "False" for MS SqlServer connections, 
indicating the missing functionality. (QGIS ver. 3.26 or older)



My first question is: Has there been done any work on this for MS SQL 
Server connections in QGIS master (next version) ?


The second question: Is it possible for someone in the group of Core 
developers to provide me with a ballpark figure for implementing the 
missing functionality for the mssql driver ??


To be specific: get method "createSqlVectorLayer 
" 
to work for MS SQL Server connections.


If somebody steps up to the challenge I will send the information to my 
customers so they can consider making QGIS better instead of paying me 
for an ugly workaround.



Med venlig hilsen / Kind regards

Bo Victor Thomsen
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

Re: [QGIS-Developer] g++ dependency?

2022-09-02 Thread Richard Duivenvoorde via QGIS-Developer 

Hi Raymond,

(I've been bitten by this one too)

g++ etc is actually in the 'build-essential' package, and named here:

https://github.com/qgis/QGIS/blob/release-3_22/INSTALL.md#310-building-debian-packages

So, it IS there, but not part of the big line(s) with dependencies per distro...

If on all Ubuntu releases it is named like that, you could add 
'build-essential' to the distro-lines?

Others?

On 9/2/22 08:10, Raymond Nijssen via QGIS-Developer wrote:

On a fresh Ubuntu 22.04 I wasn't able to compile QGIS until installing g++ as a 
dependency.

Should I add it to this page?
https://github.com/qgis/QGIS/blob/release-3_22/INSTALL.md

Raymond
___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer


___
QGIS-Developer mailing list
QGIS-Developer@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer