Support keyword substitution in provider queries - Githubissues

qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)

https://qgis.org

GNU General Public License v2.0

10.62k stars 3.01k forks source link

Support keyword substitution in provider queries #14306

Open qgib opened 13 years ago

qgib commented 13 years ago

Author Name: Sandro Santilli (@strk) Original Redmine Issue: 4374

Redmine category:data_provider

When fetching features from a query it would be useful to allow using keywords to be substituted on each fetching. Such keywords, in particular pixel sizes and extent, could be used by the query to preprocess geometries (like DP-simplification, grid snapping etc.) and reduce the amount of geometries fetched (using extent information).

qgib commented 12 years ago

Author Name: Paolo Cavallini (@pcav)

category_id was configured as Data Provider

qgib commented 12 years ago

Author Name: Giovanni Manghi (@gioman)

fixed_version_id was configured as Version 1.7.4

qgib commented 12 years ago

Author Name: Giovanni Manghi (@gioman)

fixed_version_id was changed from Version 1.7.4 to Version 2.0.0

qgib commented 12 years ago

Author Name: Pirmin Kalberer (Pirmin Kalberer)

fixed_version_id was changed from Version 2.0.0 to Future Release - Nice to have

qgib commented 8 years ago

Author Name: Andreas Wicht (@andywicht)

That would be a great change in order to make actual use of the postgis_topology in QGIS. For tiny topologies it would not make much of a difference, but for the bigger ones. Big topologies are completely un-editable in QGIS due to the restriction that spatial indexing is not compatible with the TopoGeometry type. So, given the fact, that a table additionally stores the Geometry representation of a TopoGeometry, the Geometry column could be used to query the spatial extents and therefore utilising spatial indexing while displaying and editing the TopoGeometry column.

That would enable anybody to utilise QGIS for the editing process of large postgis topologies as no custom web-gis solutions would have to be developed.

Reconsidering the target version would be highly appreciated by me :-)

qgib commented 8 years ago

Author Name: Sandro Santilli (@strk)

I guess "target version" could be changed if someone provides an actual patchset to implement the keyword substitution.

qgib commented 7 years ago

Author Name: Giovanni Manghi (@gioman)

easy_fix was configured as 0

strk commented 5 years ago

One problem with keyword substitution is that attributes fetching would then end up depending on current extent (unless we have the substitution pass an "universe" bounding box in that case)

strk commented 5 years ago

@andywicht could you please take a look at https://github.com/qgis/QGIS/pull/31468 ?