Loading...

Gas quality for MR stations Data

Total number of rows: 2,653,132


2020-06-01 10:00Z 2020-06-01 12:00 Viborg 40.5411 11.2614 53.4279 14.8411 0.7444 None
2020-06-01 10:00Z 2020-06-01 12:00 Varde 44.9823 12.4951 55.2391 15.3442 0.8573 None
2020-06-01 10:00Z 2020-06-01 12:00 Vallensbæk 40.5493 11.2637 53.4291 14.8414 0.7447 None
2020-06-01 10:00Z 2020-06-01 12:00 Ullerslev 40.5091 11.2525 53.3933 14.8315 0.7442 None
2020-06-01 10:00Z 2020-06-01 12:00 Torslunde 40.5135 11.2538 53.4009 14.8336 0.7442 None
2020-06-01 10:00Z 2020-06-01 12:00 Terkelsbøl 40.5364 11.2601 53.4212 14.8392 0.7445 None
2020-06-01 10:00Z 2020-06-01 12:00 Taulov 40.5112 11.2531 53.4007 14.8335 0.7441 None
2020-06-01 10:00Z 2020-06-01 12:00 Stenlille 43.0893 11.9693 54.5639 15.1566 0.8063 None
2020-06-01 10:00Z 2020-06-01 12:00 St. Andst 40.4429 11.2341 53.4029 14.8341 0.7434 None
2020-06-01 10:00Z 2020-06-01 12:00 Sorø 40.5160 11.2544 53.4043 14.8345 0.7442 None
2020-06-01 10:00Z 2020-06-01 12:00 Slagelse 40.5409 11.2614 53.4293 14.8415 0.7444 None
2020-06-01 10:00Z 2020-06-01 12:00 Skærbækværket 40.7138 11.3094 53.4959 14.8600 0.7489 None
2020-06-01 10:00Z 2020-06-01 12:00 Ringsted 40.5136 11.2538 53.3996 14.8332 0.7442 None
2020-06-01 10:00Z 2020-06-01 12:00 Pottehuse 40.5208 11.2558 53.4272 14.8409 0.7437 None
2020-06-01 10:00Z 2020-06-01 12:00 Nybro 45.1194 12.5332 55.3159 15.3655 0.8602 None
2020-06-01 10:00Z 2020-06-01 12:00 Nyborg 40.5445 11.2624 53.4231 14.8398 0.7447 None
2020-06-01 10:00Z 2020-06-01 12:00 Nørskov 40.5239 11.2566 53.4073 14.8354 0.7444 None
2020-06-01 10:00Z 2020-06-01 12:00 Middelfart 40.5127 11.2535 53.4003 14.8334 0.7441 None
2020-06-01 10:00Z 2020-06-01 12:00 Måløv 40.5132 11.2537 53.4063 14.8351 0.7440 None
2020-06-01 10:00Z 2020-06-01 12:00 Lynge 40.5409 11.2614 53.4254 14.8404 0.7445 None
2020-06-01 10:00Z 2020-06-01 12:00 Ll. Selskær 40.5173 11.2548 53.4149 14.8375 0.7439 None
2020-06-01 10:00Z 2020-06-01 12:00 Lille Torup 40.5416 11.2616 53.4257 14.8405 0.7445 None
2020-06-01 10:00Z 2020-06-01 12:00 Lilballe 40.8659 11.3516 53.5782 14.8828 0.7521 None
2020-06-01 10:00Z 2020-06-01 12:00 Køge 40.5447 11.2624 53.4279 14.8411 0.7446 None
2020-06-01 10:00Z 2020-06-01 12:00 Koelbjerg 40.5446 11.2624 53.4231 14.8398 0.7447 None
2020-06-01 10:00Z 2020-06-01 12:00 Karup 40.5224 11.2562 53.4130 14.8369 0.7442 None
2020-06-01 10:00Z 2020-06-01 12:00 Karlslunde 40.5162 11.2545 53.4030 14.8342 0.7442 None
2020-06-01 10:00Z 2020-06-01 12:00 Højby 40.5524 11.2646 53.4329 14.8425 0.7447 None
2020-06-01 10:00Z 2020-06-01 12:00 Herning 40.5128 11.2536 53.4003 14.8334 0.7442 None
2020-06-01 10:00Z 2020-06-01 12:00 Haverslev 40.5433 11.2620 53.4283 14.8412 0.7445 None
2020-06-01 10:00Z 2020-06-01 12:00 Frøslev 40.5391 11.2609 53.4228 14.8397 0.7445 None
2020-06-01 10:00Z 2020-06-01 12:00 Ellidshøj 40.5416 11.2616 53.4273 14.8409 0.7445 None
2020-06-01 10:00Z 2020-06-01 12:00 Egtved 41.4369 11.5102 53.7871 14.9409 0.7673 None
2020-06-01 10:00Z 2020-06-01 12:00 Dragør 40.5286 11.2579 53.4197 14.8388 0.7442 None
2020-06-01 10:00Z 2020-06-01 12:00 Brøndby 40.5356 11.2599 53.4242 14.8401 0.7443 None
2020-06-01 10:00Z 2020-06-01 12:00 Brande 40.5074 11.2521 53.3978 14.8327 0.7440 None
2020-06-01 10:00Z 2020-06-01 12:00 Billesbølle 40.5440 11.2622 53.4230 14.8397 0.7447 None
2020-06-01 10:00Z 2020-06-01 12:00 Bevtoft MR 39.4427 10.9563 52.7353 14.6487 None None
2020-06-01 10:00Z 2020-06-01 12:00 Avedøre II 40.5410 11.2614 53.4290 14.8414 0.7444 None
2020-06-01 10:00Z 2020-06-01 12:00 Amager Fælled 40.5403 11.2612 53.4254 14.8404 0.7445 None
2020-06-01 10:00Z 2020-06-01 12:00 Aalborg 40.5482 11.2634 53.4296 14.8416 0.7446 None
2020-06-01 09:00Z 2020-06-01 11:00 Viborg 40.5415 11.2615 53.4279 14.8411 0.7444 None
2020-06-01 09:00Z 2020-06-01 11:00 Varde 45.0167 12.5046 55.2576 15.3493 0.8581 None
2020-06-01 09:00Z 2020-06-01 11:00 Vallensbæk 40.5493 11.2637 53.4291 14.8414 0.7447 None
2020-06-01 09:00Z 2020-06-01 11:00 Ullerslev 40.5419 11.2616 53.4215 14.8393 0.7446 None
2020-06-01 09:00Z 2020-06-01 11:00 Torslunde 40.5131 11.2536 53.3990 14.8331 0.7442 None
2020-06-01 09:00Z 2020-06-01 11:00 Terkelsbøl 40.5382 11.2606 53.4196 14.8388 0.7446 None
2020-06-01 09:00Z 2020-06-01 11:00 Taulov 40.5113 11.2531 53.4008 14.8336 0.7441 None
2020-06-01 09:00Z 2020-06-01 11:00 Stenlille 43.0893 11.9693 54.5639 15.1566 0.8063 None
2020-06-01 09:00Z 2020-06-01 11:00 St. Andst 40.4429 11.2341 53.4029 14.8341 0.7434 None

