Feature request #9516

Allow to specify a bounding box column in addition to the geometry column

Added by Sandro Santilli over 6 years ago. Updated over 3 years ago.

Category:Data Provider/PostGIS
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:18107


Some sql queries build the geometry column on-the-fly, but can still return a bounding box from a real table. The most notable example is a query constructing a topology face geometry or centroid as used by the TopoViewer in db_manager.
Such queries cannot use an index unless you put the indexed bounding box column as one of the && inputs.

Immagine another case: you want to show a buffer of points in a table. Also in this case there's no index on the buffer, but there is one (possibly) on the points...

In both cases if you could specify the name of a column to use for spatial filtering, rather than using the single "geometry column", operations could be much faster.
Given you cannot edit queries there's no problem with that part...

Not sure if this is only related to the postgis data provider. Sounds like something that could need to be put in the QgsDataSourceUri class

\\cc @jef


#1 Updated by Giovanni Manghi over 3 years ago

  • Easy fix? set to No

Also available in: Atom PDF