Speedcollector

From OpenStreetMap Wiki
Jump to: navigation, search

Speedcollector is an experimental database to collect real-world driving-speeds.

It is a database collecting how fast you can be expected to drive a given road at a given time with a given type of vehicle.

It is intened to be used by free navigation software to improve the metrics used during routing and while updating the ETA while navigating.

Street-types and way-ID-numbers reference the OpenStreetMap.

Hosted at:

database schema

 CREATE TABLE `a3252478_speed`.`way_times` (
`id` INT NOT NULL AUTO_INCREMENT ,
`highway` TINYINT NOT NULL COMMENT 'code for highway-type',
`wayid` BIGINT NULL COMMENT 'id of the way in OpenStreetMap',
`dateclass` TINYINT NULL COMMENT 'weekend/weekday',
`datesubclass` TINYINT NULL COMMENT 'mo-fr+holiday',
`timeclass` TINYINT NULL COMMENT 'day/night',
`timesubclass` TINYINT NULL COMMENT 'hour',
`vehicleclass` TINYINT NOT NULL COMMENT 'car,food,hgv',
`vehiclesubclass` TINYINT NULL COMMENT 'fast car, ...',
`avgspeed` TINYINT NOT NULL COMMENT 'speed in km/h',
PRIMARY KEY ( `id` ) ,
INDEX ( `highway` )
) ENGINE = MYISAM