Skip to content

Instantly share code, notes, and snippets.

@irees
Created March 14, 2017 00:29
Show Gist options
  • Save irees/b01137f18d9e64830f1b6e358b3c0f93 to your computer and use it in GitHub Desktop.
Save irees/b01137f18d9e64830f1b6e358b3c0f93 to your computer and use it in GitHub Desktop.
{
"agency.txt": {
"agency_name": {
"total": 1,
"unique": 1,
"min": "Caltrain",
"max": "Caltrain"
},
"agency_url": {
"total": 1,
"unique": 1,
"min": "http://www.caltrain.com",
"max": "http://www.caltrain.com"
},
"agency_timezone": {
"total": 1,
"unique": 1,
"min": "America/Los_Angeles",
"max": "America/Los_Angeles"
},
"agency_lang": {
"total": 1,
"unique": 1,
"min": "en",
"max": "en"
},
"agency_phone": {
"total": 1,
"unique": 1,
"min": "800-660-4287",
"max": "800-660-4287"
},
"agency_id": {
"total": 1,
"unique": 1,
"min": "caltrain-ca-us",
"max": "caltrain-ca-us"
}
},
"stops.txt": {
"stop_id": {
"total": 95,
"unique": 95,
"min": "70011",
"max": "ctta"
},
"stop_code": {
"total": 64,
"unique": 64,
"min": "70011",
"max": "777403"
},
"stop_name": {
"total": 95,
"unique": 61,
"min": "22nd St Caltrain",
"max": "Tamien Caltrain Station"
},
"stop_desc": {
"total": 0,
"unique": 0,
"min": null,
"max": null
},
"stop_lat": {
"total": 95,
"unique": 94,
"min": "37.003485",
"max": "37.776439"
},
"stop_lon": {
"total": 95,
"unique": 95,
"min": "-121.566088",
"max": "-122.412076"
},
"zone_id": {
"total": 62,
"unique": 6,
"min": "1",
"max": "6"
},
"stop_url": {
"total": 0,
"unique": 0,
"min": null,
"max": null
},
"location_type": {
"total": 95,
"unique": 2,
"min": "0",
"max": "1"
},
"parent_station": {
"total": 64,
"unique": 31,
"min": "ct22",
"max": "ctta"
},
"platform_code": {
"total": 64,
"unique": 2,
"min": "NB",
"max": "SB"
}
},
"routes.txt": {
"route_id": {
"total": 5,
"unique": 5,
"min": "Bu-121",
"max": "TaSj-121"
},
"route_short_name": {
"total": 1,
"unique": 1,
"min": "SX",
"max": "SX"
},
"route_long_name": {
"total": 5,
"unique": 5,
"min": "Bullet",
"max": "Tamien / San Jose Diridon Caltrain Shuttle"
},
"route_desc": {
"total": 0,
"unique": 0,
"min": null,
"max": null
},
"route_type": {
"total": 5,
"unique": 2,
"min": "2",
"max": "3"
},
"route_url": {
"total": 0,
"unique": 0,
"min": null,
"max": null
},
"route_color": {
"total": 2,
"unique": 2,
"min": "E31837",
"max": "FEF0B5"
}
},
"trips.txt": {
"route_id": {
"total": 678,
"unique": 5,
"min": "Bu-121",
"max": "TaSj-121"
},
"service_id": {
"total": 678,
"unique": 7,
"min": "CT-14OCT-Caltrain-Saturday-02",
"max": "ME01-Calshut-Sunday-50"
},
"trip_id": {
"total": 678,
"unique": 678,
"min": "6507678-CT-14OCT-Combo-Weekday-01",
"max": "8447963-ME01-Calshut-Sunday-50"
},
"trip_headsign": {
"total": 678,
"unique": 7,
"min": "Bayshore",
"max": "Tamien Caltrain Station"
},
"trip_short_name": {
"total": 678,
"unique": 491,
"min": "101",
"max": "804"
},
"direction_id": {
"total": 678,
"unique": 2,
"min": "0",
"max": "1"
},
"block_id": {
"total": 0,
"unique": 0,
"min": null,
"max": null
},
"shape_id": {
"total": 678,
"unique": 342,
"min": "SX0240",
"max": "cal_tam_sj"
}
},
"stop_times.txt": {
"trip_id": {
"total": 5339,
"unique": 678,
"min": "6507678-CT-14OCT-Combo-Weekday-01",
"max": "8447963-ME01-Calshut-Sunday-50"
},
"arrival_time": {
"total": 5339,
"unique": 1052,
"min": "04:30:00",
"max": "25:39:00"
},
"departure_time": {
"total": 5339,
"unique": 1052,
"min": "04:30:00",
"max": "25:39:00"
},
"stop_id": {
"total": 5339,
"unique": 64,
"min": "70011",
"max": "777403"
},
"stop_sequence": {
"total": 5339,
"unique": 29,
"min": "1",
"max": "9"
},
"pickup_type": {
"total": 5339,
"unique": 1,
"min": "0",
"max": "0"
},
"drop_off_type": {
"total": 5339,
"unique": 1,
"min": "0",
"max": "0"
}
},
"calendar.txt": {
"service_id": {
"total": 7,
"unique": 7,
"min": "CT-14OCT-Caltrain-Saturday-02",
"max": "ME01-Calshut-Sunday-50"
},
"monday": {
"total": 7,
"unique": 2,
"min": "0",
"max": "1"
},
"tuesday": {
"total": 7,
"unique": 2,
"min": "0",
"max": "1"
},
"wednesday": {
"total": 7,
"unique": 2,
"min": "0",
"max": "1"
},
"thursday": {
"total": 7,
"unique": 2,
"min": "0",
"max": "1"
},
"friday": {
"total": 7,
"unique": 2,
"min": "0",
"max": "1"
},
"saturday": {
"total": 7,
"unique": 2,
"min": "0",
"max": "1"
},
"sunday": {
"total": 7,
"unique": 2,
"min": "0",
"max": "1"
},
"start_date": {
"total": 7,
"unique": 5,
"min": "20150426",
"max": "20150607"
},
"end_date": {
"total": 7,
"unique": 5,
"min": "20150606",
"max": "20241005"
}
},
"calendar_dates.txt": {
"service_id": {
"total": 16,
"unique": 3,
"min": "CT-14OCT-Caltrain-Saturday-02",
"max": "CT-14OCT-Combo-Weekday-01"
},
"date": {
"total": 16,
"unique": 9,
"min": "20150525",
"max": "20160101"
},
"exception_type": {
"total": 16,
"unique": 2,
"min": "1",
"max": "2"
}
},
"shapes.txt": {
"shape_id": {
"total": 3796,
"unique": 342,
"min": "SX0240",
"max": "cal_tam_sj"
},
"shape_pt_lat": {
"total": 3796,
"unique": 888,
"min": "37.00351229798302",
"max": "37.776439059278346"
},
"shape_pt_lon": {
"total": 3796,
"unique": 878,
"min": "-121.56614542007446",
"max": "-122.4131441116333"
},
"shape_pt_sequence": {
"total": 3796,
"unique": 775,
"min": "1",
"max": "99"
},
"shape_dist_traveled": {
"total": 0,
"unique": 0,
"min": null,
"max": null
}
},
"fare_attributes.txt": {
"fare_id": {
"total": 7,
"unique": 7,
"min": "Free",
"max": "OW_6_20141005"
},
"price": {
"total": 7,
"unique": 7,
"min": "0",
"max": "9.25"
},
"currency_type": {
"total": 7,
"unique": 1,
"min": "USD",
"max": "USD"
},
"payment_method": {
"total": 7,
"unique": 1,
"min": "1",
"max": "1"
},
"transfers": {
"total": 7,
"unique": 1,
"min": "0",
"max": "0"
},
"transfer_duration": {
"total": 7,
"unique": 1,
"min": "0",
"max": "0"
}
},
"fare_rules.txt": {
"fare_id": {
"total": 109,
"unique": 7,
"min": "Free",
"max": "OW_6_20141005"
},
"route_id": {
"total": 109,
"unique": 4,
"min": "Bu-121",
"max": "SX-134"
},
"origin_id": {
"total": 109,
"unique": 6,
"min": "1",
"max": "6"
},
"destination_id": {
"total": 109,
"unique": 6,
"min": "1",
"max": "6"
}
},
"filenames": ["agency.txt", "calendar.txt", "calendar_dates.txt", "fare_attributes.txt", "fare_rules.txt", "routes.txt", "shapes.txt", "stop_times.txt", "stops.txt", "trips.txt"]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment