Compatibility.sql File Reference

The file implements the some compatibility functions. More...

Functions
void	hloader (text dataset_name, text dataset_long_name)
	This function created the necessary tables that will host the dateset. More...
void	hloadercsv_ii (text dataset_name, text csv_file)
	This function loads the data from a csv file. Before loading the data in PostgreSql, one needs to save the data files in the PostgreSQL directory in a file type of csv with a header for column names with the following structure: <obj_id, traj_id, t, lon, lat>. More...
void	hdatasetsofflinestatistics (text dataset_name)
	This function calculates some statistics for the dataset, such as average number of points per trajectory, average duration of trajectories, and average length of trajectories. More...
float8	nm2meters (float8 nm)
	This function transform nautical miles to meters. More...

Detailed Description

The file implements the some compatibility functions.

Author

Marios Vodas (mvoda.nosp@m.s@gm.nosp@m.ail.c.nosp@m.om).

See also

Object methods

Function Documentation

void hdatasetsofflinestatistics

(

text

dataset_name

)

This function calculates some statistics for the dataset, such as average number of points per trajectory, average duration of trajectories, and average length of trajectories.

Parameters

[in]

dataset_name

the name of the dataset

void hloader	(	text	dataset_name,
		text	dataset_long_name
	)

This function created the necessary tables that will host the dateset.

Parameters

[in]	dataset_name	the short name of the dataset
[in]	dataset_long_name	the description fo the dataset

void hloadercsv_ii	(	text	dataset_name,
		text	csv_file
	)

This function loads the data from a csv file. Before loading the data in PostgreSql, one needs to save the data files in the PostgreSQL directory in a file type of csv with a header for column names with the following structure: <obj_id, traj_id, t, lon, lat>.

Parameters

[in]	dataset_name	the name of the dataset
[in]	csv_file	the file that contains the data

float8 nm2meters

(

float8

nm

)

This function transform nautical miles to meters.

Parameters

[in]

nm

the nautical miles

Returns

the meters

Normally this function should have been inside Utilities/UnitConcersion.sql but I am too bored to test the consequences of moving this function.