The Freight Trip Generation (FTG) Software applies FTG models developed by the Rensselaer Polytechnic Institute (RPI) at the zipcode and 2 digit NACIS code levels. This software is broken up into three modules. The first module preprocesses the “County Business Pattern” data obtained from the census bureau and generates a database with information at a zip Code and 2 digit NAICS code level. The second module applies FTG models and produces estimations of freight trip attraction (FTA) and production (FTP). Finally, the third module allows modifying the coefficients used in the estimation of FTG models. Advanced features in the software include applying 4 types of models and the option of selecting a set or a range of zip codes to be analyzed.
The FTG software is offered as is, without warranty or promise of support of any kind either expressed or implied. Under no circumstances will the National Academy of Sciences or the Transportation Research Board (collectively “TRB”) be liable for any loss or damage caused by the installation or operation of this product. TRB makes no representation or warranty of any kind, expressed or implied, in fact or in law, including without limitation, the warranty of merchantability or the warranty of fitness for a particular purpose, and shall not in any case be liable for any consequential or special damages.
This software is available to download here: FTG Software
Manual for Freight Trip Generation Software
Download County Business Patterns Data, for the year you need.
File type: “Complete ZIP Code Industry Detail File”
Open the file in WordPad and save it as text file with an appropriate name, which would be used for Zip Code Business Pattern Input Data. Make sure the data corresponds to ZIP and NAICS code and that it comes in a single line.
Freight Trip Generation Estimator Home Page
Purpose: This is the home page, which breaks up the program into two parts.
1) The first part of the program is the Zip Code Business Pattern Input Data, which takes in information from the raw database to reformat the text file.
2) The second part is the Freight Trip Generation (FTG) Models, which uses the saved text file from the first part to estimate FTG using one of the four models the user can select.
3) Module 3 is used to modify the default FTA and FTP coefficients, which are used when estimating the FTG Models
Module 1: Zip Code Business Pattern Input Data Preparation
Purpose: Takes the information from raw database and generates a new database containing only NAICS 2 digit level information for which ‘Freight Trips Generation’ can be estimated. The data corresponding to 2 digit NAICS code is saved as new text file to estimate FTG in further steps.
- Load File: Input the raw database so it can be preprocessed by clicking the load file button and then browse for the saved raw database and open the input file saved from WordPad.
- Save File: Need to save a file that would be exported from the program by clicking the save file button and then enter in, appropriate file name (the default extension for saving the exported file is .txt, so the you do not have to add it in the save dialog box)
- Generate Database: After loading and entering the appropriate file names when you click ‘Save File’, click on the ‘Generate Database’ button to run the program and create a new text file with pre-processed data.
Module 2: Freight Trip Generation (FTG) Models
Purpose: To estimate the Freight Trip Generation Models (FTG). FTG is the summation of Freight Trip Attraction (FTA) and Freight Trip Production (FTP) models. The output of the software will include two new columns added to the file loaded: FTA (freight trip attraction) and FTP (freight trip production). Run any one of the four different types of models in the program to calculate and analyze data depending on what you want to analyze.
A. Load File: Input the preprocessed database so it can generate freight trips by clicking this button and then browse saved output from preprocessing.
B. Save File: Need to save a file that would be exported from the program by clicking this button and then enter in, appropriate file name (the default extension for saving the exported file is .txt, so the you do not have to add it in the save dialog box)
C. Select a Type of Model: This drop down menu is used to select which model to apply in the program. The equations available in the FTG are as follows:
- Independent FTA and FTP- This a default model in the program, which calculates FTA and FTP, it creates two new columns for each line of output in a new text file
- Binary Logit Model- Outputs a corrected FTP by calculating the probability from an equation that depends on the NAICS code and FTA and multiply it by the FTP
- Simple Shares – Outputs a corrected FTP by using a default probability value that depends on the NAICS code and multiply it by FTP
- User Defined- Outputs a corrected FTP by using a probability value you would input in the text box below the drop down box and multiply it by FTP
D. Probability Value: Ony applies for the User Defined model, where you have to input a probability value.
E. Assume FTA and FTP are Equal to One Per Establishment Checkbox: If the FTA and FTP are equal to zero then FTA and FTP are equal to the establishments
F. Use Custom Coefficients of FTA and FTP: This allows you to input your own custom FTA and FTP coefficients to use for the models, instead of using the default coefficients. Read Custom FTA and FTP Coefficients for more information.
G. Use Zip Code Filter: Allows you to add a zip code filter to specify which zip codes the user wants to analyze (for more information read page 5)
H. Input Custom FTA and FTP Coefficients: For uploading custom coefficients text files, so the program will uses these coefficients rather than the default one. Read Custom FTA and FTP Coefficients for more information.
I. Run FTG Models: This will run the program and output the calculations
ZIP Code Filter
Purpose: This filter is a useful tool to be able to select and analyze certain ZIP Codes. Listed below are different methods you can use to filter information using ZIP codes:
- Use a Custom ZIP Code Filter
- Enter a range of ZIP Codes to filter
- Analyze by state
- Custom ZIP Code Filter: You are able to import the provided zip code list or a custom zip code list by clicking the load custom filter button. This custom zip code list must be a text file and have the same format as the example below, with commas and spaces dividing the zip codes and the words “Zip Codes” at the beginning of the document. Below is an example of a custom zip code filter text file.
- Analyze by State: Where you are able to select a state from the drop down list and the program will only analyze the ZIP Codes that are in the provided state you have selected (only available for New York in the current version)
- Range: This function allows to output database corresponding to zip codes between the ranges that you have entered and by clicking the “enter the range” button, so the program knows you want to use the range function. Enter the min and max values and there is no need to include the zero’s at the beginning of the zip code. For example if the min value you want to input is “00640”, you should just input 640.
- Reset Filter: Resets the filter to the original settings.
Module 3: Modify Default FTA and FTP Coefficients
Purpose: To be able to modify the default coefficient values, which are used in Module 2. This allows the user to make corrections to the coefficients in a seamlessly way. You are able to add and delete coefficients from the default values, allowing you to modify and use it in module 2.
A. Select Coefficient Type: Select what type of coefficient you like to modify
B. Select Command: Select what type of action to perform on the default coefficients
- Add- To add to the default list, you have to enter a NAICS code with its respected establishment and employment (Step C,D,E and F)
- Delete- To delete a NAICS code from the list, you have to enter in the NAICS code (Step C and F)
C. NAICS code: Input NAICS Code you which to add or remove from the current list
D. Establishment Coefficient: Enter this value if you wish to add a NAICS code to the default list
E. Employment Coefficient: Enter this value if you wish to add a NAICS code to the default list
F. ADD or DELETE: Click on the button to add or delete a NAICS Code with its respected coefficients from the list
G. Set up My Default: Allows you to create a saved file that you are able to upload to default list
H. Open My Default: Upload the saved file to the current coefficient list
I. Restore Coefficient Values: This is the original coefficient value that can restore the default list to the original values