Analysis of Taxi Intelligent Scheduling Based on DZ GPS Data

1. use ftlog2csv convert from the file of dzgpsdata log format to cvs format.
2. use dzgps_csv2mysql insert cvs data to mysql: record 5379216.
3. use dzgps_mysql_convtype_2 get the infomation of taxi service to db: record 184135.
4. copy 3. table and delete data with (tdate2 - tdate1) > 140s: record 155605. delete from tbl_convert2_copy where (tdate2 - tdate1) > 140
5. alert table to add tinyint field for stateB.
• update tbl_convert2_copy set stateB=0 where state1=0 and state2=1;
• update tbl_convert2_copy set stateB=1 where state1=0 and state2=2;
• update tbl_convert2_copy set stateB=2 where state1=1 and state2=0;
• update tbl_convert2_copy set stateB=3 where state1=1 and state2=2;
• update tbl_convert2_copy set stateB=4 where state1=2 and state2=0;
• update tbl_convert2_copy set stateB=5 where state1=2 and state2=1;
6. copy 5. table and delete date stateB IS NULL: record 155605.
• delete from tbl_convert2_copy2 where stateB IS NULL
7. set stateC.
• update tbl_convert2_copy set stateC=0 where stateB=0 or stateB=5;
• update tbl_convert2_copy set stateC=1 where stateB=2 or stateB=3;
• update tbl_convert2_copy set stateC=2 where stateB=1 or stateB=3;
• update tbl_convert2_copy set stateC=3 where stateB=4 or stateB=5;
8. to Calculate the regionid of points with MO2.3, VB and MySql ODBC.