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.
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