Hermes
 All Data Structures Files Functions Variables Macros Pages
time_sr.sql File Reference

The file implements trajectory transformation with time interval. More...

Functions

integer trajectory_transformation_time_sr (text dataset, text start_date, text end_date, integer step, boolean save=true, text new_dataset_name="transformed", boolean csv_file=true)
 This function performs trajectory transformation within a specified time period, with a specified step. More...
 

Detailed Description

The file implements trajectory transformation with time interval.

Author
Kiriakos Velissariou (kir.v.nosp@m.elis.nosp@m.sario.nosp@m.u@gm.nosp@m.ail.c.nosp@m.om).

Function Documentation

integer trajectory_transformation_time_sr ( text  dataset,
text  start_date,
text  end_date,
integer  step,
boolean  save = true,
text  new_dataset_name = "transformed",
boolean  csv_file = true 
)

This function performs trajectory transformation within a specified time period, with a specified step.

Parameters
[in]datasetName of the dataset
[in]start_dateInitial timestamp
[in]end_dateLast timestamp
[in]stepThe step to be used in the search measured in seconds
[in]saveBoolean which indicates whether the new dataset will be saved in Hermes
[in]new_dataset_nameThe name with which the transformed dataset will be stored in Hermes
[in]csv_fileBoolean which indicates whether the new dataset will exported in a cvs format (traj_new.txt)
Returns
Interger 1 to indicate succesfull completion