Search
  1. Home
  2. United States Feeds
  3. columbia-county-public-transit
  4. Source Data Validation Report

columbia-county-public-transit — Source Data Validation Report

This report was generated by the Canonical GTFS Schedule validator, version 7.1.0 at 2026-04-24T12:03:34Z,
for the dataset file:///shared/columbia-county-public-transit_69fbde62.zip. No country code was provided.

Use this report alongside our documentation.

Summary

Agencies included

Feed Info

Publisher Name:
Columbia County Public Transportation
Feed Email:
N/A
Feed Language:
English
Feed Start Date:
2025-12-17
Feed End Date:
2026-12-17

Files included

  1. agency.txt
  2. calendar.txt
  3. feed_info.txt
  4. routes.txt
  5. shapes.txt
  6. stop_times.txt
  7. stops.txt
  8. trips.txt

Counts

  • Agencies: 2
  • Blocks: 0
  • Routes: 5
  • Shapes: 37
  • Stops: 83
  • Trips: 48

Specification Compliance report

369 notices reported (0 errors, 366 warnings, 3 infos)

Notice Code Severity Total
fast_travel_between_consecutive_stops WARNING 7

fast_travel_between_consecutive_stops

A transit vehicle moves too fast between two consecutive stops.

The speed threshold depends on route type:

Route type Description Threshold, km/h
0 Light rail 100
1 Subway 150
2 Rail 500
3 Bus 150
4 Ferry 80
5 Cable tram 30
6 Aerial lift 50
7 Funicular 50
11 Trolleybus 150
12 Monorail 150
- Unknown 200

You can see more about this notice here.

tripCsvRowNumber (?) The row number of the problematic trip. tripId (?) `trip_id` of the problematic trip. routeId (?) `route_id` of the problematic trip. speedKph (?) Travel speed (km/h). distanceKm (?) Distance between stops (km). csvRowNumber1 (?) The row number of the first stop time. stopSequence1 (?) `stop_sequence` of the first stop. stopId1 (?) `stop_id` of the first stop. stopName1 (?) `stop_name` of the first stop. departureTime1 (?) `departure_time` of the first stop. csvRowNumber2 (?) The row number of the second stop time. stopSequence2 (?) `stop_sequence` of the second stop. stopId2 (?) `stop_id` of the second stop. stopName2 (?) `stop_name` of the second stop. arrivalTime2 (?) `arrival_time` of the second stop.
2 "95e6f865-de08-4059-a288-6801c2501d04" "eznr" 332.8669486227523 5.547782477045871 17 15 "CBR03" "Whittier Trailer Park" "10:50:00" 18 16 "CBT03" "Greenport Manor" "10:50:00"
3 "275ff9d1-6cdd-4e77-8ffe-22ec71bf4822" "eznr" 260.64176153469117 4.34402935891152 24 4 "SS02" "Providence Hall" "10:30:00" 25 5 "CBM10" "Walmart Supercenter" "10:30:00"
3 "275ff9d1-6cdd-4e77-8ffe-22ec71bf4822" "eznr" 708.0920270841235 11.801533784735392 27 7 "HAB03a" "Stottville" "12:00:00" 28 8 "5big" "Stuyvesant NY-9J" "12:00:00"
3 "275ff9d1-6cdd-4e77-8ffe-22ec71bf4822" "eznr" 1174.1189913570847 19.56864985595141 29 9 "CBM10" "Walmart Supercenter" "12:45:00" 30 10 "CBT02" "Palatine Manor" "12:45:00"
7 "4bd9d321-b2e8-4b73-bcbb-bcfe729706ef" "eznr" 1795.5987986481225 29.926646644135374 68 5 "CBM06" "ShopRite" "13:15:00" 69 6 "CBW02" "Ancramdale" "13:15:00"
7 "4bd9d321-b2e8-4b73-bcbb-bcfe729706ef" "eznr" 603.9298482257984 10.065497470429975 69 6 "CBW02" "Ancramdale" "13:15:00" 70 7 "CBW04" "Copake" "13:15:00"
7 "4bd9d321-b2e8-4b73-bcbb-bcfe729706ef" "eznr" 497.8971288806658 8.29828548134443 70 7 "CBW04" "Copake" "13:15:00" 71 8 "CBW05" "Farm Road" "13:15:00"
fast_travel_between_far_stops WARNING 2

fast_travel_between_far_stops

A transit vehicle moves too fast between two far stops.

Two stops are considered "far" if they are more than 10 km apart. This normally indicates a more serious problem than too fast travel between consecutive stops.

The speed threshold depends on route type and are the same as fast_travel_between_consecutive_stops.

You can see more about this notice here.

