Changes

Jump to navigation Jump to search
119 bytes added ,  12:33, 8 August 2018
--5556
Since oldfirmcoords does not have state codes, we have to find a way to include state codes to add in companies based in Puerto Rico, Hawaii, and Alaska. I did this by matching the firmoldfilter table back to the firm base table. I used the coalesce function because we wanted to exclude companies that we had not geocoded due to faulty addresses.
DROP TABLE firmcoordsmatch1;
158

edits

Navigation menu