Data Rail fuels

Rail fuel

Last imported 10:05AM UTC on Tuesday, March 26, 2013. See log

Fuels used by rail transport (e.g. diesel).

Citing this data

To cite this data, reference Brighter Planet, "Rail fuels," <http://data.brighterplanet.com/rail_fuels>, retrieved 2013-05-26 05:04:55 UTC.

Download

Total: 1 records.

Random data sample

Sample: 1 records.

name fuel name ch4 emission factor ch4 emission factor units n2o emission factor n2o emission factor units
diesel Distillate Fuel Oil No. 2 0.00528625 kilograms_co2e_per_litre 0.0201639 kilograms_co2e_per_litre

Import steps

Click a step for more detail.

  1. Import Rail diesel CH4 and N2O emission factors from the EPA GHG Inventory

    1. Fetch data from docs.google.com.
    2. Store
      • name
      • fuel_name
      • ch4_emission_factor
      • n2o_emission_factor
      .

  2. Ensure Fuel and GreenhouseGas are populated

    Fuel.run_data_miner!
GreenhouseGas.run_data_miner!

  3. Convert ch4 and n2o emission factor units to kg co2e / l

    RailFuel.safe_find_each do |fuel|
  if (fuel.ch4_emission_factor_units == "grams_per_kilogram") and (fuel.density_units == "kilograms_per_litre") then
    fuel.ch4_emission_factor = (((GreenhouseGas["ch4"].global_warming_potential * fuel.density) * fuel.ch4_emission_factor) / 1000.0)
    fuel.ch4_emission_factor_units = "kilograms_co2e_per_litre"
    fuel.save!
  else
    raise("We don't know how to perform this unit conversion.")
  end
  if (fuel.n2o_emission_factor_units == "grams_per_kilogram") and (fuel.density_units == "kilograms_per_litre") then
    fuel.n2o_emission_factor = (((GreenhouseGas["n2o"].global_warming_potential * fuel.density) * fuel.n2o_emission_factor) / 1000.0)
    fuel.n2o_emission_factor_units = "kilograms_co2e_per_litre"
    fuel.save!
  else
    raise("We don't know how to perform this unit conversion.")
  end
end

Table structure

CREATE TABLE rail_fuels
  (
     name                      CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     fuel_name                 CHARACTER VARYING(255),
     ch4_emission_factor       FLOAT,
     ch4_emission_factor_units CHARACTER VARYING(255),
     n2o_emission_factor       FLOAT,
     n2o_emission_factor_units CHARACTER VARYING(255)
  );