An automatic approach to qualitative risk assessment in metropolitan areas