Aggregate administrative channels - MEL

This table contains the administrative routes that extend over the territory of the European Metropolis of Lille. Road sections, part of a track between two junctions, are surveyed or updated daily. These sections are assigned to an administrative route. Every day the materialized view is updated from these sections. The view is based on an *aggregation of sections* following the route of belonging. Thus, there is no repetition of the wording. For these activities, the European Metropolis of Lille has a road network that presents the administrative routes of the MEL.