Diference between at the corner and in the corner

In the corner of is used when referring to a concept of closed space.
At the corner of and on the corner of are used to indicate an open space, say street or park.

Examples:
The tree is at the corner of the street.
The tree is in the corner of the street.