encrypting emid
added coalesce function and lat_long