tripCsvRowNumber (?) The row number of the problematic trip. tripId (?) `trip_id` of the problematic trip. routeId (?) `route_id` of the problematic trip. speedKph (?) Travel speed (km/h). distanceKm (?) Distance between stops (km). csvRowNumber1 (?) The row number of the first stop time. stopSequence1 (?) `stop_sequence` of the first stop. stopId1 (?) `stop_id` of the first stop. stopName1 (?) `stop_name` of the first stop. departureTime1 (?) `departure_time` of the first stop. csvRowNumber2 (?) The row number of the second stop time. stopSequence2 (?) `stop_sequence` of the second stop. stopId2 (?) `stop_id` of the second stop. stopName2 (?) `stop_name` of the second stop. arrivalTime2 (?) `arrival_time` of the second stop.
3 "275ff9d1-6cdd-4e77-8ffe-22ec71bf4822" "eznr" 708.0920270841235 11.801533784735392 27 7 "HAB03a" "Stottville" "12:00:00" 28 8 "5big" "Stuyvesant NY-9J" "12:00:00"
7 "4bd9d321-b2e8-4b73-bcbb-bcfe729706ef" "eznr" 1795.5987986481225 29.926646644135374 68 5 "CBM06" "ShopRite" "13:15:00" 69 6 "CBW02" "Ancramdale" "13:15:00"
missing_feed_contact_email_and_url WARNING 1

missing_feed_contact_email_and_url

Best Practices for feed_info.txt suggest providing at least one of feed_contact_email and feed_contact_url.

You can see more about this notice here.

csvRowNumber (?) The row number of the validated record.
2
missing_recommended_field WARNING 1

missing_recommended_field

A recommended field is missing.

The given field has no value in some input row, even though values are recommended.

You can see more about this notice here.

filename (?) The name of the faulty file. csvRowNumber (?) The row of the faulty record. fieldName (?) The name of the missing field.
"feed_info.txt" 2 "feed_version"
missing_timepoint_value WARNING 325

missing_timepoint_value

stop_times.timepoint value is missing for a record.

When at least one of stop_times.arrival_time or stop_times.departure_time are provided, stop_times.timepoint should be defined

You can see more about this notice here.

Only the first 50 of 325 affected records are displayed below.

csvRowNumber (?) The row number of the faulty record. tripId (?) The faulty record's `stop_times.trip_id`. stopSequence (?) The faulty record's `stop_times.stop_sequence`.
84 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 0
85 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 1
86 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 2
87 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 3
88 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 4
89 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 5
90 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 6
91 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 7
92 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 8
93 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 9
94 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 10
95 "ed3c4901-9992-402d-881e-c0d97e9e1de0" 11
96 "f88bc440-4a0a-453a-9166-542fad679f47" 0
97 "f88bc440-4a0a-453a-9166-542fad679f47" 1
98 "f88bc440-4a0a-453a-9166-542fad679f47" 2
99 "f88bc440-4a0a-453a-9166-542fad679f47" 3
100 "f88bc440-4a0a-453a-9166-542fad679f47" 4
101 "f88bc440-4a0a-453a-9166-542fad679f47" 5
102 "f88bc440-4a0a-453a-9166-542fad679f47" 6
103 "f88bc440-4a0a-453a-9166-542fad679f47" 7
104 "f88bc440-4a0a-453a-9166-542fad679f47" 8
105 "f88bc440-4a0a-453a-9166-542fad679f47" 9
106 "f88bc440-4a0a-453a-9166-542fad679f47" 10
107 "f88bc440-4a0a-453a-9166-542fad679f47" 11
108 "CC-COMM-ABOUT-WD-01" 0
109 "CC-COMM-ABOUT-WD-01" 1
110 "CC-COMM-ABOUT-WD-01" 2
111 "CC-COMM-ABOUT-WD-01" 3
112 "CC-COMM-ABOUT-WD-01" 4
113 "CC-COMM-ABOUT-WD-01" 5
114 "CC-COMM-ABOUT-WD-01" 6
115 "CC-COMM-ABOUT-WD-01" 7
116 "CC-COMM-ABOUT-WD-01" 8
117 "CC-COMM-ABOUT-WD-01" 9
118 "CC-COMM-ABOUT-WD-01" 10
119 "CC-COMM-ABOUT-WD-01" 11
120 "75217690-f23c-400e-b2e5-8140fa19b49d" 0
121 "75217690-f23c-400e-b2e5-8140fa19b49d" 1
122 "75217690-f23c-400e-b2e5-8140fa19b49d" 2
123 "75217690-f23c-400e-b2e5-8140fa19b49d" 3
124 "75217690-f23c-400e-b2e5-8140fa19b49d" 4
125 "75217690-f23c-400e-b2e5-8140fa19b49d" 5
126 "75217690-f23c-400e-b2e5-8140fa19b49d" 6
127 "75217690-f23c-400e-b2e5-8140fa19b49d" 7
128 "75217690-f23c-400e-b2e5-8140fa19b49d" 8
129 "75217690-f23c-400e-b2e5-8140fa19b49d" 9
130 "edddbbb8-11c5-4802-a930-4c168265b71b" 0
131 "edddbbb8-11c5-4802-a930-4c168265b71b" 1
132 "edddbbb8-11c5-4802-a930-4c168265b71b" 2
133 "edddbbb8-11c5-4802-a930-4c168265b71b" 3
route_long_name_contains_short_name WARNING 2

