Hi,
I am doing volunteer work for a charity. The job is to coordinate money
collecting activities of people who
raise money with collecting-boxes. I am involved with one postal code 4 (pc4)
area (our postal codes have the format 1234 AB (postal code 6). So 'one postal
code 4 area' means [0-9]{4}[A-Z]{2} (1234AA, 1234AB, etc.). One pc4 area is
typically divided over a group of 8 people who actually go out there to collect
the money.
I would like to make a webtool that makes it possible for collectors to select
what streets they want to visit.
Other collectors of their pc4 area should also be able to see their selection,
once it's final (it's a BIG no-no that the same street is visited by multiple
collectors in the same week). Selection would be done by selecting street names
or pc6 (tick boxes). A selection would be visualized on a map (a different
color for each collector). The number of households associated with the
selection is shown to see if the selection is a realistic amount.
Now, this is where Python comes in. Or wait, maybe not quite yet. The problem
should (I think) be divided into two major steps: (1) database design (2) UI
design (Python, I hope!)
(1) Database design. Here are the database tables I think are necessary:
tblPostalcode: pc6, streetname, nHouseholds, isVisitable, remarks
tblCollectorSelection: collectorname, streetname, selectiondate
(2) UI design. Ah, finally, Python. ;-) I had Django in mind to create the web
interface and GeoDjango to display the selection on a map. I am open for other
suggestions though (D3?). I am not even sure how realistic this is, given that
I have zilch experience with web programming (and Java script). The whole thing
should be non-geeky, non-techy for users.
I would love to hear your thoughts about this. Does this make sense? Is Django
a good choice?
Regards,
Albert-Jan
ps: sorry about the large amount of text. ;-)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
All right, but apart from the sanitation, the medicine, education, wine, public
order, irrigation, roads, a
fresh water system, and public health, what have the Romans ever done for us?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
_______________________________________________
Tutor maillist - Tutor@python.org
To unsubscribe or change subscription options:
http://mail.python.org/mailman/listinfo/tutor
