Database for efficient storage of track geometry and feature locations

Abstract

A database schema is disclosed that can significantly reduce the quantity of data required to describe the geometry of a train track and the geo-locations of features (e.g., grade crossings, mileposts, signals, platforms, switches, spurs, etc.) along the track. In accordance with the illustrative embodiment, a railroad track is represented as a plurality of partitions, each of which has its geometry contained within unique track point elements. Multiple track partitions are then joined together by common track point elements at their boundaries to create continuous rail networks. A compact table schema is employed that enables continuous sections of three-dimensional track splines to be rendered accurately in the track database, irrespective of the location of vertical and horizontal curvature along track segments. The data representation scheme also enables efficient storage of the geo-locations of features along a track, as well as the direct reconstitution of accurate three-dimensional track splines.