Using the PostgreSQL database and R statistical software for path analysis

Despite the technological advances in the system for determining spatial coordinates in recent years, still they have minimal defects, therefore, the GPS not as evidenciable would be considered as the localization error is denoted in a few meters unlike what actually recorded. That's why, to analyze a vehicle trajectory, conducted the study of a set of records, downloaded from a website, which contain GPS trajectories 10,357 taxis during the period from 2 to 8 February 2008 in the city of Beijing. Fields containing the data set are: taxi identifier, date and time, longitude and latitude. a corresponding geographical map was also used to the city mentioned, which was unloaded in download.geofabrik.de, and was implemented by the Geographic Information System QGIS, the same which allows a geographical display of all vehicular paths. The resulting information will be integrated into the R statistical analysis tool for the user to visualize in statistical tables movements of taxis at certain times or points of the city, so it can be displayed in bar statistics frequency fields and time. These data obtained have greater relevance because, you can work and manage an accurate and concrete way.