It's outside the city centre around Gilesgate way. It's actually the road which joins the city to the A1 motorway. It's a council estate (actually, most of the houses are probably private now) and a little rough around the edges, but one of the roughest parts of the country? Yeah, it's well known for its gun and knife crime, its riots and battles with the police
Also, that bit about the police not going there is a pile of nonsense. I can put you in touch with the former Chief Constable of Durham if you want, the brother of a family friend, he'll tell you the score
It actually reminds me a little of an estate on the edge of my small town (the town is semi-rural, largely middle class). It's a very small estate, has a terrible reputation and it was said the emergency services don't go there. It is rough, and all the shoplifters who come into the local shops are from there, but it's not that bad.
Does form quite a contrast, up the road from £800,000 Victorian semis and £400,000 1960s semis and detached. But its problems are very, very minor compared to the deprived areas of major cities and hardly affects those elsewhere in the town. The same with Sherburn Road. All areas have their dodgy parts, but Sherburn Road isn't all that bad and even if you live in Gilesgate after your first year it's easy enough to avoid it.