Feature request #3227

Load PostGIS layer only for current canvas extent

Added by Ivan Mincik almost 14 years ago. Updated about 7 years ago.

Status:Open
Priority:Low
Assignee:-
Category:Vectors
Pull Request or Patch supplied:No Resolution:
Easy fix?:No Copied to github as #:13287

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 2011-06-20

History

#1 Updated by Giovanni Manghi almost 13 years ago

  • Target version changed from Version 1.7.0 to Version 1.7.4

#2 Updated by Giovanni Manghi over 12 years ago

  • Pull Request or Patch supplied set to No

see also #4006

#3 Updated by Giovanni Manghi over 12 years ago

  • Target version changed from Version 1.7.4 to Version 2.0.0

#4 Updated by Pirmin Kalberer about 12 years ago

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

#5 Updated by Giovanni Manghi over 7 years ago

  • Easy fix? set to No

#6 Updated by Jürgen Fischer about 7 years ago

  • Assignee deleted (Jürgen Fischer)

Also available in: Atom PDF