Here is a picture from Flickr that shows who is taking pictures around New York City. The red represents pictures taken by tourists; the blue represents pictures taken by locals; and the yellow could be either tourists or locals.
A few things to note: tourists cram into Manhattan like cake into a fat guy, though living on the extreme west side of Midtown seems to be fairly cram-free. Probably because that's Daredevil's territory.
You'll note that Brooklyn is a pretty shade of blue, which is why I live there. If someone did this map for Honolulu, my old neighborhood would be red as the blood of my enemies. However, you'll note the large number of pictures taken in Williamsburg, and hipsters running around photographing brownstones isn't a hell of a lot better than tourists doing the same thing. The hipsters are just more smug about it.
In fact, most of the outer borough territory is blue, except for little dots around Flushing Meadow in Queens--site of the 1939 and 1964 Worlds Fairs--Yankee Stadium and Bronx Zoo in the Bronx, and the Brooklyn Bridge in Brooklyn.
All that yellow is New York Harbor, and before you go thinking that New Yorkers can walk on water, let me clarify that there are many companies doing water tours of the area, in addition to the various ferries that take you to Ellis Island, Governor's Island, Staten Island, and the Statue of Liberty.
If you visit the link for this nifty picture and hover your mouse over the image, you'll see place names and be better able to avoid tourist-congested areas the next time you visit New York. And, as a bonus, here is the link to a whole gallery of these images for cities like London, Tokyo, Taipei, and Sydney. Get choke pics! Check um out.
And don't think I forgot about you, Hawaii. Happy Kamehameha Day!