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	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:

Type	Column name	Format	Example
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.