/**
*
* @author gordon
*/
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/

package demonormalize;

import java.io.*;

import org.apache.hadoop.io.*;
import org.apache.hadoop.util.*;

/**
*
* @author appadmin
*/
public class ZipCensus implements Writable {

   public String zipcode;
   public String state;
   public int population;
   public int housingunits;
   public long landareameters;
   public long waterareameters;
   public double landareamiles;
   public double waterareamiles;
   public double latitude;
   public double longitude;
   public int numstates;
   public String state1;
   public String state2;
   public String state3;
   public int partpop1;
   public int partpop2;
   public int partpop3;
   public int pop;
   public int popedu;
   public int hh;
   public int fam;
   public int hhunits;
   public int hhuoccupied;
   public double purban;
   public double pinurbanarea;
   public double pinurbancluster;
   public double prural;
   public double pruralfarm;
   public double pruralnonfarm;
   public double pracewhite;
   public double praceblack;
   public double praceamerind;
   public double praceasian;
   public double pracepacind;
   public double praceother;
   public double pracemulti;
   public double hhperson1;
   public double hhperson1m;
   public double hhperson1f;
   public double hhperson2pl;
   public double hhperson2family;
   public double hhperson2married;
   public double hhperson2marriedkids;
   public double hhperson2marriedonly;
   public double hhperson2other;
   public double hhperson2m;
   public double hhperson2mkids;
   public double hhperson2mnokids;
   public double hhperson2f;
   public double hhperson2fkids;
   public double hhperson2fnokids;
   public double hhperson2nonfamily;
   public double hhperson2mnonfamily;
   public double hhperson2fnonfamily;
   public double popedunone;
   public double popedunohs;
   public double popedusomehs;
   public double popeduhsgrad;
   public double popedusomecol;
   public double popeduassoc;
   public double popedubach;
   public double popedumast;
   public double popeduprofdoct;
   public double hhmedincome;
   public double hhssincome;
   public double hhnossincome;
   public double hhpubassist;
   public double hhnopubassist;
   public double faminc000_010;
   public double faminc010_015;
   public double faminc015_020;
   public double faminc020_025;
   public double faminc025_030;
   public double faminc030_035;
   public double faminc035_040;
   public double faminc040_045;
   public double faminc045_050;
   public double faminc050_060;
   public double faminc060_075;
   public double faminc075_100;
   public double faminc100_125;
   public double faminc125_150;
   public double faminc150_200;
   public double faminc200;
   public double fammedincome;
   public double hhuowner;
   public double hhuorenter;
   public double hhuo1per;
   public double hhuo2per;
   public double hhuo3per;
   public double hhuo4per;
   public double hhuo5per;
   public double hhuo6per;
   public double hhuo7per;
   public double hhumedianyear;
   public double hhuofuelutilgas;
   public double hhuofuelbotgas;
   public double hhuofuelelec;
   public double hhuofueloil;
   public double hhuofuelcoal;
   public double hhuofuelwood;
   public double hhuofuelsolar;
   public double hhuofuelother;
   public double hhuofuelnone;
   public double hhuoplumbingcomplete;
   public double hhuoplumbinglacking;
   public double hhumediancashrent;
   public double hhunmarried;
   public double hhunmarriedmm;
   public double hhunmarriedmf;
   public double hhunmarriedff;
   public double hhunmarriedfm;
   public double hhother;

