BlueSynthesizer Version 2.0 Beta

Amir Zarinbal

Prof. Hellinga

University of Waterloo

Outputs:

Connectors Table:

Fields:

1-      ConnectorID: Identification number of connector in ViSSIM

2-      MaxAngle: Maximum angle of movements through the connector

3-      Direction:

1-      Through Movement

2-      Right Turn

3-      Left Turn

This table can be used to verify the output of “Detection of Direction of Movements” modules.

Detections Table:

Fields:

1-      ID: Row identification Number

2-      VehicleID

3-      DetetctorID

4-      Connector: The ID of connector which the direction movement is determined by.

5-      Angle: Angle of movements through the connector

6-      Direction

7-      Xfd: X coordinate of First Detection

8-      Yfd: Y coordinate of First Detection

9-      Xld: X coordinate of Last Detection

10-   Yld: Y coordinate of Last Detection

11-   Tfd: Time of First Detection

12-   Tld: Time of Last Detection

13-   Tenter: Entrance Time of the vehicle in the detection zone of the detector

14-   Texit: Exit Time of the vehicle from the detection of the detector

15-   Tsensor: The first time that distance of vehicle and the sensor become minimum. (based on DistanceAdj in RawDetetion)

16-   Nhits: Number of Hits

Random Car Table:

Fields:

1-      ID: Row identification Number

2-      RandomVN:  Vehicle number of selected random vehicle.

Raw Detections Table:

This table stores the Bluetooth hits.

Fields:

1-      ID: Row identification Number

2-      DetetctorID

3-      LinkID

4-      VehicleID

5-      X: X coordinate of point that hit may happen

6-      Y: Y coordinate of point that hit may happen

7-      Thit: Time of Hit

8-      Distance: Distance to the detector

9-      DistanceAdj: Distance to the Adjusted coordinate of the detector (Usually centroid of intersection). The First time this value become minimum, the time will be marked as the Tsensor. If the adjusted coordinate of Detector has not been entered In the detectors’ setting form, the actual coordinate will be used and DistanceAdj =Distance.

10-   IsDetected:

-2: Impossible: A trajectory point in the detection zone of . No detection is possible for this vehicle at this time due as the bluetooth devices is not in inquiry scan mode.

-1: Skipped: Skipped Slave’s Inquiry Scanning interval. This is because of a prior detection at the same masters’ scan interval.

0: No detection: Detection was possible. However, it was not detected.

1: Detected

11-   NextSlaveScan: Time of next inquiry scan of the Vehicle

12-   NextMasterScan: Time of next inquiry of the detector

13-   NextPossibleHit: The next possible time of Hit.

Trip Table:

Fields:

1-      ID: Row identification Number

2-      LinkName

3-      VehicleID

4-      srcDetector: Origin detector of the link

5-      desDetetor: Destination detector of the link.

17-   srcTfd: Time of First Detection at origin (source)

18-   srcTld: Time of Last Detection at origin (source)

19-   desTfd: Time of First Detection at destination

20-   desTld: Time of Last Detection at destination

21-   TTTrue: True travel time

22-   TTFF: First-First detections travel time

23-   TLLL: : Last-Last detections travel time

24-   TTLF: Last-First detections travel time

25-   TTFL: First-Last detections travel time

Temporary Items:

Turning Movement Table

This table include all of the important connectors in the DB entered manually by me.

1-      ID

2-      Detector ID

3-      LinkID: connectors number

4-      Direction

5-      Desc

Check Connection

1-      Query that will bring the data from other soured and you can compare the result