1 00:00:00,288 --> 00:00:05,288 (gentle music) (air swooshing) 2 00:00:05,970 --> 00:00:07,860 - [Narrator] The Texas Department of Transportation 3 00:00:07,860 --> 00:00:11,400 receives information regarding operation, construction, 4 00:00:11,400 --> 00:00:15,180 and testing records from several independent systems. 5 00:00:15,180 --> 00:00:17,730 Working with the Center for Transportation Research, 6 00:00:17,730 --> 00:00:20,310 TxDOT organized these technology databases 7 00:00:20,310 --> 00:00:22,980 to better understand the impact of certain materials 8 00:00:22,980 --> 00:00:25,590 on the long-term performance of pavements. 9 00:00:25,590 --> 00:00:27,960 - TxDOT have been collecting data on materials 10 00:00:27,960 --> 00:00:29,400 and construction projects 11 00:00:29,400 --> 00:00:32,190 and pavement performance over several years. 12 00:00:32,190 --> 00:00:35,820 So they have all the data in separate databases 13 00:00:35,820 --> 00:00:38,070 that do not communicate with each other. 14 00:00:38,070 --> 00:00:39,840 - And so before this project, 15 00:00:39,840 --> 00:00:41,400 we never really combined the two. 16 00:00:41,400 --> 00:00:42,510 You know, you go to a roadway 17 00:00:42,510 --> 00:00:44,070 and you say, "Man, that's a really good roadway. 18 00:00:44,070 --> 00:00:46,080 What made it good, right?" 19 00:00:46,080 --> 00:00:47,370 You just assume it was 20 00:00:47,370 --> 00:00:49,950 you did everything right during construction. 21 00:00:49,950 --> 00:00:53,460 So this project was to combine those two databases 22 00:00:53,460 --> 00:00:55,380 so we can see the materials used, 23 00:00:55,380 --> 00:01:00,380 we can see the QC/QA, did we do everything right? 24 00:01:00,600 --> 00:01:01,680 And then what did that lead to 25 00:01:01,680 --> 00:01:03,630 in terms of overall performance? 26 00:01:03,630 --> 00:01:06,360 - We created two separate applications, 27 00:01:06,360 --> 00:01:11,010 one for the state use and one for the district use. 28 00:01:11,010 --> 00:01:16,010 And each application has nine dashboards to track project 29 00:01:17,130 --> 00:01:20,310 and material performance at different levels. 30 00:01:20,310 --> 00:01:24,570 And during the making of the application, 31 00:01:24,570 --> 00:01:26,580 we saw feedback from TxDOT 32 00:01:26,580 --> 00:01:30,960 asking how they intended to use it and their specific needs. 33 00:01:30,960 --> 00:01:35,960 And we also created text guide and a video guide 34 00:01:36,270 --> 00:01:40,830 to show them how to operate and manage the application. 35 00:01:40,830 --> 00:01:43,890 - In the project, as we would go to these projects, 36 00:01:43,890 --> 00:01:46,290 trying to combine them, right, we combine them and we say, 37 00:01:46,290 --> 00:01:48,210 okay, let's go get some real eyes on the pavement 38 00:01:48,210 --> 00:01:51,393 and let's see if the databases, 39 00:01:52,440 --> 00:01:54,510 you know, in agreeance with what we're seeing. 40 00:01:54,510 --> 00:01:56,250 And what we would find is we'd go to a project 41 00:01:56,250 --> 00:01:57,840 and it was already covered with the sealcoat. 42 00:01:57,840 --> 00:01:59,820 And so what we found out 43 00:01:59,820 --> 00:02:01,620 was districts have these four-year plans 44 00:02:01,620 --> 00:02:04,710 and they're doing district-wide sealcoat programs. 45 00:02:04,710 --> 00:02:06,060 And that is not being captured 46 00:02:06,060 --> 00:02:08,100 in either one of those databases. 47 00:02:08,100 --> 00:02:10,440 What the research team did is they actually pulled in 48 00:02:10,440 --> 00:02:13,650 another database so they can filter out those ones 49 00:02:13,650 --> 00:02:16,890 that have had TxDOT preventative maintenance on there. 50 00:02:16,890 --> 00:02:19,020 Now we have this all encompassing database 51 00:02:19,020 --> 00:02:20,430 that has everything together. 52 00:02:20,430 --> 00:02:22,890 It's turned into a really nice Tableau dashboard. 53 00:02:22,890 --> 00:02:24,450 So you can actually go in and say, 54 00:02:24,450 --> 00:02:27,750 hey, I wanna look in this district with a given mix type, 55 00:02:27,750 --> 00:02:30,000 and you wanna see a performance across the district. 56 00:02:30,000 --> 00:02:34,560 - So TxDOT can use this application to track project 57 00:02:34,560 --> 00:02:37,800 or materials performance in near real time. 58 00:02:37,800 --> 00:02:41,250 So on a geographical map on the application, 59 00:02:41,250 --> 00:02:44,370 they can locate projects on a given section 60 00:02:44,370 --> 00:02:47,340 and see how many projects were constructed, 61 00:02:47,340 --> 00:02:50,250 what materials were put in those projects, 62 00:02:50,250 --> 00:02:53,073 and how much money was spent. 63 00:02:53,940 --> 00:02:55,320 They can also see 64 00:02:55,320 --> 00:02:59,040 if there was any maintenance activity involved. 65 00:02:59,040 --> 00:03:02,550 They can also use this application as an investigative tool, 66 00:03:02,550 --> 00:03:06,660 as in they can track the historical performance 67 00:03:06,660 --> 00:03:09,510 of any projects and materials 68 00:03:09,510 --> 00:03:11,850 and flag any section 69 00:03:11,850 --> 00:03:14,730 with unsatisfactory performance. 70 00:03:14,730 --> 00:03:16,980 So by doing so, 71 00:03:16,980 --> 00:03:20,370 TxDOT can identify durable materials 72 00:03:20,370 --> 00:03:23,940 and they can promote use of those materials 73 00:03:23,940 --> 00:03:25,500 more in future projects. 74 00:03:25,500 --> 00:03:28,350 And there will be less maintenance, 75 00:03:28,350 --> 00:03:30,690 there will be less traffic congestion 76 00:03:30,690 --> 00:03:32,850 due to maintenance and construction, 77 00:03:32,850 --> 00:03:36,900 and there will be less delay in travel time 78 00:03:36,900 --> 00:03:39,720 with overall better driving experience 79 00:03:39,720 --> 00:03:41,910 for the people of Texas. 80 00:03:41,910 --> 00:03:42,930 - [Narrator] or more information 81 00:03:42,930 --> 00:03:45,360 and to find the publication for this project, 82 00:03:45,360 --> 00:03:47,670 please visit the TxDOT research library 83 00:03:47,670 --> 00:03:48,870 at the link shown below.