Dataset: Average Rainfall And Temperature

Metadata for the Average Rainfall and Temperature dataset. This file contains Metadata (information about a dataset). It shows the schema for dataset fields and their contents. This file should be used along with the dataset, to aid correct interpretation of the data.

dataset_id_dsid Dataset ID (DSID)	dataset_name Dataset Name	field Field	type Type	mandatory_or_optional_requirement_mor Mandatory Or Optional Requirement (MOR)	field_description Field Description	schema Schema	schema_data_rules_comment Schema Data Rules Comment	formatreference FormatReference	example Example
62	RainfallTemp	OrganisationName	String	Optional	Name of the organisation that is the asset owner and if not the owner the main user of the asset.	LGA	Name of the Organisation's area coverage		Lincolnshire
62	RainfallTemp	OrganisationCode	String	Optional	A unique code to identify the asset owning/using organisation. For LAs this can be the URI from Open Data Communities.	LGA	URI weblink for the Organisation	http://opendatacommunities.org/def/concept/folders/themes/geography	Lincolnshire County Council: http://opendatacommunities.org/doc/geography/administration/cty/E10000019
62	RainfallTemp	PublishedDate	DateTime	Optional	Date at which the information provided is true. This field contains the publication date.	LGA	Include this field to show the publication date of the dataset (ie. the date on which the dataset's information is true).	https://www.w3.org/TR/NOTE-datetime	YYYY-MM-DDThh:mm:ss eg: 2017-02-15T00:00:00
62	RainfallTemp	DurationFrom	DateTime	Optional	Dataset time period start, or start of accounting/reporting period. DurationFrom will always include a Time of 00:00:00.	LGA	Dataset time period start, or start of accounting/reporting period. DurationFrom will always include a Time of 00:00:00.	http://calendars.wikia.com/wiki/ISO_8601	YYYY-MM-DDThh:mm:ss eg: 2017-04-01T00:00:00
62	RainfallTemp	DurationTo	DateTime	Optional	Dataset time period end, or end of accounting/reporting period. DurationTo will always include a Time of 23:59:59	LGA	Dataset time period end, or end of accounting/reporting period. DurationTo will always include a Time of 23:59:59	http://calendars.wikia.com/wiki/ISO_8601	YYYY-MM-DDThh:mm:ss eg: 2017-06-30T23:59:59
62	RainfallTemp	LatestData	Boolean	Mandatory	TRUE where the data is the latest for the indicator. Else blank	LCC
62	RainfallTemp	GeoName	String	Mandatory	The name of the geographic area covered by the data	LCC	GeoName is unique to Met Office		England E & NE
62	RainfallTemp	ReportingPeriodType	String	Mandatory	The type of time period the data record covers (eg. Financial Year, Calendar Year, Month, Quarter)	LCC	The type of time period the data record covers (eg. Financial Year, Calendar Year, Month, Quarter)		eg. Financial Year, Calendar Year, Month, Quarter
62	RainfallTemp	Year	Number	Mandatory	Calendar Year in which the data record occurred	LCC	This data runs through a calendar year by month		2010
62	RainfallTemp	Period	String	Mandatory	Time period for the data record (Month, meteorological Season, or Annual)	LCC	Period to which the data pertains		Jan, Fab, Aut

dataset_id_dsid

Dataset ID (DSID)

dataset_name

Dataset Name

field

Field

type

Type

mandatory_or_optional_requirement_mor

Mandatory Or Optional Requirement (MOR)

field_description

Field Description

schema

Schema

lcc_mapping

LCC Mapping

schema_comments

Schema Comments

schema_data_rules_comment

Schema Data Rules Comment

formatreference

FormatReference

example

Example

RainfallTemp

OrganisationName

String

Optional

Name of the organisation that is the asset owner and if not the owner the main user of the asset.

LGA

Name of the Organisation's area coverage

Lincolnshire

RainfallTemp

OrganisationCode

String

Optional

A unique code to identify the asset owning/using organisation. For LAs this can be the URI from Open Data Communities.

LGA

URI weblink for the Organisation

http://opendatacommunities.org/def/concept/folders/themes/geography

Lincolnshire County Council: http://opendatacommunities.org/doc/geography/administration/cty/E10000019

RainfallTemp

PublishedDate

DateTime

Optional

Date at which the information provided is true. This field contains the publication date.

LGA

Include this field to show the publication date of the dataset (ie. the date on which the dataset's information is true).

https://www.w3.org/TR/NOTE-datetime

YYYY-MM-DDThh:mm:ss eg: 2017-02-15T00:00:00

RainfallTemp

DurationFrom

DateTime

Optional

Dataset time period start, or start of accounting/reporting period. DurationFrom will always include a Time of 00:00:00.

LGA

Dataset time period start, or start of accounting/reporting period. DurationFrom will always include a Time of 00:00:00.

http://calendars.wikia.com/wiki/ISO_8601

YYYY-MM-DDThh:mm:ss eg: 2017-04-01T00:00:00

RainfallTemp

DurationTo

DateTime

Optional

Dataset time period end, or end of accounting/reporting period. DurationTo will always include a Time of 23:59:59

LGA

Dataset time period end, or end of accounting/reporting period. DurationTo will always include a Time of 23:59:59

http://calendars.wikia.com/wiki/ISO_8601

YYYY-MM-DDThh:mm:ss eg: 2017-06-30T23:59:59

RainfallTemp

LatestData

Boolean

Mandatory

TRUE where the data is the latest for the indicator. Else blank

LCC

RainfallTemp

GeoName

String

Mandatory

The name of the geographic area covered by the data

LCC

GeoName is unique to Met Office

England E & NE

RainfallTemp

ReportingPeriodType

String

Mandatory

The type of time period the data record covers (eg. Financial Year, Calendar Year, Month, Quarter)

LCC

The type of time period the data record covers (eg. Financial Year, Calendar Year, Month, Quarter)

eg. Financial Year, Calendar Year, Month, Quarter

RainfallTemp

Year

Number

Mandatory

Calendar Year in which the data record occurred

LCC

This data runs through a calendar year by month

2010

RainfallTemp

Period

String

Mandatory

Time period for the data record (Month, meteorological Season, or Annual)

LCC

Period to which the data pertains

Jan, Fab, Aut

CREATE TABLE table_2 ( "dataset_id_dsid" BIGINT, "dataset_name" VARCHAR, "field" VARCHAR, "type" VARCHAR, "mandatory_or_optional_requirement_mor" VARCHAR, "field_description" VARCHAR, "schema" VARCHAR, "lcc_mapping" VARCHAR, "schema_comments" VARCHAR, "schema_data_rules_comment" VARCHAR, "formatreference" VARCHAR, "example" VARCHAR );

Average Rainfall And Temperature

Table List

Table 2

@ukgov.average_rainfall_temperature.table_2

dataset_id_dsid

dataset_name

field

type

mandatory_or_optional_requirement_mor

field_description

schema

lcc_mapping

schema_comments

schema_data_rules_comment

formatreference

example

Share link