What is Foursquare?

The social networking service is suddenly everywhere — even “Gossip Girl.” What’s the big deal?