   public ZipCensus () {
       zipcode = new String("");
       state = new String("");
       population = 0;
       housingunits = 0;
       landareameters = 0L;
       waterareameters = 0L;
       landareamiles = 0.0;
       waterareamiles = 0.0;
       latitude = 0.0;
       longitude = 0.0;
       numstates = 0;
       state1 = new String("");
       state2 = new String("");
       state3 = new String("");
       partpop1 = 0;
       partpop2 = 0;
       partpop3 = 0;
       pop = 0;
       popedu = 0;
       hh = 0;
       fam = 0;
       hhunits = 0;
       hhuoccupied = 0;
       purban = 0.0;
       pinurbanarea = 0.0;
       pinurbancluster = 0.0;
       prural = 0.0;
       pruralfarm = 0.0;
       pruralnonfarm = 0.0;
       pracewhite = 0.0;
       praceblack = 0.0;
       praceamerind = 0.0;
       praceasian = 0.0;
       pracepacind = 0.0;
       praceother = 0.0;
       pracemulti = 0.0;
       hhperson1 = 0.0;
       hhperson1m = 0.0;
       hhperson1f = 0.0;
       hhperson2pl = 0.0;
       hhperson2family = 0.0;
       hhperson2married = 0.0;
       hhperson2marriedkids = 0.0;
       hhperson2marriedonly = 0.0;
       hhperson2other = 0.0;
       hhperson2m = 0.0;
       hhperson2mkids = 0.0;
       hhperson2mnokids = 0.0;
       hhperson2f = 0.0;
       hhperson2fkids = 0.0;
       hhperson2fnokids = 0.0;
       hhperson2nonfamily = 0.0;
       hhperson2mnonfamily = 0.0;
       hhperson2fnonfamily = 0.0;
       popedunone = 0.0;
       popedunohs = 0.0;
       popedusomehs = 0.0;
       popeduhsgrad = 0.0;
       popedusomecol = 0.0;
       popeduassoc = 0.0;
       popedubach = 0.0;
       popedumast = 0.0;
       popeduprofdoct = 0.0;
       hhmedincome = 0.0;
       hhssincome = 0.0;
       hhnossincome = 0.0;
       hhpubassist = 0.0;
       hhnopubassist = 0.0;
       faminc000_010 = 0.0;
       faminc010_015 = 0.0;
       faminc015_020 = 0.0;
       faminc020_025 = 0.0;
       faminc025_030 = 0.0;
       faminc030_035 = 0.0;
       faminc035_040 = 0.0;
       faminc040_045 = 0.0;
       faminc045_050 = 0.0;
       faminc050_060 = 0.0;
       faminc060_075 = 0.0;
       faminc075_100 = 0.0;
       faminc100_125 = 0.0;
       faminc125_150 = 0.0;
       faminc150_200 = 0.0;
       faminc200 = 0.0;
       fammedincome = 0.0;
       hhuowner = 0.0;
       hhuorenter = 0.0;
       hhuo1per = 0.0;
       hhuo2per = 0.0;
       hhuo3per = 0.0;
       hhuo4per = 0.0;
       hhuo5per = 0.0;
       hhuo6per = 0.0;
       hhuo7per = 0.0;
       hhumedianyear = 0.0;
       hhuofuelutilgas = 0.0;
       hhuofuelbotgas = 0.0;
       hhuofuelelec = 0.0;
       hhuofueloil = 0.0;
       hhuofuelcoal = 0.0;
       hhuofuelwood = 0.0;
       hhuofuelsolar = 0.0;
       hhuofuelother = 0.0;
       hhuofuelnone = 0.0;
       hhuoplumbingcomplete = 0.0;
       hhuoplumbinglacking = 0.0;
       hhumediancashrent = 0.0;
       hhunmarried = 0.0;
       hhunmarriedmm = 0.0;
       hhunmarriedmf = 0.0;
       hhunmarriedff = 0.0;
       hhunmarriedfm = 0.0;
       hhother = 0.0;
   }  // ZipCensus()

