Feature request #3227

Load PostGIS layer only for current canvas extent

Added by Ivan Mincik over 6 years ago. Updated about 2 months ago.

Status:Open
Priority:Low
Assignee:Jürgen Fischer
Category:Vectors
Pull Request or Patch supplied:No Resolution:
Easy fix?:No

Description

It would be nice to add spatial query to 'Add PostGIS Table Build query' dialog to limit loading layer features only to features intersected/contained by current map canvas extent (or possibly also extent of some other already loaded layer).

This feature is very useful when You have huge table and You want to work only with its small part. In case of huge table it will speed up dramatically loading time and You can profit also from some other benefits.

Currently I am doing this by using CopyPasta plugin > Map Extent SQL and placing it to 'Build query' dialog. This will limit loaded layer to my custom extent.

Thanks a lot


Related issues

Duplicated by QGIS Application - Feature request #4006: Filter (on load) Postgis layers by canvas Bounding Box Closed 06/20/2011

History

#1 Updated by Giovanni Manghi over 5 years ago

  • Target version changed from Version 1.7.0 to Version 1.7.4

#2 Updated by Giovanni Manghi over 5 years ago

  • Pull Request or Patch supplied set to No

see also #4006

#3 Updated by Giovanni Manghi about 5 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

#4 Updated by Pirmin Kalberer over 4 years ago

  • Target version changed from Version 2.0.0 to Future Release - Nice to have

#5 Updated by Giovanni Manghi about 2 months ago

  • Easy fix? set to No

Also available in: Atom PDF