Heterogeneous Graph Importance Scoring and Clustering with Automated LLM-based Interpretation
Organizations: Yachiyo Engineering Co., Ltd., Japan
Abstract
Urban bridge networks are critical infrastructure whose disruption can cascade into severe impacts on transportation, emergency services, and economic activity. This paper presents a comprehensive methodology for assessing bridge importance through heterogeneous graph analysis, unsupervised clustering, and automated interpretation via large language models (LLMs). Our approach addresses three fundamental challenges: (1) quantifying multi-dimensional bridge importance using only open data sources, (2) discovering functional bridge archetypes across different cities, and (3) generating policy-relevant interpretations automatically. We construct heterogeneous graphs from OpenStreetMap (OSM) data incorporating bridges, road networks, buildings, and public facilities. Five social impact indicators are computed: transit desert score, hospital access score, isolation risk score, supply chain impact score, and green space access score. These 52-dimensional feature vectors undergo dimensionality reduction via UMAP and density-based clustering via HDBSCAN. Discovered clusters are interpreted using temperature-optimized LLMs (Elyza8b, trained on construction domain corpus). (1) A complete open-data pipeline from OSM to actionable bridge importance rankings, (2) a five-indicator scoring methodology with 40 computational optimization, (3) a UMAP+HDBSCAN clustering framework validated on multi-city data, (4) an LLM interpretation methodology including temperature optimization and model selection rationale, and (5) transferability demonstration across cities via configuration-only adaptation.
Figures & tables
| Phase | v1.5.0 (naive) | v1.5.3 (optimized) | Speedup |
|---|---|---|---|
| Transit Desert | 118 hours (est.) | 7.6 min | 933 |
| Hospital Access | 13 hours (est.) | 8.7 min | 90 |
| Isolation Risk | 2 hours (est.) | 5–10 min | 12–24 |
| Supply Chain | – | 9.6 min | N/A |
| Green Space | – | 43.5 min | N/A |
| Total | 133 hours | 20–25 min | 40 |
| Metric | Tama City | Morioka City |
|---|---|---|
| Total bridges | 353 | 422 |
| Area (km²) | 99.4 | Regional (larger) |
| Urban character | Dense metro | Regional mixed |
| Mean elevation (m) | 97–176 | 539.6 (rural areas) |
| Cluster count | 10 (Tama-dom.) | 9 (Morioka-dom.) |
| Top archetype | Transit hub | Isolation mitigation |
| Indicator | Mean | Std Dev | Max |
|---|---|---|---|
| Transit desert score | 8.72 | 16.53 | 83.41 |
| Hospital access score | 4.38 | 9.47 | 51.04 |
| Isolation risk score | 17.24 | 19.88 | 51.74 |
| Supply chain impact | 0.65 | 1.21 | 5.62 |
| Green space access | 4.19 | 8.97 | 47.68 |
| Composite score | 7.04 | 6.95 | 77.30 |
| Indicator | Time (min) | % of Total |
|---|---|---|
| Transit desert | 7.6 | 5.6% |
| Hospital access | 61.0 | 45.2% |
| Isolation risk | 9.5 | 7.0% |
| Supply chain | 9.6 | 7.1% |
| Green space | 43.5 | 32.2% |
| Total | 135.0 | 100% |
| Cluster | Size | City | Top-3 Features (z-score) | Role Type |
|---|---|---|---|---|
| 2 | 54 | Tama 100% | Transit desert (3.27), Isolation (3.14), | Transit-Connectivity |
| Social impact (1.32) | (Rural linkage) | |||
| 6 | 59 | Morioka 98% | Lanes (1.39), Buildings (1.26), | Arterial |
| Transit desert (high) | (Urban core) | |||
| 9 | 48 | Tama 98% | Supply chain (2.20), Metapath (high), | Logistics Network |
| Supply routes (significant) | (Commercial) |
| Metric | Value |
|---|---|
| 5-section completeness rate | 100% (19/19) |
| Typo/error rate | 0% |
| Mean report length (chars) | 290 |
| Output length variance | 4.0 |
| Factual grounding (no speculation) | 100% |
| Total generation time | 2 min 30 sec |
| Temp | Variance | Mean Len | Issues |
|---|---|---|---|
| 0.1 | 4.3 | 315 | Over-speculation, fabricated context |
| 0.3 | 4.0 | 290 | None (optimal) |
| 0.5 | 6.7 | 290 | Extreme instability (101–672 range) |
| 0.7 | 3.5 | 320 | Verbose, repetitive |
Appendix figures & tables1 asset
Supplementary material from the paper’s appendix.
Appendix
| Cluster | N | City | Betweenness | Transit | Hospital | Isolation | Supply | Green |
|---|---|---|---|---|---|---|---|---|
| (mean) | Desert | Access | Risk | Chain | Space | |||
| 0 | 43 | Morioka 100% | 0.0040 | 4.60 | 0.26 | 16.37 | 0.19 | 0.26 |
| 1 | 30 | Morioka 100% | 0.0002 | 0.17 | 0.00 | 0.00 | 0.00 | 0.00 |
| 2 | 54 | Tama 100% | 0.0036 | 83.41 | 6.80 | 0.95 | 1.03 | 4.93 |
| 3 | 38 | Tama 100% | 0.0034 | 0.00 | 3.43 | 2.71 | 0.44 | 3.09 |
| 4 | 54 | Morioka 100% | 0.0020 | 1.59 | 0.31 | 0.00 | 0.08 | 0.21 |
Importance Weighting
Importance weighting adjusts the influence of samples, features, or outcomes to correct distribution differences or emphasize relevant information.
See all 30 papers