It is held in New York, Los Angeles, and San Diego. I did hear that they will be bringing it to many more cities in the future. I went to see it at the Descanso Garden in La Cañada Flintridge, CA.
I also heard a nice brief overview from one of the pumpkin sculptors, when you first enter onto the trail. He was finishing up another pumpkin carving. So awesome!