1 / 9

PostTrajectory : Querying and Managing GPS and Trajectories on PostgreSQL/ PostGIS

PostTrajectory : Querying and Managing GPS and Trajectories on PostgreSQL/ PostGIS. KiHyun Yoo E-mail : khyoo1221@gmail.com. Introduction. In modern cities, many people drive the vehicles that equipped with the GPS devices It is easily being collected and stored the GPS data

ulyssesj
Download Presentation

PostTrajectory : Querying and Managing GPS and Trajectories on PostgreSQL/ PostGIS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. PostTrajectory : Querying and Managing GPS and Trajectories on PostgreSQL/PostGIS KiHyunYoo E-mail: khyoo1221@gmail.com

  2. Introduction • In modern cities, many people drive the vehicles that equipped with the GPS devices • It is easily being collected and stored the GPS data • Many applications for location-based services(LBS) and moving object have been studied using these GPS data • Moreover, we can use a large-scale GPS data • Because it is easily collected from the vehicles • Recently it is increasing studies for mining a meaningful and a valuable information from the large-scale data

  3. Motive • The trajectory is the set of information of the location by the time • Unfortunately traditional spatial database systems do not support data types and functions for trajectory data • PostgreSQL is probably one of the best solutions for trajectory data • It is an open-source ORDBMS(Object-Relational Database Management System) • Supports objects, classes and inheritance in database schemas and query language • Large-scale trajectory data is useful • By analyzing and predicting the trajectory data, it provide a new opportunity to understand the city dynamics and economic phenomena

  4. Framework PostTrajectory GeoContents Client(Phone) Data Types GeoContents Client(Tablet) GeoContents Client(Web) Function_1 Server PostGIS Function_2 Function_3 PostTrajectory …. Data Types Functions PostgreSQL DB

  5. PostTrajectory

  6. PostTrajectory (Cont.) Q1) What is the longest distance that was travelled by a vehicle during the periods? SELECTMax(TR_Length(TR_AtPeriods (traj.Trip, ‘PERIOD(5005, 5008)’))) AS Dist FROMTrajectory traj WHERETR_Present(traj.Trip, ‘PERIOD(5005, 5008)’); Q2) Which vehicles travelled within one of the regions from City's Table during the periods? SELECTc.Region AS Region, traj.car AS car FROM Trajectory traj, City c WHERE NOT (TR_IsEmpty(TR_At(TR_AtPeriods(traj.Trip, ‘PERIOD(5005, 5008)’), c.Region)));

  7. PostTrajectory(Cont.)

  8. Applications

  9. Thank youAny Questions? khyoo1221@gmail.com

More Related