Data Dictionary

Column Type Label Description
HourUTC timestamptz
HourDK timestamp
MRStation text
GrossCalorificValue-MJ_per_Nm3 float8
GrossCalorificValue-kWh_per_Nm3 float8
WobbeIndex-MJ_per_Nm3 float8
WobbeIndex-kWh_per_Nm3 float8
NormalDensity float8
MethaneNumber float8

Hour UTC

Name Hour UTC
Description

A date and time (interval), shown in UTC time zone, where the values are valid. 00:00 o\u2019clock is the first hour of a given day interval 00:00 - 00:59 and 01:00 covers the second hour (interval) of the day and so forth. Please note: The naming is based on the length of the interval of the finest grain of the resolution.

Comment

Please note that the format shown in the example applies to data download as JSON, XML or fetched through the API and is in accordance with the ISO 8601 standard. The format is slightly different when it is shown on screen or downloaded manually as CSV or XLSX. This is mainly due to readability and consideration for Excel users.

In preview (in the GUI) all timestamps are shown as (display convention) YYYY-MM-DD hh:mmZ e.g. 2017-07-14 08:00Z. The Z will remind viewers that this is UTC.

In download (CSV and XLSX) the date time are exported as YYYY-MM-DD hh:mm e.g. 2017-07-14 08:00. That is without the \u201cT\u201d and the \u201cZ\u201d and the seconds. Excel will recognize it as date-time. The user must remember the convention about time zones.

In download (JSON and XML) the full format is used YYYY-MM-DDThh:mmZ e.g. 2017-07-14T08:00Z.

Example 2017-07-14T08:00Z
Unit
Field HourUTC
Property Constraint
Type datetime
Size 17
Format Regex
Validation Rules Always full hours, i.e. minutes are 00