   public void write(DataOutput out) throws IOException {
       out.writeUTF(zipcode);
       out.writeUTF(state);
       out.writeInt(population);
       out.writeInt(housingunits);
       out.writeLong(landareameters);
       out.writeLong(waterareameters);
       out.writeDouble(landareamiles);
       out.writeDouble(waterareamiles);
       out.writeDouble(latitude);
       out.writeDouble(longitude);
       out.writeInt(numstates);
       out.writeUTF(state1);
       out.writeUTF(state2);
       out.writeUTF(state3);
       out.writeInt(partpop1);
       out.writeInt(partpop2);
       out.writeInt(partpop3);
       out.writeInt(pop);
       out.writeInt(popedu);
       out.writeInt(hh);
       out.writeInt(fam);
       out.writeInt(hhunits);
       out.writeInt(hhuoccupied);
       out.writeDouble(purban);
       out.writeDouble(pinurbanarea);
       out.writeDouble(pinurbancluster);
       out.writeDouble(prural);
       out.writeDouble(pruralfarm);
       out.writeDouble(pruralnonfarm);
       out.writeDouble(pracewhite);
       out.writeDouble(praceblack);
       out.writeDouble(praceamerind);
       out.writeDouble(praceasian);
       out.writeDouble(pracepacind);
       out.writeDouble(praceother);
       out.writeDouble(pracemulti);
       out.writeDouble(hhperson1);
       out.writeDouble(hhperson1m);
       out.writeDouble(hhperson1f);
       out.writeDouble(hhperson2pl);
       out.writeDouble(hhperson2family);
       out.writeDouble(hhperson2married);
       out.writeDouble(hhperson2marriedkids);
       out.writeDouble(hhperson2marriedonly);
       out.writeDouble(hhperson2other);
       out.writeDouble(hhperson2m);
       out.writeDouble(hhperson2mkids);
       out.writeDouble(hhperson2mnokids);
       out.writeDouble(hhperson2f);
       out.writeDouble(hhperson2fkids);
       out.writeDouble(hhperson2fnokids);
       out.writeDouble(hhperson2nonfamily);
       out.writeDouble(hhperson2mnonfamily);
       out.writeDouble(hhperson2fnonfamily);
       out.writeDouble(popedunone);
       out.writeDouble(popedunohs);
       out.writeDouble(popedusomehs);
       out.writeDouble(popeduhsgrad);
       out.writeDouble(popedusomecol);
       out.writeDouble(popeduassoc);
       out.writeDouble(popedubach);
       out.writeDouble(popedumast);
       out.writeDouble(popeduprofdoct);
       out.writeDouble(hhmedincome);
       out.writeDouble(hhssincome);
       out.writeDouble(hhnossincome);
       out.writeDouble(hhpubassist);
       out.writeDouble(hhnopubassist);
       out.writeDouble(faminc000_010);
       out.writeDouble(faminc010_015);
       out.writeDouble(faminc015_020);
       out.writeDouble(faminc020_025);
       out.writeDouble(faminc025_030);
       out.writeDouble(faminc030_035);
       out.writeDouble(faminc035_040);
       out.writeDouble(faminc040_045);
       out.writeDouble(faminc045_050);
       out.writeDouble(faminc050_060);
       out.writeDouble(faminc060_075);
       out.writeDouble(faminc075_100);
       out.writeDouble(faminc100_125);
       out.writeDouble(faminc125_150);
       out.writeDouble(faminc150_200);
       out.writeDouble(faminc200);
       out.writeDouble(fammedincome);
       out.writeDouble(hhuowner);
       out.writeDouble(hhuorenter);
       out.writeDouble(hhuo1per);
       out.writeDouble(hhuo2per);
       out.writeDouble(hhuo3per);
       out.writeDouble(hhuo4per);
       out.writeDouble(hhuo5per);
       out.writeDouble(hhuo6per);
       out.writeDouble(hhuo7per);
       out.writeDouble(hhumedianyear);
       out.writeDouble(hhuofuelutilgas);
       out.writeDouble(hhuofuelbotgas);
       out.writeDouble(hhuofuelelec);
       out.writeDouble(hhuofueloil);
       out.writeDouble(hhuofuelcoal);
       out.writeDouble(hhuofuelwood);
       out.writeDouble(hhuofuelsolar);
       out.writeDouble(hhuofuelother);
       out.writeDouble(hhuofuelnone);
       out.writeDouble(hhuoplumbingcomplete);
       out.writeDouble(hhuoplumbinglacking);
       out.writeDouble(hhumediancashrent);
       out.writeDouble(hhunmarried);
       out.writeDouble(hhunmarriedmm);
       out.writeDouble(hhunmarriedmf);
       out.writeDouble(hhunmarriedff);
       out.writeDouble(hhunmarriedfm);
       out.writeDouble(hhother);
   }  // write()

