You seem to lack all historical context on the social dynamic in Crown Heights and South Williamsburg, the disproportionately massive political power of the Hasidim voting block, and how this leads to disproportionately one-sided arrest and conviction rates whenever ethnic violence occurs in these neighborhoods.
The severe 1991 Crown Heights riots occurred directly as a result of a Hasidic rabbi's motorcade running a red light and striking two black children, one fatally. Ethnic tensions in this area had already been simmering for a long time, and while they've improved since 1991, there are still lots of problems. But this is just two Brooklyn neighborhoods, and has absolutely nothing to do with liberal-run cities or widespread "severe social dysfunction" in NYC, a city of over 8 million people and a combined metro area of 20 million people.
So, no, I'm absolutely not going to waste my time researching some arbitrary ratio that is completely orthogonal to the topic at hand, just because some random person on the internet is trying to gaslight me from 2500 miles away.
As for looting and "the data" and "the videos": two NewsCorp-owned publications put the estimated number of looted businesses at 450. As NewsCorp skews far-right we can assume that's the worst-case (highest possible) number. Among the approx 220,000 businesses in NYC, an estimated 32,000 are retail businesses, but this number does not account for how many of these are businesses with multiple storefronts.
From this, as well as daily personal observation in various parts of the NYC metro area, I would conclude far less than 1% of storefronts in NYC were looted. While this was a significant event, it's FAR from a "major riot". It's also not an ongoing problem.
In all the videos I saw, the perpetrators were large groups of teens on bicycles. Meanwhile NYPD has 36,000 officers and a nontrivial amount of military-grade equipment. One can either conclude that somehow they were incapable of stopping groups of teenagers on bicycles, or one can more logically conclude that they chose not to.