Hour DK

Name Hour DK
Description

A date and time (interval), shown in Danish time zone, where the values are valid. 00:00 o\u2019clock is the first hour of a given day, interval 00:00 - 00:59, and 01:00 covers the second hour period (interval) of the day and so forth.

Comment

On one normal day there will be 24 intervals.

When daylight saving times shifts there will be either 23 or 25 intervals.

Please note that the format shown in the example applies to data download as JSON, XML or fetched through the API and is in accordance with the ISO 8601 standard. The format is slightly different when it is shown on screen or downloaded manually as CSV or XLSX. This is mainly due to readability and consideration for Excel users.

In preview (in the GUI) all timestamps are shown as (display convention) YYYY-MM-DD hh:mm e.g. 2017-07-14 08:00. Please note that is no time zone indicator, showning that this is local (Danish) time.

In download (CSV and XLSX) the date time are exported as YYYY-MM-DD hh:mm e.g. 2017-07-14 08:00. That is without the \u201cT\u201d and the seconds. Excel will recognize it as date-time. The user must remember that this is local (Danish) time.

In download (JSON and XML) the format used is YYYY-MM-DDThh:mm e.g. 2017-07-14T08:00.

Example 2017-07-14T08:00
Unit
Field HourDK
Property Constraint
Type datetime
Size 17
Format Regex
Validation Rules Always full hours, i.e. minutes are 00

MR Station

Name MR Station
Description

Meter and regulator stations that deliver gas from transmission to distribution grids.

Comment
Example Herning or Torslunde
Unit
Field MRStation
Property Constraint
Type string
Size 30
Format Regex
Validation Rules

Gross Calorific Value

Name Gross Calorific Value
Description

A term describing the amount of heat developed by combustion of one cubic metre of gas at constant pressure when the gas and air for the combustion have a temperature of 25\u00b0C, the combustion products being brought to that temperature and the water formed by the combustion being present in liquid state. The reference conditions for normal cubic metres are 0\u00b0C and 1 atm.

Comment
Example 43.8149
Unit MJ/Nm\u00b3
Field GrossCalorificValue-MJ_per_Nm3
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [35:55]

Gross Calorific Value

Name Gross Calorific Value
Description

A term describing the amount of heat developed by combustion of one cubic metre of gas at constant pressure when the gas and air for the combustion have a temperature of 25\u00b0C, the combustion products being brought to that temperature and the water formed by the combustion being present in liquid state. The reference conditions for normal cubic metres are 0\u00b0C and 1 atm.

Comment
Example 12.1708
Unit kWh/Nm\u00b3
Field GrossCalorificValue-kWh_per_Nm3
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [9.7;15.3]

Wobbe Index

Name Wobbe Index
Description

The Wobbe index offers information about the heating effect a burner is exposed to during combustion of a fuel. The greater the Wobbe index, the greater the heating effect and thereby the greater the load on the burner. The load on a burner is thus directly proportional to the Wobbe index. Different gases with the same Wobbe index will impose the same load on the burner.

Comment
Example 54.8543
Unit MJ/Nm\u00b3
Field WobbeIndex-MJ_per_Nm3
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [45;60]

Wobbe Index

Name Wobbe Index
Description

The Wobbe index offers information about the heating effect a burner is exposed to during combustion of a fuel. The greater the Wobbe index, the greater the heating effect and thereby the greater the load on the burner. The load on a burner is thus directly proportional to the Wobbe index. Different gases with the same Wobbe index will impose the same load on the burner.

Comment
Example 15.2373
Unit kWh/Nm\u00b3
Field WobbeIndex-kWh_per_Nm3
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [12.5;16.7]

Normal Density

Name Normal Density
Description

Normal density is the mass of a normal cubic meter of gas. The reference conditions for normal cubic metres are 0\u00b0C and 1 atm.

Comment
Example 0.8241
Unit kg/Nm\u00b3
Field NormalDensity
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [0.5;1]

Methane Number

Name Methane Number
Description

A methane number characterises the gas's knock tendency as a fuel for gas engines. It can be compared to the octane number for petrol.

Comment

Per definition pure methane has a methane number of 100 and pure hydrogen a methane number of 0. A content of higher hydrocarbons than methane reduces the methane number while the CO2 content increases the methane number.

Currently not available

Example 71
Unit Number
Field MethaneNumber
Property Constraint
Type number
Size 3.1
Format Regex
Validation Rules [50;120]