lib/earth/industry/mecs_energy/data_miner.rb in earth-0.11.20 vs lib/earth/industry/mecs_energy/data_miner.rb in earth-0.12.0
- old
+ new
@@ -26,10 +26,10 @@
})
data_miner do
MecsEnergy::CENSUS_REGIONS.each do |region, data|
import("MECS table 3.2 #{region}",
- :url => "http://205.254.135.24/emeu/mecs/mecs2006/excel/Table3_2.xls",
+ :url => "http://www.eia.gov/emeu/mecs/mecs2006/excel/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'