Slashdot Mirror
Open Source Geographic Tracking?
Walkingshark writes "I work for a company that needs to track people and equipment across the US as they move to, work on, and leave jobs. The boss has been looking at the typical mix of closed, proprietary software and has also considered building off our existing 10-year-old SQL database (with the kind of clunky interface you'd expect from a program built in the late '90s). I'd like to be able to bring him a good open source alternative, but so far I haven't been able to find anything that can do what we need. Ultimately, we need to be able to keep track of a few thousand separate people and pieces of equipment, and to move them in dynamically created groups to and from our locations and jobsites in a way that is sharable between workstations, with updates to location entered at one station being broadcast to all clients in real time. Ideally, this program needs to also give us access to road routing similar to the capability found on Google Maps. We'd doubtless need to be able to modify the source for customization, but I was hoping there was something we could find out there that had the core functionality we're looking for."
Exactly, this isn't difficult.
PseudoSQL:
select name,longitude,latitude from location order time desc limit 1.
Google Maps API and that should be it.
I didn't want to mess with the API and what I was plotting doesn't change quickly, so I just used PHP to create a KML file which I loaded through GoogleMaps/Earth.
Make it Ajaxy some 'inserts' of the data and ... that should be it. If the SQL database itself works, there is no reason that you need to replace it. It sounds like it's just the interface that is the problem.