-------------------------------------------------------------------------------
-- 
--
-- @package opencimetiere
-- @version SVN : $Id$
-------------------------------------------------------------------------------

-- plan pour option localisation = plan
INSERT INTO plans (plans, planslib, fichier)
VALUES
(nextval('plans_seq'), 'PLAN CIMETIÈRE DE MOULÈS', 'f28b77608f272813b4daaf5ce064cab7')
;

-- data géographiques issues du cimetiere de moules
INSERT INTO cimetiere (cimetiere, cimetierelib, adresse1, adresse2, cp, ville, observations, geom)
VALUES 
(1, 'CIMETIÈRE DE MOULÈS', NULL, NULL, '99607', 'LIBREVILLE', '', '01060000206A080000010000000103000000010000000A0000007429DD1376A62941DFE2604711FA57416432F86ED3A629415A0CC1B115FA57415810EBBAFAA62941E79524E908FA5741CDB11612FDA62941D4A9B10109FA5741B3C3734101A7294178B3389607FA5741E459572DFFA62941800ED37D07FA5741ED1DD4AF08A729416095695D04FA5741096D3ABF89A6294172E935A000FA5741096D3ABF89A6294172E935A000FA57417429DD1376A62941DFE2604711FA5741')
,
(2, 'CIMETIÈRE DE RAPHÈLE', NULL, NULL, '99607', 'LIBREVILLE', '', '01060000206A080000010000000103000000010000000600000072ACEE64719429414631911F71F957419BC9188459942941726EB20360F957416DBC472CE1942941503E8DD25CF95741EE57ECCBF494294120E0057D6DF95741406BEC2473942941D7902A0571F9574172ACEE64719429414631911F71F95741')
;
SELECT pg_catalog.setval('cimetiere_seq', 2, true);

-- zone
INSERT INTO zone (zone, cimetiere, zonetype, zonelib, geom) VALUES (1, 1, 2, '2', '01060000206A080000010000000103000000010000000A000000821C4C1982A62941593CE21907FA57416AA92D3BA5A629410A111BC508FA574181335624F0A6294182DC5F5A0CFA57415810EBBAFAA62941E79524E908FA5741CDB11612FDA62941D4A9B10109FA5741B3C3734101A7294178B3389607FA5741E459572DFFA62941800ED37D07FA5741ED1DD4AF08A729416095695D04FA5741096D3ABF89A6294172E935A000FA5741821C4C1982A62941593CE21907FA5741');
INSERT INTO zone (zone, cimetiere, zonetype, zonelib, geom) VALUES (2, 1, 2, '3', '01060000206A08000001000000010300000001000000050000002C5DD01D82A62941C14C0F1607FA57417FCD494AA5A6294106822BC008FA5741C6E9DE8588A62941469AD02512FA57417429DD1376A62941DFE2604711FA57412C5DD01D82A62941C14C0F1607FA5741');
INSERT INTO zone (zone, cimetiere, zonetype, zonelib, geom) VALUES (3, 1, 2, '1', '01060000206A08000001000000010300000001000000050000000588B83CA5A629414F149AC408FA57411EEDE925F0A629416D9BDC590CFA57415161C775D3A62941058F7FAD15FA5741C6E9DE8588A62941469AD02512FA57410588B83CA5A629414F149AC408FA5741');
INSERT INTO zone (zone, cimetiere, zonetype, zonelib, geom) VALUES (35, 2, 2, '2', '01060000206A08000001000000010300000001000000060000001E245C0AE3942941D66CA8C861F957411EA9D669EB942941390C616967F957417F7CDFC467942941737585636AF957414733DC2560942941933785E464F957414533DC25609429419E3785E464F957411E245C0AE3942941D66CA8C861F95741');
INSERT INTO zone (zone, cimetiere, zonetype, zonelib, geom) VALUES (36, 2, 2, '1', '01060000206A080000010000000103000000010000000500000021A9D669EB942941290C616967F9574166C16080F4942941EA8CD3436EF95741C9D0B73A7194294100CE943271F95741797CDFC467942941687585636AF9574121A9D669EB942941290C616967F95741');


