Building Open-Source Tools to Perform Quality Control Checks on Transit On-Board Survey Data

摘要

In 2010, the Ohio-Kentucky-Indiana Regional Council of Governments conducted a transit on-board survey with the help of a consultant. OKI undertook all of the geocoding, and in the process of geocoding. After the completion of the survey, OKI undertook a rigorous quality control review of the survey with the intent to revise records that were illogical from a spatial trip-making standpoint. This included locating and correcting records where the origin, boarding, alighting, or destination locations didn't make sense. OKI created an ArcMap add-in to automate and streamline a cumbersome and time-consuming manual editing approach. The tools that OKI created are open source and available to any agency wishing to use them. This approach utilizes readily available software including ArcMap ArcObjects Development Kit for Java, Eclipse, and a few related Eclipse plug-ins. It is estimated that these tools saved over four weeks of work and shortened a six-month review and revision process down to two weeks.