Skip to main content


A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.

Experimental MySQL schema for OnTheMap OD files released

Print Friendly, PDF & Email

MySQL table definitions and readin programs for the OnTheMap microdata may come in handy to users of the data we distribute. We have posted such programs for the OD files (one of four file types in the OnTheMap public use data distribution). Interested users can access them here. Table definitions for other files will become available over time. Please note that these programs are designed for the OnTheMap V2 files, and are not yet available for the soon-to-be-released OnTheMap V3 files. To register for access to the data, please request a login for the site by sending an email to
If loading the entire OD matrix, please plan for 15GB of storage if using all three currently available years and only the first implicate. If using the two-column index specified in the dtatabase schema, it will require an additional 3.8GB.