lib/earth/industry/mecs_energy/data_miner.rb in earth-1.1.2 vs lib/earth/industry/mecs_energy/data_miner.rb in earth-1.2.1

- old
+ new

@@ -26,10 +26,11 @@ }) data_miner do MecsEnergy::CENSUS_REGIONS.each do |region, data| import("MECS table 3.2 #{region}", - :url => "http://www.eia.gov/emeu/mecs/mecs2006/excel/Table3_2.xls", + # @seamusabshere note 2010 is available + :url => "http://www.eia.gov/consumption/manufacturing/data/2006/xls/Table3_2.xls", :crop => data[:crop], :headers => ["NAICS Code", "Subsector and Industry", "Total", "BLANK", "Net Electricity", "BLANK", "Residual Fuel Oil", "Distillate Fuel Oil", "Natural Gas", "BLANK", "LPG and NGL", "BLANK", "Coal", "Coke and Breeze", "Other"]) do key :name, :synthesize => proc { |row| "#{Industry.format_naics_code(row['NAICS Code'])}-#{data[:code]}" } store :census_region_number, :static => data[:code] store :naics_code, :field_name => 'NAICS Code'