Class: Naics2002Sic1987Concordance

Inherits:
ActiveRecord::Base
  • Object
show all
Extended by:
Earth::Model
Defined in:
lib/earth/industry/naics_2002_sic_1987_concordance.rb

Constant Summary collapse

TABLE_STRUCTURE =
<<-EOS

CREATE TABLE naics2002_sic1987_concordances
  (
     row_hash        CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     naics_2002_code CHARACTER VARYING(255),
     sic_1987_code   CHARACTER VARYING(255),
     sic_note        CHARACTER VARYING(255)
  );

EOS

Class Method Summary collapse

Methods included from Earth::Model

extend_mining, extended, registry

Class Method Details

.extract_note(description) ⇒ Object

for data import



27
28
29
# File 'lib/earth/industry/naics_2002_sic_1987_concordance.rb', line 27

def self.extract_note(description)
  (note = description.match /.+?\((.+)\)/) ? note.captures.first : nil
end