Tweetmap is not a separate product it is a demonstraton of a custom application built using MapD components.
It uses MapD Core, MapD Charting and MapD Connection components.
It is currently being tidied up and modified so we can share it as a more complex open sources example. This should be complete in the next month. Once that is completed you would be able to run that code locally.