[QGIS-trac] [Quantum GIS] #3227: Load PostGIS layer only for current canvas extent

[Quantum GIS]

#3227: Load PostGIS layer only for current canvas extent
--------------------------------+-------------------------------------------
   Reporter:  imincik1          |              Owner:  jef          
       Type:  enhancement       |             Status:  new          
   Priority:  minor: annoyance  |          Milestone:  Version 1.7.0
  Component:  Vectors           |            Version:  Trunk        
   Keywords:                    |   Platform_version:               
   Platform:  All               |           Must_fix:  No           
Status_info:  0                 |  
--------------------------------+-------------------------------------------
 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

-- 
Ticket URL: <http://trac.osgeo.org/qgis/ticket/3227>
Quantum GIS <http://qgis.org>
Quantum GIS is an Open Source GIS viewer/editor supporting OGR, PostGIS, and GRASS formats