"TrapperKeeper" - a tool that stores the results of UrbanSim model estimations into a database

Abstract

TrapperKeeper was developed for use on the UrbanSim implementation used in the dynamic land use and transportation model of Chittenden County, Vermont, at the Spatial Analysis Lab and University Transportation Center of The University of Vermont.

Before we began estimating the various sub-models of the land use model, we recognized the potential for confusion that could ensue if we had no way of tracking and managing the hundreds of estimations we would likely be performing. TrapperKeeper was designed and implemented to make it easy to keep track of these many model estimations.

Author: Brian Miles, Spatial Analysis Lab, Rubenstein School of Environment and Natural Resources, The University of Vermont
First submitted on: 11/1/2007
Last modified on: 11/27/2007

Comments, questions, and suggestions are welcome. Please send a message to "Brian dot Miles at uvm dot edu"

Version Note

Version 2.0 fixes a few bugs and adds the ability to write estimation specifications and coefficients to an UrbanSim baseyear database. To support this new feature, the database has changed (which is why I'm calling it 2.0 instead of say 1.1). The variables tables now store the specification for a given variable. If you've used TrapperKeeper 1.0, I suggest that you uninstall it and re-install 2.0. I don't anticipate any further database changes. If there are, I will ensure backward compatibility so that you don't have to re-install and lose data.

Download

• See attachments section below

Software Requirements

• Python 2.4.3 or 2.5.1 (other versions may work but have not been tested)
• MySQL_python
• SQLAlchemy
• Installed and running MySQL database
  • version 5.0.12 has been tested, though any version compatible with UrbanSim 4.1 should work
• Microsoft Access 2003 (optional; for using supplied Access database to view estimation receipts)

Instructions

• See "docs/README.txt" for usage information