Sha256: 927b4b29aaee26ea7a9951ca31c6eccbe1673d8b5093fd7769d210c9a97fc456
Contents?: true
Size: 1.12 KB
Versions: 13
Compression:
Stored size: 1.12 KB
Contents
EgridRegion.class_eval do
data_miner do
schema Earth.database_options do
string 'name'
float 'loss_factor'
end
import "eGRID regions and loss factors derived from eGRID 2007 data",
:url => 'http://www.epa.gov/cleanenergy/documents/egridzips/eGRID2007_Version1-1.zip',
:filename => 'eGRID2007_Version1-1/eGRID2007V1_1_year0504_STIE_USGC.xls',
:sheet => 'STIE05',
:skip => 4,
:select => lambda { |row| row['eGRID2007 2005 file State sequence number'].to_i.between?(1, 51) } do
key 'name', :field_name => 'Grid region (E=Eastern grid, W=Western grid, AK=Alaska, HI=Hawaii, TX=Texas)'
store 'loss_factor', :field_name => '2005 grid gross loss factor'
end
verify "Loss factor should be greater than zero and less than one" do
EgridRegion.all.each do |region|
unless region.loss_factor > 0 and region.loss_factor < 1
raise "Invalid loss factor for EgridRegion #{region.name}: #{region.loss_factor} (should be > 0 and < 1)"
end
end
end
# FIXME TODO verify fallback loss factor
end
end
Version data entries
13 entries across 13 versions & 1 rubygems