It used to be called the "Wolf Whistle" and it was a way of some brassy men to let a woman know they think she's attractive. It's a compliment in a crude manner, but more often than not, women appreciate it.
I am 14 and do not like being whisled at by old creepy guys! Its just discusting! I hate it when guys whistle!