Bicycle Signage (Digital Workflow)
Digitising bicycle signage inventories through an automated GIS workflow
-
Schroeder & Associés
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
From field survey to final report
-
01
Preparation
Survey structures and accessibility criteria are prepared in QGIS in close coordination with the planning office.
-
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.
-
03
Processing
Measurements and calculations are automated directly within the GIS. Data consistency and structure are ensured.
-
04
Output
Automated reports and interactive maps are generated immediately after the survey.
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