[Openstreetmap] ecourier.co.uk GPS data mine
tom at tom-carden.co.uk
Tue Jun 28 14:56:43 BST 2005
That sounds fantastic, and I'm sure there's a way to sort it out.
Thinking... are you sure that someone who won't allow scripts to run on
their server would allow a 3rd party box onto their network (and the web)
and allow it access to the database!?!
One thing that springs to mind is that raw gps points aren't all that - it
would be utterly, jaw-droppingly, amazingly fantastic if they could give us
street names as well. Presumably they record the destination of the
packages, and the time of delivery?
If anyone has contacts with a taxi firm that records similar information,
this is exactly the kind of information we need - raw points AND metadata.
----- Original Message -----
From: "Saul Albert" <saul at twenteenthcentury.com>
To: "openstreetmap" <openstreetmap at vr.ucl.ac.uk>
Sent: Tuesday, June 28, 2005 2:41 PM
Subject: [Openstreetmap] ecourier.co.uk GPS data mine
> Dear OSM,
> Well I just had a *very* intereasting meeting with Jay, the cto of
> ecourier.co.uk - they're running a very slick-looking courier-logistics
> business, delivering real-time-trackable packages to businesses in the
> city. Their offices are like some kind of 1996 web-company throwback,
> growing like mad, new open plan workspaces springing up like mushrooms as
> they take on new swathes of staff....
> Anyway, they're totally into the free mapping thing and their GPRS / GPS
> toting army of 60 couriers are clocking up about 1.5 million gps points /
> day, which they're collecting in a mssql database, then just dumping
> them all after a week so their M$ database doesn't fall over.
> If we can suggest an easy way for Jay to give us a weekly dump before he
> flushes the database, and hopefully automate that, this could be a very
> very useful source of data..
> Would anyone from the dev team be up for talking to him about how to do
> this? It's going to be a bit of a 'mare, because he's already said
> there's no way he could put a script on the server.. they're too precious
> about that, but I don't see why we couldn't put a *nix box in their
> offices that fires off a query to the server once a week pre-dump,
> applies any necessary formatting / futzing to the results, and blats them
> striaght up to OSM.
> I *could* attempt to do something like that myself, but it would probably
> take me 1000* longer than anyone with a clue and is less likely to
> -- http://chinabone.lth.bclub.org.uk/~saul/
> Openstreetmap mailing list
> Openstreetmap at vr.ucl.ac.uk
More information about the talk