   public void readFields(DataInput in) throws IOException {
       zipcode = in.readUTF();
       state = in.readUTF();
       population = in.readInt();
       housingunits = in.readInt();
       landareameters = in.readLong();
       waterareameters = in.readLong();
       landareamiles = in.readDouble();
       waterareamiles = in.readDouble();
       latitude = in.readDouble();
       longitude = in.readDouble();
       numstates = in.readInt();
       state1 = in.readUTF();
       state2 = in.readUTF();
       state3 = in.readUTF();
       partpop1 = in.readInt();
       partpop2 = in.readInt();
       partpop3 = in.readInt();
       pop = in.readInt();
       popedu = in.readInt();
       hh = in.readInt();
       fam = in.readInt();
       hhunits = in.readInt();
       hhuoccupied = in.readInt();
       purban = in.readDouble();
       pinurbanarea = in.readDouble();
       pinurbancluster = in.readDouble();
       prural = in.readDouble();
       pruralfarm = in.readDouble();
       pruralnonfarm = in.readDouble();
       pracewhite = in.readDouble();
       praceblack = in.readDouble();
       praceamerind = in.readDouble();
       praceasian = in.readDouble();
       pracepacind = in.readDouble();
       praceother = in.readDouble();
       pracemulti = in.readDouble();
       hhperson1 = in.readDouble();
       hhperson1m = in.readDouble();
       hhperson1f = in.readDouble();
       hhperson2pl = in.readDouble();
       hhperson2family = in.readDouble();
       hhperson2married = in.readDouble();
       hhperson2marriedkids = in.readDouble();
       hhperson2marriedonly = in.readDouble();
       hhperson2other = in.readDouble();
       hhperson2m = in.readDouble();
       hhperson2mkids = in.readDouble();
       hhperson2mnokids = in.readDouble();
       hhperson2f = in.readDouble();
       hhperson2fkids = in.readDouble();
       hhperson2fnokids = in.readDouble();
       hhperson2nonfamily = in.readDouble();
       hhperson2mnonfamily = in.readDouble();
       hhperson2fnonfamily = in.readDouble();
       popedunone = in.readDouble();
       popedunohs = in.readDouble();
       popedusomehs = in.readDouble();
       popeduhsgrad = in.readDouble();
       popedusomecol = in.readDouble();
       popeduassoc = in.readDouble();
       popedubach = in.readDouble();
       popedumast = in.readDouble();
       popeduprofdoct = in.readDouble();
       hhmedincome = in.readDouble();
       hhssincome = in.readDouble();
       hhnossincome = in.readDouble();
       hhpubassist = in.readDouble();
       hhnopubassist = in.readDouble();
       faminc000_010 = in.readDouble();
       faminc010_015 = in.readDouble();
       faminc015_020 = in.readDouble();
       faminc020_025 = in.readDouble();
       faminc025_030 = in.readDouble();
       faminc030_035 = in.readDouble();
       faminc035_040 = in.readDouble();
       faminc040_045 = in.readDouble();
       faminc045_050 = in.readDouble();
       faminc050_060 = in.readDouble();
       faminc060_075 = in.readDouble();
       faminc075_100 = in.readDouble();
       faminc100_125 = in.readDouble();
       faminc125_150 = in.readDouble();
       faminc150_200 = in.readDouble();
       faminc200 = in.readDouble();
       fammedincome = in.readDouble();
       hhuowner = in.readDouble();
       hhuorenter = in.readDouble();
       hhuo1per = in.readDouble();
       hhuo2per = in.readDouble();
       hhuo3per = in.readDouble();
       hhuo4per = in.readDouble();
       hhuo5per = in.readDouble();
       hhuo6per = in.readDouble();
       hhuo7per = in.readDouble();
       hhumedianyear = in.readDouble();
       hhuofuelutilgas = in.readDouble();
       hhuofuelbotgas = in.readDouble();
       hhuofuelelec = in.readDouble();
       hhuofueloil = in.readDouble();
       hhuofuelcoal = in.readDouble();
       hhuofuelwood = in.readDouble();
       hhuofuelsolar = in.readDouble();
       hhuofuelother = in.readDouble();
       hhuofuelnone = in.readDouble();
       hhuoplumbingcomplete = in.readDouble();
       hhuoplumbinglacking = in.readDouble();
       hhumediancashrent = in.readDouble();
       hhunmarried = in.readDouble();
       hhunmarriedmm = in.readDouble();
       hhunmarriedmf = in.readDouble();
       hhunmarriedff = in.readDouble();
       hhunmarriedfm = in.readDouble();
       hhother = in.readDouble();
   }  // readFields()

