Data improvement system and method

• US 9,418,099 B2
• Filed: 04/06/2015
• Issued: 08/16/2016
• Est. Priority Date: 01/07/2011
• Status: Active Grant

• Current Assignee: Wabtec Corporation (Westinghouse Air Brake Technologies Corporation)
• Original Assignee: Wabtec Corporation (Westinghouse Air Brake Technologies Corporation)
• Inventors: Wilson, M. Frank, Olson, Lee A., Schouten, Matthew
• Primary Examiner(s): Elchanti, Hussein A.
• Application Number:
  US14/679,861
• Publication Number:
  US 20150213080A1
• Time in Patent Office: 498 Days
• Field of Search: 701/19
• US Class Current: 1/1
• CPC Class Codes: B61L 15/0072 On-board train data handling
• CPC Class Codes: B61L 23/00 Control, warning or like safety means along the route or between vehicles or trains
• CPC Class Codes: B61L 27/57 for vehicles or trains, e.g. trackside supervision of train conditions
• CPC Class Codes: G06F 16/122 using management policies backup systems G06F11/1446; file migration policies for HSM systems G06F16/185
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/24573 using data annotations, e.g. user-defined metadata
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06F 16/951 Indexing; Web crawling techniques

Abstract

A data improvement system, including an initial database, a verification database, and a processing device in communication with the initial database and the verification database. The processing device receives data from the initial database and the verification database, and determines verification data based thereon. A track data improvement system and a track database improvement system are also disclosed.

Claims

1. A track database data improvement system, comprising:

a source database comprising a plurality of data fields representing source data, which includes at least one of the following;

track data, identification data, location data, position data, heading data, curvature data, type data, grade data, coordinate data, cross track error data, centerline data, positioning system data, geographic information system data, survey data, log data, dynamic data, batch data, or any combination thereof; and

a processing device in communication with the source database and programmed or configured to;

determine initial track data for a specified segment of track based at least in part upon the source data, the segment having end points;

determine error data based upon the initial track data and a straight line between the end points, and create intermediate segments as defined as a straight line between intermediate end points;

determine trimming data for at least two of the intermediate end points, thereby defining trimmed track segments; and

provide at least a portion of the trimming data to a track database;

wherein the trimming data includes at least one of the following;

first end point data, second end point data, coordinate data, heading data, grade data, linear distance data, track type data, or any combination thereof.

2. The system of claim 1, wherein at least a portion of trimming data from the track database is transmitted to at least one of the following:

a train, a central control system, a central track database, or any combination thereof.

3. The system of claim 1, wherein the processing device is further configured to format or arrange the trimming data in the track database, thereby providing formatted data.

4. The system of claim 1, wherein at least a portion of the initial track data comprises a plurality of coordinates, each defining at least one point, and the heading of the track at the at least one point.

5. The system of claim 4, wherein the processing device is further programmed or configured to, based at least partially on the plurality of coordinates, determine a set of heading points for a segment of track.

6. The system of claim 5, wherein the set of heading points comprises a heading point at the beginning of the segment of track and a heading point at the end of the segment of track.

7. The system of claim 5, wherein the processing device is further programmed or configured to, based at least partially on the set of heading points, determine whether the set of heading points is within a specified error margin.

8. The system of claim 7, wherein the processing device is further programmed or configured to create at least one additional heading point if the set of heading points is outside the specified error margin.

9. The system of claim 8, wherein the processing device is further programmed or configured to create the at least one additional heading point at a point that is the furthest outside the specified error margin.

10. The system of claim 9, wherein the processing device is further programmed or configured to repeat the creation step until all of the heading points in the set of heading points are within the specified error margin.

11. The system of claim 5, wherein the processing device is further programmed or configured to separate the track into a plurality of track segments, comprising at least one of the following:

a tangent segment, a curve segment, a spiral segment, a straight segment, or any combination thereof.

12. The system of claim 11, wherein the trimming data comprises at least one end point of at least one of the following:

a tangent segment, a curve segment, a spiral segment, a straight segment, or any combination thereof.

13. The system of claim 1, wherein at least a portion of the initial track data comprises a plurality of coordinates, each defining at least one point, and the grade of the track at the at least one point.

14. The system of claim 13, wherein the processing device is further programmed or configured to, based at least partially on the plurality of coordinates, determine a set of grade points for a segment of track.

15. The system of claim 14, wherein the set of grade points comprises a grade point at the beginning of the segment of track and a grade point at the end of the segment of track.

16. The system of claim 14, wherein the processing device is further programmed or configured to, based at least partially on the set of grade points, determine whether the set of grade points is within a specified error margin.

17. The system of claim 16, wherein the processing device is further programmed or configured to create at least one additional grade point if the set of grade points is outside the specified error margin.

18. The system of claim 17, wherein the processing device is further programmed or configured to create the at least one additional grade point at a point that is the furthest outside the specified error margin.

19. The system of claim 18, wherein the processing device is further programmed or configured to repeat the creation step until all of the grade points in the set of grade points are within the specified error margin.

20. The system of claim 14, wherein the processing device is further programmed or configured to separate the track into a plurality of track segments, comprising at least one of the following:

a constant grade, an elevation point, an elevation area, or any combination thereof.

21. The system of claim 20, wherein the trimming data comprises elevation data associated with at least one end point of a specified track segment.

22. A computer-implemented track data improvement method, comprising:

on at least one computer in communication with at least one source database comprising a plurality of data fields representing source data, which includes at least one of the following;

track data, identification data, location data, position data, heading data, curvature data, type data, grade data, coordinate data, cross track error data, centerline data, positioning system data, geographic information system data, survey data, log data, dynamic data, batch data, or any combination thereof;

determining initial track data for a specified segment of track based at least in part upon the source data, the segment having end points;

determining error data based upon the initial track data and a straight line between the end points, and create intermediate segments as defined as a straight line between intermediate end points;

determining trimming data for at least two of the intermediate end points, thereby defining trimmed track segments; and

providing at least a portion of the trimming data to a track database, wherein the trimming data includes at least one of the following;

first end point data, second end point data, coordinate data, heading data, grade data, linear distance data, track type data, or any combination thereof.