roaddefect_setup.sql

Java的框架

--
-- PostgreSQL database dump
--

SET client_encoding = 'UNICODE';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 1922 (class 0 OID 0)
-- Name: DUMP TIMESTAMP; Type: DUMP TIMESTAMP; Schema: -; Owner: 
--

-- Started on 2006-06-19 16:19:18 Malay Peninsula Standard Time


SET search_path = public, pg_catalog;

--
-- TOC entry 1924 (class 0 OID 0)
-- Dependencies: 1582
-- Name: prrm_roaddefect_gid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('prrm_roaddefect', 'gid'), 100, true);


--
-- TOC entry 1921 (class 0 OID 173649)
-- Dependencies: 1583
-- Data for Name: prrm_roaddefect; Type: TABLE DATA; Schema: public; Owner: postgres
--

insert into prrm_roaddefect values(1,1,'Normal','Edge Rut','Pending',pointfromtext('POINT(103.84476089477545 1.3481093049049375)'));
insert into prrm_roaddefect values(2,2,'Major','Base Failure','Pending',pointfromtext('POINT(103.67898750305184 1.3850831985473593)'));
insert into prrm_roaddefect values(3,3,'Normal','Pothole','Pending',pointfromtext('POINT(103.80453777313231 1.3338310122489951)'));
insert into prrm_roaddefect values(4,4,'Normal','Pothole','Pending',pointfromtext('POINT(103.81268644332883 1.332624852657319)'));
insert into prrm_roaddefect values(5,5,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.81050395965553 1.3255984783172599)'));
insert into prrm_roaddefect values(6,6,'Minor','Base Failure','Opened',pointfromtext('POINT(103.64523839950547 1.3356832265853888)'));
insert into prrm_roaddefect values(7,7,'Minor','Pothole','Opened',pointfromtext('POINT(103.64878749847401 1.3197785019874533)'));
insert into prrm_roaddefect values(8,8,'Minor','Edge Rut','Opened',pointfromtext('POINT(103.69257736206066 1.349310636520383)'));
insert into prrm_roaddefect values(9,9,'Major','Base Failure','Opened',pointfromtext('POINT(103.68214130401586 1.3122594356536876)'));
insert into prrm_roaddefect values(10,10,'Critical','Other','Opened',pointfromtext('POINT(103.66405963897697 1.306063175201412)'));
insert into prrm_roaddefect values(11,11,'Critical','Base Failure','AssignedInspection',pointfromtext('POINT(103.69398928555576 1.3090436837908587)'));
insert into prrm_roaddefect values(12,12,'Normal','Other','AssignedInspection',pointfromtext('POINT(103.75253772735611 1.40985071659088)'));
insert into prrm_roaddefect values(13,13,'Major','Pothole','AssignedInspection',pointfromtext('POINT(103.76689910888666 1.3403873443603522)'));
insert into prrm_roaddefect values(14,14,'Normal','Pothole','AssignedInspection',pointfromtext('POINT(103.85336875915553 1.3643760681152306)'));
insert into prrm_roaddefect values(15,15,'Critical','Base Failure','AssignedInspection',pointfromtext('POINT(103.86244964599622 1.344182252883913)'));
insert into prrm_roaddefect values(16,16,'Normal','Edge Rut','AssignedInspection',pointfromtext('POINT(103.83240127563482 1.3182402253150938)'));
insert into prrm_roaddefect values(17,17,'Major','Base Failure','AssignedInspection',pointfromtext('POINT(103.67957949761916 1.381279535244162)'));
insert into prrm_roaddefect values(18,18,'Normal','Pothole','AssignedInspection',pointfromtext('POINT(103.80500984191893 1.3340885043144248)'));
insert into prrm_roaddefect values(19,19,'Normal','Pothole','AssignedInspection',pointfromtext('POINT(103.8150782201197 1.3337086007192415)'));
insert into prrm_roaddefect values(20,20,'Minor','Edge Rut','AssignedInspection',pointfromtext('POINT(103.81406230506461 1.3274224014479871)'));
insert into prrm_roaddefect values(21,21,'Minor','Base Failure','Done',pointfromtext('POINT(103.64686904546614 1.332655045034991)'));
insert into prrm_roaddefect values(22,22,'Minor','Pothole','Done',pointfromtext('POINT(103.64927029609669 1.3197034001350363)'));
insert into prrm_roaddefect values(23,23,'Minor','Edge Rut','Done',pointfromtext('POINT(103.69420814514172 1.3487956523895237)'));
insert into prrm_roaddefect values(24,24,'Major','Base Failure','Done',pointfromtext('POINT(103.68248462676976 1.3142335414886486)'));
insert into prrm_roaddefect values(25,25,'Critical','Other','Done',pointfromtext('POINT(103.66448879241935 1.3108267784118612)'));
insert into prrm_roaddefect values(26,26,'Critical','Base Failure','AssignedInspection',pointfromtext('POINT(103.69252920150748 1.309305250644683)'));
insert into prrm_roaddefect values(27,27,'Normal','Other','AssignedInspection',pointfromtext('POINT(103.7645111083986 1.4147859811782824)'));
insert into prrm_roaddefect values(28,28,'Major','Pothole','AssignedInspection',pointfromtext('POINT(103.77230644226069 1.3348941802978522)'));
insert into prrm_roaddefect values(29,29,'Normal','Pothole','AssignedInspection',pointfromtext('POINT(103.85963439941432 1.3618869781494103)'));
insert into prrm_roaddefect values(30,30,'Critical','Base Failure','AssignedInspection',pointfromtext('POINT(103.86210632324232 1.3535377979278582)'));
insert into prrm_roaddefect values(31,31,'Normal','Edge Rut','Pending',pointfromtext('POINT(103.84407424926763 1.3893080353736875)'));
insert into prrm_roaddefect values(32,32,'Major','Base Failure','Pending',pointfromtext('POINT(103.68662643432626 1.40379428863525)'));
insert into prrm_roaddefect values(33,33,'Normal','Pothole','Pending',pointfromtext('POINT(103.80664062499999 1.3348180651664756)'));
insert into prrm_roaddefect values(34,34,'Normal','Pothole','Pending',pointfromtext('POINT(103.81588363647458 1.3340196013450631)'));
insert into prrm_roaddefect values(35,35,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.81490278243996 1.3279802799224845)'));
insert into prrm_roaddefect values(36,36,'Major','Base Failure','AssignedRepair',pointfromtext('POINT(103.64613962173448 1.3337949514389045)'));
insert into prrm_roaddefect values(37,37,'Minor','Pothole','Pending',pointfromtext('POINT(103.65552965933787 1.3237824501768873)'));
insert into prrm_roaddefect values(38,38,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.69951970484382 1.346365848764194)'));
insert into prrm_roaddefect values(39,39,'Major','Base Failure','Pending',pointfromtext('POINT(103.68141952450405 1.3115984368200768)'));
insert into prrm_roaddefect values(40,40,'Critical','Other','Pending',pointfromtext('POINT(103.66836689235055 1.315623069056572)'));
insert into prrm_roaddefect values(41,41,'Critical','Base Failure','Pending',pointfromtext('POINT(103.69398928555576 1.3090436837908587)'));
insert into prrm_roaddefect values(42,42,'Normal','Other','Pending',pointfromtext('POINT(103.76999773297949 1.4129712752022198)'));
insert into prrm_roaddefect values(43,43,'Major','Pothole','Pending',pointfromtext('POINT(103.78424787397846 1.327750283819404)'));
insert into prrm_roaddefect values(44,44,'Normal','Pothole','Pending',pointfromtext('POINT(103.86706460881106 1.3651307327142108)'));
insert into prrm_roaddefect values(45,45,'Critical','Base Failure','Pending',pointfromtext('POINT(103.86374864121193 1.3414312971688318)'));
insert into prrm_roaddefect values(46,46,'Normal','Edge Rut','Pending',pointfromtext('POINT(103.83914108344031 1.3334531830270397)'));
insert into prrm_roaddefect values(47,47,'Major','Base Failure','Pending',pointfromtext('POINT(103.67957949761916 1.381279535244162)'));
insert into prrm_roaddefect values(48,48,'Normal','Pothole','Pending',pointfromtext('POINT(103.80810253589169 1.3356451534604945)'));
insert into prrm_roaddefect values(49,49,'Normal','Pothole','Pending',pointfromtext('POINT(103.8150782201197 1.3337086007192415)'));
insert into prrm_roaddefect values(50,50,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.81406230506461 1.3274224014479871)'));
insert into prrm_roaddefect values(51,51,'Minor','Base Failure','Pending',pointfromtext('POINT(103.64686904546614 1.332655045034991)'));
insert into prrm_roaddefect values(52,52,'Minor','Pothole','Pending',pointfromtext('POINT(103.65552965933787 1.3237824501768873)'));
insert into prrm_roaddefect values(53,53,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.69951970484382 1.346365848764194)'));
insert into prrm_roaddefect values(54,54,'Major','Base Failure','Pending',pointfromtext('POINT(103.68141952450405 1.3115984368200768)'));
insert into prrm_roaddefect values(55,55,'Critical','Other','Pending',pointfromtext('POINT(103.66836689235055 1.315623069056572)'));
insert into prrm_roaddefect values(56,56,'Critical','Base Failure','Pending',pointfromtext('POINT(103.69398928555576 1.3090436837908587)'));
insert into prrm_roaddefect values(57,57,'Normal','Other','Pending',pointfromtext('POINT(103.76999773297949 1.4129712752022198)'));
insert into prrm_roaddefect values(58,58,'Major','Pothole','Pending',pointfromtext('POINT(103.78424787397846 1.327750283819404)'));
insert into prrm_roaddefect values(59,59,'Normal','Pothole','Pending',pointfromtext('POINT(103.86706460881106 1.3651307327142108)'));
insert into prrm_roaddefect values(60,60,'Critical','Base Failure','Pending',pointfromtext('POINT(103.86374864121193 1.3414312971688318)'));
insert into prrm_roaddefect values(61,61,'Normal','Edge Rut','Pending',pointfromtext('POINT(103.83914108344031 1.3334531830270397)'));
insert into prrm_roaddefect values(62,62,'Major','Base Failure','Pending',pointfromtext('POINT(103.67957949761916 1.381279535244162)'));
insert into prrm_roaddefect values(63,63,'Normal','Pothole','Pending',pointfromtext('POINT(103.80810253589169 1.3356451534604945)'));
insert into prrm_roaddefect values(64,64,'Normal','Pothole','Pending',pointfromtext('POINT(103.8150782201197 1.3337086007192415)'));
insert into prrm_roaddefect values(65,65,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.81406230506461 1.3274224014479871)'));
insert into prrm_roaddefect values(66,66,'Minor','Base Failure','Pending',pointfromtext('POINT(103.64686904546614 1.332655045034991)'));
insert into prrm_roaddefect values(67,67,'Minor','Pothole','Pending',pointfromtext('POINT(103.65552965933787 1.3237824501768873)'));
insert into prrm_roaddefect values(68,68,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.69951970484382 1.346365848764194)'));
insert into prrm_roaddefect values(69,69,'Major','Base Failure','Pending',pointfromtext('POINT(103.68141952450405 1.3115984368200768)'));
insert into prrm_roaddefect values(70,70,'Critical','Other','Pending',pointfromtext('POINT(103.66836689235055 1.315623069056572)'));
insert into prrm_roaddefect values(71,71,'Critical','Base Failure','Pending',pointfromtext('POINT(103.69398928555576 1.3090436837908587)'));
insert into prrm_roaddefect values(72,72,'Normal','Other','Pending',pointfromtext('POINT(103.76999773297949 1.4129712752022198)'));
insert into prrm_roaddefect values(73,73,'Major','Pothole','Pending',pointfromtext('POINT(103.78424787397846 1.327750283819404)'));
insert into prrm_roaddefect values(74,74,'Normal','Pothole','Pending',pointfromtext('POINT(103.86706460881106 1.3651307327142108)'));
insert into prrm_roaddefect values(75,75,'Critical','Base Failure','Pending',pointfromtext('POINT(103.86374864121193 1.3414312971688318)'));
insert into prrm_roaddefect values(76,76,'Normal','Edge Rut','Pending',pointfromtext('POINT(103.83914108344031 1.3334531830270397)'));
insert into prrm_roaddefect values(77,77,'Major','Base Failure','Pending',pointfromtext('POINT(103.67957949761916 1.381279535244162)'));
insert into prrm_roaddefect values(78,78,'Normal','Pothole','Pending',pointfromtext('POINT(103.80810253589169 1.3356451534604945)'));
insert into prrm_roaddefect values(79,79,'Normal','Pothole','Pending',pointfromtext('POINT(103.8150782201197 1.3337086007192415)'));
insert into prrm_roaddefect values(80,80,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.81406230506461 1.3274224014479871)'));
insert into prrm_roaddefect values(81,81,'Minor','Base Failure','Pending',pointfromtext('POINT(103.64686904546614 1.332655045034991)'));
insert into prrm_roaddefect values(82,82,'Minor','Pothole','Pending',pointfromtext('POINT(103.65552965933787 1.3237824501768873)'));
insert into prrm_roaddefect values(83,83,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.69951970484382 1.346365848764194)'));
insert into prrm_roaddefect values(84,84,'Major','Base Failure','Pending',pointfromtext('POINT(103.68141952450405 1.3115984368200768)'));
insert into prrm_roaddefect values(85,85,'Critical','Other','Pending',pointfromtext('POINT(103.66836689235055 1.315623069056572)'));
insert into prrm_roaddefect values(86,86,'Critical','Base Failure','Pending',pointfromtext('POINT(103.69398928555576 1.3090436837908587)'));
insert into prrm_roaddefect values(87,87,'Normal','Other','Pending',pointfromtext('POINT(103.76999773297949 1.4129712752022198)'));
insert into prrm_roaddefect values(88,88,'Major','Pothole','Pending',pointfromtext('POINT(103.78424787397846 1.327750283819404)'));
insert into prrm_roaddefect values(89,89,'Normal','Pothole','Pending',pointfromtext('POINT(103.86706460881106 1.3651307327142108)'));
insert into prrm_roaddefect values(90,90,'Critical','Base Failure','Pending',pointfromtext('POINT(103.86374864121193 1.3414312971688318)'));
insert into prrm_roaddefect values(91,91,'Normal','Edge Rut','Pending',pointfromtext('POINT(103.83914108344031 1.3334531830270397)'));
insert into prrm_roaddefect values(92,92,'Major','Base Failure','Pending',pointfromtext('POINT(103.67957949761916 1.381279535244162)'));
insert into prrm_roaddefect values(93,93,'Normal','Pothole','Pending',pointfromtext('POINT(103.80810253589169 1.3356451534604945)'));
insert into prrm_roaddefect values(94,94,'Normal','Pothole','Pending',pointfromtext('POINT(103.8150782201197 1.3337086007192415)'));
insert into prrm_roaddefect values(95,95,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.81406230506461 1.3274224014479871)'));
insert into prrm_roaddefect values(96,96,'Minor','Base Failure','Pending',pointfromtext('POINT(103.64686904546614 1.332655045034991)'));
insert into prrm_roaddefect values(97,97,'Minor','Pothole','Pending',pointfromtext('POINT(103.65552965933787 1.3237824501768873)'));
insert into prrm_roaddefect values(98,98,'Minor','Edge Rut','Pending',pointfromtext('POINT(103.69951970484382 1.346365848764194)'));
insert into prrm_roaddefect values(99,99,'Major','Base Failure','Pending',pointfromtext('POINT(103.68141952450405 1.3115984368200768)'));
insert into prrm_roaddefect values(100,100,'Critical','Other','Pending',pointfromtext('POINT(103.66836689235055 1.315623069056572)'));


--
-- TOC entry 1925 (class 0 OID 0)
-- Name: DUMP TIMESTAMP; Type: DUMP TIMESTAMP; Schema: -; Owner: 
--

-- Completed on 2006-06-19 16:19:18 Malay Peninsula Standard Time