Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support multiple climatological normal periods #229

Open
rod-glover opened this issue Jan 14, 2025 · 1 comment · May be fixed by #231
Open

Support multiple climatological normal periods #229

rod-glover opened this issue Jan 14, 2025 · 1 comment · May be fixed by #231

Comments

@rod-glover
Copy link
Contributor

rod-glover commented Jan 14, 2025

For a statement of the motivation and requirements for this feature, see Confluence document Multiple climatological normal periods on the PCDS - Conceptual work plan. Summary:

  • The last time that PCIC produced a set of 30-year climatologies (the 1971-2000 period) for PCDS station observations was 2012. At that time, the PCDS data portal was still in its infancy and there was no need to differentiate between various 30 year normal periods, because there was only one set of climate normals available.
  • In order to make climatologies available via the PCDS data portal on short notice, all of the climatologies were added the to PCDS database, differentiated by only by using specially named variables, but intermixed with the "raw" recorded meteorological observations.
  • With the advent of two new normal periods (1981-2010 and 1991-2020) and the associated sets of climatologies, it is required that the climatologies be properly separated from the raw observations and be tracked and attributed according to their climatological period.
  • It is also required to improve the PCDS portal to make all climatology periods available and allow interested parties to select between them.
  • Additionally, it is common practice, when creating climatologies to utilize information from multiple neighboring stations within a small area if available and pulling their records together to create a single "composite station".

Data modelling for this feature is found in Data model(s) for multiple climatological normal periods. This data modelling is now in a state suitable for an initial implementation and testing. In summary, it adds the following tables to the CRMP database:

  • Climatological Station
  • Climatological Station Histories (association table for Histories that contribute to the Climatological Station)
  • Climatological Variable
  • Climatological Value

There are some outstanding questions about this design, but none that prevent work from going forward on it.

@rod-glover
Copy link
Contributor Author

Also of possible note: #99 . I am not clear whether that is a separate concern or is more or less about this feature.

@rod-glover rod-glover linked a pull request Jan 16, 2025 that will close this issue
1 task
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant