Freelancer

Description

Looking for someone to create a mapping software which will do the following task(s):

1 - Chart a group of clients by feed (please see attached) based on Zip codes
2 - Split the city in different zones (Zone A, Zone B, etc. etc.). Yes, focus will be city size and not state size. Splitting the city(s) in zones means geographically creating boundaries where the zones start and finish. Please see attached example.
3 - For each zone, colors are defined on how they are as zones performing. This also depends on clients mapped in each of the zones.

Example:

Zones clients sales by month
A xys 10
A ere 3
A rew 6
B jhy 23
B we3 43
B rfe 100

Looking at the above example, you can tell Zone A is not doing so well. These zones can be based on zip codes or something else. I am not 100% sure about this aspect of the software. You can provide me with ideas / feedback but zones should have a dividing line very visible (please see attached example).

4 - Last requirement is to capture / update sales made to individual clients in each of the zones by month. This should be done from the map by clicking on each of the clients and then accessing a screen where sales can be entered. This updates should recalculate zones total sales and change colors if necessary (from red meaning these zones are doing bad to blue indicating zones are doing well).

There are additional requirement for this project but i will keep this initial deliverable somewhat simple.

This is a non-web based system storing information in a DB (mysql or sql server express possible or access). This can be done in .NET or Java.

Please see attached an image of how the city will be split in zones and the data feed which will plot the clients on a city map.

Please keep in mind, main interface of the software is map based. Goal is to visually see the data mapped (like google maps) split in different zones and within each of the zones, we will see the clients as possible click able objects having sales history.


Additional information submitted:

08/16/2009 at 12:18 EDT:
Clarifications below:

- In the attached image, zones are overlapping. This should not be the case for the application being discussed. Thats the best image i was able to pull which shows sales driven territories.

- One more point, since the interface of the application is like a Map (google map is a good example), it will be nice to have mouse over / hover over effects when going over or selecting individual clients.

Following is a realistic scenario: I see four zone, i see one zone not performing well (showing up in red based on predefined thresholds), i three start to look at client list in that region and see sales by months. AND / OR, i can simply move my mouse over clients located in that specific zones to get a quick view of what has been sold to them.

Please let me know if you need more information.

08/16/2009 at 13:51 EDT:
Please see one more example of mapping clients by zone. Please see the attached image.

This scenario captures the need to override a client's default zone if necessary.

Since zip codes can cover large area, i dont want this software to be strictly creating zones by zip codes.

However, this should be the primary method to start out but there should be a place where certain clients are forced in a different zone.

Please see attached image.

08/18/2009 at 7:56 EDT:
Project requirement focused changed a bit.

Thank you for taking the time to bid on this project. There has been a few interesting conversation which lead me to change my focus from a purely graphical system to more of a hybrid approach. I am going to open a new project with those requirements.

Thanks for bidding on this project.

Regards,

Additional files submitted:
Sample Physicians Database v6.9.2 (1).xls
city split.JPG
overriding zones.JPG