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:

IntervalColumn nameFormatRange of valuesExample

Annual

year

YYYY

YYYY: 1900 onwards

2015

Monthly

month

YYYY-MM

MM: 01 to 12

2015-01

Daily

date

YYYY-MM-DD

DD: 01 to 31

2015-01-01

Weekly

week

YYYY-[W]WW

[W]WW: W01 to W52

2015-W01

Quarterly

quarter

YYYY-[Q]Q

[Q]Q: Q1 to Q4

2015-Q1

Half-yearly

half_year

YYYY-[H]H

[H]H: H1 or H2

2015-H1

For date-time variables:

TypeColumn nameFormatExample

Date + time

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

time

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