I am looking for an application (server-side+flash client) that will visualize geo information about a web site's visitors in semi-real time.
Here is what needs to be done.
The server side will collect apache combined logs from one or more web servers. How the logs get to the processing machine doesn't need to be covered. Assume all relevant logs are in a known directory with known filenames. The server side will process logs, extracting visitor IP address information, do the geolocation and will put the results in a database (preferably mysql, but this is negotiable and mysql may be an overkill). The logs are updated in realtime, so the process needs to work while the log is being updated and needs to keep track of what records have already been processed to avoid dupes.
The server side will also have an interface for the client side to fetch the recent visitors for a configurable period of time (5 min, 15 min, all visitors) and format it for the client to understand (XML is a good idea, but not required).
The server side must run on Linux or FreeBSD. Preferably the server side would be done in PHP, but it's not an absolute requirement.
The client side will be a Flash (preferred, negotiable, but no windows/asp, please) app running in a browser, that will periodically fetch the recent visitors information from the server, refresh the world map and display where the visitors come from. There should be an option to select a timeframe, to choose whether to display visitors as dots/circles or as lines from the visitor location to the datacenter location (configurable).
It should be possible to configure which image is used as a world map.
The client app needs to auto-scale the map image: if all visitors are from the US, only that part needs to be zoomed into and displayed.
It is ok to use free GeoIP databases, but something that is commercial but reasonably priced is ok, too. We are not aiming for 100% accuracy, just something that would give our visitors a visual representation of how popular the service is. This will be running on a big monitor on the wall somewhere for eye candy purposes, not for service monitoring or troubleshooting.
You must provide a link to a sample project of this kind that you have completed, specifically, the Flash UI that interacts with the server.
Of course all source code will need to be furnished and will become our property with unrestricted rights, so you have to either write it yourself, use open source software or be authorized to sell it to us with all rights.
I always pay very promptly for the services, see my feedback, but I will NOT do escrow: the providers at GAF have just been absolutely horrible lately in terms of meeting deadlines often not completing projects without notice, so I don't want to have a bunch of money tied up in an escrow account for nothing.
Please ask specific questions in PMs and I'll update details as necessary.
Thank you for your interest.