road_defect_setup.sql

Java的框架

 (61,'Edge Rut','Defect Detail',6,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:42:59','Pending',61,'103.83914108344031,1.3334531830270397'),
 (62,'Base Failure','Defect Detail',1,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:43:52','Pending',62,'103.67957949761916,1.381279535244162'),
 (63,'Pothole','Defect Detail',29,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:45:33','Pending',63,'103.80810253589169,1.3356451534604945');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (64,'Pothole','Defect Detail',30,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:46:41','Pending',64,'103.8150782201197,1.3337086007192415'),
 (65,'Edge Rut','Defect Detail',31,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:47:24','Pending',65,'103.81406230506461,1.3274224014479871'),
 (66,'Base Failure','Defect Detail',34,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:48:46','Pending',66,'103.64686904546614,1.332655045034991'),
 (67,'Pothole','Defect Detail',10,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:49:33','Pending',67,'103.65552965933787,1.3237824501768873'),
 (68,'Edge Rut','Defect Detail',36,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:14','Pending',68,'103.69951970484382,1.346365848764194'),
 (69,'Base Failure','Defect Detail',12,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:52','Pending',69,'103.68141952450405,1.3115984368200768'),
 (70,'Other','Defect Detail',13,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:52:31','Pending',70,'103.66836689235055,1.315623069056572');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (71,'Base Failure','Defect Detail',14,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:53:25','Pending',71,'103.69398928555576,1.3090436837908587'),
 (72,'Other','Defect Detail',41,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 16:08:03','Pending',72,'103.76999773297949,1.4129712752022198'),
 (73,'Pothole','Defect Detail',18,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 16:08:46','Pending',73,'103.78424787397846,1.327750283819404'),
 (74,'Pothole','Defect Detail',46,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 16:09:33','Pending',74,'103.86706460881106,1.3651307327142108'),
 (75,'Base Failure','Defect Detail',23,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:18:45','Pending',75,'103.86374864121193,1.3414312971688318'),
 (76,'Edge Rut','Defect Detail',6,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:42:59','Pending',76,'103.83914108344031,1.3334531830270397'),
 (77,'Base Failure','Defect Detail',1,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:43:52','Pending',77,'103.67957949761916,1.381279535244162');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (78,'Pothole','Defect Detail',29,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:45:33','Pending',78,'103.80810253589169,1.3356451534604945'),
 (79,'Pothole','Defect Detail',30,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:46:41','Pending',79,'103.8150782201197,1.3337086007192415'),
 (80,'Edge Rut','Defect Detail',31,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:47:24','Pending',80,'103.81406230506461,1.3274224014479871'),
 (81,'Base Failure','Defect Detail',34,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:48:46','Pending',81,'103.64686904546614,1.332655045034991'),
 (82,'Pothole','Defect Detail',10,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:49:33','Pending',82,'103.65552965933787,1.3237824501768873'),
 (83,'Edge Rut','Defect Detail',36,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:14','Pending',83,'103.69951970484382,1.346365848764194'),
 (84,'Base Failure','Defect Detail',12,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:52','Pending',84,'103.68141952450405,1.3115984368200768');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (85,'Other','Defect Detail',13,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:52:31','Pending',85,'103.66836689235055,1.315623069056572'),
 (86,'Base Failure','Defect Detail',14,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:53:25','Pending',86,'103.69398928555576,1.3090436837908587'),
 (87,'Other','Defect Detail',41,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 16:08:03','Pending',87,'103.76999773297949,1.4129712752022198'),
 (88,'Pothole','Defect Detail',18,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 16:08:46','Pending',88,'103.78424787397846,1.327750283819404'),
 (89,'Pothole','Defect Detail',46,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 16:09:33','Pending',89,'103.86706460881106,1.3651307327142108'),
 (90,'Base Failure','Defect Detail',23,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:18:45','Pending',90,'103.86374864121193,1.3414312971688318'),
 (91,'Edge Rut','Defect Detail',6,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:42:59','Pending',91,'103.83914108344031,1.3334531830270397');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (92,'Base Failure','Defect Detail',1,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:43:52','Pending',92,'103.67957949761916,1.381279535244162'),
 (93,'Pothole','Defect Detail',29,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:45:33','Pending',93,'103.80810253589169,1.3356451534604945'),
 (94,'Pothole','Defect Detail',30,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:46:41','Pending',94,'103.8150782201197,1.3337086007192415'),
 (95,'Edge Rut','Defect Detail',31,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:47:24','Pending',95,'103.81406230506461,1.3274224014479871'),
 (96,'Base Failure','Defect Detail',34,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:48:46','Pending',96,'103.64686904546614,1.332655045034991'),
 (97,'Pothole','Defect Detail',10,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:49:33','Pending',97,'103.65552965933787,1.3237824501768873'),
 (98,'Edge Rut','Defect Detail',36,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:14','Pending',98,'103.69951970484382,1.346365848764194');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (99,'Base Failure','Defect Detail',12,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:52','Pending',99,'103.68141952450405,1.3115984368200768'),
 (100,'Other','Defect Detail',13,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:52:31','Pending',100,'103.66836689235055,1.315623069056572');
 
ALTER TABLE ROADDEFECT AUTO_INCREMENT = 101;


INSERT INTO `ROADINSPECTION` VALUES (1,16,6,'Edge Rut','Caused by erosion.','CENTRAL EXPRESSWAY','At the side of the road.','Normal','Edge Rut was found caused by erosion. This is due to the recently non-stop heavy rain. ','The road is not damaged hence repair is not required.',0,'2007-04-18 16:14:56','2007-04-18 16:15:26');
INSERT INTO `ROADINSPECTION` VALUES (2,17,7,'Base Failure','Width of 1 metre.','ABBOTSINGH ROAD','In front of the bus stop.','Minor','Base failure found. Does not hinder vehicles movement. ','Immediate repair is not necessary. ',0,'2007-04-18 16:19:32','2007-04-18 16:19:32');
INSERT INTO `ROADINSPECTION` VALUES (3,18,8,'Pothole','Depth of 2 inches.','MANDAI ROAD','In front of the traffic light.','Minor','At the side of road near the traffic lights. Away from vehicles movement.','Immediate repair is not required.',0,'2007-04-18 16:23:23','2007-04-18 16:23:23');
INSERT INTO `ROADINSPECTION` VALUES (4,19,9,'Pothole','Worsen after the rain.','NANYANG FLYOVER','Near the drain.','Minor','Pothole expanded after several days of rain. Quite far from the road. ','Immediate repair is not required.',0,'2007-04-18 16:26:44','2007-04-18 16:26:44');
INSERT INTO `ROADINSPECTION` VALUES (5,20,10,'Edge Rut','Caused by erosion.','NEW BRIDGE ROAD','Near the slope along the road.','Normal','Edge Rut was found caused by erosion. This is due to the recently non-stop heavy rain. ','The road is not damaged hence repair is not required.',0,'2007-04-18 16:30:07','2007-04-18 16:30:07');
INSERT INTO `ROADINSPECTION` VALUES (6,21,11,'Base Failure','Due to hot weather.','PANDAN FLYOVER','At the centre of the road.','Minor','Minor base failure.','',0,'2007-04-18 16:37:28','2007-04-18 16:37:28');
INSERT INTO `ROADINSPECTION` VALUES (7,22,12,'Pothole','Pothole depth approximately 4 inches.','BATTERY ROAD','At the side of the road.','Minor','Does not hinder vehicles movement.','Immediate repair is not necessary.',0,'2007-04-18 16:40:02','2007-04-18 16:40:02');
INSERT INTO `ROADINSPECTION` VALUES (8,23,13,'Edge Rut','Caused by erosion.','SELETAR FLYOVER','Between 2 drains at the sides.','Minor','Edge Rut was found caused by erosion. This is due to the recently non-stop heavy rain. ','The road is not damaged hence repair is not required.',0,'2007-04-18 16:44:12','2007-04-18 16:44:12');
INSERT INTO `ROADINSPECTION` VALUES (9,24,14,'Base Failure','Reoccurred base failure. Previous failure is 6 months ago.','CAUSEWAY','In front of the bus stop.','Minor','Base failure found. Does not hinder vehicles movement. ','Immediate repair is not necessary.',0,'2007-04-18 16:48:24','2007-04-18 16:48:24');
INSERT INTO `ROADINSPECTION` VALUES (10,25,15,'Other','Pavement crack caused by an accident.','CHANGI AIRPORT','Near the pavement.','Minor','Slight crack on pavement only.','',0,'2007-04-18 16:51:11','2007-04-18 16:51:11');
INSERT INTO `ROADINSPECTION` VALUES (11,26,16,'Base Failure','Width of 15 inches.','CHANTEK FLYOVER','At the side of the road.','Major','Base failure found. Covered part of the road and hinders vehicles movement.','Repair and re-paint the markings of the road. ',1,'2007-04-18 17:03:27','2007-04-18 17:03:58');
INSERT INTO `ROADINSPECTION` VALUES (12,27,17,'Other','Faded road marking.','ULU PANDAN ROAD','At the side of the road.','Normal','Double lanes road markings by the side faded.','Re-paint the markings.',1,'2007-04-18 17:11:22','2007-04-18 17:11:22');
INSERT INTO `ROADINSPECTION` VALUES (13,28,18,'Pothole','Worsen after the rain.','EAST COAST PARKWAY','In front of the bus stop.','Critical','Serious worsen after the rain. Hinders bus movements. ','Cover up the pothole. ',1,'2007-04-18 17:16:11','2007-04-18 17:16:11');
INSERT INTO `ROADINSPECTION` VALUES (14,29,19,'Pothole','Depth of 2 inches.','WEST COAST HIGHWAY','Between 2 drains at the sides.','Normal','The pothole might hinder and cause problems.','Cover up the pothole.',1,'2007-04-18 17:28:12','2007-04-18 17:28:12');
INSERT INTO `ROADINSPECTION` VALUES (15,30,20,'Base Failure','Reoccurred base failure. Previous failure a month ago.','HAVELOCK ROAD','At the turning point of the road.','Critical','Base failure quite bad. Cover large portion of the road. ','Repair the road and take prevention measures.',1,'2007-04-18 17:35:36','2007-04-18 17:36:30');
INSERT INTO `ROADINSPECTION` VALUES (16,36,21,'Base Failure','Width of 20 inches.','PANDAN FLYOVER','Across the road.','Major','The base failure area covers more than reported. ','Repair and take prevention measures.',1,'2007-04-18 17:50:09','2007-04-18 17:50:09');

ALTER TABLE ROADINSPECTION AUTO_INCREMENT = 17;


INSERT INTO `TASK` VALUES (1,'Inspection','2007-04-18 15:43:20','2007-04-18 15:43:20','High','2008-04-15','Opened','Ensure the base failure is properly repaired to prevent reoccurrence.',11,'admin');
INSERT INTO `TASK` VALUES (2,'Inspection','2007-04-18 15:45:44','2007-04-18 15:45:44','Normal','2006-06-06','Opened','',12,'admin');
INSERT INTO `TASK` VALUES (3,'Inspection','2007-04-18 15:47:55','2007-04-18 15:47:55','High','2007-05-07','Opened','',13,'admin');
INSERT INTO `TASK` VALUES (4,'Inspection','2007-04-18 15:48:42','2007-04-18 15:48:42','High','2007-05-16','Opened','',14,'admin');
INSERT INTO `TASK` VALUES (5,'Inspection','2007-04-18 15:49:56','2007-04-18 15:49:56','High','2007-11-15','Opened','Ensure the base failure is properly repaired to prevent reoccurrence.',15,'admin');
INSERT INTO `TASK` VALUES (6,'Inspection','2007-04-18 15:53:16','2007-04-18 15:53:16','High','2007-08-08','Opened','Ensure erosion prevention measures are taken.',16,'admin');
INSERT INTO `TASK` VALUES (7,'Inspection','2007-04-18 16:16:53','2007-04-18 16:16:53','Normal','2007-05-03','Opened','',17,'admin');
INSERT INTO `TASK` VALUES (8,'Inspection','2007-04-18 16:20:18','2007-04-18 16:20:18','Low','2008-04-01','Opened','',18,'admin');
INSERT INTO `TASK` VALUES (9,'Inspection','2007-04-18 16:24:19','2007-04-18 16:24:19','Low','2007-12-04','Opened','',19,'admin');
INSERT INTO `TASK` VALUES (10,'Inspection','2007-04-18 16:27:45','2007-04-18 16:27:45','Low','2007-12-20','Opened','',20,'admin');
INSERT INTO `TASK` VALUES (11,'Inspection','2007-04-18 16:36:24','2007-04-18 16:36:24','Normal','2007-05-29','Done','',21,'admin');
INSERT INTO `TASK` VALUES (12,'Inspection','2007-04-18 16:39:03','2007-04-18 16:39:03','Normal','2007-06-27','Done','',22,'admin');
INSERT INTO `TASK` VALUES (13,'Inspection','2007-04-18 16:42:39','2007-04-18 16:42:39','Normal','2008-04-15','Done','',23,'admin');
INSERT INTO `TASK` VALUES (14,'Inspection','2007-04-18 16:46:16','2007-04-18 16:46:16','High','2007-10-17','Done','Ensure the base failure is properly repaired to prevent reoccurrence.',24,'admin');
INSERT INTO `TASK` VALUES (15,'Inspection','2007-04-18 16:49:41','2007-04-18 16:49:41','High','2007-11-13','Done','',25,'admin');
INSERT INTO `TASK` VALUES (16,'Inspection','2007-04-18 16:58:12','2007-04-18 16:58:12','High','2007-04-25','Opened','',26,'admin');
INSERT INTO `TASK` VALUES (17,'Inspection','2007-04-18 17:06:17','2007-04-18 17:06:17','Normal','2007-05-16','Opened','',27,'admin');
INSERT INTO `TASK` VALUES (18,'Inspection','2007-04-18 17:13:06','2007-04-18 17:13:06','High','2007-09-12','Opened','',28,'admin');
INSERT INTO `TASK` VALUES (19,'Inspection','2007-04-18 17:21:19','2007-04-18 17:21:19','Normal','2009-04-13','Opened','',29,'admin');
INSERT INTO `TASK` VALUES (20,'Inspection','2007-04-18 17:31:05','2007-04-18 17:31:05','High','2007-05-23','Opened','Ensure the base failure is properly repaired to prevent reoccurrence.',30,'admin');
INSERT INTO `TASK` VALUES (21,'Inspection','2007-04-18 17:48:19','2007-04-18 17:48:19','High','2008-04-16','Done','',36,'admin');
INSERT INTO `TASK` VALUES (22,'Repair','2007-04-18 17:51:18','2007-04-18 17:51:18','High','2007-09-11','Opened','',36,'admin');

ALTER TABLE TASK AUTO_INCREMENT = 23;