DENSE_RANK not working as expected
Remove your PARTITION clause. The window functions are calculated within the PARTITION itself, and it sounds like you're trying to rank the data globally (i.e. uniquely rank the addresses globally).
Or adjust the PARTITION clause to reflect the window of what you want the rank to be calculated across. For example, if you wanted to rank the data within the field arcs_name1 then you'd use PARTITION arcs_name1 only (but leave your ORDER BY clause as is) and the ranking would only be within the grouping of each value of arcs_name1 (resetting it's counter between each unique value of arcs_name1).