road_defect_setup.sql

Java的框架

 (82,'123','SG','[e-mail]','James',11,'2006-06-15 11:33:46','Xiao','523587','Holland Drive','623153533',11),
 (83,'246','SG','[e-mail]','Jason',6,'2006-06-16 18:42:43','Shao','754112','Jurong Town Hall Road','63243444',191),
 (84,'999','SG','[e-mail]','Jasper',13,'2006-06-19 16:09:33','Yao','978422','Merchant Road','67745544',211),
 (85,'123','SG','[e-mail]','Jeff',11,'2006-06-15 11:33:46','Zhan','523587','Pioneer Road','623153533',11),
 (86,'246','SG','[e-mail]','Jonathan',6,'2006-06-16 18:42:43','Dai','754112','Simei Road','63243444',191),
 (87,'999','SG','[e-mail]','Jack',13,'2006-06-19 16:09:33','Song','978422','Tiong Bahru Road','67745544',211),
 (88,'123','SG','[e-mail]','Kevin',11,'2006-06-15 11:33:46','Xiong','523587','Upper Changi Road','623153533',11),
 (89,'246','SG','[e-mail]','Mike',6,'2006-06-16 18:42:43','Mo','754112','Woodlands Road','63243444',191),
 (90,'999','SG','[e-mail]','Owen',13,'2006-06-19 16:09:33','Duan','978422','Yio Chu Kang Road','67745544',211);

INSERT INTO `CONTACT` (`ID`,`BLOCK`,`COUNTRY`,`EMAIL`,`FIRSTNAME`,`FLOOR`,`LASTMODIFIEDTIME`,`LASTNAME`,`POSTCODE`,`ROADNAME`,`TELEPHONE`,`UNIT`) VALUES 
 (91,'123','SG','[e-mail]','Paul',11,'2006-06-15 11:33:46','Si Ma','523587','Ang Mio Kio Avenue','623153533',11),
 (92,'246','SG','[e-mail]','Peter',6,'2006-06-16 18:42:43','Ou Yang','754112','Braddell Road','63243444',191),
 (93,'999','SG','[e-mail]','Quincy',13,'2006-06-19 16:09:33','Si Tu','978422','Clementi Road','67745544',211),
 (94,'123','SG','[e-mail]','Sam',11,'2006-06-15 11:33:46','Mai','523587','Delta Road','623153533',11),
 (95,'246','SG','[e-mail]','Sean',6,'2006-06-16 18:42:43','Ang','754112','Elias Road','63243444',191),
 (96,'999','SG','[e-mail]','Simon',13,'2006-06-19 16:09:33','An','978422','French Road','67745544',211),
 (97,'123','SG','[e-mail]','Sonny',11,'2006-06-15 11:33:46','Goh','523587','Holland Drive','623153533',11),
 (98,'246','SG','[e-mail]','Tomas',6,'2006-06-16 18:42:43','Yap','754112','Jurong Town Hall Road','63243444',191),
 (99,'999','SG','[e-mail]','Walker',13,'2006-06-19 16:09:33','Cai','978422','Merchant Road','67745544',211),
 (100,'123','SG','[e-mail]','Yosef',11,'2006-06-15 11:33:46','Pan','523587','Pioneer Road','623153533',11);
 
ALTER TABLE CONTACT AUTO_INCREMENT = 101;

