NoPa stands for North of Panhandle. As you guessed, it is north of Golden Gate Park's panhandle. There is a neighborhood association called NOPNA, which stands for "North of Panhandle Neighborhood Association" (creative, huh!). The NOPNA website contains a lot of happenings in the neighborhood.
The neighborhood sometimes referred to as Alamo Square is often considered "NoPa."