Transition probability matrix generation:

1. convert timestamp to serial number and then sort
   
2. divide area into grids
   
3. loop: for each taxiid, find current grid & next grid, fill into grid matrix (row is current grid #, column is next grid #)
   
4. get probability matrix by normalizing grid matrix

---

Update generation:

1. divide updates into three different speed groups
   
2. in each speed group, set timestamp(poisson distribution) for each update
   
3. pick GUID (and its corresponding source AS) for each update randomly
   
4. compute destination AS (prob: how to match AS to grid in probability matrix)
   

---

table TAXIDATA has all data loaded, table TAXI1 loads only the first data file

table contents are below
CREATE TABLE TAXIDATA
(
ID NUMBER(10) CONSTRAINT TAXIDATA_ID NOT NULL,
TAXIID NUMBER(7),
LONGITUDE NUMBER(9,6),
LATITUDE NUMBER(8,6),
SPEED NUMBER(3),
ANGLE NUMBER(3),
DATETIME TIMESTAMP(6),
STATUS NUMBER(1),
EXTENDSTATUS NUMBER(1),
REVISED NUMBER(1),
PRIMARY KEY(ID) )
TABLESPACE USERS;

---