SELECT pg_catalog.setval('zone_seq', 36, true);

-- voie 
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (2, 1, 1, 'E', '01060000206A0800000100000001030000000100000005000000203149C195A629410B22C2FA00FA5741462FD76E95A62941CD80B3B401FA57419B37B7C9FAA62941F2C911C204FA5741A119172EFDA6294167F7A40604FA5741203149C195A629410B22C2FA00FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (4, 1, 1, 'D', '01060000206A080000010000000103000000010000000500000070D550EF02A7294148F6093204FA5741ED1DD4AF08A729416095695D04FA5741E459572DFFA62941800ED37D07FA5741D9372831F9A62941B653973F07FA574170D550EF02A7294148F6093204FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (6, 1, 1, 'G', '01060000206A0800000100000001030000000100000005000000D9B5A24694A62941BE49F08602FA57413A5875A092A6294176983CF303FA5741832EA1F8E1A629411990D76406FA57414FE12DAFE4A629411C0D3FFA04FA5741D9B5A24694A62941BE49F08602FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (8, 1, 1, 'F', '01060000206A080000010000000103000000010000000500000090237E1B82A62941D065061807FA57411E5E73BF87A629419029FA5907FA57416EE9F98A8FA62941D140EACB00FA5741096D3ABF89A6294172E935A000FA574190237E1B82A62941D065061807FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (10, 1, 1, 'C', '01060000206A08000001000000010300000001000000050000005810EBBAFAA62941E79524E908FA5741D80F4E9DF5A629415ED1B2B208FA574132CDDCB0EAA629417133C5210CFA5741D6E10D27F0A62941A0B07D590CFA57415810EBBAFAA62941E79524E908FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (11, 2, 1, 'F', '01060000206A08000001000000010300000001000000050000000006EA9980A62941992A795E08FA57418F4022B385A629415798349308FA5741CB04E9D27AA6294173659D8011FA57417429DD1376A62941DFE2604711FA57410006EA9980A62941992A795E08FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (12, 3, 1, 'G', '01060000206A08000002000000010300000001000000050000001DFFC767BAA62941118A07370BFA5741A6EFD1A8AFA62941133A1DBE0EFA5741F27FD3D1B4A629415E0F35020FFA5741214B06ACBFA629412AFC03760BFA57411DFFC767BAA62941118A07370BFA5741010300000001000000050000008614C7409DA62941CA933D8811FA57418DF159E4A2A62941AF1AE3CE11FA57410677236DB7A62941276BAF160BFA5741233CF2BBB1A6294142E409D00AFA57418614C7409DA62941CA933D8811FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (13, 3, 1, 'A', '01060000206A0800000100000001030000000100000005000000F27FD3D1B4A629415E0F35020FFA574150E105F4B9A629411033BF430FFA5741EB925DA5C4A62941CBD698B10BFA5741214B06ACBFA629412AFC03760BFA5741F27FD3D1B4A629415E0F35020FFA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (14, 2, 1, 'C', '01060000206A08000002000000010300000001000000050000002F315FAA88A629412A70529F09FA57412A0FB6EB87A62941BD0A0B410AFA5741184923FF93A62941734725D50AFA5741DB48B29795A62941013F573F0AFA57412F315FAA88A629412A70529F09FA574101030000000100000005000000566415FC88A62941E546DAFE0AFA57410A747C2292A62941C335CD6B0BFA57412099AE7590A629410281B8040CFA5741ADEFFD5987A62941A512A39B0BFA5741566415FC88A62941E546DAFE0AFA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (15, 2, 1, 'D', '01060000206A0800000200000001030000000100000005000000ADEFFD5987A62941A512A39B0BFA57412099AE7590A629410281B8040CFA5741389F46AD8EA629419575389E0CFA574160ED7D9485A629412E1EAD340CFA5741ADEFFD5987A62941A512A39B0BFA574101030000000100000005000000128711F184A62941EC04AC7A0DFA57413F975AE68AA629416A3DDFC30DFA57414E6C01C38CA629413C695D2C0DFA5741F928027C86A62941BE302AE30CFA5741128711F184A62941EC04AC7A0DFA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (16, 2, 1, 'E', '01060000206A0800000100000001030000000100000005000000128711F184A62941EC04AC7A0DFA57413F975AE68AA629416A3DDFC30DFA5741C4DB8E3289A6294164AE45560EFA5741E3A05D8183A629418F7095150EFA5741128711F184A62941EC04AC7A0DFA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (17, 2, 1, 'A', '01060000206A0800000200000001030000000100000005000000C9CC503581A629415243E7DA07FA57417C2C96908BA629418C1B3E6508FA5741692FA86A8DA629417717A0C407FA574106F5A4F981A62941D6BBAE3407FA5741C9CC503581A629415243E7DA07FA57410103000000010000000500000040C0E59D96A629411EEB680E08FA574120FC201D95A6294157B1C4E508FA5741B40325DEA2A6294147A9BE8A09FA57417FCD494AA5A6294106822BC008FA574140C0E59D96A629411EEB680E08FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (18, 3, 1, 'B', '01060000206A0800000200000001030000000100000005000000889607B08FA6294162812D9111FA5741E63F02128DA62941D432A75C12FA5741FEDCC62AAAA62941B88689BB13FA57411D8108D7ACA62941C8DA73EC12FA5741889607B08FA6294162812D9111FA574101030000000100000005000000DA951291B1A629413741C51414FA57418C483635B4A62941FDCEE35013FA5741CC4E700AD6A629411467B6D614FA57415161C775D3A62941058F7FAD15FA5741DA951291B1A629413741C51414FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (20, 1, 1, 'A', '01060000206A08000001000000010300000001000000050000002770BDCE9DA6294144C849FA05FA57410DA37EDF9FA62941F1C2B34705FA5741CC10123BEFA629412EFFEB0C09FA574107002A2FEDA62941E9CEB4BC09FA57412770BDCE9DA6294144C849FA05FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (22, 1, 1, 'B', '01060000206A0800000200000001030000000100000005000000B8F449DB9BA62941571CFAA206FA574189330E30EBA62941945832680AFA574107002A2FEDA62941E9CEB4BC09FA57412770BDCE9DA6294144C849FA05FA5741B8F449DB9BA62941571CFAA206FA5741010300000001000000050000002D9CA59DE5A62941EDB0E5D80BFA57417ACB5702E8A62941DEAE27250BFA57411E24FBB098A629416D87986707FA574140C0E59D96A629411EEB680E08FA57412D9CA59DE5A62941EDB0E5D80BFA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (23, 3, 1, 'CT', '01060000206A0800000100000001030000000100000005000000DD7DE529A6A6294110D1A2F211FA5741FE737127AFA62941BC5C7A5A12FA5741FAC79B32B8A629418542EB530FFA5741B52FAE42AFA62941FD5875DE0EFA5741DD7DE529A6A6294110D1A2F211FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (24, 3, 1, 'FC', '01060000206A08000001000000010300000001000000050000003437B83AB6A62941358536BD12FA57419D71071DBFA6294126455A2313FA5741856E4ADCD3A62941E14137760CFA57418CAB7430CBA62941468790070CFA57413437B83AB6A62941358536BD12FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (25, 3, 1, 'F', '01060000206A0800000200000001030000000100000005000000C4FF0FA3D2A629416EE220ED0FFA57414EAB03C9CCA62941AC75A1A50FFA5741FE2BD181D6A629418A3CBA7E0CFA574198223F4EDCA6294191DD85C40CFA5741C4FF0FA3D2A629416EE220ED0FFA5741010300000001000000050000001D4F7C8FC1A62941CC2F664513FA5741021B02A0C7A6294105344D9013FA574195195C33D1A6294148C19C7310FA5741D4EF3715CBA6294186541D2C10FA57411D4F7C8FC1A62941CC2F664513FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (26, 3, 1, 'C', '01060000206A0800000100000001030000000100000005000000B40325DEA2A6294147A9BE8A09FA574184977ACCEDA62941E29B641D0DFA5741D6E10D27F0A62941A0B07D590CFA5741FD5560D4A5A6294187F26ECC08FA5741B40325DEA2A6294147A9BE8A09FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (27, 3, 1, 'E', '01060000206A0800000300000001030000000100000005000000021B02A0C7A6294105344D9013FA5741FAB7B8A9CDA62941826C80D913FA5741D5FAD521D7A62941E913F6BB10FA574195195C33D1A6294148C19C7310FA5741021B02A0C7A6294105344D9013FA574101030000000100000005000000C4FF0FA3D2A629416EE220ED0FFA5741BC9CC6ACD8A629410E357A3510FA5741733D8232E2A6294186AD20110DFA574198223F4EDCA6294191DD85C40CFA5741C4FF0FA3D2A629416EE220ED0FFA574101030000000100000005000000EABD07AAECA62941E2F5D17B0DFA574101F09D81E6A62941B500C52F0DFA574183482B3AD1A62941DC02523014FA5741B0254731D7A629411AA2DB7614FA5741EABD07AAECA62941E2F5D17B0DFA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (28, 2, 1, 'B', '01060000206A0800000100000001030000000100000005000000EF802C0FA1A62941BC97D0FD09FA57410E7FD1BB9CA6294127E0ABC809FA5741B67593F686A62941AB08B1F610FA5741F96C4B5E8BA62941D8D67D2911FA5741EF802C0FA1A62941BC97D0FD09FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (29, 3, 1, 'D', '01060000206A0800000200000001030000000100000005000000CE1C9FD7A1A629414A12C0080AFA57414336892D8DA6294121B648C710FA57415D6B3D2593A629410F47AC0D11FA5741456880E4A7A62941BABE31540AFA5741CE1C9FD7A1A629414A12C0080AFA574101030000000100000005000000A048413097A62941918F563D11FA57418614C7409DA62941CA933D8811FA5741233CF2BBB1A6294142E409D00AFA574119CE0AB9ABA6294180778A880AFA5741A048413097A62941918F563D11FA5741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (38, 35, 1, 'C', '01060000206A08000002000000010300000001000000050000001CFEA8A1699429414D8FE2416BF95741C2CFACBCE19429414B06539E68F957411583357BE09429410C00ABA867F95741EEC3366C6894294162A0BC5F6AF957411CFEA8A1699429414D8FE2416BF95741010300000001000000050000003A0DC3DD75942941F0FA1E436CF95741F464F45EE5942941299AF4D669F95741F893FE21E4942941A9CE0EF068F957418E1647AB74942941B0D5DD636BF957413A0DC3DD75942941F0FA1E436CF95741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (39, 35, 1, 'B', '01060000206A0800000200000001030000000100000005000000E3CD251A77942941309996296DF95741603BBC9AE6942941CD73FEBC6AF95741F464F45EE5942941299AF4D669F957413A0DC3DD75942941F0FA1E436CF95741E3CD251A77942941309996296DF95741010300000001000000050000003CE7065D789429410BFB29786EF95741F63E38DEE7942941449AFF0B6CF95741FA6D42A1E6942941C4CE19256BF9574190F08A2A77942941CBD5E8986DF957413CE7065D789429410BFB29786EF95741');
INSERT INTO voie (voie, zone, voietype, voielib, geom) VALUES (41, 35, 1, 'D', '01060000206A080000020000000103000000010000000500000042AC8670E9942941F6D59CAE6AF9574145D5A294EE942941991EEE906AF9574102FE4A29EC9429417913E2BD68F95741B9782E05E794294105CD90DB68F9574142AC8670E9942941F6D59CAE6AF9574101030000000100000005000000587A0C52EC942941AA49C7DA6CF9574155352876F1942941CB9418BD6CF9574143F79011EF942941B1E223EF6AF95741DFE074EDE99429419E99D20C6BF95741587A0C52EC942941AA49C7DA6CF95741');

SELECT pg_catalog.setval('voie_seq', 41, true);
