The road model data files

There are four core files that define the Patchworks road network. These files are listed in Table 16, “Road model core input files”.


The format of these files are described so that you have a better understanding of the workings of the model. You do not have to develop these files from scratch, as they are created by the Build Road Segments tool described in the previous section (see the section called “Generating a Road Model”).

Table 16. Road model core input files

File namePurpose
vertices.csv Defines nodes in the "arc-node' topology
segments.csv Defines road segment cost characteristic
destinations.csv Define the mill destination locations on the road network
linkages.csv Defines how blocks connect to road segments

The four core files work together to describe a connected road network that can be used to model wood flow to multiple or single destinations, as well as economic factors that influence scheduling and treatment decisions.

In addition supplemental files are generated by the Build Road Segment tool that describe cost and connectivity characteristics of the road network. These files are not used by the Patchworks model, but can be used for diagnosing errors in the network. A final file describes intersections between the road segment and block features. The relationships described in this file can optionally be loaded in the Patchworks model and used for spatial queries to select block features that have been intersected by road features (see the description of the intersection file for more details).

Table 17. Build Road Segments supplemental output files

File namePurpose
connectivity.csv Identifies segments that do not have connectivity to any mill
cost_destination.csv Defines the least cost path values for every node in the network. One file is generated for each destination.
intersections.csv Identifies the spatial intersections between the blocks and the road segments.

The optional files (intersections, connectivity, cost_destination) provide diagnostic information or additional capabilities to the Patchworks model.

These seven files represent the Patchworks data model in a fully normalized relational format. The Figure 182, “Patchworks road network data model entity relationship diagram” shows the relationship between the tables in the road network data model. When combined together, the Patchworks model forms a fully topologically connected network that is the result of linking and indexing all of these road network files.

Figure 182. Patchworks road network data model entity relationship diagram


Table and field names shown in italics are optional and if omitted will be replaced with default values.

The following sections will look at each of these files in greater detail.