It is a database table which i have created using QTableWidget n it contains 7 columns. first column is checkbox for selecting the rows den name, site, latitude, longitude, altitude and date of entry.
in that database some r redundant data like same name n same site but little difference in latitude or longitude. so i want to sort the table in such a way that the redundant data having least value will come first like in name- A, Site- V, latitude-23.456, longitude-87.789 n in another row name-A, Site-V, latitude-23.222, longitude-87.789. so i want the minimum value sud come first. another query is how to sort the table by date of entry as the date of entry is in string.... i will b vry grateful if u give me sum help............no api n no GIS... thanzzz in advance.............. On Tue, Apr 16, 2013 at 3:50 PM, Gora Mohanty <g...@mimirtech.com> wrote: > On 16 April 2013 12:17, Smrutilekha Swain <smrutile...@gmail.com> wrote: > > i am writing a program using PyQt4. i have created a table containg name > of > > the instruments, locations, its latitudes, longitude and altitude. > > > > there may be two instruments and its locations are same but different > > latitude and longitude with mild difference. > > > > so now i want to sort the table by latitude or longitude whose have least > > difference... > [...] > > What do you mean by a "table"? A database table, or a > Python sequence? > > Abdul has already pointed out how to sort a list in > Python. However, if you want any kind of scale, you > will need a database that supports GIS operations, > and a web GIS framework if you need a presence on > the web. I would suggest GeoDjango with PostGIS. > > Regards, > Gora > _______________________________________________ > BangPypers mailing list > BangPypers@python.org > http://mail.python.org/mailman/listinfo/bangpypers > _______________________________________________ BangPypers mailing list BangPypers@python.org http://mail.python.org/mailman/listinfo/bangpypers
