Bicycle Signage (Digital Workflow)

Digitising bicycle signage inventories through an automated GIS workflow

Luxembourg · Luxembourg · 2025 · Prototype

In partnership with
  • Schroeder & Associés

A prototype project transforming manual bicycle signage inventories into a fully digital workflow. From field data collection to automated reporting, the system improves efficiency, consistency, and data reliability.

Automated Data Processing Automated Reports Decision Support Digital Data Collection GIS Workflows Interactive Maps Mobile Data Collection

Challenge

• Bicycle signage inventories were recorded analog, using handwritten notes and separate photo documentation
• Data was manually transferred into Excel tables
• Final reports were assembled by hand in PowerPoint, combining maps and drawings
• The process was slow and error-prone

Solution by COFT

• QGIS/QField solution replicating Excel structures
• Automated filling of coordinates and attributes
• Field survey conducted directly in QField
• Automated report generation equivalent to the old manual version
• Additional Python script for thematic maps at sign level

Workflow details

From field survey to final report

  1. 01

    Preparation

    Survey structures and accessibility criteria are prepared in QGIS in close coordination with the planning office.

  2. 02

    Field Survey

    Field experts collect data directly on-site using QField. Photos are taken via the app and automatically linked to the corresponding object.

  3. 03

    Processing

    Measurements and calculations are automated directly within the GIS. Data consistency and structure are ensured.

  4. 04

    Output

    Automated reports and interactive maps are generated immediately after the survey.

Results & impact

Results

• Immediate availability of maps and reports after the survey
• Automatic photo-linking
• Fewer media breaks-one system from field to report
• Standardized input ensures error-free data
• Flexible Excel export for further processing