Re: [Qgis-user] problem with maximum value selection

[Micha Silver]

(forwarding to the maillist) On 27/08/2013 12:51, ibad raza wrote: Hi Micha I have encountered another problem I have been trying to load an image into postgis through raster2pgsql command the image gets added nicely with different tile sizes but when i try to open it in Qgis, it takes ages and finally crashes my system the image size is 10gb is there a way of image indexing that can make its view faster? Best Ibad Raza On Mon, Aug 26, 2013 at 12:36 PM, ibad raza <ibadraza...@gmail.com> wrote: Thanks  Micha I completed the task using the query. Best Ibad Raza On Mon, Aug 26, 2013 at 11:18 AM, Micha Silver <mi...@arava.co.il> wrote: On 25/08/2013 20:22, ibad raza wrote: HI team I have a shpe file consisting of points having population values in each point. there are 7000 points and I have a polygon shape file of council boundaries. 60 polygons every council boundary covers  different number of points in it. (for example 100, 150 or less) I want to know the maximum population value point for every council. Have a look at this: http://gis.stackexchange.com/questions/68546/want-to-display-count-of-records-within-a-given-area-electoral-district/68555#68555 I think the solution presented there is similar to what you require. But you'll need to substitute the MAX() Spatialite function, instead of SUM() HTH, Micha so that I know which spatial location has maximum population in every council. Best Ibad Raza.. This mail was received via Mail-SeCure System. _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user This mail was received via Mail-SeCure System. -- Micha Silver GIS Consulting 052-3665918 http://www.surfaces.co.il This mail was received via Mail-SeCure System. -- Micha Silver GIS Consulting 052-3665918 http://www.surfaces.co.il

_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user