Data types
You are encouraged to upload data in accordance with SG-DRM data standards.
Column headers
Only alphanumeric or these 3 special characters: .-_
Ampersand (&) should be replaced by βandβ if needed
Each must be unique
You should not have two headers called "duration"
All headers are in lower case
e.g. "rating"
If a header contains more than one word, use underscores to combine them
e.g. vehicle_type
Units of measurement should be omitted
Keep it to less than 25 characters
Full names can be stored in the schema section of the metadata file
For date variables:
Interval | Column name | Format | Range of values | Example |
---|---|---|---|---|
Annual |
| YYYY | YYYY: 1900 onwards | 2015 |
Monthly |
| YYYY-MM | MM: 01 to 12 | 2015-01 |
Daily |
| YYYY-MM-DD | DD: 01 to 31 | 2015-01-01 |
Weekly |
| YYYY-[W]WW | [W]WW: W01 to W52 | 2015-W01 |
Quarterly |
| YYYY-[Q]Q | [Q]Q: Q1 to Q4 | 2015-Q1 |
Half-yearly |
| YYYY-[H]H | [H]H: H1 or H2 | 2015-H1 |
For date-time variables:
Type | Column name | Format | Example |
---|---|---|---|
Date + time |
| YYYY-MM-DD[T]hh:mm hh:mm+hh:mm or hh:mm:ss+hh:mm | 2015-01-01T12:00 |
or YYYY-MM-DD[T]hh:mm:ss | 2015-01-01T12:00:00 | ||
Time only |
| hh:mm | 12:00 |
or hh:mm:ss | 12:00:00 |
Get in touch
Our guidelines are always up for review to give our users the best experience possible. Have more feedback or questions? Contact us and we will reach out to you as soon as we can.
Last updated