Speaking of crazy street systems, Avenue R becomes Avenue O when it crosses Flatbush Avenue.
To add to WTP’s explanation of Queens street numbers, the numbered streets also have places and lanes. Like Brooklyn, Queens was made up of several villages. Some areas have numbered streets, others don’t. Some areas just have north-south streets and east-west avenues and not all the other flavors (WTP presumably meant to say that the streets are perpendicular to the avenues). Even Queens’s well-known hyphenated house numbers aren’t universal: there are a few streets in Kew Gardens that have regular three digit numbers, and the in the Rockaways, house numbers usually aren’t hyphenated.