--
-- Dumping data for table `prrm`.`roaddefect`
--
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (1,'Edge Rut','Worsen after the rain.',6,'At the centre of the road.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 13:06:07','Pending',1,'103.84476089477545,1.3481093049049375'),
 (2,'Base Failure','Width of 10 inches.',1,'Near the traffic light.','Major','2006-06-16 18:45:33',NULL,'2007-04-18 15:19:50','Pending',2,'103.67898750305184,1.3850831985473593'),
 (3,'Pothole','Depth of 2 inches. ',29,'Near the drain.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 13:09:26','Pending',3,'103.80453777313231,1.3338310122489951'),
 (4,'Pothole','Big pothole formed from several smaller ones. ',30,'At the turning of the road.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 13:12:53','Pending',4,'103.81268644332883,1.332624852657319'),
 (5,'Edge Rut','Width of 6 inches.',31,'At the side of the road. ','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 14:11:41','Pending',5,'103.81050395965553,1.3255984783172599'),
 (6,'Base Failure','Width of 1 metre. ',34,'Across the road. ','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 15:38:26','Opened',6,'103.64523839950547,1.3356832265853888');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (7,'Pothole','Depth of 5 inches',10,'At the centre of the road.','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 15:38:46','Opened',7,'103.64878749847401,1.3197785019874533'),
 (8,'Edge Rut','',36,'In front of the traffic light.','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 15:38:56','Opened',8,'103.69257736206066,1.349310636520383'),
 (9,'Base Failure','Reoccurred base failure. Previous failure is 6 months ago. ',12,'At the turning point of the road.','Major','2006-06-16 18:45:33',NULL,'2007-04-18 15:39:08','Opened',9,'103.68214130401586,1.3122594356536876'),
 (10,'Other','Faded road marking. ',13,'At the centre of the road. ','Critical','2006-06-16 18:45:33',NULL,'2007-04-18 15:39:22','Opened',10,'103.66405963897697,1.306063175201412'),
 (11,'Base Failure','Reoccured base failure. Previous failure is a month ago. ',14,'Across the road.','Critical','2006-06-16 18:45:33',NULL,'2007-04-18 15:43:20','AssignedInspection',11,'103.69398928555576,1.3090436837908587'),
 (12,'Other','Pavement crack caused by an accident. ',41,'Near the pavement. ','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 15:45:44','AssignedInspection',12,'103.75253772735611,1.40985071659088');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (13,'Pothole','Pothole depth approximately 4 inches.',18,'At the side of the road.','Major','2006-06-16 18:45:33',NULL,'2007-04-18 15:47:55','AssignedInspection',13,'103.76689910888666,1.3403873443603522'),
 (14,'Pothole','Pothole depth approximately 6 inches.',46,'At the centre of the road.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 15:48:42','AssignedInspection',14,'103.85336875915553,1.3643760681152306'),
 (15,'Base Failure','Reoccured base failure. Previous failure 2 months ago.',23,'Across the road. ','Critical','2006-06-16 18:45:33',NULL,'2007-04-18 15:49:56','AssignedInspection',15,'103.86244964599622,1.344182252883913'),
 (16,'Edge Rut','Caused by erosion. ',6,'At the side of the road. ','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 15:53:16','AssignedInspection',16,'103.83240127563482,1.3182402253150938'),
 (17,'Base Failure','Width of 1 metre.',1,'In front of the bus stop. ','Major','2006-06-16 18:45:33',NULL,'2007-04-18 16:16:53','AssignedInspection',17,'103.67957949761916,1.381279535244162');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (18,'Pothole','Depth of 2 inches. ',29,'In front of the traffic light.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 16:20:18','AssignedInspection',18,'103.80500984191893,1.3340885043144248'),
 (19,'Pothole','Worsen after the rain.',30,'Near the drain.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 16:24:19','AssignedInspection',19,'103.8150782201197,1.3337086007192415'),
 (20,'Edge Rut','Caused by erosion. ',31,'Near the slope along the road.','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 16:27:45','AssignedInspection',20,'103.81406230506461,1.3274224014479871'),
 (21,'Base Failure','Due to hot weather. ',34,'At the centre of the road.','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 16:37:55','Done',21,'103.64686904546614,1.332655045034991'),
 (22,'Pothole','Pothole depth approximately 4 inches.',10,'At the side of the road. ','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 16:40:17','Done',22,'103.64927029609669,1.3197034001350363'),
 (23,'Edge Rut','Caused by erosion. ',36,'Between 2 drains at the sides.','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 16:44:38','Done',23,'103.69420814514172,1.3487956523895237');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (24,'Base Failure','Reoccurred base failure. Previous failure is 6 months ago.',12,'In front of the bus stop. ','Major','2006-06-16 18:45:33',NULL,'2007-04-18 16:48:51','Done',24,'103.68248462676976,1.3142335414886486'),
 (25,'Other','Pavement crack caused by an accident.',13,'Near the pavement.','Critical','2006-06-16 18:45:33',NULL,'2007-04-18 16:51:51','Done',25,'103.66448879241935,1.3108267784118612'),
 (26,'Base Failure','Width of 10 inches.',14,'At the side of the road. ','Critical','2006-06-16 18:45:33',NULL,'2007-04-18 16:58:12','AssignedInspection',26,'103.69252920150748,1.309305250644683'),
 (27,'Other','Faded road marking. ',41,'At the side of the road. ','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 17:06:17','AssignedInspection',27,'103.7645111083986,1.4147859811782824'),
 (28,'Pothole','Worsen after the rain.',18,'In front of the bus stop. ','Major','2006-06-16 18:45:33',NULL,'2007-04-18 17:13:06','AssignedInspection',28,'103.77230644226069,1.3348941802978522'),
 (29,'Pothole','Depth of 2 inches. ',46,'Between 2 drains at the sides.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 17:21:19','AssignedInspection',29,'103.85963439941432,1.3618869781494103');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (30,'Base Failure','Reoccurred base failure. Previous failure a month ago. ',23,'At the turning point of the road.','Critical','2006-06-16 18:45:33',NULL,'2007-04-18 18:03:13','AssignedInspection',30,'103.86210632324232,1.3535377979278582'),
 (31,'Edge Rut','',6,'At the centre of the road.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 17:37:24','Pending',31,'103.84407424926763,1.3893080353736875'),
 (32,'Base Failure','Width of 1 metre.',1,'Between 2 drains at the sides.','Major','2006-06-16 18:45:33',NULL,'2007-04-18 17:39:18','Pending',32,'103.68662643432626,1.40379428863525'),
 (33,'Pothole','Pothole depth approximately 4 inches.',29,'Near the pavement.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 17:40:18','Pending',33,'103.80664062499999,1.3348180651664756'),
 (34,'Pothole','Worsen after the rain.',30,'Near the drain.','Normal','2006-06-16 18:45:33',NULL,'2007-04-18 17:41:58','Pending',34,'103.81588363647458,1.3340196013450631'),
 (35,'Edge Rut','',31,'Near the drain.','Minor','2006-06-16 18:45:33',NULL,'2007-04-18 17:44:19','Pending',35,'103.81490278243996,1.3279802799224845');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (36,'Base Failure','Width of 10 inches.',34,'Across the road.','Major','2006-06-16 18:45:33',NULL,'2007-04-18 17:51:18','AssignedRepair',36,'103.64613962173448,1.3337949514389045'),
 (37,'Pothole','Defect Detail',10,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:49:33','Pending',37,'103.65552965933787,1.3237824501768873'),
 (38,'Edge Rut','Defect Detail',36,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:14','Pending',38,'103.69951970484382,1.346365848764194'),
 (39,'Base Failure','Defect Detail',12,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:52','Pending',39,'103.68141952450405,1.3115984368200768'),
 (40,'Other','Defect Detail',13,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:52:31','Pending',40,'103.66836689235055,1.315623069056572'),
 (41,'Base Failure','Defect Detail',14,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:53:25','Pending',41,'103.69398928555576,1.3090436837908587'),
 (42,'Other','Defect Detail',41,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 16:08:03','Pending',42,'103.76999773297949,1.4129712752022198');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (43,'Pothole','Defect Detail',18,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 16:08:46','Pending',43,'103.78424787397846,1.327750283819404'),
 (44,'Pothole','Defect Detail',46,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 16:09:33','Pending',44,'103.86706460881106,1.3651307327142108'),
 (45,'Base Failure','Defect Detail',23,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:18:45','Pending',45,'103.86374864121193,1.3414312971688318'),
 (46,'Edge Rut','Defect Detail',6,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:42:59','Pending',46,'103.83914108344031,1.3334531830270397'),
 (47,'Base Failure','Defect Detail',1,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:43:52','Pending',47,'103.67957949761916,1.381279535244162'),
 (48,'Pothole','Defect Detail',29,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:45:33','Pending',48,'103.80810253589169,1.3356451534604945'),
 (49,'Pothole','Defect Detail',30,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 15:46:41','Pending',49,'103.8150782201197,1.3337086007192415');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (50,'Edge Rut','Defect Detail',31,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:47:24','Pending',50,'103.81406230506461,1.3274224014479871'),
 (51,'Base Failure','Defect Detail',34,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:48:46','Pending',51,'103.64686904546614,1.332655045034991'),
 (52,'Pothole','Defect Detail',10,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:49:33','Pending',52,'103.65552965933787,1.3237824501768873'),
 (53,'Edge Rut','Defect Detail',36,'Location','Minor','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:14','Pending',53,'103.69951970484382,1.346365848764194'),
 (54,'Base Failure','Defect Detail',12,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 15:51:52','Pending',54,'103.68141952450405,1.3115984368200768'),
 (55,'Other','Defect Detail',13,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:52:31','Pending',55,'103.66836689235055,1.315623069056572'),
 (56,'Base Failure','Defect Detail',14,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:53:25','Pending',56,'103.69398928555576,1.3090436837908587');
INSERT INTO `ROADDEFECT` (`ID`,`DEFECTTYPE`,`DEFECTDETAIL`,`ROADID`,`LOCATION`,`SEVERITY`,`CREATIONTIME`,`CLOSEDDATE`,`LASTMODIFIEDTIME`,`STATUS`,`CONTACTID`,`COORDINATES`) VALUES 
 (57,'Other','Defect Detail',41,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 16:08:03','Pending',57,'103.76999773297949,1.4129712752022198'),
 (58,'Pothole','Defect Detail',18,'Location','Major','2006-06-16 18:45:33',NULL,'2006-06-19 16:08:46','Pending',58,'103.78424787397846,1.327750283819404'),
 (59,'Pothole','Defect Detail',46,'Location','Normal','2006-06-16 18:45:33',NULL,'2006-06-19 16:09:33','Pending',59,'103.86706460881106,1.3651307327142108'),
 (60,'Base Failure','Defect Detail',23,'Location','Critical','2006-06-16 18:45:33',NULL,'2006-06-19 15:18:45','Pending',60,'103.86374864121193,1.3414312971688318'),