route_long_name_contains_short_name

Long name should not contain short name for a single route.

In routes.txt, route_long_name should not contain the value for route_short_name, because when both are provided, they are often combined by transit applications. Note that only one of the two fields is required. If there is no short name used for a route, use route_long_name only.

Good examples:

route_short_name/route_long_name Dataset
"N"/"Judah" Muni San Fransisco
"6"/"ML King Jr Blvd" Trimet Portland Streetcar
"55"/"Boulevard Saint Laurent" STM Montreal
"1"/"Rangiora/Cashmere" Metro Christchurch

Bad examples:

route_short_name/route_long_name
"604"/"604"
"14"/"Route 14"
"2"/"Route 2: Bellows Falls In-Town"

You can see more about this notice here.

routeId (?) The id of the faulty record. csvRowNumber (?) The row number of the faulty record. routeShortName (?) The faulty record's `route_short_name`. routeLongName (?) The faulty record's `route_long_name`.
"eznr" 4 "County" "County Bus"
"1uvt" 6 "Chatham-Hudson" "Chatham-Hudson Bus"
route_short_name_too_long WARNING 1

route_short_name_too_long

Short name of a route is too long (more than 12 characters).

You can see more about this notice here.

routeId (?) The id of the faulty record. csvRowNumber (?) The row number of the faulty record. routeShortName (?) The faulty record's `route_short_name`.
"1uvt" 6 "Chatham-Hudson"
stop_without_stop_time WARNING 24

stop_without_stop_time

A stop in stops.txt is not referenced by any stop_times.stop_id.

Such stops are not used by any trip and normally do not provide user value. This notice may indicate a typo in stop_times.txt.

You can see more about this notice here.

csvRowNumber (?) The row number of the faulty record. stopId (?) The id of the faulty stop. stopName (?) The name of the faulty stop.
9 "CBT04" "Germantown - Main St"
10 "CBT05" "Germantown - Young American Rd"
15 "HAB03b" "Stottville"
16 "HAB03c" "Stottville"
17 "HAB03d" "Stottville"
19 "HAB04b" "Columbiaville"
20 "HAB04c" "Columbiaville"
21 "HAB04d" "Columbiaville"
23 "HAB05b" "Kinderhook"
24 "HAB05c" "Kinderhook"
25 "HAB05d" "Kinderhook"
27 "HAB06a" "Valatie"
28 "HAB06b" "Valatie"
29 "HAB06c" "Valatie"
30 "HAB06d" "Valatie"
31 "HAB06e" "Valatie"
32 "HAB07a" "Schodack"
33 "HAB07b" "Schodack"
34 "HAB07c" "Schodack"
35 "HAB07d" "Schodack"
36 "HAB07e" "Schodack"
41 "CBT11" "Stuyvesant - DELETE St Rt 9J"
45 "CB00" "Garage"
74 "CBW06" "Plaza Diner"
trip_distance_exceeds_shape_distance_below_threshold WARNING 3

trip_distance_exceeds_shape_distance_below_threshold

The distance between the last shape point and last stop point is greater than 0 but less than the 11.1m threshold.

You can see more about this notice here.

tripId (?) The faulty record's trip id. shapeId (?) The faulty record's shape id. maxTripDistanceTraveled (?) The faulty record's trip max distance traveled. maxShapeDistanceTraveled (?) The faulty record's shape max distance traveled. geoDistanceToShape (?) The distance in meters between the shape and the stop.
"4bd9d321-b2e8-4b73-bcbb-bcfe729706ef" "sa80" 64633.67772962744 64613.48338173871 0.4120330363982542
"48aa0a91-a26b-4bac-af1e-22be8503cea1" "8vtl" 57247.16954053028 57229.28305630166 0.5533093580119063
"1db61f94-6911-4489-9d00-a248643e9024" "ivqn" 58218.47968597955 58200.289722579146 2.7124832604491025
unknown_column INFO 3

unknown_column

A column name is unknown.

You can see more about this notice here.

filename (?) The name of the faulty file. fieldName (?) The name of the unknown column. index (?) The index of the faulty column.
"agency.txt" "agency_branding_url" 7
"feed_info.txt" "feed_id" 2
"routes.txt" "route_branding_url" 8