   @Override public String toString() {
       return (this.zipcode + "," +
               this.state + "," +
               Integer.toString(this.population) + "," +
               Integer.toString(this.housingunits) + "," +
               Long.toString(this.landareameters) + "," +
               Long.toString(this.waterareameters) + "," +
               Double.toString(this.landareamiles) + "," +
               Double.toString(this.waterareamiles) + "," +
               Double.toString(this.latitude) + "," +
               Double.toString(this.longitude) + "," +
               Integer.toString(this.numstates) + "," +
               this.state1 + "," +
               this.state2 + "," +
               this.state3 + "," +
               Integer.toString(this.partpop1) + "," +
               Integer.toString(this.partpop2) + "," +
               Integer.toString(this.partpop3) + "," +
               Integer.toString(this.pop) + "," +
               Integer.toString(this.popedu) + "," +
               Integer.toString(this.hh) + "," +
               Integer.toString(this.fam) + "," +
               Integer.toString(this.hhunits) + "," +
               Integer.toString(this.hhuoccupied) + "," +
               Double.toString(this.purban) + "," +
               Double.toString(this.pinurbanarea) + "," +
               Double.toString(this.pinurbancluster) + "," +
               Double.toString(this.prural) + "," +
               Double.toString(this.pruralfarm) + "," +
               Double.toString(this.pruralnonfarm) + "," +
               Double.toString(this.pracewhite) + "," +
               Double.toString(this.praceblack) + "," +
               Double.toString(this.praceamerind) + "," +
               Double.toString(this.praceasian) + "," +
               Double.toString(this.pracepacind) + "," +
               Double.toString(this.praceother) + "," +
               Double.toString(this.pracemulti) + "," +
               Double.toString(this.hhperson1) + "," +
               Double.toString(this.hhperson1m) + "," +
               Double.toString(this.hhperson1f) + "," +
               Double.toString(this.hhperson2pl) + "," +
               Double.toString(this.hhperson2family) + "," +
               Double.toString(this.hhperson2married) + "," +
               Double.toString(this.hhperson2marriedkids) + "," +
               Double.toString(this.hhperson2marriedonly) + "," +
               Double.toString(this.hhperson2other) + "," +
               Double.toString(this.hhperson2m) + "," +
               Double.toString(this.hhperson2mkids) + "," +
               Double.toString(this.hhperson2mnokids) + "," +
               Double.toString(this.hhperson2f) + "," +
               Double.toString(this.hhperson2fkids) + "," +
               Double.toString(this.hhperson2fnokids) + "," +
               Double.toString(this.hhperson2nonfamily) + "," +
               Double.toString(this.hhperson2mnonfamily) + "," +
               Double.toString(this.hhperson2fnonfamily) + "," +
               Double.toString(this.popedunone) + "," +
               Double.toString(this.popedunohs) + "," +
               Double.toString(this.popedusomehs) + "," +
               Double.toString(this.popeduhsgrad) + "," +
               Double.toString(this.popedusomecol) + "," +
               Double.toString(this.popeduassoc) + "," +
               Double.toString(this.popedubach) + "," +
               Double.toString(this.popedumast) + "," +
               Double.toString(this.popeduprofdoct) + "," +
               Double.toString(this.hhmedincome) + "," +
               Double.toString(this.hhssincome) + "," +
               Double.toString(this.hhnossincome) + "," +
               Double.toString(this.hhpubassist) + "," +
               Double.toString(this.hhnopubassist) + "," +
               Double.toString(this.faminc000_010) + "," +
               Double.toString(this.faminc010_015) + "," +
               Double.toString(this.faminc015_020) + "," +
               Double.toString(this.faminc020_025) + "," +
               Double.toString(this.faminc025_030) + "," +
               Double.toString(this.faminc030_035) + "," +
               Double.toString(this.faminc035_040) + "," +
               Double.toString(this.faminc040_045) + "," +
               Double.toString(this.faminc045_050) + "," +
               Double.toString(this.faminc050_060) + "," +
               Double.toString(this.faminc060_075) + "," +
               Double.toString(this.faminc075_100) + "," +
               Double.toString(this.faminc100_125) + "," +
               Double.toString(this.faminc125_150) + "," +
               Double.toString(this.faminc150_200) + "," +
               Double.toString(this.faminc200) + "," +
               Double.toString(this.fammedincome) + "," +
               Double.toString(this.hhuowner) + "," +
               Double.toString(this.hhuorenter) + "," +
               Double.toString(this.hhuo1per) + "," +
               Double.toString(this.hhuo2per) + "," +
               Double.toString(this.hhuo3per) + "," +
               Double.toString(this.hhuo4per) + "," +
               Double.toString(this.hhuo5per) + "," +
               Double.toString(this.hhuo6per) + "," +
               Double.toString(this.hhuo7per) + "," +
               Double.toString(this.hhumedianyear) + "," +
               Double.toString(this.hhuofuelutilgas) + "," +
               Double.toString(this.hhuofuelbotgas) + "," +
               Double.toString(this.hhuofuelelec) + "," +
               Double.toString(this.hhuofueloil) + "," +
               Double.toString(this.hhuofuelcoal) + "," +
               Double.toString(this.hhuofuelwood) + "," +
               Double.toString(this.hhuofuelsolar) + "," +
               Double.toString(this.hhuofuelother) + "," +
               Double.toString(this.hhuofuelnone) + "," +
               Double.toString(this.hhuoplumbingcomplete) + "," +
               Double.toString(this.hhuoplumbinglacking) + "," +
               Double.toString(this.hhumediancashrent) + "," +
               Double.toString(this.hhunmarried) + "," +
               Double.toString(this.hhunmarriedmm) + "," +
               Double.toString(this.hhunmarriedmf) + "," +
               Double.toString(this.hhunmarriedff) + "," +
               Double.toString(this.hhunmarriedfm) + "," +
               Double.toString(this.hhother));
   }  // toString()
}  // class ZipCensus