'where it's at' is a set expression that became widespread in the sixties of the 20th century. In an example like I don't know where it's at it means that the speaker does not understand the essential truth of the situation, so, as you see, there is no spacial implication. A sentence like I put my hat down and now I don't know where it's at is sur