Tables

Patchworks makes extensive use of tables to provide access to internal simulation data. Tables are similar to spreadsheets or database tables in that they are made up of cells that are arranged by rows and columns. The cells in the tables may contain labels and numeric data, as appropriate for the element. Columns most often represent different data items, and rows often represent features (e.g. polygons) in the dataset.

Some tables allowed cell values to be modified. In this case the changed values will immediately modify the behaviour and results of the simulation model. Cells that allow modification will have a column heading that is shown in a non-italicized font.

Tables can be viewed as spreadsheets or (if the dataset contains GIS data) as maps. Tables can be exported, or used as input to reports in the report writer. Tables can also be manipulated programmatically using the BeanShell scripting language.

Patchworks provides a number of special dynamic attribute tables that contain simulation attributes. The the section called “The Block Attribute Table” and the the section called “The Target Table” are perhaps the most important and commonly used tables, but the simulation model also provides tables describing simulation performance characteristics, road network information, and individual route to destination data. The following sections provide a quick overview of these tables, but more detail can be found in the section called “Table Viewer”, and a reference to these tables is found in Patchworks Attributes Tables.

In addition to the simulation tables provided by Patchworks, tables can also be created by opening up a CSV, DBase or GIS dataset. These types of tables contain the contents of the underlying dataset, and can be joined to other tables using relational techniques.