ADAMS Research
  • Data Mining
  • Reports
  • GIS
  • Charts
  • Documents

APTS Data Archiving and Mining System (ADAMS) is the name of the data mining application. The application was designed to demonstrate how APTS data can be taken from the point of generation through archiving, processing, data mining and analysis. The research performed on this project established ADAMS, as the foundation for demonstrating techniques on the use APTS data as well as providing technical assistance to the transit agencies in demonstrating data mining and analysis techniques and reporting.

Data mining (DM), also called Knowledge-Discovery in Databases (KDD) or Knowledge-Discovery and Data Mining, is the process of automatically searching large volumes of data for patterns using tools such as classification, association rule mining, clustering, etc.. Data mining is a complex topic and has links with multiple core fields such as computer science and adds value to rich seminal computational techniques from statistics, information retrieval, machine learning and pattern recognition.

Please go to Data Mining Reports for more information about data model based reports or Data Mining Prediction for more information about data mining.

We know how important reports are to our world. After we are finished analyzing the data, one important job is to create reports and show them to the people who need them. SQL Server 2005 Reporting Services delivers enterprise, Web-enabled reporting functionality so you can create reports that draw content from a variety of data sources, publish reports in various formats, and centrally manage security and subscriptions.

Please go to Data Analysis Reports for more information about reports for ADAMS.

(Compatible with Firefox, IE6, and Google Chrome)

Click here to view our ADAMS charts.




The objective of this project is to develop of data mining and analysis program to demonstrate how raw data generated by APTS technologies can be converted into meaningful and useful information for transit planning and management, a web-based prototype data archiving, mining and analysis application will be developed to serve as an example of such application for Florida transit systems.

Final Report

SQL (sometimes expanded as Structured Query Language) is a computer language used to create, retrieve, update and delete data from relational database management systems. SQL has been standardized by both ANSI and ISO. SQL is commonly spoken either as the names of the letters ess-cue-el or like the word sequel . The official pronunciation of SQL according to ANSI is ess-cue-el. However, each of the major database products (or projects) containing the letters SQL has its own convention, for our project, we use Microsoft SQL Server which is commonly spoken as Microsoft-sequel-server.

Click here to download the SQL statements zip file

Lehman Center for Transporation Research Florida Department of Transportation
Copyright © 2011 Florida APTS Program. All rights reserved.