Add 2013 data to the NFIRS database.

[garnertb]

• [x] Append the 2013 incident data the the NFIRS database with data from 2002-2012.
• [x] Update the building fires table using this: https://github.com/FireCARES/data/blob/master/sources/nfirs/scripts/building_fires.sql.
• [x] Upload PostGRES dump of the entire NFIRS database to S3.

[garnertb]

@meilinger, I have a shapefile with the geometry for these records which I will send to you. Once you receive it, please up the geom field one the incidentaddress table with it.

[garnertb]

Load 2013 records for the NFIRS data base into the production NFIRS db.

QC

• [x] arson.txt
• [x] basicincident.txt
• [x] ems.txt
• [x] fireincident.txt
• [x] arsonagencyreferal.txt
• [x] incidentaddress.txt
• [x] arsonjuvsub.txt
• [x] civiliancasualty.txt
• [x] ffcasualty.txt
• [x] wildlands.txt
• [x] basicaid.txt
• [x] codelookup.txt

Issues

• [x] hazmobprop table has 23,710 records in 2013 hazmobprop.txt only has 11,856 lines (including the header).
• [x] hazchem table has 17,122 records in 2013 hazchem.txt only has 8,562 lines (including the header).
• [x] hazmat table has 23,710 records in 2013 hazmat.txt only has 11,856 lines (including the header).
• [x] ffequipfail has 766 records in 2013, ffequpfail.txt only has 384 lines (including the header).
• [x] hazmatequipinvolved has 23,710 in 2013 hazmatequipinvolved.txt has 11,856 lines (including the header).

Fixes

delete from hazmobprop where substring(inc_date, 6,1)='/' and right(inc_date, 4)='2013'; delete from hazmat where substring(inc_date, 6,1)='/' and right(inc_date, 4)='2013'; delete from hazchem where substring(inc_date, 6,1)='/' and right(inc_date, 4)='2013'; delete from ffequipfail where ctid not in (select min(ctid) from ffequipfail where right(inc_date, 4)='2013' group by state, fdid, inc_date, inc_no, exp_no, cas_seq_no, eqp_seq_no, version, equip_item, eqp_prob, eqp_man, eqp_mod, eqp_ser_no) and right(inc_date, 4)='2013'; delete from hazmatequipinvolved where substring(inc_date, 6,1)='/' and right(inc_date, 4)='2013';