What is the best locally sourced restaurant in Manhattan or Brooklyn?
I think the local thing is overplayed. Also quite often local is exaggerated and expands for 100's of miles. Sometimes they even lie. I've seen potato chips that say they use "long island potatoes" not true and not possible to use those all the time.
In any case, North End Grill has pea shoots growing right there in front of you on the counter, i guess that's as local as you can get.
I personally like my fish from Japan, my oysters from Nova Scotia, my truffles from Italy, my coffee from Colombia etc etc
I wont jump into the discussion about the locavore trend, but all of these places have some sort of locally sourced ingredients thing going on, do your homework if you want to find out the specifics about each, but they are all headed that direction.
My views on this trend change daily depending on my mood. Its very nuanced, lots of ways to think about the question, but maybe some of these places will help you decide for yourself.