[BangPypers] I need some help/guidance

[Smrutilekha Swain]

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 <gora at mimirtech.com> wrote:

> On 16 April 2013 12:17, Smrutilekha Swain <smrutilekha at 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 at python.org
> http://mail.python.org/mailman/listinfo/bangpypers
>