Gawking is common in places that are not culturally diverse. I drove to many small towns in Midwest. I got stared at when I was walking around the town. Especially so when I entered local stores, diners, and pubs where everybody else was white. I could tell many store owners, waitresses, etc. were not comfortable when talking to me. I hope it is getting better.
Thank you for the data point! I spent 5 years in Chengdu, China and (full comment elsewhere in the thread) found it fairly easy to crystallize a line out of chaos. The only explanation I can think of is that many people feel similarly to you!
Fairness may be instinctual: https://www.theatlantic.com/entertainment/archive/2010/07/is...
Also, not that it matters to my point, your quick Google search was for the Asian population - the Indian population is much lesser - you made me curious, so I Googled. Apparently 3.95% of the Asian population of Oakland is Indian - which actually comes to < 1%.
This was not a major road - I got off any major road, and walked quite a bit to this cafe (30 min walks for me are common - this likely probably greater than that via much smaller roads through residential areas).
Gawking as well is common in a lot of places which aren't as culturally diverse as say California. If a Chinese or white person visits India, then outside of a few areas in the big cities they'll see similar behavior. Heck I could see people staring at me when I was in Charlotte, NC a while back.