Abstract: In view of the problems such as the manual compilation of coal mine mining plans, the tedious compilation process of mining excavation relay, and the failure to carry out early warning of mining excavation relay stress, based on GIS theory, the early warning system of mining and exaction relay compilation is developed. The relay plan report, relay graph, basic data and so on are managed by GIS database to realize the automatic generation of mining follow-up chart and report, and monitor the tension of production tasks, and realize the early warning of mining and excavation plan combined with the actual progress of coal production. Compared with the traditional CAD and Excel report, the paper realizes the unified input, edit and output of graphic report, and provides intelligent auxiliary tools for mining and excavation relay compilation.