I am trying to grab time series data from a database storing data on a propritary format. When i chose a resolution which is not a multiple of the power of two of the sampling resolution i get these weird staircase, quantised artifacts. Does any one know why this might be?

Resolution used to generate this signal is <span class=$6$ times the sampling resolution"> Resolution used to generate this signal is <span class=$4 (2^2)$ times the sampling resolution">

  • $\begingroup$ What is the database? The steps are plain simple nearest neighbour interpolation. $\endgroup$
    – A_A
    Oct 15, 2019 at 9:22
  • $\begingroup$ It is the elspec pqscada, and it is stored in on the PQZIP format. OK, but how does this relate to the change in the resolution? Even 16 times the sample resolution gives a smooth curve. Do you know the theory behind this. Or is it just that simple. Thanks for the reply :) $\endgroup$
    – Kristian
    Oct 15, 2019 at 9:32
  • $\begingroup$ So, you don't have access to the raw data from which the database provider is giving you resampled signals? (I think we both agree this looks like a bug, and if you're paying for database access, you should raise that with them) $\endgroup$ Oct 15, 2019 at 11:34
  • $\begingroup$ Yep, that's correct. It definetly do. However, I'm not in that possition, so i'll just leave it with that haha. Thanks for bothering :) $\endgroup$
    – Kristian
    Oct 16, 2019 at 13:50


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.