Asset Pipeline CLEAN

DB → ASSET PRESENCE → DATE-AWARE CHAINAGE ENRICHMENT → CSV DOWNLOAD

▸ One-time setup — run these in your terminal:
pip install flask flask-cors pandas mysql-connector-python python-dotenv
python app.py

Keep that terminal open, then click RETRY above.

Date Range

Start Date

End Date

1 day(s)

Database Configs

USING SERVER DEFAULTS

Pipeline Steps

STEP 01 Asset Presence + Video Match

IDLE

Queries tbl_site_asset + tbl_asset_tracking → asset_presence_with_video_name.csv

STEP 02 Chainage Enrichment

IDLE

Queries tbl_site_statics with video_date · matches by site + date + chainage (closest segment) → asset_presence_with_chainage_and_video.csv

Activity Log

— no activity yet —