Data Automobile activity year types

Automobile activity year type

Last imported 03:15AM UTC on Tuesday, March 26, 2013. See log

Automobiles by year of use and type (e.g. light-duty trucks driven in 2010).

We take annual HFC emissions for automobiles grouped by type from the U.S. EPA Greenhouse Gas Inventory. We then calculate HFC emissions per kilometre using annual distance traveled by each automobile type from our automobile activity year type fuel data.

Citing this data

To cite this data, reference Brighter Planet, "Automobile activity year types," <http://data.brighterplanet.com/automobile_activity_year_types>, retrieved 2013-05-22 01:16:43 UTC.

Download

Total: 30 records.

Random data sample

Sample: 5 records.

name activity year type name hfc emissions hfc emissions units hfc emission factor hfc emission factor units
1995 Light-duty trucks 1995 Light-duty trucks 31000000000.0 kilograms_co2e 0.0243829 kilograms_co2e_per_kilometre
1995 Passenger cars 1995 Passenger cars 28400000000.0 kilograms_co2e 0.0122693 kilograms_co2e_per_kilometre
1996 Light-duty trucks 1996 Light-duty trucks 31200000000.0 kilograms_co2e 0.0237438 kilograms_co2e_per_kilometre
1996 Passenger cars 1996 Passenger cars 27100000000.0 kilograms_co2e 0.011456 kilograms_co2e_per_kilometre
1997 Light-duty trucks 1997 Light-duty trucks 30100000000.0 kilograms_co2e 0.0219857 kilograms_co2e_per_kilometre

Import steps

Click a step for more detail.

  1. Import annual automobile air conditioning emissions derived from the 2010 EPA GHG Inventory

    1. Fetch data from .
    2. Store
      • name
      • activity_year
      • type_name
      • hfc_emissions
      .

  2. Ensure AutomobileActivityYearTypeFuel is populated

    AutomobileActivityYearTypeFuel.run_data_miner!

  3. Derive hfc emission factor from AutomobileActivityYearTypeFuel

    safe_find_each do |ayt|
  ayt.update_attributes!(:hfc_emission_factor => ((ayt.hfc_emissions / ayt.activity_year_type_fuels.sum(:distance))), :hfc_emission_factor_units => (((ayt.hfc_emissions_units + "_per_") + ayt.activity_year_type_fuels.first.distance_units.singularize)))
end

Table structure

CREATE TABLE automobile_activity_year_types
  (
     name                      CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     activity_year             INTEGER,
     type_name                 CHARACTER VARYING(255),
     hfc_emissions             FLOAT,
     hfc_emissions_units       CHARACTER VARYING(255),
     hfc_emission_factor       FLOAT,
     hfc_emission_factor_units CHARACTER VARYING(255)
  );