Rosetta in context: Street-network sprawl trends

The chart above shows SNDi trends for new street additions (left panel) and the entire network (right panel), with Rosetta plotted against Al Buhayrah and Egypt. The SNDi of new construction in Rosetta rose steadily, compared to Al Buhayrah which peaked in 1976-1990 and Egypt which followed a zig-zag trend with an overall increase. Most recently, Rosetta's incremental SNDi rose from 6.19 to 6.65 between 1991-2005 and 2006-2020. In terms of the aggregate network, Rosetta ranked 11th out of 13 cities in Al Buhayrah and 180th out of 213 in Egypt as of 2020.

Rankings go from most connected to most disconnected — rank 1 is the most connected.

What about similarly populated cities?

• Al Qurna, Iraq
• Rayagada, India
• Gaocheng, China
• Abalak, Niger
• Raniyan, India
• Shucheng, China

In new street additions, Rosetta built increasingly disconnected streets over time, while Al Qurna fluctuated in its street-construction patterns and Abalak built increasingly connected streets from 1975 through 1976-1990, then shifted to more disconnected patterns. For the full network, Rosetta became progressively more disconnected, while Al Qurna became progressively more connected and Abalak became more connected from 1975 through 1976-1990, then grew more sprawly from 1976-1990 onwards. Notably, Rosetta had a more connected network than Abalak in 1975 but the two have since reversed their relative ranking.