Figure 1.
The image shows two main tables and their relationship. The upper table is an inspection register with columns for inspection i d, inspection year, route name, position, member, damage summary, and kihon i d. Each row lists an inspection with a corresponding kihon i d. The middle table is a base register with columns for kihon i d, route name, starting pier, ending pier, inbound or outbound direction, and mainline or ramp. Matching kihon i d values in both tables are visually connected to indicate a relational link. The lower section shows that, after linking through the kihon i d, information is merged into several registers, including inspection register, base register, superstructure register, painting register, pavement register, expansion joint register, and traffic volume register, forming an integrated data structure.Dataset construction process for data analysis