UvAGPS

UVA_TRACKING_DATA

Tracking data from UvA GPS tags

Field	Type	Key	Constraints	Comments
device_info_serial	int4	PK	NOT NULL
date_time	timestamp	PK	NOT NULL	GMT
latitude	float8			Decimal degrees
longitude	float8			Decimal degrees
h_accuracy	float8			Horizontal accuracy (m)
v_accuracy	float8			Vertical accuracy (m)
altitude	float8			m
x_acceleration	Float8			x axis acceleration (m/s22) movement to right is + and to left is -
y_acceleration	Float8			y axis acceleration (m/s22) forward movement is + and backwards is -
z_acceleration	Float8			z axis acceleration (m/s22) upwards movement is + downwards is -
speed	float8			m/s
course	float8			Degrees
pressure	float8			Pressure sensor (pascal)
temperature	Float8			Degrees celcius
solar_voltage	Float8			V
battery_voltage	Float8			V
quality	text			Data flagged as unacceptable by user
“"location”"	geometry			postgreSQL geometry

UVA_ENGINEERING_DATA

Engineering data from UvA GPS tags

Field	Type	Key	Constraints	Comments
device_info_serial	int4	PK	NOT NULL
date_time	timestamp	PK	NOT NULL	GMT
t_syncsts	smallint			0: not synced, 1: user synced, 2: Gps synced
t_entzt	smallint			0: UCT time,1: TZT time (timezone time)
gzp_currentrategps	int4
gzp_currentratecom	int4
gzp_currentratepwr	int4
sbm_voltagesolarpanel	float8
sbm_voltagebattery	float8
sbm_chargemode	int2
egzp_mainrategps	integer
egzp_mainratecom	integer
egzp_mainratepwr	integer
smg_on	text
smg_off	text
smg_esavegpsrate	integer
smz_on	text
smz_off	text
smz_esavecomrate	integer
gpsnavigationmode	smallint
gpsfixtimeout	smallint
eh	text