Every city has their known skate spots that all the skaters around know and love. In addition you will also probably know every trick that has been thrown down whether it be a shedding local, or a pro skater. I have came across a few different forums that have a compilation of the most widely known skate spots including photos and ratings. The best site I have came across so far is skateboardspots.com. Don’t be fooled by the funky orange navigation, this site has a large user base with a large number of quality skate spots. 
This site is awesome, I have also had pretty good luck with http://skatespotter.com/ although it looks like the site is down now, hmm…