Regional Traffic Counts Available on ACOG Web
Posted: Monday, October 31, 2005In August, ACOG Transportation staff completed the design of a new Microsoft Access Database of all Oklahoma City Area Regional Transportation Study (OCARTS) area traffic counts. Benefits of the new format include reduced redundancy and inaccuracy, the ability to quickly generate statistics and reports, and easy online access.
The final Access database contains two primary tables for storing traffic count information. The first table is called “stations” and contains any attribute that is specifically related to a location where traffic counts are taken. It includes roughly 15 fields such as name of community, street number location, and destination coordinates. The database currently has 3369 stations (2423 stations with associated counts).
The second table lists all of the information related to the specific counts with a common ID field that links the individual counts back to the related station. The “counts” table contains the following fields: ACOG ID name, Count, Date, Fiscal Year, Source, and Comment. The counts table currently contains 12,367 counts from 1995 – 2005.
Access to this database is available in a new online system that will provide the public and staff easy access to our traffic count information through a series of form searches. The application is comparable to what other entities across the nation currently offer.
To access the database, go to www.acogok.org, and pull down the “traffic counts” menu from “transportation services.” For more information, contact Darla Hugaboom, ACOG.