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'