Here it is in action:

Basically in TF2 and source games, the sprays (and by extension textures= have different mipmap levels that will display a higher/lower resolution image depending on how close or far away you are to said texture, but since you can modify what each mipmap looks like, you can pull off stuff like that.